Counting items on the page... - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

Development Tools

Reporting Services Development

Counting items on the page...

Author

Topic

GunZ
Starting Member

29 Posts

Posted - 2005-01-31 : 22:01:43

Does anyone know how to count the number of items in the page and print it on a page summary? or maybe a hidden textbox to hold a value for computation?

for example, the page footers on page 1, 2 and 3 should say


there are 21 items of item A on page 1
there are 11 items of item B on page 1
there are 38 items of item C on page 2
there are 20 items of item D on page 3

at the end of the report, it should say



there are a total of 90 items in the report, the breakdown as follows:
21 items of A
11 items of B
38 items of C
20 items of D

Australia.NSW.Sydney.GunZ

EDIT: changed the result

GunZ
Starting Member

29 Posts

Posted - 2005-02-03 : 22:20:51

Anyone?

Australia.NSW.Sydney.GunZ

GunZ
Starting Member

29 Posts

Posted - 2005-02-10 : 18:21:39

Please?

Australia.NSW.Sydney.GunZ

MichaelP
Jedi Yak

2489 Posts

Posted - 2005-02-10 : 18:45:57

Sounds like you want some sort of Group By / Summary thing. I suspect getting what PAGE they are on is gonna be tough.

Michael

<Yoda>Use the Search page you must. Find the answer you will.</Yoda>

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2005-02-10 : 18:50:01

You can get the page number from Globals!PageNumber. To get the counts though, I think you are going to have to do that inside a query. Then you'd have another table in the report that points to this query that contains the information that you need.

Tara

GunZ
Starting Member

29 Posts

Posted - 2005-02-10 : 22:38:17

quote:
Originally posted by MichaelP

Sounds like you want some sort of Group By / Summary thing. I suspect getting what PAGE they are on is gonna be tough.

Michael

<Yoda>Use the Search page you must. Find the answer you will.</Yoda>

So you're suggesting that from the result set of the query, I'll add another column to find out what page it will go to? Yes, that's tough

. And what if the user changes paper size (as in from A4 to Letter)? Does that mean I'll have to populate teh column dynamically just for this report?

Australia.NSW.Sydney.GunZ

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2005-02-11 : 12:32:42

I was suggesting a whole nother query. But yes that would be difficult to get if they changed paper sizes. It doesn't seem RS can do this for you.

Tara

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources