Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 159
  • Last Modified:

Preventing User from Changing a Parameter in Reports

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
acadenilla
Asked:
acadenilla
  • 4
  • 3
1 Solution
 
mlmccCommented:
The only way would be to build a prompt in the application for it then pass both to the application

mlmcc
0
 
acadenillaAuthor Commented:
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
 
mlmccCommented:
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
Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

 
acadenillaAuthor Commented:
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
 
mlmccCommented:
I don't know enough about SRS and your method.

mlmcc
0
 
acadenillaAuthor Commented:
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
 
acadenillaAuthor Commented:
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 4
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now