Solved

Preventing User from Changing a Parameter in Reports

Posted on 2007-11-21
7
146 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 100

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 100

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
Windows Server 2016: All you need to know

Learn about Hyper-V features that increase functionality and usability of Microsoft Windows Server 2016. Also, throughout this eBook, you’ll find some basic PowerShell examples that will help you leverage the scripts in your environments!

 

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 100

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

NAS Cloud Backup Strategies

This article explains backup scenarios when using network storage. We review the so-called “3-2-1 strategy” and summarize the methods you can use to send NAS data to the cloud

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
C# GridRow get Old/New Value 1 55
About delegates in c sharp 3 35
Not showing JavaScript in the list 5 40
SQL Exceptions 3 39
Introduction: When running hybrid database environments, you often need to query some data from a remote db of any type, while being connected to your MS SQL Server database. Problems start when you try to combine that with some "user input" pass…
Data architecture is an important aspect in Software as a Service (SaaS) delivery model. This article is a study on the database of a single-tenant application that could be extended to support multiple tenants. The application is web-based develope…
In this video I am going to show you how to back up and restore Office 365 mailboxes using CodeTwo Backup for Office 365. Learn more about the tool used in this video here: http://www.codetwo.com/backup-for-office-365/ (http://www.codetwo.com/ba…
Many functions in Excel can make decisions. The most simple of these is the IF function: it returns a value depending on whether a condition you describe is true or false. Once you get the hang of using the IF function, you will find it easier to us…

896 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

Need Help in Real-Time?

Connect with top rated Experts

13 Experts available now in Live!

Get 1:1 Help Now