I have Created one SSRS report with dependency between two parameters. One Parameter is having Dropdown of All Managers and another parameter is Employees dropdown which populates on selection of Particular Manager.
Now I want to use this Report in Kentico CMS. So I have Created New webpart to display the Report. Custom Webpart is used in CMS desk so it is Inheriting class "CMSAbstractWebPart".
CMSAbstractWebPart does not allow to add Report Viewer as Control so I have to dynamicaaly add REportviewer on Page Load Like below
ReportViewer() ReportViewer1 = new ReportViewer(); reportViewer.Controls.Add(ReportViewer1);
Since on each selection page is reploading and control is getting added on page load i have written this code in Page_init
Issues facing: 1) Now when I am select any Manager then Employees related with selected Manager gets Populated but View Report button is No More working untill I reload the page.
2) Report is also having two date filters. It is not showing calendar in Google Chorme but is showing Mozilla Firefox.
Please suggest some solution to make it work along with Dependent Parameter
the main issue is that ,"CMSAbstractWebPart does not allow to add Report Viewer as Control".
so as a work around you add the report viewer dynamically.
which solves your issue but creates another issue.
1) Now when I am select any Manager then Employees related with selected Manager gets Populated but View Report button is No More working untill I reload the page.
do you have events that get executed when you try to change the value or select the value from combobox.
try to use that event to load the report dynamically.
then you not need to again reload the page to load the report.
your second issue is totally depends upon the browser.
try to make a test with chrome browser that in normal condition it shows the calendar or not.
if it is not showing then it will also not display when you load report dynamically.
kushalpudale
None
0 Points
1 Post
Using Report Server with Kentico CMSDesk
Jul 03, 2017 09:09 AM|kushalpudale|LINK
I have Created one SSRS report with dependency between two parameters.
One Parameter is having Dropdown of All Managers and another parameter is Employees dropdown which populates on selection of Particular Manager.
Now I want to use this Report in Kentico CMS. So I have Created New webpart to display the Report.
Custom Webpart is used in CMS desk so it is Inheriting class "CMSAbstractWebPart".
CMSAbstractWebPart does not allow to add Report Viewer as Control so I have to dynamicaaly add REportviewer on Page Load Like below
ReportViewer() ReportViewer1 = new ReportViewer();
reportViewer.Controls.Add(ReportViewer1);
Since on each selection page is reploading and control is getting added on page load i have written this code in Page_init
Issues facing:
1) Now when I am select any Manager then Employees related with selected Manager gets Populated but View Report button is No More working untill I reload the page.
2) Report is also having two date filters. It is not showing calendar in Google Chorme but is showing Mozilla Firefox.
Please suggest some solution to make it work along with Dependent Parameter
Deepak Panch...
Participant
1830 Points
627 Posts
Re: Using Report Server with Kentico CMSDesk
Jul 06, 2017 09:02 AM|Deepak Panchal|LINK
Hi kushalpudale,
the main issue is that ,"CMSAbstractWebPart does not allow to add Report Viewer as Control".
so as a work around you add the report viewer dynamically.
which solves your issue but creates another issue.
1) Now when I am select any Manager then Employees related with selected Manager gets Populated but View Report button is No More working untill I reload the page.
do you have events that get executed when you try to change the value or select the value from combobox.
try to use that event to load the report dynamically.
then you not need to again reload the page to load the report.
your second issue is totally depends upon the browser.
try to make a test with chrome browser that in normal condition it shows the calendar or not.
if it is not showing then it will also not display when you load report dynamically.
Regards
Deepak