Solved

Preventing User from Changing a Parameter in Reports

Posted on 2007-11-21
7
151 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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
Three Reasons Why Backup is Strategic

Backup is strategic to your business because your data is strategic to your business. Without backup, your business will fail. This white paper explains why it is vital for you to design and immediately execute a backup strategy to protect 100 percent of your data.

 

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

Visualize your virtual and backup environments

Create well-organized and polished visualizations of your virtual and backup environments when planning VMware vSphere, Microsoft Hyper-V or Veeam deployments. It helps you to gain better visibility and valuable business insights.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
jquery + C#.net radiobuttonlist 3 45
JQuery Detecting page post back 6 19
Need to find substring in SQL 5 40
What Is an Error? 2 21
INTRODUCTION: While tying your database objects into builds and your enterprise source control system takes a third-party product (like Visual Studio Database Edition or Red-Gate's SQL Source Control), you can achieve some protection using a sing…
Entity Framework is a powerful tool to help you interact with the DataBase but still doesn't help much when we have a Stored Procedure that returns more than one resultset. The solution takes some of out-of-the-box thinking; read on!
The Email Laundry PDF encryption service allows companies to send confidential encrypted  emails to anybody. The PDF document can also contain attachments that are embedded in the encrypted PDF. The password is randomly generated by The Email Laundr…
Attackers love to prey on accounts that have privileges. Reducing privileged accounts and protecting privileged accounts therefore is paramount. Users, groups, and service accounts need to be protected to help protect the entire Active Directory …

740 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