This is a migrated thread and some comments may be shown as answers.

How to custom the export method

9 Answers 381 Views
General Discussions
This is a migrated thread and some comments may be shown as answers.
Yuki Wong
Top achievements
Rank 1
Yuki Wong asked on 06 May 2010, 06:34 AM
Dear All,
I have two problems with telerik reporting, could anyone give me some helps?
  1.How to hide the row(s) in a table(each rows have more than 1 columns)
  2.How to custom the export method for exporting the data to Excel/PDF file.


best wishes.

9 Answers, 1 is accepted

Sort by
0
Yuki Wong
Top achievements
Rank 1
answered on 10 May 2010, 07:02 AM
Anybody helps me ?

0
Peter
Telerik team
answered on 10 May 2010, 03:17 PM
Hi Yuki Wong,

You have to use a Filter to hide rows (regardless of the column count). For more information check out How-To: Add filtering to Table item and Crosstab item help article.

As to your second question we are not sure that we have correctly understood you. If you want to Export a Report Programmatically  you can use the RenderReport method of the ReportProcessor object. This method converts the contents of the report to a byte array in the specified format, which you can then use with other classes such as MemoryStream or FileStream.

Regards,
Peter
the Telerik team

Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Public Issue Tracking system and vote to affect the priority of the items.
0
Yuki Wong
Top achievements
Rank 1
answered on 14 May 2010, 07:20 AM

Thks for reply.

For the first question.  I want to control a specific row.  Currently we use filter only can filter the dataset or the table.  Not for a row in the table.  So how to hide a row in the table?

For the second question:
I want to customize the export event.  I want to define some operation on the export event, how to do that?
I have a table which has the url link as the table content.  When I export it to a file, currently the exported file has the url link information plus the record content.  I want to delete the url link information and only keep the table content.  so how to do that.
      for example,   ABC is the record, it is a link to http://www.abc.com,  currently the exported file has: http://www.abc.com ABC.  I want only ABC in my expored file.  so how to delete the url information.
0
Yuki Wong
Top achievements
Rank 1
answered on 17 May 2010, 02:25 AM
up again:(, waitting...
0
Peter
Telerik team
answered on 19 May 2010, 03:04 PM
Hi Yuki Wong,

We are sorry but we can't understand why don't you use the Filters - when the data is filtered so is the respective Table item row. If you want to hide conditionally a row's TextBox item you have to use  Conditional Formatting. To avoid further confusion please elaborate and/or send us a screenshots/project that illustrates your goal.

As to your second question Telerik Reporting doesn't support any export events, but as noted in the Roadmap - Q2 2010 will be the first Telerik Reporting version to provide interactive reports, by allowing end users to drill through reports and subreports, to jump to other sections in a report, and to go to external web URLs. This functionality will be provided by using hyperlinks. Thus, the reporting engine will take care for cases like yours.

Best wishes,
Peter
the Telerik team

Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Public Issue Tracking system and vote to affect the priority of the items.
0
Yuki Wong
Top achievements
Rank 1
answered on 21 May 2010, 03:52 AM
thks!

For my question, pls see the attach file.

best wishes.
0
Peter
Telerik team
answered on 26 May 2010, 11:58 AM
Hello Yuki Wong,

Thank you for the screenshoot.

To achieve the requirement shown in the screenshoot you have to set a Conditional Formatting with Style's Visibility property set to False for the TextBox items in the Table rows. 

As for the export method, you can't change the report prior exporting to PDF. As I have explained in my last answer - in Q2 we will introduce functionality that will handle links.

All the best,
Peter
the Telerik team

Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Public Issue Tracking system and vote to affect the priority of the items.
0
Yuki Wong
Top achievements
Rank 1
answered on 29 May 2010, 05:55 AM
thks,but i am sorry, i haven't know how to do it( for issue 1),
could u give me a sample?

best wishes.
0
Peter
Telerik team
answered on 02 Jun 2010, 02:46 PM
Hi Yuki Wong,

It looks like the most fluent way to achieve the desired effect to hide the whole group if there is no data by setting a Group Filter. If the data is filtered so is the whole group we have attached a small video and the CrossTab report demo that demonstrates how this can be achieved. 

We hope this helps. If you need additional directions/assistance please send us a small sample project with some dummy data, so we can further advise you on your concrete case.

Regards,
Peter
the Telerik team

Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Public Issue Tracking system and vote to affect the priority of the items.
Tags
General Discussions
Asked by
Yuki Wong
Top achievements
Rank 1
Answers by
Yuki Wong
Top achievements
Rank 1
Peter
Telerik team
Share this question
or