|
|
Has my subreport go data in it or not?
Hi
I am printing a report of Items Ordered in response to a mailshot. If
there are any Advance Orders for books not yet in print, a subreport
is included with the detail line. I am then trying to add the total of
books ordered to the total value of advance orders. Can I tell from my
main report if my subreport has data in it? I have tried using IsNull
on one of the fieldnames, but I get #Error or #Name.
Stapes
|
|
0
|
|
|
|
Reply
|
 Stapes
|
4/17/2007 2:02:55 PM |
|
Test the HasData property of the report in the subreport control.
Details in:
Bring the total from a subreport onto a main report
at:
http://allenbrowne.com/casu-18.html
--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.
"Stapes" <steve.staple@gmail.com> wrote in message
news:1176818575.593137.109550@d57g2000hsg.googlegroups.com...
>
> I am printing a report of Items Ordered in response to a mailshot. If
> there are any Advance Orders for books not yet in print, a subreport
> is included with the detail line. I am then trying to add the total of
> books ordered to the total value of advance orders. Can I tell from my
> main report if my subreport has data in it? I have tried using IsNull
> on one of the fieldnames, but I get #Error or #Name.
|
|
|
0
|
|
|
|
Reply
|
Allen
|
4/17/2007 4:04:18 PM
|
|
|
1 Replies
159 Views
(page loaded in 0.442 seconds)
Similiar Articles: Subreport On No Data event - microsoft.public.access.modulesdaovba ...I have a report with a subreport. Sometimes the subreport has data and sometimes it does not. If the subreport has no data, I want the lblAdditio... Display "No details" if subreport has no records ...I've got a report that has group headings which may or may not have detail information (in a subreport). I've got the subreport Can Shrink set to T... hide label in subreport within report - microsoft.public.access ...I have a report which utilizes a subreport for the information. within the subreport is a textbox named "InTol". If the textbox has "IN", I need to ... Subreport messing up spacing of report - microsoft.public.access ...Hi everybody. I have a report problem that I cannot figure out. I have a subreport in the body section of my report that is causing some big proble... My subreport shows in total report, but does not print ...I labored long and hard to create a subreport within my usual monthly customer statement, for a certain group of clients that need specific inform... Subreport columns not showing - microsoft.public.access.reports ...The simplest way to do this is to more your column head labels out of the subreport, and onto ... Do not display subreport if no data ... want is for the subreport Report ... Conditional SubReports - Case statement to print one of two ...OTOH, your statements in this post do seem incinsistent to ... In the subreport On No Data even I ... on the report that ... microsoft.public.access... the problem in ... show "None" when no data in the sub-report - microsoft ...Display "No details" if subreport has no records ..... show "None" when no data in the sub-report ... Do not display subreport if no data ... want is for the subreport ... Subreport always appears blank (even during basic testing with no ...I have a subreport in my report that takes a set of basic parameters. It does not appear on my main report when the main report is run. As a test,... Can Shrink - many subreports - microsoft.public.access.reports ...Display "No details" if subreport has no records ... I've got a report that has group headings which may or may not have detail information (in a subreport). Showing SQL Subreport even when no data is returned.: subreport ...Hello, I'm writing a sql reporting services report that has a subreport. The subreport is a table that pending on what data is passed in may or not show ... Microsoft: Access Reports - Subreport has no data - Print 'No data ...I've tried what was shown, but I can't get the message to show up. I put a textbox in the subreport header as the answer suggested, with the following source: Re: Hide Subreport With No Data - GrapeCity06-28-2007, 11:49 AM My company wants to hide a subreport if it has no data, so that subreport labels don't even appear. How can this be done? Way to hide subreports based on item existing in a data set.The idea is there would only be one row when data is available and no rows when no data is available so the subreport would not appear. When the data is ... How to suppress the subreport when there is no data in it ...Since there is no way to pass value from subreport to the main report, how to suppress the subreport when it is blank? Thanks. Oh, by the way I found an easy way to ... 7/17/2012 2:26:20 PM
|
|
|
|
|
|
|
|
|
Search |
Post Question |
Groups |
Stream |
About |
Register
71 followers. 