Subreport trouble

[crumpm]

Hi

I'm using CR2008 on a progress database, using a proprietary driver.

I have a table with the data I want, where the key index fields are strings (stupid design fault)
To get around this, I have created 2 SQL conversion expressions, and use them to link 4 subreports to bring extra data.

My problem comes when I want to do more than just display the subreports (which work fine)
I need to do suppression in the main reports, based on a combination from main and sub.

Main
RH
PH
GH1 - Code type
GH2 - Case reference subreports 1 - 4
D - main data, sql conversion formulas, formaulas (to bring in the shared variables)


Sub
D - Formula (shared numbervar BillBal:= {Table2.BillBal})


I want to supress the detail based on a posting code and subreport value, e.g.;

{table.code} = "CC" and shared numbervar BillBal = 0

I just get 0 in the Billbal formula instead of the value that is displayed in the subreport.


Any ideas?

Thanks

 

[pmax9999]

Assuming the Sub-Report is in the Details Section, you will need to split that section into 2, place the Sub-Report in Da and everything else in Db. This is because the variable value assigned in a Sub-Report is not available until the next section.

If you don't want to see the Sub-Report values, supress all sections in it, format the Sub-report to "Suppress Blank Sub-Report", and format section Da to "Suppress Blank Section".

Hope this helps.

Cheers
Pete