Home

Products
       NCAA Tourney
       Loan Calculator
       Text / HTML Versioner
       HTML Fader
       HTML Scheduler
       SQL Reporting Services
       MySkype

Support & Forums
Friday, September 03, 2010 You Are Here: Support & Forums  | 
Welcome to Module Masters support forums - the primary support mechanism for our products. Feel free to post your questions, and we will aim to respond in a timely manner.  We also encourage our users to post any feedback you may have.  You may also email us directly at service@modulemasters.com
Forums > Module Masters Forum > SQL Reporting Services
Subject: query string & selecting a report
Prev Next
You are not authorized to post a reply.

Author Messages
mmolterUser is Offline

Posts:12
10/17/2008 13:05  

I read in the features that you are able to submit a query string to the module and get it to display a report.  I have a few questions on how to implement this feature.

1.  what is the correct format of the querystring/url in order for the module to display a specific report whose name is put into the query string?  http://domain/???????

2.  When sending via query string will the module accept various parameters that might be in the url? 

3.  How does the module choose which reporting services connection to use when rendering a report sent to it via a query string? 

4.  Is there a way for it to automatically render an export option?  So if I sent in the url command render pdf ... when the user gets sent to that page will it just pop up with the pdf format.  (or the option to open or save via adobe). 

thx.  Product looks great so far now that we got that web.config sorted out. 

 
hostUser is Offline

Posts:449
10/17/2008 16:33  
Ok, to answer the questions:

1) Check the documentation which was in the zip, here is an example of passing the specific report to run via the URL:

http://server/dnn/page/tabid/54/Default.aspx?ItemPath=/Repository Folder/ReportName&EnumType=Report

2) Yes, you can put parameters in the querystring, here's an example from the doc...the trick here is to make sure that your parm names match exactly...e.g. how you defined it in the report should match how it is passed, e.g. the report below would have parameters called Parameter1 and Parameter2 in it and it'd get these values:

http://server/dnn/page/tabid/54/Default.aspx?Parameter1=11/14/2006&Parameter2=11/20/2006&ParameterBar=False

3) The report server is configured per instance of the module, you'd have to only have 1 instance of a module on a page for it to work properly if you wanted to link to it.

4) Excellent idea, should be doable, will put it on roadmap for the next version.

Hope this helps.
mmolterUser is Offline

Posts:12
10/17/2008 20:08  

Sorry, I figured it was probably in the documentation, but we are still using the demo and I didn't see it in there.  Thanks for the info, that helps a lot.  We'll be purchasing your product, so if you could add render part into the roadmap we will definitely use it. 

Thanks. 

hostUser is Offline

Posts:449
10/17/2008 20:14  
Good deal, will definitely add it to the list of options, surprised nobody has requested it yet.
mmolterUser is Offline

Posts:12
10/17/2008 20:43  
also, we are having a bit a trouble trying to do both 1 & 2 at once. Do they need to go in certain order?
mmolterUser is Offline

Posts:12
10/17/2008 20:57  
Dont' worry about it yet, I'll play around a little bit. It seems to work for some reports and not for others. Thanks for all the help.
hostUser is Offline

Posts:449
10/17/2008 21:00  
It should work, the only issue may be if you are using parameters of PortalId or UserId, you need to check the box to allow them to be sent via the URL if you are trying to do that.
mmolterUser is Offline

Posts:12
10/17/2008 21:06  
Got it, it was the report design not your mdoule. Great product exactly what we needed especially now that sql 2008 doesn't allow anonymous access.
hostUser is Offline

Posts:449
10/17/2008 21:07  
Thanks for the feedback and your business!
You are not authorized to post a reply.
Forums > Module Masters Forum > SQL Reporting Services > query string & selecting a report


ActiveForums 3.7
Copyright 2005 by Module Masters Privacy StatementTerms Of Use