odbc error while generating crystal reports
Crystal reports are not getting generated with odbc error. After the upgradation of rational tools from SQL to DB2 version, refreshing crystal reports template is not fetching data and end with ODBC Error. What could be the reason for this? Is any settings needed for this upgradation?
Answer Question
| September 10, 2009 10:28 AM
Crystal Reports, Crystal Reports 8.5, ODBC, ODBC Errors
Crystal reports are not getting generated with odbc error. After the upgradation of rational tools from SQL to DB2 version, refreshing crystal reports template is not fetching data and end with ODBC Error. What could be the reason for this? Is any settings needed for this upgradation?
Answer Question
| September 10, 2009 10:28 AM
Crystal Reports, Crystal Reports 8.5, ODBC, ODBC Errors
Multiple charts – over 200 charts in one Crystal Report
Hi, I want to use multiple data sources and create data multiple charts packages for clients and export each 100-200 chart packages into pdf files automatically to a local drive folder. I know how to create one chart but how to create multiple charts and process them to pdf automatically. It would be great if you [...]
Answer Question
| August 25, 2009 3:42 PM
Crystal Reports, Data management
Hi, I want to use multiple data sources and create data multiple charts packages for clients and export each 100-200 chart packages into pdf files automatically to a local drive folder. I know how to create one chart but how to create multiple charts and process them to pdf automatically. It would be great if you [...]
Answer Question
| August 25, 2009 3:42 PM
Crystal Reports, Data management
how to fix ” cannot find database dll”
how to fix ” cannot find database dll”
Answer Question
| August 30, 2009 9:41 AM
Crystal Reports, VB 6, Visual Basic, Visual Basic Error Messages
how to fix ” cannot find database dll”
Answer Question
| August 30, 2009 9:41 AM
Crystal Reports, VB 6, Visual Basic, Visual Basic Error Messages
Need help with Crystal Report formula for most current data
Moderator note: Buggie recently posted this question and it was, well, buggy! I’m reposting it here for him with a clean format. Thanks Buggie! I’m relatively new with Crystal Reports and I would woudl appreciate any help with a formula. I am using CR 10 and my data is stored in several tables. What I [...]
Answer Question
| August 17, 2009 8:49 PM
Crystal Reports, Crystal Reports 10, Crystal Reports formulas
Moderator note: Buggie recently posted this question and it was, well, buggy! I’m reposting it here for him with a clean format. Thanks Buggie! I’m relatively new with Crystal Reports and I would woudl appreciate any help with a formula. I am using CR 10 and my data is stored in several tables. What I [...]
Answer Question
| August 17, 2009 8:49 PM
Crystal Reports, Crystal Reports 10, Crystal Reports formulas
Crystal Reports
Dears, i’ve a report called (transaction list report)this report has different values and type like (inv,cash,credit) what i need is: each time i run this report i need the result as this: all the INV which is [strong]same value[/strong] only . pls advice and i really appreciated,, best rgds JAA1983
Answer Question
| August 17, 2009 11:58 AM
Crystal Reports, Crystal Reports 2008
Dears, i’ve a report called (transaction list report)this report has different values and type like (inv,cash,credit) what i need is: each time i run this report i need the result as this: all the INV which is [strong]same value[/strong] only . pls advice and i really appreciated,, best rgds JAA1983
Answer Question
| August 17, 2009 11:58 AM
Crystal Reports, Crystal Reports 2008
CPYTOPCD
I have problem in CPYTOPCD command; I have on PF and one flat file, My RPG1 program dump data first in PF then RPG2 program dump data with (~) saprater In Flat file, Then my CL program dump data from flat file to QDLS folder in TXT format, when I open the TXT folder in [...]
Answer Question
| August 17, 2009 11:22 AM
CPYTOPCD, Crystal Reports
I have problem in CPYTOPCD command; I have on PF and one flat file, My RPG1 program dump data first in PF then RPG2 program dump data with (~) saprater In Flat file, Then my CL program dump data from flat file to QDLS folder in TXT format, when I open the TXT folder in [...]
Answer Question
| August 17, 2009 11:22 AM
CPYTOPCD, Crystal Reports
User Defined Field Setup Crystal Reports 8.5
How does one create a user defined field in Crystal Reports 8.5. I needed a field in IQMS to enter employee information so I created a user defined setup with a pull down menu, but I have to now add the field to the table that is being used in Crystal Reports but I don’t [...]
Answer Question
| August 13, 2009 8:54 PM
Crystal Report 8.5, Crystal Reports, User report
How does one create a user defined field in Crystal Reports 8.5. I needed a field in IQMS to enter employee information so I created a user defined setup with a pull down menu, but I have to now add the field to the table that is being used in Crystal Reports but I don’t [...]
Answer Question
| August 13, 2009 8:54 PM
Crystal Report 8.5, Crystal Reports, User report
Blobs and Memos in formulas
I need to use a field that is varchar2(2000) in the Oracle. How do I use this field in a formula in Crystal Reports 8.5?
Answer Question
| August 14, 2009 1:36 PM
Crystal Reports, Crystal Reports 8.5, Crystal Reports 8.x
I need to use a field that is varchar2(2000) in the Oracle. How do I use this field in a formula in Crystal Reports 8.5?
Answer Question
| August 14, 2009 1:36 PM
Crystal Reports, Crystal Reports 8.5, Crystal Reports 8.x
Crystal Reports VII, viewing data while using select expert
Sorry if this duplicated, I thought I posted this but I can’t find it anywhere here goes I created a report with crystal 7 and I using the select expert for a particular field/table. When I use the expert the drop drown menu does show me every thing in the table. Is there a limit [...]
Answer Question
| August 12, 2009 5:20 PM
Crystal Reports, Crystal Reports 7
Sorry if this duplicated, I thought I posted this but I can’t find it anywhere here goes I created a report with crystal 7 and I using the select expert for a particular field/table. When I use the expert the drop drown menu does show me every thing in the table. Is there a limit [...]
Answer Question
| August 12, 2009 5:20 PM
Crystal Reports, Crystal Reports 7
Crystal Reports grouping by date
Hi, I’m trying to group single dates (eg. 1 Jan 09, 9 Jan 09, 11 Jan 09, etc) by weekly interval (e.g. 1-7 Jan 09, 8-14 Jan 09, etc). Any suggestions please?
Answer Question
| August 11, 2009 2:17 PM
Crystal Reports
Hi, I’m trying to group single dates (eg. 1 Jan 09, 9 Jan 09, 11 Jan 09, etc) by weekly interval (e.g. 1-7 Jan 09, 8-14 Jan 09, etc). Any suggestions please?
Answer Question
| August 11, 2009 2:17 PM
Crystal Reports
runtime error “server has not yet been opened”
Runs in Crystal IDE but not when run from VB. Access DB. Have 8 other reports using same code which work.
Answer Question
| August 12, 2009 4:06 PM
Crystal IDE, Crystal Reports, Crystal Reports 8.5, Crystal Reports error messages
Runs in Crystal IDE but not when run from VB. Access DB. Have 8 other reports using same code which work.
Answer Question
| August 12, 2009 4:06 PM
Crystal IDE, Crystal Reports, Crystal Reports 8.5, Crystal Reports error messages
Crystal report Crosstab
I want to run the report for 2007,2008 and 2009 how to display this three year in the top by month
Answer Question
| March 11, 2010 3:23 PM
Crystal Reports, Crystal Reports Crosstabs, Crystal Reports Projects
I want to run the report for 2007,2008 and 2009 how to display this three year in the top by month
Answer Question
| March 11, 2010 3:23 PM
Crystal Reports, Crystal Reports Crosstabs, Crystal Reports Projects
Crystal 8 & SQL problem
I created 80+ reports for the company intranet and they worked great. At the time the ODBC’s were set up for a general SQL connection of sa/blank password. Now the connection connects via windows login/password. The reports have stopped working. I rebuilt one from scratch and put in on the intranet but it still doesn’t [...]
Answer Question
| August 5, 2009 2:19 PM
Crystal Reports, Crystal Reports 8, ODBC, SQL
I created 80+ reports for the company intranet and they worked great. At the time the ODBC’s were set up for a general SQL connection of sa/blank password. Now the connection connects via windows login/password. The reports have stopped working. I rebuilt one from scratch and put in on the intranet but it still doesn’t [...]
Answer Question
| August 5, 2009 2:19 PM
Crystal Reports, Crystal Reports 8, ODBC, SQL
More than one level nesting in crystal reports
Hi, **************** Using: Crystal reports XI release 2 Database – DB2 **************** I have three screens(say A,B and C). When I click on an item in A screen then it should display screen B and when I click on an item in screen B then it should display scren C. Eg. screen A -> screen [...]
Answer Question
| August 3, 2009 10:49 AM
Crystal Reports, Crystal Reports Nesting, Crystal Reports XI
Hi, **************** Using: Crystal reports XI release 2 Database – DB2 **************** I have three screens(say A,B and C). When I click on an item in A screen then it should display screen B and when I click on an item in screen B then it should display scren C. Eg. screen A -> screen [...]
Answer Question
| August 3, 2009 10:49 AM
Crystal Reports, Crystal Reports Nesting, Crystal Reports XI
Refresh/Run SQL
We upgraded to Crystal Reports 2008. Our older version queries appear to work… In the Older Verion all we did is click the lightening blot. Now… we have to go through Database, SQL to run/refresh the query. Isn’t there a one click key for to run these queries?
Answer Question
| August 3, 2009 9:28 PM
Crystal Reports, Crystal Reports 2008, SQL, SQL Database
We upgraded to Crystal Reports 2008. Our older version queries appear to work… In the Older Verion all we did is click the lightening blot. Now… we have to go through Database, SQL to run/refresh the query. Isn’t there a one click key for to run these queries?
Answer Question
| August 3, 2009 9:28 PM
Crystal Reports, Crystal Reports 2008, SQL, SQL Database
Crystal Reports Formula
I am trying to seperate data in a field. For example the data in my field looks like this: Coldwell Banker Residential – IL – Waukegan…I need to get rid of everything before Waukegan. In other words I want it to display only the town. I can do it with the mid function, however, there [...]
Answer Question
| July 31, 2009 3:14 PM
Crystal Reports
I am trying to seperate data in a field. For example the data in my field looks like this: Coldwell Banker Residential – IL – Waukegan…I need to get rid of everything before Waukegan. In other words I want it to display only the town. I can do it with the mid function, however, there [...]
Answer Question
| July 31, 2009 3:14 PM
Crystal Reports
Formula setup on the crystal report
I want to generate error on the report viewer when sum of the specific column is not equal to the sum of the other specific column.How can i solve this?
Answer Question
| July 30, 2009 12:21 PM
Crystal Reports, Crystal Reports formulas
I want to generate error on the report viewer when sum of the specific column is not equal to the sum of the other specific column.How can i solve this?
Answer Question
| July 30, 2009 12:21 PM
Crystal Reports, Crystal Reports formulas
view data from ODBC to Crystal Reports
i am using Crystal Reports 10 to display data from ODBC. The error “Failed to open rowset. Details:HY000:
Answer Question
| July 29, 2009 7:14 AM
Crystal Reports, Crystal Reports 10, ODBC
i am using Crystal Reports 10 to display data from ODBC. The error “Failed to open rowset. Details:HY000:
Answer Question
| July 29, 2009 7:14 AM
Crystal Reports, Crystal Reports 10, ODBC
I use crystal report version 1o
I want to bring a value fron a table, but the sales order is in one company and the shipment isi in other company (in the same database) how can I display dis value . I can display the the received name but not the global id number . asigned to this name this is [...]
Answer Question
| July 28, 2009 7:47 PM
Crystal Reports
I want to bring a value fron a table, but the sales order is in one company and the shipment isi in other company (in the same database) how can I display dis value . I can display the the received name but not the global id number . asigned to this name this is [...]
Answer Question
| July 28, 2009 7:47 PM
Crystal Reports
VB 6, SQL Server 2000 & Crystal Reports
i am a developer using VB 6 EE, SQL Server 2000 & Crystal Reports 7 and windows XP & Windows NT platforms. But now i installed Windows Vista. i installed VB 6 EE, but cant work with SQL Server 2000 or Crystal reports. can u please suggest me wat i need 2 do.
Answer Question
| July 28, 2009 3:54 PM
Crystal Reports, SQL Server 2000, VB 6 EE, VB6
i am a developer using VB 6 EE, SQL Server 2000 & Crystal Reports 7 and windows XP & Windows NT platforms. But now i installed Windows Vista. i installed VB 6 EE, but cant work with SQL Server 2000 or Crystal reports. can u please suggest me wat i need 2 do.
Answer Question
| July 28, 2009 3:54 PM
Crystal Reports, SQL Server 2000, VB 6 EE, VB6
