How to hide a subreport but still needs to access some shared variable

[siddu1234]

Hi,
I have a crystal report main report with a formula which checks the value of a particular column say a datetime column in current record for some calculation.I want to compare this value with the immediate next record datetime column.As the main record does not bring this record(immediate next)due to some filter criterias, i need to get this immediate record using a subreport(using a stored proc by passing main report current record primary key) and get this datetime value in the main report formula using a Shared variable from subreport.But i do not want to show this subreport to user.How can i hide that?The records are at Group 2 level.Where should i put this subreport in main report.Is it at Group 2 level itself?Is it the right procedure for this? Please help.Its very urgent.

 

[lbass]

The subreport must be in a section above the section in which you reference the shared variable in the main report, so if you want to do a comparison in GH2b, the sub must be in GH2a.

Depending upon your version of CR (which you should always identify), you can suppress all sections WITHIN the subreport, then format the subreport object to "suppress blank subreport" (format subreport->subreport tab), and then go into the section expert and format the section containing the subreport (GH2a) to "suppress blank section".

-LB

 

[Madawc]

You can have a subreport with the border-lines removed and with no details shown. You can also make it very small so that it ceases to be noticeable.

Madawc Williams (East Anglia, UK). Using Windows XP & Crystal 10