| Author |
Topic |
|
sankalp.singhal
Starting Member
9 Posts |
 Posted - 2009-09-25 : 08:50:47
|
| Hi,I am generating the PDF and excel export files using below code ReportViewer1.LocalReport.Render( reportType, deviceInfo, out mimeType, out encoding, out fileNameExtension, out streams, out warnings);I also have a row whose visibility is toggled by another text box. The issue is when i do the export, the visibility of the textbox doesnt remain in sync with the on screen toggle action. That is even when the user toggles the visibility to false, in exported PDF it appears.Please suggest any possible workaround.Thanks in Advance,Sankalp Singha; |
|
|
JCirocco
Constraint Violating Yak Guru
392 Posts |
Posted - 2009-09-25 : 09:01:10
|
| by any chance is the default on the report set to Initial Visibility=Visible? I had that issue once before where the ontrols became "confused" but only on the rows set that way.John |
 |
|
|
sankalp.singhal
Starting Member
9 Posts |
Posted - 2009-09-25 : 09:14:51
|
| Initial Visibility of the row has been set as Visible, however for the report i couldnt locate the option of setting the default visibility.Please let me know if require any other information. I tried to attached the screenshot, however it seems that i dont have the access to attach that. |
|
|
|
JCirocco
Constraint Violating Yak Guru
392 Posts |
Posted - 2009-09-25 : 09:21:58
|
| Assuming this is a standard tabular report? Select the row with the that is not functioning properly. In properties box look for the Visibility section and expand it. It probably says Visibility FALSE and has a Toggle Item of another field on your report. If that is correct, change the Visibility to True and by default the report starts with that row hidden.John |
|
|
|
sankalp.singhal
Starting Member
9 Posts |
Posted - 2009-09-25 : 10:52:05
|
| Thanks John for your reply..let me explain it clearly..No matter what is specified in Visibility property, even when i mention it false, on screen its false. Ok let me explain step by step1) Visibility of the row is false(initially)2) On Screen it is false3) On Export its false4) When toggle is done to make it visible5) On Screen it becomes visible6) Whereas in export it is still false, which it shudnt...Please let me know if you get the issue...thanks again |
|
|
|
JCirocco
Constraint Violating Yak Guru
392 Posts |
Posted - 2009-09-25 : 11:54:43
|
| When you create a PDF outside of the report viewer, you will get the default visibility of how the report is designed. I just created a subscription and ran it against a report that by default has all detail hidden and all the rows are hidden like your problem. A good way to test this is to view the report from within the report viewer, expand/toggle the rows to be visible and click the extract button. You can also change the default to have them start out visible so your export option works.John |
|
|
|
sankalp.singhal
Starting Member
9 Posts |
Posted - 2009-10-09 : 14:08:18
|
| So does that mean user would not be able to export the current snapshot of the report. Meaning in exported excel, the default state of that row would appear i.e either visible or invisible depeneding upon the initial setup of the report irrespective of the onscreen toggling done by the user.For Ex:-If there is a row(say row D) on which toggling has been set, if the default Visibility is True of row D. Now user opens the report and click on the toggle button, as a result of that now the row D becomes invisible, if the user exports the data in Excel, the row D would always become visible, even though onscreen user has toggled its visibility to false?Just for more inofmration on this, this is working fine when i export in PDF, problem exists in Excel export only.Please provide your valuable inputs on this. This is really urgent.Thanks,Sankalp Singhal |
|
|
|
JCirocco
Constraint Violating Yak Guru
392 Posts |
Posted - 2009-10-10 : 08:44:24
|
| Sankalp, If by the "current snapshot" you mean that the user is viewing the report through the Report Viewer and has expanded the rows, clicks export to Excel and they do not appear expanded? Then you definitely have a problem as that should work. Not sure where else to direct you. Sorry?But if you are using another method such as the code you initially posted in your first question, then I believe it will use the default state of visibility.John |
|
|
|
sankalp.singhal
Starting Member
9 Posts |
Posted - 2009-10-10 : 15:20:40
|
| John,I am facing this issue irrespective of the mode i chose to export the data(internal or external).The only strange thing is that it is working fine in PDF export whereas the problem is faced while exporting data into excel format only.Can you guess any possible reasons where the things might be going wrong.Thanks,Sankalp Singhal |
|
|
|
JCirocco
Constraint Violating Yak Guru
392 Posts |
Posted - 2009-10-10 : 17:30:27
|
| When you export to excel do you see the toggle plus signes in left margin? I am on Excel 2008 and all the functionality to toggle is active in Excel and exports as the original defaults. BUT you can still click the plus sign in Excel to expand. Unfortunately I am not at work and don't remember the Excel option to view. I think it was Sub-Totals.John |
|
|
|
sankalp.singhal
Starting Member
9 Posts |
Posted - 2009-10-11 : 03:54:14
|
| No John, i do not see +/- signs in exported EXcel file, even these signs are not visible in PDF as well.I do not realize that Toggle feature is supported in Excel, if it is then it would be great for our client.Can you please share details on this, whenever you are back to work?Thanks in advance,Sankalp Singhal |
|
|
|
JCirocco
Constraint Violating Yak Guru
392 Posts |
Posted - 2009-10-11 : 09:42:24
|
| I will but do not get back there till tomorrow which will be Monday late afternoon for you.John |
|
|
|
sankalp.singhal
Starting Member
9 Posts |
Posted - 2009-10-12 : 02:24:49
|
| No Problem, but please let me know the solution whenever you can.Thanks in Advance...Regards,Sankalp |
|
|
|
JCirocco
Constraint Violating Yak Guru
392 Posts |
Posted - 2009-10-12 : 08:08:44
|
| Sankalp< I am using Office 2007, MS SQL Server 2005. When I export a report that is either a Matrix or normal Table that has Row Visibility tottles defined and then export to Excel, both types automatically create what my version of excel calls Groups. Maybe it is possible to turn off the Group function but I don't recall that option. You may also see something labeled Auto-Outline. In my tests, what ever state your line toggles are, is how they are exported but I still have the ability to click a plus (or minus) sign to the left of the row number. What version of Excel and Reporting Services are you running?John |
|
|
|
JCirocco
Constraint Violating Yak Guru
392 Posts |
Posted - 2009-10-12 : 08:12:22
|
| Sankalp, You may also want to check your "View" settings in excel. If defaults to outline or print preview that may also hide the toggles. Also, I am using the standard report viewer and exporting using the standard interface.John |
|
|
|
sankalp.singhal
Starting Member
9 Posts |
Posted - 2009-10-12 : 08:15:17
|
| John,I was esgerly waiting for your reply. Thanks for replying.I am using Report Viewer Control in asp.net and MS SQL Server 2005. Office is 2007..is it possible for you to send me your sample .rdlc and exported excel file.Or if you require any other info please let me know. Thanks..Sankalp |
|
|
|
sankalp.singhal
Starting Member
9 Posts |
Posted - 2009-10-12 : 09:29:33
|
| View Settings are set as 'Normal' in Excel. Can you send me your .rdlc file and eported excel. Thanks again,Sankalp |
|
|
|
|
Toggle state not working when doing export