Repeating .rdlc chart in vb.net 2005 winforms project

[Steve]

Hi All

Using VB.net 2005 to create reports using MS Report Viewer

I create a .rdlc file with a graph component on it

It is Graph object I am sending data to, on the .rdlc file, to show a bar
graph of products and their total qty sales
x axis is Product, y axis is qty sales

I need to be able to repeat the graph on multiple pages of the report if the
number of Products is > 40, otherwise the graph crunches the Product names
up making them illegible

First Graph (page 1) shows Products 1 to 40
2nd graph (page 2) shows Products 41 to 80
and so on

Is there any way to have the report graph object repeat the graphs as
additional pages, as the Table object does
e.g page 1 has products 1 to 40, page 2 has products 41 to 80 etc

OR

Is there a way to pass the data to the report in chunks of 40 rows and still
have the 1 report but multiple pages


Regards
Steve

 

[Steven Cheng[MSFT]]

Hi Steve,

Regarding on this issue, I've tested more and replied you in the previous
thread, here is my reply here:

============
I originally misunderstood the graphic object you mentioned( I opined that
it is an image). So the graphic object is also an report item(a bar chart
on the report). If so, I think to make a chart (report Item) repeat on a
report(according to the data supplied), you should use a List instead of
Table. Based on my test, the List ReportItem can contains other reportitem
such as Chart. Thus, you can use List to display the main report records
and also include a barchart in the List. And this barchart will repeat in
the list for every record. Also, by default, the chart (in the list) will
be displayed for each record, thus, it may also require you to investigate
more on how you will define the paging(the group you'll define for paging )
================

the things I've tried is using a List to display the main records and put a
chart in the List. Thus, the chart will repeat in the list for every
record, to make the repeat behavior change, you may try changing the group
setting that will affect the paging according to your actual data. Anyway,
this is a potential workable approach.

Sincerely,

Steven Cheng

Microsoft MSDN Online Support Lead


This posting is provided "AS IS" with no warranties, and confers no rights.
--------------------

 

[Steve]

Hi Steven

Thanks for the help

The Chart repeats OK in the list object

Problem I have is how to Group on number of Items = 40 per page

Grouping on Fields!item.value results in 1 Product per chart per page

I want to have up to 40 items per chart per page, so the chart is legible

Any help appreciated

regards
steve

 

[Steven Cheng[MSFT]]

Thanks for your reply Steve,

My original thought was group by a calculated value. e.g.

group by Value / 40 or Value Mod 40 or something else

Sincerely,

Steven Cheng

Microsoft MSDN Online Support Lead


This posting is provided "AS IS" with no warranties, and confers no rights.

--------------------

From: "Steve" <[email protected]>
References: <#[email protected]>

Subject: Re: Repeating .rdlc chart in vb.net 2005 winforms project
Date: Tue, 12 Feb 2008 07:14:38 +0900