Getting total number of records

[NingImport]

Getting total number of records

Posted by Rob Glassman on April 5, 2010 at 4:16am

I would like to print the number of records in the report...
How would I do that? Can this be accomplished?

Thanks!
Rob

=====

Reply by Jan Schenkel on April 6, 2010 at 8:03pm

Hi Rob,

It depends a bit on where you want to print it. If you only want to print it at the end, in a 'Summary' section, you can put a data field there with expression '1' + aggregate function 'Count' + reset 'End of report' (this is also the easiest way to print the number of records in a data group as part of the data group footer).

Other than that, you can always put the number of records beforehand into a global variable, and then use that global in your data field expression.

HTH,

Jan Schenkel
--
Quartam Reports & PDF Library for Revolution
www.quartam.com

=====

Reply by Rob Glassman on April 6, 2010 at 9:04pm

Thanks! That worked!

=====

Reply by Rob Glassman on April 6, 2010 at 9:13pm

Thanks for responding. That worked!

One more question:
When I try to run the report, I get an error "Group: bad object type"
I run it a second time, and I get the same error.
On the third run, it runs perfectly.
I added in the data field as you said in your last message. The error occurred after adding a graphic to the header and I also added a label "No. of inquiries sent" to the Summary next to the record data field.

Any ideas?

=====

Reply by Jan Schenkel on April 6, 2010 at 9:27pm

Hmm, that is an odd error, indeed. Does it happen again if you quit and re-open Revolution ?
And if so, could you send the layout file and a minimal script to simulate to support@quartam.com ?

TIA,

Jan Schenkel
--
Quartam Reports & PDF Library for Revolution
www.quartam.com