Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

Preventing User from Changing a Parameter in Reports

Posted on 2007-11-21
7
Medium Priority
?
156 Views
Last Modified: 2010-03-19
My web app retrieves a report from the reporting server with the following url

http://myReportServer?%2fWRS%2fRanking List By Member&UnionId=1111&MemberId=4321&rs:Command=Render

The MemberId part is determined by the user while the UnionId is determined by the application.

When the report pops up a UnionId and MemberId dropdownlist appears with the right values

My Question is

A) Is there a way for the UnionId dropdownlist not to show up ?

OR

B) Gray out the UnionId dropdownlist?

The end result is that i do not want the user to be able to change the UnionId selection


Thanks

Allan

0
Comment
Question by:acadenilla
  • 4
  • 3
7 Comments
 
LVL 101

Expert Comment

by:mlmcc
ID: 20330779
The only way would be to build a prompt in the application for it then pass both to the application

mlmcc
0
 

Author Comment

by:acadenilla
ID: 20330971
mlmcc,

sorry but i dont quite follow your suggestion

The current ASP.Net Page has a control where the user can search and choose which member they would like to create a report of. Lets say they chose member "A". These member are part of a Union lets say "1".
The Union is determined by the application when the user of the application is signed in

When the user clicks on view report i concate the member and unionid along with various other paramaters to be pass to the reporting server to recreate the report. When the page for the report comes up the a unionid dropdown list appears with a selected value of "1" but it also has values that can go from 1 - 100 and there is memberid dropdown list appears with a selected value of "A" This too has a list lets say "A-Z".

my issue is in the report i do not want the user to be able to change the unionid selection but they are able to change the memberid selection to create a new report.

Note the report generated is a from a ".rdl" Report Definition Language.

Allan
0
 
LVL 101

Expert Comment

by:mlmcc
ID: 20337000
I understand the issue.  I am not that familiar with SRS so I don't know this for sure.  Generally the parameter values available are the ones the report specifies so unless you can restrict the selection from the report desing, you need to have the application prompt for all the parameters then you can pass them to the report and the report prompt won't be available to the user.

mlmcc
0
Veeam Disaster Recovery in Microsoft Azure

Veeam PN for Microsoft Azure is a FREE solution designed to simplify and automate the setup of a DR site in Microsoft Azure using lightweight software-defined networking. It reduces the complexity of VPN deployments and is designed for businesses of ALL sizes.

 

Author Comment

by:acadenilla
ID: 20350905
mlmcc,

I have double checked and my application is prompting and passing all the information i need for the report.

If i removed the prompt for a parameter  in the report, it does not show up in the layout of the report at design time. But when i run it the parameter appears.

here is a snippet of the code

<ReportParameter Name="UnionId">
      <DataType>String</DataType>
     /*<Prompt>Union ID:</Prompt>*/       <----------- If i removed this it does not prompt at design but will appear during run time.
       <ValidValues>
        <DataSetReference>
          <DataSetName>dsUnion</DataSetName>
          <ValueField>UnionId</ValueField>
          <LabelField>ApplicationName</LabelField>
        </DataSetReference>
     </ValidValues>
    </ReportParameter>
<ReportParameter Name="MemberId">
      <DataType>String</DataType>
      <Nullable>true</Nullable>
      <Prompt>Member ID:</Prompt>
      <ValidValues>
        <DataSetReference>
          <DataSetName>dsMembers</DataSetName>
          <ValueField>MemberId</ValueField>
          <LabelField>Name</LabelField>
        </DataSetReference>
      </ValidValues>
    </ReportParameter>

Allan
0
 
LVL 101

Expert Comment

by:mlmcc
ID: 20352482
I don't know enough about SRS and your method.

mlmcc
0
 

Author Comment

by:acadenilla
ID: 20359623
Thanks for trying mlmcc

I have to look more on the documentation maybe pick up a book to find a solution

again thanks for your suggestions

allan
0
 

Accepted Solution

by:
acadenilla earned 0 total points
ID: 20746868
For Those that are interested

Here is the solution i came across

http://msdn2.microsoft.com/en-us/library/ms155908.aspx

Summary of Steps

1) Select Report
2) Select Report -> Report Parameters
3) Add / Select Report Parameter and check "Hidden"
4) Add Parameter in the dataset
0

Featured Post

[Webinar] Cloud and Mobile-First Strategy

Maybe you’ve fully adopted the cloud since the beginning. Or maybe you started with on-prem resources but are pursuing a “cloud and mobile first” strategy. Getting to that end state has its challenges. Discover how to build out a 100% cloud and mobile IT strategy in this webinar.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article is for Object-Oriented Programming (OOP) beginners. An Interface contains declarations of events, indexers, methods and/or properties. Any class which implements the Interface should provide the concrete implementation for each Inter…
There have always been a lot of questions related to when Crystal Reports evaluates report components (such as formulas, summaries, cross-tabs, charts, to name a few examples). Crystal Reports uses a two-pass reporting process to provide greater …
Are you ready to place your question in front of subject-matter experts for more timely responses? With the release of Priority Question, Premium Members, Team Accounts and Qualified Experts can now identify the emergent level of their issue, signal…
Screencast - Getting to Know the Pipeline

782 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question