Solved

Preventing User from Changing a Parameter in Reports

Posted on 2007-11-21
7
149 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
Optimizing Cloud Backup for Low Bandwidth

With cloud storage prices going down a growing number of SMBs start to use it for backup storage. Unfortunately, business data volume rarely fits the average Internet speed. This article provides an overview of main Internet speed challenges and reveals backup best practices.

 

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

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

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

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 …
In this article we will get to know that how can we recover deleted data if it happens accidently. We really can recover deleted rows if we know the time when data is deleted by using the transaction log.
This Micro Tutorial will give you a basic overview how to record your screen with Microsoft Expression Encoder. This program is still free and open for the public to download. This will be demonstrated using Microsoft Expression Encoder 4.

832 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