Hello,
I have a create a report in which there will be dynamic number of columns. How can I add dynamic columns in a report and if the report size gets wider than the page size then the first two columns should repeat on the next page and the dynamic columns should start from the next after what is displayed on the first page.
What makes this report tricky is that is has to page not only on rows but on columns. For example the dynamic columns of type is "Room Type" with columns "K-1A" through "DD-1B" on one page. And If there are more room types, I need to create a second page with the same rows but with the additional room types. The header of Room Type(The dynamic column should be dynamic also)
For the deatiled view of report please see the following link:
http://picasaweb.google.com/lh/photo/lVd31YDancIyTPORZrwPaQ?feat=directlink
- In the above link Item Code and description should repeat on the next page and the columns "K-1A"-"K-5A" are on one page and other columns should be on other page with the "Item code" and "description" repeat on the next pages too.
- The next question is how can I add the columns dynamically with dynamic headers.
Hope my problem is clear in these words.
Please reply as I have to deliver my report as early as possible.
Thanks
Yuvika
5 Answers, 1 is accepted
We've already answered your inquiry in the "Paging report on row and column" forum thread. We also noticed that you are opening similar threads from two different accounts. Please note that opening multiple threads does not guarantee a faster response (reply on forums is not guaranteed although we try to answer all of them), on the contrary, multiple threads only slow us down.
Thank you for the understanding on the matter.
Greetings,
Steve
the Telerik team
Instantly find answers to your questions on the new Telerik Support Portal.
Check out the tips for optimizing your support resource searches.
Rank 1
I have achieved this by adding the rows and columns dynamically(now whole report is created dynamically adding boxes to display data).And when the page width is over I add a new column to be repeated in my .net datatable and finally when my data table is ready, I create a number of columns in the report as in datatable,this may be repetition of columns that I want to add on next page.This gives me correct result in PDF, but not on webpage.
Just the problem left is that the repeated columns are visible in webpage as the webpage does not add page break to report after the page width is over and sufficient columns have accomodated the report width, this only is valid for PDF and other media to display the report. But the webpage viewer, add the scrollbar, if the report width increases the width set in pagesettings. Can I accomodate it that, even if, the user view report in explorer, the report page should break according to the width in page settings, else the report shows the repeated columns.
Page settings are done by followng code :
Telerik.Reporting.
Report report1 = new Telerik.Reporting.Report();
Telerik.Reporting.Drawing.
PageSettings pageSetting = new PageSettings();
Telerik.Reporting.Drawing.
SizeU papersize = new SizeU(Unit.Inch(8.5), Unit.Inch(11));
Hope I am clear in my words.
Please Reply.
Thanks
Yuvika
As explained in the Design Considerations for HTML Rendering help article, html is not a page oriented format and it has no definition for how long it can stretch on width and height. Once the report is rendered it has already taken into account the specified papersize and page settings from the report PageSettings. They cannot be altered dynamically, without having to re-render the report from scratch as the whole layout would change.
Kind regards,
Steve
the Telerik team
Instantly find answers to your questions on the new Telerik Support Portal.
Check out the tips for optimizing your support resource searches.
Rank 1
Ok, I will try to get the information when the report is being rendered that it is rendered as which format. If the report is rendered as webpage then I will not add any new columns in the datatable, else for PDF view I wll add new columns in the report.
Can u plz help me to identify whether the report is being rendered in PDF format of in viewer.
I read about the following method but this exists in windows forms only and I am using web.
private void reportViewer1_RenderingBegin(object sender, System.ComponentModel.CancelEventArgs e)
event is not there in web report viewer.
How can I judge the rendering of the report at runtime.
Thanks for the constant support.
Thanks,
Yuvika
I know that you have been working on this report for a while. If I have understood your needs correctly (the picture from the 1st post) it seems that you are trying to create a cross table. It is my pleasure to inform you that starting with the new 2009 Q1 release Telerik Reporting has got native support for Table/Crosstab. For more information on the new features please check out the product's What's new page. If you haven't seen the new features in action you will find the new demos very interesting. Please note the Product Sales Per Period demo report that demonstrates a crosstab similar to the one you are working on.
To get started with the new Table item I would suggest to see the introduction video and Understanding the CrossTab/Table/List report items help article.
Best wishes,
Svetoslav
the Telerik team
Instantly find answers to your questions on the new Telerik Support Portal.
Check out the tips for optimizing your support resource searches.