execute hidden subreport

[initworks]

I need to place a subreport in the details section.
I also need to hide the details section.

Is there a way to execute the subreport even if it is hidden?

unfortunately i can't just hide the subreport sections, nor can i place the calculated values in an array because there are 1.5 mln values to be calculated on detail level.

 

[satinsilhouette]

You can put a subreport in a detail section, but processing needs to occur after the main report detail section most likely. So I would put a detail a and a detail b section in the report and put the subreport in detail b. Then you can hide the main report detail section if necessary.

If you need to display information from the subreport you have a couple possibilities - pass variables back and forth or underlay the following section from detail a to detail b.

What version of CR are you on?

Thanks so much!
satinsilhouette

 

[initworks]

Thanks for the reply.
I'm using Crystal Reports v11

The main problem is that I have 1.5 mln records this comes
down to approx 200 pages if I minimize the details section.

The actual result I want to show is only 6 pages.
therefore 'underlay following section' doesn't seem an option for me.

What I need to do with these records is the following:
determine if the date is 30-september-2006. if so replace it with the date generated in the subreport, if not keep the date from the main report.

the subreport itself contains 1.2 mln records

the report is linked based on articlenumber and storage location.

 

[IdoMillet]

Can you use a SQL Expression instead of a subreport?
If not, explain what the subreport is doing.

- Ido

view, e-mail, export, burst, distribute, and schedule Crystal Reports.

http://www.MilletSoftware.com

 

[initworks]

Thanks for the replies,

I'm solving the problem using the left outer join I was hoping to avoid.
Unfortunately the datasets are stored in completely different area's. One Oracle the other MS SQL Server 2000.

This is giving me a horrible performance but it does seem to work.