Hiding Parameter Prompts

Jan 24, 2008

Hello everyone,

I have a request to hide certain parameters in a report based on the current user logged into our web based report viewer using the ReportViewer control fo asp.net.

I am doing the standard stuff required to display the report as shown below.




Code Snippet
rptViewer.ServerReport.ReportServerUrl = new Uri("http://172.17.144.26/ReportServer"); // new Uri(MINETSecurity.WebSettings.WebServerPath, UriKind.Absolute);
rptViewer.ServerReport.ReportPath = ReportName;
rptViewer.ServerReport.DisplayName = "Report1";
rptViewer.ServerReport.ReportServerCredentials = new CustomReportCredentials("myUsername", "myPassword", "myDomain");






Now that i have loaded the report into the viewer i illiterate through the report parameters looking for the ones which the specified user should not see as show below.




Code Snippet
ReportParameterInfoCollection MyReportParams = rptViewer.ServerReport.GetParameters();
foreach (ReportParameterInfo MyParameter in MyReportParams)
{
// returns a value from a custom class which is a predefined value for this user based on the current user logged into the website
string Value = CustomParameterValues.ToString(GlobalUserSettings.CurrentUser.CustomValueList);
if(Value != "") MyParameter.PromptUser = false;
}



Here is where the promblem lies, when i try to set the value of PromptUser i get the following compiler error.

Property or indexer 'Microsoft.Reporting.WebForms.ReportParameterInfo.PromptUser' cannot be assigned to -- its is read only

Is there anything i can do to set certain parameters invisible to the user and set there value myself. I know i could create 2 seperate reports and set the PromptUser value in the designer but i dont really want to be duplicating reports just to hide or show parameters.

I have tried using the SetParameters method of the ReportViewer component to pass the value of the parameters that should be hidden and even set the visible property to false, but it dosn't seem to work.

Any help here would be appreciated.

Cheers
Scott Blood

View 8 Replies


ADVERTISEMENT

Conditionally Showing/hiding A Parameter

Jul 16, 2007

I have a report that in most cases takes 4 parameters. In a few special cases, though, it takes 5 parameters. I have my code modified enough such that it can handle this exception, however I cannot figure out how to conditionally show the 5th parameter based on the 4th parameter. Is this possible?

View 3 Replies View Related

How To Make Hiding The Parameter Row As Default?

Apr 17, 2007

When I ran the report from the browser (not from the preview when designing the report), the parameters and the View Report button still displayed. I noticed clicking a double arrow button can hide or show the parameter section . How can I make hiding the parameter section as default? Currently showing the section is the default.



Thanks.

DanYeung

View 3 Replies View Related

Cascading Prompts

Jun 30, 2005

This question is for Bill directly. Hi Bill, I have lots of experience with RS, implementing the beta in a production environment, I was so impressed. Currently my company uses Cognos for financial reporting, and I am hoping to replace this with RS and MSAS. I have little knowledge of MDX, so I have been using your various series of articles to get up to speed. However, I don't get the article Mastering OLAP Reporting: Cascading Prompts. I fully understand how to build the prompts, but there seems to be a step missing in the article. You never replace the hardcoded where clause in the base dataset, and I can't seem to work out how to pass the parameter from the cascading prompts to the report. Maybe I'm being stupid, but the article doesn't seem to tell us how to do that.

Many Thanks

Sam

View 3 Replies View Related

User Prompts

Nov 13, 2006

Hi guys

I have been asked to develop a query which when run will prompt the user to enter the number of months before runnin the query.

I know we can do this in MS Acess .

can we do the similar sort of thing in SQL as well??

My query is

SELECT DHBMappingTable.[DHB Name], Agency.DHB_service, PurchaseUnitMappingTable.PU, PurchaseUnitMappingTable.PU_name,

SUM([NMDS Data for IDF Report].[Number of caseweighted discharges]) AS Expr1, AVG(wies2.[0607_cwd_WIES11]) AS Expr2,

AdmissionMappingTable.Admission, wies2.Admission_type

FROM DomicileCodes



In the above query, I need to multiply "0607_cwd_WIES11" with the no. of months



Lets say if the user is being prompted to enter the no of months and he enters 3, then "0607_cwd_WIES11" should be multiplied by 3 and divided by 12.

Do i have to use stored procedures(which I have got no knowledge of)

What do I have to do??

Pls help



Thanks

Mita

View 5 Replies View Related

Prompts In Model Designer

Oct 19, 2006

I would like to set up a prompt / filter as part of the model that carries through to the report builder. I have a query where I would like to force a prompt on the user as part of any report they create. Ideally, I would like to have it default as well.

I noticed that there is a prompt attribute in model designer. When I go to add the filter attribute in model designer, I get the same dialog box I get in the report builder - except it does not have the prompt as an option. Is there a way to accomplish this?

Thanks

View 3 Replies View Related

Use Parameters/Prompts In Calculates Fields

May 22, 2008



Hello,

We want to have one prompt (parameter) to set a point in time, so we can use this parameter as filter in other elements.
e.g. We have a point in time prompt, that we can set and use to filter by examples illness records and availability record (by the same (one) prompt)

View 9 Replies View Related

Database Prompts In SSRS Cannot Be Deselected

Oct 15, 2007



Hi,

Suppose I have two prompts, say A and B.
These two prompts are populated by using database queries.
B is dependent on A.
These prompts are multiselect.

I have noticed that it is not possible to deselect them once a value(s) are selected.
If I deselect all in A. They automatically get selected again.

They work fine as long as some value selected.
It is possible however to deselect all in B.

Thanks in advance.



View 6 Replies View Related

Create SQL Server Objects From Command Prompts

Jan 15, 2005

Hi

Is there any why to Create SQL Server Objects from Command Prompts like (Databases , Tables, Stored Procedures, …) ??

If you will Install some Applications Like this forums you will see the SQL Server object Created from Command Prompts

How Can I do that .. ??

And thanks with my regarding

Fraas

View 1 Replies View Related

Internet Explorer Prompts For Password After 300 Seconds

Jan 5, 2008



I am running a report which takes a long time to render. It has 500K rows in it that need to be summed and grouped. After 5 minutes IE prompts for a password. I set the report time out to 15 min just to see if it would make a difference. I even set the IIS timeout to an to 15 min as well.

I know that its bad to run a report this big, but I'm just curious why it prompts for a password. In case a user runs the report. Report uses dates so its possible they could go way back and not realize its 500K rows. I am assuming it is an IE issue with the browser and found a registry edit, but I don't really want to edit registries on my users' computers.

View 1 Replies View Related

Problem For The Prompts Will Display At The Top Of The Report In The Browser

Sep 27, 2007

hye everyone,
i have Problem for the prompts will display at the top of the report in the browser :






1)go to the report manager on computer and set the
set the Prompt User check boxes to checked.
--> auto check





2)select the report viewer control, if you are using it, and set the Parameters property to false.
--> the eror mesage will be display
" The ' field " parameter is missing value. "



what should i do...any idea
thanks in advance
thank you very much

View 1 Replies View Related

Retrun All Rows On Any Table From EM Prompts For Username/Password .. Why ?

Sep 16, 2004

Hello -

I dont know something weired happened on our MSSQL server today. We are able to connect to any Databases from Enterprise Manager from a Remote server.

Once we logged in and connected to a database on my database server, it keep prompting for the user id and password as we browsing through different tables in that database?

(Right click on the table then select Open Table -> Return all rows -> and it prompts for password )

Now when we enter password the contents of Table are displayed and now when we try to see contents of another table in the database it again prompts for password.


Any Idea whats wrong? How this can be resolved as it was not happening before .. :(

View 1 Replies View Related

Reporting Services :: Adding Values To Parameters In Dropdown Prompts In Reports In BIDS Or Report Builder

Nov 20, 2015

I run these stored procedure to build the report and I am able successfully to build the report but I need some prompts to in the report to get the specific data .

ALTER
PROCEDURE [dbo].[Sharepoint_Ticket_Report]
@StartDate
DATETIME,
@EndDate

[Code] ....

And for prompts how to create created_by and message_type dropdowns as shown in picture.

View 7 Replies View Related

Hiding A Zero Value

Jan 11, 2007

How can I hide or suppress the 0-values (zero) in a report?

View 8 Replies View Related

Hiding Particular Objects

Aug 1, 2000

Hey guys,
Is there any way to hide a particular object(table,sp,tr etc) from
a particular user?

we are developing softwares for the clients..and Once we install our product we dont want the clients site guys to go and delibrately view the data from sql server but through the front end. Is there anyway that i can do that...?

For Eg..the front end codes are capsulated as DLLs so that no can view the code.. Like that for SQL Server..can we do that kinda stuffs to prevent them?

View 5 Replies View Related

MS SQL Hiding Behind Access

Dec 7, 2005

Hi guys

We have a helpdesk application which is based on an MS SQL database, and which runs with a rather large and complicated C# based interface. We don't have the code for this, so we can't customise it. Long story short, what we want is to create an interface in Access (or similar) which accesses the same database as the helpdesk suite, and allows reading AND writing, and some rather complex operations (which SHOULD be fairly simple to do in SQL).

Unfortunately, I have been given this project, and I know about as much about Access and SQL as I do about Ghengis Khan's fashion sense.

I will follow with more information as required, but I'm going to need a lot of help with this one. First things first, is Access the way to do this? Is it going to be easier to create a new Access DB and synchronise it with the SQL, instead of both applications using the same database?

The only way I can get Access to interrogate the SQL database is to create a Data Access Page - is this the correct starting point? The only problem is that this seems to only offer HTML, and is far from being a friendly interface, at least not to me.

I know that I currently have no grounding in physics and I'm trying to build a space station, but any advice that you could give me would be much appreciated.

Thanks guys!

View 4 Replies View Related

Hiding The DB Design.

Feb 3, 2004

Hi all,

I am going to install my application at my Client's place.

I do not want them to know about my DB design and also i have a lot of master information that I dont want the Client to view.

The Client insists that he would have the Super Administrator user ids and passwords (ie. "sa" - user).

Is there any way i can encrypt my DB design and the data in the DB.

Or is there any other way of restricting the Client from viewing my DB design and data???

Thanks

Vishal

View 5 Replies View Related

Hiding NULL

Mar 29, 2006

In SQL 2000 Query Analyzer, you can set up the text output pane toleave null values blank.That could give you this (assuming it's set to comma-delimited) --CREATE TABLE #Test (A int, B int)INSERT #Test SELECT 1,2INSERT #Test SELECT NULL,4INSERT #Test SELECT 5,NULLINSERT #Test SELECT NULL,NULLSELECT * FROM #TestA,B1,2,45,,I can't figure out how to set up 2005 Management Studio the same way.I can only manage to get outputs like this, with "NULL" instead ofempty fields --A,B1,2NULL,45,NULLNULL,NULLHow can I get rid of the NULLs?Thanks,Jim

View 2 Replies View Related

Hiding Data

Jul 20, 2005

Hi,I am intetrested to know if there is a way to hide the information in aspecific column in my table. SQLServer 200. Something like a passwordprotection were you only see *****. I have a DBA but want to hide salaryinformation from him that is stored in the database.Any suggestionsThanksElmo

View 3 Replies View Related

Hiding A Table

Feb 28, 2008

Hi,

I am designing a report with a few tables in it which i selectively want to hide if there is no data to display in them.
The tables hide themselves but leave behind a big void without compressing the fields beneath them.

Is there anyway to make sure that the tables are hidden and it compresses the space which it would have otherwise occupied?

The two methods i have tried are:

1. Put an expression in the visibility property and set it to true if the row count is zero
2. set the expression in the NoRows property to =""

(both without luck)

Any suggestions would be greatly appreciated.

Regards,

Ash

View 4 Replies View Related

Hiding Parameters

Jan 11, 2008



Hi There,

I am fairly new at RS, and have a question about showing/hiding parameters :

What i would like to do is have one report, with the parameters :

Report By : (Date/Week)
Buisiness Stream : (Spares/OEM)
Start Date : (Date)
End Date : (Date)
Start Week : (Start Week Num)

End Week : (End Week Num)

What I would like to do is show the 'Start Date' and 'End Date' when the Report By value = Date

OR

Show the 'Start Week' and 'End Week' parameter when Report By value = Week.

Can someone help me with this?

Thanks

Jamie

P.S. If its not possible to hide the fields, could i grey them out??

View 3 Replies View Related

Hiding Sub Report

Jan 9, 2008

I have main reports and also sub reports in the same project [folder]. I don't want to show sub reports in the reports drop down list. Can you please let me know how to do it?

View 1 Replies View Related

Hiding Reports

Jul 23, 2007

Is there a way to hide reports before publishing and then hiding reports via the Report Manager? We have some subreports that before we publish, we would like to set a flag to hidden so the Report Manager will know after the deploy that this report is to be hidden.



Thanks for the information.

View 4 Replies View Related

Hiding A Subreport

Jul 24, 2007

We have a parameter that takes the values of "Yes" or "No" (non-queried). If the user chooses "Yes", we want the subreport to display, but remain hidden on "No".



In the expression for visibility, we have the following:
=IIf(cstr(Parameters!Heading.Value = "Yes"),False,True)



When the report runs we get the following error: "The input string was not in the correct format."



Has anybody seen this before?



Thanks for the information.

View 1 Replies View Related

Hiding Groups

May 1, 2008

I know how to hide groups using Expressions that use parameters that can be passed in, but can you hide groups that are inside other groups. Here is my situation. Our company has different organization levels. On reports the users want to select which organization levels they want to see the #s for. So I set up groups for each org level like so....

Org Level 1
Org Level 2
Org Level 3

The data results are like so

Org Level 1 Org Level 2 Org Level 3 Category $ Amount
USA Midwest Kansas 1 500.00
USA Northeast Maine 1 200.00

And I sum the $ Amount Per Category for each Org Level using grouping in the report.

Then based on the selections they make it hides the org levels they don't need to see. The issue is that the report will not show org level 2 or org level 3 if org level 1 is not visible, and org level 3 can't be visible if org level 2 isn't visible, etc.....Anyone know a solution to this situation, I know this has had to have come up.

Thanks,
Adam

View 1 Replies View Related

Hiding Database Views

Oct 17, 2001

Help Please!
How can I hide databases from users that do not have permission to log onto them in the SQL Enterprise Manager.
Thanks in advance for the help.
-Rich

View 3 Replies View Related

Hiding System Tables

Jan 25, 2000

Is there anyway to hide system tables in a database so that only user tables are viewed?

Gary

View 1 Replies View Related

Hiding Implementation/Code

Jul 14, 2004

We are planning to sell a software.. and don't want our clients to access the code or database design.

Is there any way to hide the stored proc/trig code and the database table?

Help is highly appreciated.

Thanks

View 4 Replies View Related

Hiding System Tables

Jan 12, 2004

Hi,

Is there a way to hide the system tables on EM?

Thanks

View 3 Replies View Related

Is There A Unique Row Id Hiding Behind The Scenes?

Oct 11, 2007

I've heard that if one doesnt have a clustered index on his/her table, that clustering occurs on some underlying row id. Is this true? If so, is that id retrievable?

View 16 Replies View Related

Hiding A Subreport SSRS

Mar 9, 2007

Hi,

I'm a newbie inSSRS, kindly help!!

i have a subreport  and it needs to be displayed only based on some selection criteria, in all other case it needs to be hidden.i made the visibility to hidden, but when i run the report,it gives me a blank page where it usually gets me the subreport.How can i remove this blank page from getting displayed ?

 

PS: this is the expression i have added :

=IIF(Parameters!strChoice.Value="Single",True,False)

Thanks in advance for any help..

View 8 Replies View Related

Hiding Tables In A Report

May 6, 2007

Hi,



Can anyone help me with the expression I need to use in order to hide a table with no rows? I have put my table inside a rectangle with the idea that I would just hide the rectangle if there weren't any rows but I can't find any examples of what expression I can use to specify the no rows condition.



Thanks!

Debi

View 5 Replies View Related

Hiding Sections Of Text

Feb 15, 2008

I'm new at Reporting Services. I need to know if the Reporting Services will meet my needs.

I need to create a report that looks much like a Word document with large sections of text. Is it possible to hide some sections of text based on boolean fields in a SQL table/query?

Alternatively.. will it handle rich text? I could then select the appropreate section to display by query.


Thanks in advance

View 1 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved