Report with x items per page. Can't get this to work.

I have a very simple design that is causing a very large headache, and
I was hoping you could point me in the right direction.
All I need is for my report to have some information at the top, a
list of 5 items, and then some information at the bottom. But there
maybe more then 5 items, say 10. So I would need to generate 2 pages
with all the same information at the top and the bottom but the first
page would contain the first 5 lines and the second the next 5 lines.
The number of items would vary anywhere from 1 to 100, so it needs to
start a new page every 5 items.
I'm actually not using a database connection instead I'm using .net
object that contains all the information I need, including the list of
items. Now when I use a table or list and grouping so I can group the
items into chunks of 5, and then use a page break on group end I can
generate the next page, but the next set of items start at the top of
the page not where the list is on layout, and none of my other
information repeats. Now I've also tried using headers and footers
but for some reason it says I can't use "Fields" in the header and
footer sections so the additional information I need to display cant
be put in the header and foot.
This seems like a very very simple report yet I can't get the report
to do what I need.
Any help would be appreciated, Thanx.On Mar 30, 10:31 am, Edgey.Er...@.gmail.com wrote:
> I have a very simple design that is causing a very large headache, and
> I was hoping you could point me in the right direction.
> All I need is for my report to have some information at the top, a
> list of 5 items, and then some information at the bottom. But there
> maybe more then 5 items, say 10. So I would need to generate 2 pages
> with all the same information at the top and the bottom but the first
> page would contain the first 5 lines and the second the next 5 lines.
> The number of items would vary anywhere from 1 to 100, so it needs to
> start a new page every 5 items.
> I'm actually not using a database connection instead I'm using .net
> object that contains all the information I need, including the list of
> items. Now when I use a table or list and grouping so I can group the
> items into chunks of 5, and then use a page break on group end I can
> generate the next page, but the next set of items start at the top of
> the page not where the list is on layout, and none of my other
> information repeats. Now I've also tried using headers and footers
> but for some reason it says I can't use "Fields" in the header and
> footer sections so the additional information I need to display cant
> be put in the header and foot.
> This seems like a very very simple report yet I can't get the report
> to do what I need.
> Any help would be appreciated, Thanx.
Have you tried adding the header and footer information in the
grouping rows (top and bottom rows of the table control (if you're
using any))?
Enrique Martinez
Sr. Software Consultant

Report Two Data Subsets in the same Grid

This is likely very easy, but I'm not sure which direction is the best
way to go...
Dimension:
Time: Date and Hour the record occurred
Cube:
Has a field that counts the number of times an event occurred in a
given hour
I want to show a grid that has for each day of the month how many times
an event occured between 8:00 and 16:00 and from 16:00 to 20:00 hours.
What is the best way to role up the records in the report?
I've seen two possible ways to do it...
1) Use calculated fields with IIF statements to try to role up the
records.
Problem: IIF statement doesn't seem to work correctly.
2) Use a Matrix control to Filter the records correctly.
Problem: I can't seem to have two Filters on the Hour Group in the same
Matrix. One for 08:00 to 16:00 and one for 16:00 to 20:00.
Clearly I'm missing some key concept, because what I'm asking has to be
commonplace. Can someone point me in the right direction?
Thanks,
Paul WI might have missed something, but this is my suggestion:
Create a dataset that returns the number of events in two section, one for
8-16 and the other for 16-20. You should be able to do this with a
calculated member and filter in your MDX query. (No good examples spring to
mind, but you can always ask in the microsoft.public.sqlserver.olap news
group.)
Then create a matrix, and have two coloums (one for each section of the day)
and group on date.
Kaisa M. Lindahl Lervik
"Paul W" <pbwedz@.yahoo.com> wrote in message
news:1155143250.949345.213080@.n13g2000cwa.googlegroups.com...
> This is likely very easy, but I'm not sure which direction is the best
> way to go...
> Dimension:
> Time: Date and Hour the record occurred
> Cube:
> Has a field that counts the number of times an event occurred in a
> given hour
> I want to show a grid that has for each day of the month how many times
> an event occured between 8:00 and 16:00 and from 16:00 to 20:00 hours.
> What is the best way to role up the records in the report?
> I've seen two possible ways to do it...
> 1) Use calculated fields with IIF statements to try to role up the
> records.
> Problem: IIF statement doesn't seem to work correctly.
> 2) Use a Matrix control to Filter the records correctly.
> Problem: I can't seem to have two Filters on the Hour Group in the same
> Matrix. One for 08:00 to 16:00 and one for 16:00 to 20:00.
> Clearly I'm missing some key concept, because what I'm asking has to be
> commonplace. Can someone point me in the right direction?
> Thanks,
> Paul W
>