Products

Solutions

Resources

Partners

Community

Blog

About

QA

Ideas Test

New Community Website

Ordinarily, you'd be at the right spot, but we've recently launched a brand new community website... For the community, by the community.

Yay... Take Me to the Community!

Welcome to the DNN Community Forums, your preferred source of online community support for all things related to DNN.
In order to participate you must be a registered DNNizen

HomeHomeDNN Open Source...DNN Open Source...Module ForumsModule ForumsReportsReportsReporting Services Visualizer parametersReporting Services Visualizer parameters
Previous
 
Next
New Post
3/20/2007 9:00 AM
 

Since the gridview visualizer can't do formatting yet, I decided to try the Reporting Services Visualizer. I created a report (formatted currency and dates as I wanted) and deployed it to our ReportServer, and did the rest of the install steps to publish the report. However, it doesn't seem to be passing the parameter information properly. I am trying to use the UserID = @UserId, but the report displays "

  • The 'UserID' parameter is missing a value"
  •  
  •  
  •  
  •  
  •  
  • When I hardcode the userid in my sql statement, the report works correctly.

    Can you tell me if the parameters are supposed to work in the Reporting Service Visualizer, and how it is supposed to be set up?

    It seems to me that deploying the report to my report server doesn't matter, because to see my changes, I have to re-upload my .rdl file...

     

     
    New Post
    3/20/2007 10:23 AM
     
    If you deployed the Report to the Report Server then the Query in the Reports module has no effect as the report is run on the server (although a query is required that returns at least one row due to a bug in the current version that has been fixed). So you will need to configure your Report on the server with the parameters you need. Unfortunately there is no way in the current visualizer to send the parameters (such as UserID, PortalID etc.) to the Report Server (the Reporting Services Visualizer is a pre-release version and very limited in features).

    Andrew Nurse
    DotNetNuke Core Team Member and Reports Module Project Lead
    Microsoft Certified Professional Developer

     
    New Post
    1/22/2008 10:48 PM
     

    Andrew -- Any chance the Report Server Visualizer could be extended to automatically pass DNN parameters to the Report Server? So for example the following procedure may work:

    When a Report Server report is executed do the following:

    1. Get the report's parameter collection.

    2. For each parameter in the collection:

       if parameter name = UserID, set value to UserID
       if parameter name = PortalID, set value to PortalID
       if parameter name = ModuleID, set value to ModuleID
       if parameter name = TabID, set value to TabID

    Is this possible?

    Thanks!

     

     
    New Post
    1/24/2008 2:46 PM
     

    I don't see why not. If you are running the report in Local Mode, the parameters should be passed (because the Query is run locally), but if running a Server Report I should be able to forward those parameters on to SQL Server. I'll post an enhancement request and work on that for the next release of the Module.

    Here's a link to the enhancement request so you can follow the progress: RPT-7013

    Thanks for the idea! Hope you are finding the module useful.


    Andrew Nurse
    DotNetNuke Core Team Member and Reports Module Project Lead
    Microsoft Certified Professional Developer

     
    Previous
     
    Next
    HomeHomeDNN Open Source...DNN Open Source...Module ForumsModule ForumsReportsReportsReporting Services Visualizer parametersReporting Services Visualizer parameters


    These Forums are dedicated to discussion of DNN Platform and Evoq Solutions.

    For the benefit of the community and to protect the integrity of the ecosystem, please observe the following posting guidelines:

    1. No Advertising. This includes promotion of commercial and non-commercial products or services which are not directly related to DNN.
    2. No vendor trolling / poaching. If someone posts about a vendor issue, allow the vendor or other customers to respond. Any post that looks like trolling / poaching will be removed.
    3. Discussion or promotion of DNN Platform product releases under a different brand name are strictly prohibited.
    4. No Flaming or Trolling.
    5. No Profanity, Racism, or Prejudice.
    6. Site Moderators have the final word on approving / removing a thread or post or comment.
    7. English language posting only, please.
    What is Liquid Content?
    Find Out
    What is Liquid Content?
    Find Out
    What is Liquid Content?
    Find Out