• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 612
  • Last Modified:

Subreports Record count

Hi All,

I have a subreport inside a main report . the structure is like

GH1 Invoive No
GH1A Subreport --> Invoice Detail
GF1

Subreport is linked with main report with InvoiceNo

The Group Header 1 contains invoice number
the Group Header 1A contains subreport with Invoice details.

Now i want to suppress the GH1 section of main report if its subreport does not contain any record.

Please help me

regards
Vishal
0
vishalgoyal123
Asked:
vishalgoyal123
2 Solutions
 
dkDeveloperCommented:
Hi vishalgoyal123,

I was wondering what your data source is for this report.  Could you include a count of the detailed line items along side the invoice number and then just conditionally suppress when that count is equal to 0?  If not, I'm afraid this might not be possible since the processing of the subreport occurs after the section you wish to suppress.

Good Luck!
dK
0
 
frodomanCommented:
dk is right on the money - you can't suppress one section based on the results of a subreport in a subsequent section.

If you can return the count in your primary recordset that's probably the most efficient.  If not, you may be able to run a separate subreport prior to the section that does not but count the records and share the result with the main report.

frodoman
0
 
James0628Commented:
Another option might be to eliminate the GH1 section and put whatever was there in the subreport.  Then perhaps the subreport can suppress it if there are no details.  Whether or not that will work will depend on the details of your reports and data.

 James
0

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now