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
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”
Answer Question | August 30, 2009 9:41 AM
Crystal Reports, VB 6, Visual Basic, Visual Basic Error Messages
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
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
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
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
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
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
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
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
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 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
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
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
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
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 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 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
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