PDA

View Full Version : No children, but report parent



JimNC9
12-Oct-2005, 07:09 AM
I have a working attendance report in CR8 that reports a date range. The
customer wants a report of attendance less than a number they input and in
the date range. E.g. If they input 5, the reports shows all who attended 5
times or less (including zero) within the date range. It works when run from
CR, but omits those who did not attend when run from VDF 9.1. Basically it
reports 0-5 from CR & 1-5 from VDF.

The subtotal is suppressed when the attendance in the time period is greater
than the number selected by the user. My guess is since no child record is
found, there is no parent record to report.

How do I fix this?

Jim /*

WebApp Hosting
http://www.advanceddesignsinc.com/Web%20Hosting.htm

Marco
12-Oct-2005, 07:50 PM
Jim,

I dont see in your message if you are using a subreport.
I believe the only way how you can output parents without childs is to
put the parents in the body, and the children in a subreport of a 2nd
Body section.

To then 'transfer' the count of children from the subreport to the main
report, you have to work with sharedvar's

Basically quite simple;
Generate 3 body sections, A, B, C
In the Body A (the parent record) define and place a formula, does not
matter what name, that declares a sharedvar and initialises it, make it
supressed so it does not show in your report

In the body of the subreport (put in section B);
Define another formula, (name again does not matter), and declare herin
the same sharedvar, then add one to it. Make this formula also suppressed.

Then in the Body section C
Create again a formula and put it in the section. Declare again the
sharedvar and output it.

If you need the count of children before section B, create another
section (hidden) between A and B, with a subreport that is just counting
the records.

Good luck,
Marco

Jim Ward wrote:
> I have a working attendance report in CR8 that reports a date range. The
> customer wants a report of attendance less than a number they input and in
> the date range. E.g. If they input 5, the reports shows all who attended 5
> times or less (including zero) within the date range. It works when run from
> CR, but omits those who did not attend when run from VDF 9.1. Basically it
> reports 0-5 from CR & 1-5 from VDF.
>
> The subtotal is suppressed when the attendance in the time period is greater
> than the number selected by the user. My guess is since no child record is
> found, there is no parent record to report.
>
> How do I fix this?
>
> Jim /*
>
> WebApp Hosting
> http://www.advanceddesignsinc.com/Web%20Hosting.htm
>
>

JimNC9
13-Oct-2005, 10:43 AM
Thanks Marco. I'll try your suggestion. I am not using a subreport, but that
sounds like a good solution.

Jim /*

WebApp Hosting
http://www.advanceddesignsinc.com/Web%20Hosting.htm

"Marco Kuipers" <marco.kuipers@nci.com.au> wrote in message
news:ontrlA5zFHA.6080@dacmail.dataaccess.com...
> Jim,
>
> I dont see in your message if you are using a subreport.
> I believe the only way how you can output parents without childs is to put
> the parents in the body, and the children in a subreport of a 2nd Body
> section.
>
> To then 'transfer' the count of children from the subreport to the main
> report, you have to work with sharedvar's
>
> Basically quite simple;
> Generate 3 body sections, A, B, C
> In the Body A (the parent record) define and place a formula, does not
> matter what name, that declares a sharedvar and initialises it, make it
> supressed so it does not show in your report
>
> In the body of the subreport (put in section B);
> Define another formula, (name again does not matter), and declare herin
> the same sharedvar, then add one to it. Make this formula also suppressed.
>
> Then in the Body section C
> Create again a formula and put it in the section. Declare again the
> sharedvar and output it.
>
> If you need the count of children before section B, create another section
> (hidden) between A and B, with a subreport that is just counting the
> records.
>
> Good luck,
> Marco
>
> Jim Ward wrote:
>> I have a working attendance report in CR8 that reports a date range. The
>> customer wants a report of attendance less than a number they input and
>> in the date range. E.g. If they input 5, the reports shows all who
>> attended 5 times or less (including zero) within the date range. It works
>> when run from CR, but omits those who did not attend when run from VDF
>> 9.1. Basically it reports 0-5 from CR & 1-5 from VDF.
>>
>> The subtotal is suppressed when the attendance in the time period is
>> greater than the number selected by the user. My guess is since no child
>> record is found, there is no parent record to report.
>>
>> How do I fix this?
>>
>> Jim /*
>>
>> WebApp Hosting
>> http://www.advanceddesignsinc.com/Web%20Hosting.htm
>>