Crystal Reports

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...

how to fix " cannot find database dll"

how to fix " cannot find database dll" Software/Hardware used: vb 6, cristal report

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....

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...

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 last row I see some wild...

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 know how. ...

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? Software/Hardware used: Crystal reports 8.5

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 to how many...

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?

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.

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

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...

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 B...

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?

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 is one...

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?

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:[UVODBC][1401030] ERROR ID:46 Severity: ERROR Facility: DBCAPERR-UCI.Error. Func: SQLPrepare(DML);State:S1000;Universecode:950088; MSg:[SQL Client][Universe]universe/sql syntax error.unexpected...

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 the field i need to display ...

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.

Crystal reports, change recurrance pattern

Hi, I have some reports that automatically run through the Crystal Management Console. I need to turn off or remove recipients from some of these reports. I have gone into the Schedule tab for each report and changes the recurrance and recipients then updated the parameters. The problem is that my...