Reporting Services or Report Viewer control

This forum is only for questions or discussions about working with the mojoPortal source code in Visual Studio, obtaining the source code from the repository, developing custom features, etc. If your question is not along these lines this is not the right forum. Please try to post your question in the appropriate forum.

Please do not post questions about design, CSS, or skinning here. Use the Help With Skins Forum for those questions.

This forum is for discussing mojoPortal development

This forum is only for questions or discussions about working with the mojoPortal source code in Visual Studio, obtaining the source code from the repository, developing custom features, etc. If your question is not along these lines this is not the right forum. Please try to post your question in the appropriate forum.

You can monitor commits to the repository from this page. We also recommend developers to subscribe to email notifications in the developer forum as occasionally important things are announced.

Before posting questions here you might want to review the developer documentation.

Do not post questions about design, CSS, or skinning here. Use the Help With Skins Forum for those questions.
This thread is closed to new posts. You must sign in to post in the forums.
5/5/2011 7:56:08 AM
Gravatar
Total Posts 12

Reporting Services or Report Viewer control

Hi,

First time user of mojoPortal and so far really liking what i see. I'm wondering if it's possible you use a report viewer control on a page or to link to a reporting Services site?

Any help or suggestion appreciated.

Thanks

Bert

 

5/5/2011 11:39:59 AM
Gravatar
Total Posts 18439

Re: Reporting Services or Report Viewer control

We don't have anything built in for that but anything that can be done in ASP.NET can be done in mojoPortal. You could certainly develop a feature with a report viewer control or links to a reporting service site.

Probably a good place to start is with our Hello World Tutorial that can help you get a custom usercontrol onto a page and you could embed a reportviewer control in your usercontrol

Hope that helps,

Joe

5/6/2011 12:57:11 PM
Gravatar
Total Posts 115
mojoPortal Community Expert

Re: Reporting Services or Report Viewer control

If you are talking about the using the report viewer control for use with SSRS then creating a user control that Joe referred too is easily done. I am currently using that same setup for one of my customers that use MojoPortal for their salesperson portal and all reports are developed with SSRS.

5/7/2011 5:00:14 AM
Gravatar
Total Posts 12

Re: Reporting Services or Report Viewer control

Joe,

Thanks have went through the tutorial but can't seem to get the report viewer to display.

Anvil,

Can you please advise how you implemented it I'm having a few issues getting the report viewer to even display when I put it in the user control. Is it also possible to pass parameters based on a Querystring? I've done this using a webforms implementation not sure if the process is the same for the usercontrol.

Thanks

Bert

5/7/2011 7:29:12 AM
Gravatar
Total Posts 18439

Re: Reporting Services or Report Viewer control

You might want to look in the log under Administration > System log if it fails to load your module because of errors it will log the error details.

I would avoid using query string params on a CMS page plugin because it loads in a page where other features may also be loaded. It is fine to use query string params in supporting pages. 

If I were working on something like this what I would do is make the module part of the feature ie the UserControl that plugs into the CMS page to be just a list of reports, the list would link to a supporting page and the links would pass the pageid moduleid (&mid=) and your own custom params to the supporting page in the url.

Then in the supporting page you would host the report viewer and use whatever logic based on the parameters to configure it.

The Hello World tutorial doesn't really cover supporting pages, but I know it is covered in the Guest Book tutorial video series. It is well worth watching these to get up to speed for custom development, there are quite a few of them but each one is less than 10 minutes long. The hello world approach is the quick and dirty approach whereas the Guest Book tutorial teaches how to do a more professional approach with custom projects and code behind instead of inline code like in the hello world example.

And of course the mojoPortal source code is also rich with code examples for most common tasks and can be a good reference for building custom features.

Hope that helps,

Joe

5/9/2011 12:07:05 PM
Gravatar
Total Posts 115
mojoPortal Community Expert

Re: Reporting Services or Report Viewer control

I would recommend that you first get the report viewer working in a normal user control outside of mojoPortal. I can tell you from my experience that I did not run into any problems using the report viewer on a user control, but each situation is different.

One item that might cause some issue is you security setting in SSRS. If you can elaborate on the issues you are having I will try to help.

You must sign in to post in the forums. This thread is closed to new posts.