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
Getting total number of records
-
- Posts:87
- Joined:Sun Jul 18, 2010 5:23 pm [phpBB Debug] PHP Warning: in file [ROOT]/vendor/twig/twig/lib/Twig/Extension/Core.php on line 1275: count(): Parameter must be an array or an object that implements Countable
===== The above post was imported from the old forum hosted at quartam.ning.com =====