Crystal Reports+CPU Performance

Hi all
I am to actually integrate different sub reports into the main report.
I was able to solve the problem of linking the sub report parameter fields to the main report.This particular link of msdn helped me

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/crystlmn/html/crtskinsertingsubreports.asp

I am linking the parameter field value of the main report to that of the sub report using the above method.
But my application's performance is going very slow..The cpu usage of the application is almost 100%.I think its because of the double reference that this happens.Reference I mean,the main reports parameters should link to the subreport and then print the data,I guess its this reason that makes the performance go poor.
Can anyone help mein giving any ideas of improving the CPU performance ?

Thanks in advance.How long does it take to print the data?

Crystal Reports and Simply Accounting - Sub report issue

Hello,

I am having a problem with Crystal reports 8.5 for Simply Accounting version 2006-D.

We have a custom report that is used for printing cheques. The report is made up from the databases VENCHQ1_CSV (header) and VENCHQ2_CSV (detail). In the stub portion of the cheque, there are two sub reports that run. The first sub report shows the first 12 detail lines from VENCHQ2_CSV and the second sub report shows the next 12. We have cheques with up to 36 detail lines and we need to change the report to have 3 columns side by side that show the first, second and third set of 12 line items.

So far, I have taken the second sub report and saved it as an individual sub report then inserted it as the third column. The result is that the cheque prints out with three columns, but instead of the third column showing the last set of line items, it shows the same line items as in the second column.

Each sub report is grouped on the VENCHQ2_CSV.LINE_COUNT field in ascending mode. I can't figure out how to make the third group continue where the second group finishes.

Does anyone know how I can fix this?

Thanks,

Salar Madadi
- Latest Developments Inc.See answer in other forum - probably a record selection issue.

Crystal Report Error

Hi

How do I open the password protected .mdb when there is sub reports in the Crystal Report. I got it to work on reports which contains no subreports. The problem is with the ones thats got subreports. It crashes the calling program and generate the runtime error 20535
unable to open database incorrect session parameters.

Please help me.Hi

How do I open the password protected .mdb when there is sub reports in the Crystal Report. I got it to work on reports which contains no subreports. The problem is with the ones thats got subreports. It crashes the calling program and generate the runtime error 20535
unable to open database incorrect session parameters.

Please help me.
Urgent need please help me.

Crystal report - using sub report

i am using a sub report in my main report. I am able to count/ total a field using the Running total within that subreport which match the criteria of selection. i am passing a parameter from my main report say Issue number to subreport.

For each issue no passed i am totalling and writing in the report - one row per issue no ( with different columns like January, Feb, March,...)

Problem: At the end of the report i want the Verticle total of each coulmn say total in January, Feb, March,...I am not able to do this.

Is there a way to do this?

In the sub report i use Formula field in running total as i need to pick up only those records in the database which match the selection criteria provided. I tried other options like Sum of a field,..but no success.

let me know if any one of you have answer. THANKSdo you use grouping in the report(Jan, Feb, Mar...)?|||NO.

I have formula fields to calculate the First and the last day of each of the months using the current date. Using these i check the date in the record to count that record whether that should fall in Jan or Feb or march in the sub report.

Data comes from 2 seperate db tables. Issueno table(main report) and Tickets table (sub report)
Only Selected Issue no is passed as parameter to the sub report to do the above calculation (count no of tickets with date in Jan or Feb or Mar..).
Sub Report footer has these running total fields with the formula to count the tickets.

Report looks like this:

Issue# Rec in Jan Recs..Feb RecMarch Recs..April Total
5 0 1 2 0 3
12 2 0 7 2 11
14 0 2 0 4 6
17 11 4 0 0 15
24 0 7 1 0 8
======================================
GTotal ?? ?? ?? ?? ??
========================================
Or is there a way to count the figures in each column at the end of the Report?

(Data: First Row:- Issue no=5, Jan=0, Feb=1, March=2, Apr=0, Total=3)|||Your bottom line is to count the tickets on january, february..., i im right?

If that is you case, try this... add running total field(january) and the type of summary is count. Then in "evaluate", click the formula option and type this

month({ticket.date})=1

This means fo the month of january...

Add the another running total field for the month of february and so for...

Sorry, im slow in english so i cant understand yor question clearly.|||Your English: Not a problem at all. Thanks for the Feedback.

My problem in Short:
I am trying to Grand Total a DERIVED Field/Column like Jan, Feb, Mar...SO there is no Month field as such to Grand Total. All this calculation is done ina Sub report using the Formula field to determine in which coulmn (jan/feb/..) the record falls and accordingly counted in that month. For every issue no passed from main report as a parameter to subreport all the attached tickets to that Issue no are validated and if the selection criteria matched then counted.
Only vertical total of a devived field like Jan/feb/.. is a problem