For Programmers: Free Programming Magazines  


Home > Archive > Visual Basic Crystal Reports > June 2005 > No data in Report, sub report has data









You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

 

Author No data in Report, sub report has data
Michelle

2005-05-30, 4:01 pm

Hello,

I am using CRViewer version 8.0 with VB6 and have run into an issue
that i'd love some help with. I have a report that displays data and
also contains 2 sub reports - one sits in "Report Footer a" and the
other in "Report Footer b". In VB I utilize the function
Report_NoData(cancel as Boolean) to close the report and display a
msgbox to the customer if the report has no data.

This function works great except in the situation where the main report
has no data, but the sub reports do - the Report_NoData function still
gets called by the CRViewer. Does anyone know of a way to verify if
the sub report(s) also have no data? Or any other way around this
problem?

Thank you,
Michelle

John Mishefske

2005-06-01, 3:59 am

Michelle wrote:
> Hello,
>
> I am using CRViewer version 8.0 with VB6 and have run into an issue
> that i'd love some help with. I have a report that displays data and
> also contains 2 sub reports - one sits in "Report Footer a" and the
> other in "Report Footer b". In VB I utilize the function
> Report_NoData(cancel as Boolean) to close the report and display a
> msgbox to the customer if the report has no data.
>
> This function works great except in the situation where the main report
> has no data, but the sub reports do - the Report_NoData function still
> gets called by the CRViewer. Does anyone know of a way to verify if
> the sub report(s) also have no data? Or any other way around this
> problem?


I haven't done this but I saw some tips on how to do it in the "20 Secrets"
paper available at:

http://www.integrasolutions.net/isi...stalReports.htm

I'm not relatted to this site in any way; I was searching for info on
another topic last w and ran across it...

--
'---------------
'John Mishefske
'---------------
Sponsored Links







Also available: Server administration forum archive | Web Design forum archive | Software forum archive | Hardware reviews archive

Copyright 2008 codecomments.com