Report pagination for charts

Hi,

We have developed few reports displaying data using chart layout. In the Data tab, we have specified MDX query that will return top 10 records.

But now, instead of restricting to just top 10 records, we would like to display all records and go in for pagination.

Is there some setting in the chart properties, where in I can display the first n records in first page, and the next n records( if available) in the next page and so on?

Can I specify the value of n somewhere in the propeties?

I read through many posts regarding pagination but those couldn't help me much.

Please help me in solving this problem.

Any help would be appreciated.

Thanks in advance!

No response yet!:(|||

One approach is the following:

Step 1: Add a table to the report
Step 2: Group by a number of rows
Right-click on the table and select Properties. Add a table group (with a group header, but no group footer)
Enter this for the group expression: =Ceiling(RowNumber(Nothing)/10)
This will cause the table to group on every ten rows. So you'll get a separate table group for every ten rows.
Step 3: Add a chart in the table group header
Design your chart.

Note: this approach is similar to the table inline charts approach discussed in the following whitepaper: http://msdn2.microsoft.com/en-us/library/aa964128.aspx

-- Robert

|||

Thanks a lot Robert!

I got the idea from the solution provided by you and did the following:

Step 1: Add a list to the report

Step 2: Added group expression for the list to group the data

Grouping =Ceiling(RowNumber(Nothing)/10)

Set the following properties for list:

KeepTogether: False

PageBreakAtEnd: True

Step 3: Added chart to the list

Set the property, PageBreakAtEnd: True for the chart.

The above steps solved my problem of report pagination for charts.

Thanks once again!

sql

Report pagination for charts

Hi,

We have developed few reports displaying data using chart layout. In the Data tab, we have specified MDX query that will return top 10 records.

But now, instead of restricting to just top 10 records, we would like to display all records and go in for pagination.

Is there some setting in the chart properties, where in I can display the first n records in first page, and the next n records( if available) in the next page and so on?

Can I specify the value of n somewhere in the propeties?

I read through many posts regarding pagination but those couldn't help me much.

Please help me in solving this problem.

Any help would be appreciated.

Thanks in advance!

No response yet!:(|||

One approach is the following:

Step 1: Add a table to the report
Step 2: Group by a number of rows
Right-click on the table and select Properties. Add a table group (with a group header, but no group footer)
Enter this for the group expression: =Ceiling(RowNumber(Nothing)/10)
This will cause the table to group on every ten rows. So you'll get a separate table group for every ten rows.
Step 3: Add a chart in the table group header
Design your chart.

Note: this approach is similar to the table inline charts approach discussed in the following whitepaper: http://msdn2.microsoft.com/en-us/library/aa964128.aspx

-- Robert

|||

Thanks a lot Robert!

I got the idea from the solution provided by you and did the following:

Step 1: Add a list to the report

Step 2: Added group expression for the list to group the data

Grouping =Ceiling(RowNumber(Nothing)/10)

Set the following properties for list:

KeepTogether: False

PageBreakAtEnd: True

Step 3: Added chart to the list

Set the property, PageBreakAtEnd: True for the chart.

The above steps solved my problem of report pagination for charts.

Thanks once again!

Report Page Issue?

I have a report that I developed. When I click the preview tab and see the
report it show's 1 page which is correct. When I click the "Print Preview"
button it shows the 1st page and 3 blank pages after? It also prints this
way.
Why is it doing this?
DavidMake sure that your report satisfies the condition specified below
(Report.PageWidth - Report.LeftMargin - Report.Right Margin) >=Body.Width
Ponnurangam
"Yoshi" <yoshi@.home.com> wrote in message
news:#p5bc4IsEHA.2008@.TK2MSFTNGP12.phx.gbl...
> I have a report that I developed. When I click the preview tab and see the
> report it show's 1 page which is correct. When I click the "Print Preview"
> button it shows the 1st page and 3 blank pages after? It also prints this
> way.
> Why is it doing this?
> David
>|||Ponnurangam,
I thought that was going to solve my problem but it didn't. Thanks for good
info. Do you have any other suggestions?
Thanks,
Davod
"Ponnurangam" <ponnurangam@.trellisys.net> wrote in message
news:eYHybtQsEHA.376@.TK2MSFTNGP09.phx.gbl...
> Make sure that your report satisfies the condition specified below
> (Report.PageWidth - Report.LeftMargin - Report.Right Margin) >=> Body.Width
> Ponnurangam
> "Yoshi" <yoshi@.home.com> wrote in message
> news:#p5bc4IsEHA.2008@.TK2MSFTNGP12.phx.gbl...
>> I have a report that I developed. When I click the preview tab and see
>> the
>> report it show's 1 page which is correct. When I click the "Print
>> Preview"
>> button it shows the 1st page and 3 blank pages after? It also prints
>> this
>> way.
>> Why is it doing this?
>> David
>>
>|||Hi
I have also had the same problem today and have worked out that the white
background with the dots is like the canvas, is the body width and must be
smaller than Report.PageWidth - Report.LeftMargin - Report.Right Margin.
Hope you get my meaning.
Fiona
"Yoshi" wrote:
> Ponnurangam,
> I thought that was going to solve my problem but it didn't. Thanks for good
> info. Do you have any other suggestions?
> Thanks,
> Davod
> "Ponnurangam" <ponnurangam@.trellisys.net> wrote in message
> news:eYHybtQsEHA.376@.TK2MSFTNGP09.phx.gbl...
> > Make sure that your report satisfies the condition specified below
> >
> > (Report.PageWidth - Report.LeftMargin - Report.Right Margin) >=> > Body.Width
> >
> > Ponnurangam
> >
> > "Yoshi" <yoshi@.home.com> wrote in message
> > news:#p5bc4IsEHA.2008@.TK2MSFTNGP12.phx.gbl...
> >> I have a report that I developed. When I click the preview tab and see
> >> the
> >> report it show's 1 page which is correct. When I click the "Print
> >> Preview"
> >> button it shows the 1st page and 3 blank pages after? It also prints
> >> this
> >> way.
> >>
> >> Why is it doing this?
> >>
> >> David
> >>
> >>
> >
> >
>
>|||I finally understand what everyone is saying. Thank you so much!
David P.
"Fiona Harrison" <FionaHarrison@.discussions.microsoft.com> wrote in message
news:40621EF4-C726-4859-935F-53C239980B96@.microsoft.com...
> Hi
> I have also had the same problem today and have worked out that the white
> background with the dots is like the canvas, is the body width and must be
> smaller than Report.PageWidth - Report.LeftMargin - Report.Right Margin.
> Hope you get my meaning.
> Fiona
> "Yoshi" wrote:
>> Ponnurangam,
>> I thought that was going to solve my problem but it didn't. Thanks for
>> good
>> info. Do you have any other suggestions?
>> Thanks,
>> Davod
>> "Ponnurangam" <ponnurangam@.trellisys.net> wrote in message
>> news:eYHybtQsEHA.376@.TK2MSFTNGP09.phx.gbl...
>> > Make sure that your report satisfies the condition specified below
>> >
>> > (Report.PageWidth - Report.LeftMargin - Report.Right Margin) >=>> > Body.Width
>> >
>> > Ponnurangam
>> >
>> > "Yoshi" <yoshi@.home.com> wrote in message
>> > news:#p5bc4IsEHA.2008@.TK2MSFTNGP12.phx.gbl...
>> >> I have a report that I developed. When I click the preview tab and see
>> >> the
>> >> report it show's 1 page which is correct. When I click the "Print
>> >> Preview"
>> >> button it shows the 1st page and 3 blank pages after? It also prints
>> >> this
>> >> way.
>> >>
>> >> Why is it doing this?
>> >>
>> >> David
>> >>
>> >>
>> >
>> >
>>