report that give us previous values & qty level of an item

[thebigbadwolf]

Hello to all,

I have a question. I need a report to give me the level of item's value & qty on a previous date without having it in a table.

I have done that by creation sub-reports on every transaction type that I have (receipt, issue etc), and calculate the summary data in formula fields backwards.

The result is OK, but the report takes too long to preview, even now that the data are for 2 months (I wonder how long will get to preview if the data are for 1 year etc)

The question is: I there another way to do the same job, and have the report working faster?

Thanks in advance

 

[jlopeman]

It sounds like you are trying to calculate inventory turns or something similar. The way I've done this in the past is to set up MS SQL express database and create some SSIS packages to extract the data from the production DB to the data store to report off of.

Improving performance on reports can be a daunting task. Is there a way around the sub-report design? Keep in mind that the sub-report fires off for each individual record group. Assuming you have the sub-report in a part_number group header or footer, and you have 1,000's of parts; then each sub-report runs 1,000's of times (for each part). This takes a while to run. Can you replace the sub-report design with a fancy SQL command, to make the database do all the work and you can just format the returned data-set?

What version of Crystal and what database system are you reporting off of?

 

[thebigbadwolf]

I will try to do this

Systems are:
Oracle 10.2.0.5 and Crystal 9