Showing posts with label parameters. Show all posts
Showing posts with label parameters. Show all posts

Friday, March 30, 2012

Hide Parameters toolbar

How to hide specific parameters from the toolbar:

I use the following link, it hides the whole parameters toolbar.

http://ServerName/reportserver?/PPTReports/rptStatSU&rs:Command=Render&rs:Format=HTML4.0&rc:Parameters=false&eStatus=Open&UserName=jSmith

I have two parameters out of that would oike to hide just one of them which is username.

i am using sqlserver 2000 reporting services, i don't see that option hide.

Please does anyone know how to do it.

Thank you very much for the information.

No, in SQL Server 2k you can only hide the report parameters as a whole. In SQL Server you have the possibility to set the parameter to "hidden" or "internal", but if you don′t have the chance of migrating you are stuck to the option to switch of the whole parameter toolbar.

HTH, Jens Suessmeyer.

http://www.sqlserver2005.de

Hide Parameters passed to drillthrough report

hi,
Is it possible to hide parameters passed to drillthrough report?
If yes, How?
regards,
SAchin.yes using rc:parameters=false, when you click on the link the parametes wont
be visible but one small problem (rather big:-) is that it will be visible on
the "address box" in the IE. so if some one goes and removes it then the
parameters will be visile.
Amarnath
"sachin laddha" wrote:
> hi,
> Is it possible to hide parameters passed to drillthrough report?
> If yes, How?
> regards,
> SAchin.
>|||Hi,
Where to set rc:parameters=false so that it appears by defualt in the
report URL?
Can I set it while designing the drillthrough report ?
I am using RS's report manger to view and manager reports.
regards,
Sachin.
Amarnath wrote:
> yes using rc:parameters=false, when you click on the link the parametes wont
> be visible but one small problem (rather big:-) is that it will be visible on
> the "address box" in the IE. so if some one goes and removes it then the
> parameters will be visile.
> Amarnath
> "sachin laddha" wrote:
> > hi,
> >
> > Is it possible to hide parameters passed to drillthrough report?
> > If yes, How?
> >
> > regards,
> > SAchin.
> >
> >|||When you jump to report the parameters section of the report you are jumping
to is not shown. Are you seeing different behavior than this?
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"sachin laddha" <sachinladdha@.gmail.com> wrote in message
news:1146816702.039630.18710@.e56g2000cwe.googlegroups.com...
> Hi,
> Where to set rc:parameters=false so that it appears by defualt in the
> report URL?
> Can I set it while designing the drillthrough report ?
> I am using RS's report manger to view and manager reports.
> regards,
> Sachin.
>
> Amarnath wrote:
>> yes using rc:parameters=false, when you click on the link the parametes
>> wont
>> be visible but one small problem (rather big:-) is that it will be
>> visible on
>> the "address box" in the IE. so if some one goes and removes it then the
>> parameters will be visile.
>> Amarnath
>> "sachin laddha" wrote:
>> > hi,
>> >
>> > Is it possible to hide parameters passed to drillthrough report?
>> > If yes, How?
>> >
>> > regards,
>> > SAchin.
>> >
>> >
>|||Sorry; I meant for "Jump to URL". A small confusion,
You dont want the parameter section? or the parameters which are passed
through the URL?. Because I meant when you use in the URL
rc:parameters=false the parameter section will not be visible. So let me know
which one you are looking out for.
Amarnath
"sachin laddha" wrote:
> Hi,
> Where to set rc:parameters=false so that it appears by defualt in the
> report URL?
> Can I set it while designing the drillthrough report ?
> I am using RS's report manger to view and manager reports.
> regards,
> Sachin.
>
> Amarnath wrote:
> > yes using rc:parameters=false, when you click on the link the parametes wont
> > be visible but one small problem (rather big:-) is that it will be visible on
> > the "address box" in the IE. so if some one goes and removes it then the
> > parameters will be visile.
> >
> > Amarnath
> >
> > "sachin laddha" wrote:
> >
> > > hi,
> > >
> > > Is it possible to hide parameters passed to drillthrough report?
> > > If yes, How?
> > >
> > > regards,
> > > SAchin.
> > >
> > >
>|||I am using 'Jump to report' option and not 'jump to url' for
navigation.|||Hi Bruce,
Yes, i m seeing the paramters section of the report I am jumping to.
I have set the report to jump and the parameters it take.
Please note that I am seeing the report in VS preview pane and the
reports are not yet deployed on the report server
Please help me out.
regards,
Sachin.|||Problem solved. You are seeing a difference between the development
environment and deployed reports. Jump to Reports with deployed reports does
not show the parameters BUT the user can unhide them. To not have the option
at all to see the parameters you can make the parameters hidden OR you can
use Jump to URL and control the parameter section not to show.
Books Online: hiding parameters
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"sachin laddha" <sachinladdha@.gmail.com> wrote in message
news:1147070062.912289.317660@.u72g2000cwu.googlegroups.com...
> Hi Bruce,
> Yes, i m seeing the paramters section of the report I am jumping to.
> I have set the report to jump and the parameters it take.
> Please note that I am seeing the report in VS preview pane and the
> reports are not yet deployed on the report server
> Please help me out.
> regards,
> Sachin.
>

Hide Parameters issue : Where is the "Prompt User" checkbox

I have a problem of hiding a few of my parameters. People are talking
about the SP1 and the "Prompt User" check box. I have SP1 installed.
But I cannot see "Prompt User" checkbox anywhere either in the
ReportManager or the VS.NET Report Designer.
I've been pulling my hair all day. Please let me know how can I get to
that "Prompt User" checkbox. Where is it ?
thanks
Anand SagarThere is not a check box. Make sure your report is highlighted. Click on
the Report option in the menu. Select properties. To set a parameter as
hidden, you have to delete all the text in the "Prompt:" textbox. Once you
do that, you will not see a prompt for the user to enter data for that
parameter. This is all that is needed to "hide" parameters from the end user.
"Anand Sagar" wrote:
> I have a problem of hiding a few of my parameters. People are talking
> about the SP1 and the "Prompt User" check box. I have SP1 installed.
> But I cannot see "Prompt User" checkbox anywhere either in the
> ReportManager or the VS.NET Report Designer.
> I've been pulling my hair all day. Please let me know how can I get to
> that "Prompt User" checkbox. Where is it ?
>
> thanks
> Anand Sagar
>|||There is a "Prompt User" check box in SP1. When you've uploaded your report
to the Report Manager, you'll need to edit the "Parameters" properties.
Check the "Prompt User" check box, then empty out the Prompt String text
box. This allows the parameter to be hidden from the user, but still
updateable by the report.
HTH,
Brian
"bspann" <bspann@.discussions.microsoft.com> wrote in message
news:1F78D438-DDE9-4725-A474-A7BC7FDE880D@.microsoft.com...
> There is not a check box. Make sure your report is highlighted. Click on
> the Report option in the menu. Select properties. To set a parameter as
> hidden, you have to delete all the text in the "Prompt:" textbox. Once
you
> do that, you will not see a prompt for the user to enter data for that
> parameter. This is all that is needed to "hide" parameters from the end
user.
> "Anand Sagar" wrote:
> > I have a problem of hiding a few of my parameters. People are talking
> > about the SP1 and the "Prompt User" check box. I have SP1 installed.
> > But I cannot see "Prompt User" checkbox anywhere either in the
> > ReportManager or the VS.NET Report Designer.
> > I've been pulling my hair all day. Please let me know how can I get to
> > that "Prompt User" checkbox. Where is it ?
> >
> >
> > thanks
> > Anand Sagar
> >|||In Report Manager, select the report, select the properties tab, select the
parameters sub-tab.
--
This posting is provided "AS IS" with no warranties, and confers no rights
"bspann" <bspann@.discussions.microsoft.com> wrote in message
news:1F78D438-DDE9-4725-A474-A7BC7FDE880D@.microsoft.com...
> There is not a check box. Make sure your report is highlighted. Click on
> the Report option in the menu. Select properties. To set a parameter as
> hidden, you have to delete all the text in the "Prompt:" textbox. Once
you
> do that, you will not see a prompt for the user to enter data for that
> parameter. This is all that is needed to "hide" parameters from the end
user.
> "Anand Sagar" wrote:
> > I have a problem of hiding a few of my parameters. People are talking
> > about the SP1 and the "Prompt User" check box. I have SP1 installed.
> > But I cannot see "Prompt User" checkbox anywhere either in the
> > ReportManager or the VS.NET Report Designer.
> > I've been pulling my hair all day. Please let me know how can I get to
> > that "Prompt User" checkbox. Where is it ?
> >
> >
> > thanks
> > Anand Sagar
> >sql

Hide Parameters from User.

Hi,
Is there any way that the parameters passed from the URL is not shown to the users. Making the "Prompt User" unchecked and passing the parameter through the URL gave some error. Is there a work around.
Thanks.
--
Message posted via http://www.sqlmonster.comTry appending this to your URL:
&rc:Parameters=false
"Prashanth Rao via SQLMonster.com" wrote:
> Hi,
> Is there any way that the parameters passed from the URL is not shown to the users. Making the "Prompt User" unchecked and passing the parameter through the URL gave some error. Is there a work around.
> Thanks.
> --
> Message posted via http://www.sqlmonster.com
>

Hide parameter toolbar and send par via querystring?

Hide parameter toolbar and send par via querystring?
I have some stored proceures that receive some parameters and output some
querys. I dont want the user to select parameters because I need to gice
those parameters via query string from My Applications
How can I achieve tha?
--
LUIS ESTEBAN VALENCIA
MICROSOFT DCE 3.
MIEMBRO ACTIVO DE ALIANZADEV
http://spaces.msn.com/members/extremed/Luis,
Check out:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/RSPROG/htm/rsp_prog_urlaccess_959e.asp
Adrian M.
"Luis Esteban Valencia" <luisvalen@.haceb.com> wrote in message
news:%23n13jSW$EHA.1400@.TK2MSFTNGP11.phx.gbl...
> Hide parameter toolbar and send par via querystring?
>
> I have some stored proceures that receive some parameters and output some
> querys. I dont want the user to select parameters because I need to gice
> those parameters via query string from My Applications
>
> How can I achieve tha?
>
> --
> LUIS ESTEBAN VALENCIA
> MICROSOFT DCE 3.
> MIEMBRO ACTIVO DE ALIANZADEV
> http://spaces.msn.com/members/extremed/
>

Hide Parameter field, rc:parameters ?

Hi,
I want to reference from one reports to another and I don't want my users to
see the parameters used. In case of a url-reference I can use the
rc:parameters = false to disable the parameter field in the viewer.
How can I reach the very same behaviour when I reference from one report to
another (navigation) ?
Thanks in advance,
CarstenHow r u using the reference to another report? is it through a web link?
or a child report?
"Carsten Schlotmann" <cschlotmann@.dornbracht.de> wrote in message
news:e5XZHl2rEHA.516@.TK2MSFTNGP09.phx.gbl...
> Hi,
> I want to reference from one reports to another and I don't want my users
> to
> see the parameters used. In case of a url-reference I can use the
> rc:parameters = false to disable the parameter field in the viewer.
> How can I reach the very same behaviour when I reference from one report
> to
> another (navigation) ?
> Thanks in advance,
> Carsten
>|||Hi,
it is through a child report.
Regards,
Carsten
"avnrao" <avn@.newsgroups.com> schrieb im Newsbeitrag
news:uaKHoo5rEHA.3588@.tk2msftngp13.phx.gbl...
> How r u using the reference to another report? is it through a web link?
> or a child report?
> "Carsten Schlotmann" <cschlotmann@.dornbracht.de> wrote in message
> news:e5XZHl2rEHA.516@.TK2MSFTNGP09.phx.gbl...
> > Hi,
> >
> > I want to reference from one reports to another and I don't want my
users
> > to
> > see the parameters used. In case of a url-reference I can use the
> > rc:parameters = false to disable the parameter field in the viewer.
> > How can I reach the very same behaviour when I reference from one report
> > to
> > another (navigation) ?
> >
> > Thanks in advance,
> > Carsten
> >
> >
>

hide parameter field

Is it possible to hide or disable some fileds of parameters on report?
Thanks.You could always call the report from a URL and NOT show the parameter
bar... and in SP1 you may hide individual parameters.
--
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
<AG>; "NLB d.d." <AGNLBdd@.discussions.microsoft.com> wrote in message
news:E55FF6A7-3BDD-411B-87FB-AE4EF548E053@.microsoft.com...
> Is it possible to hide or disable some fileds of parameters on report?
> Thanks.
>|||Hi AG:
Make sure you have SP1 for reporting services:
http://www.microsoft.com/downloads/details.aspx?familyid=580febf7-2972-40e7-bccf-6cd90ac2f464&displaylang=en
From the SP1 readme:
"Previously, the only way to hide a parameter value was to clear the
Prompt User check box in the Parameters properties page. However, a
side effect of clearing the check box was that you could no longer
specify a parameter value for the report at run time. This limitation
has been removed. In SP1, you can clear the Prompt User check box to
hide the parameter fields and values in the report. Doing so does not
introduce restrictions on how you subsequently set the parameter value
externally at run time."
HTH,
--
Scott
http://www.OdeToCode.com
On Mon, 2 Aug 2004 02:15:03 -0700, AG, NLB d.d.
<AGNLBdd@.discussions.microsoft.com> wrote:
>Is it possible to hide or disable some fileds of parameters on report?
>Thanks.
>

Hide my parameter

Hi,
When i run my report i don't want to see the parameters that i have given it.
How can i hide the parameters?
Greetings,
Mike KlaarhamerIf you are passing the parameters via URL then go to Report Manger and select
the parameters options under properties for that particular report. now, for
the parameter that you wish to hide, check the Prompt User to yes, and empty
the Prompt string.
Cheers
Priya
"Mike Klaarhamer" wrote:
> Hi,
> When i run my report i don't want to see the parameters that i have given it.
> How can i hide the parameters?
> Greetings,
> Mike Klaarhamer

Wednesday, March 28, 2012

Hide Data Region based on Parameters

I have a report with 3 data regions. Based upon one of the Report Parms, I
wish to hide one of the data regions. I used an expression on the
Visibility property of the table like this:
=IIf(Parameters!ReportLevel.Value = "Summary",true,false)
this works, except it still displays the page header and no print details
since the report is hidden. how do i get it to not display the page at all?Hi JrMcG,
Thank you for your posting!
I am not sure why you want to hide the Page Header. Since you only hide the
table, the Page header will not be hidden untill you use the same
expression on the Page Header visibility.
I recommend you post the RDL file here with your requirement. I would like
to help you. Thank you!
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
==================================================This posting is provided "AS IS" with no warranties, and confers no rights.

Hide Columns in Matrix Report

Hi,

I have a matrxi report with 6 Columns (Col 1, 2, ...6). Based on the parameters I select I wanted to hide 3 of the columns (Col 2, 4 and 6. But the problem is when I hide the columns, it leaves a gap. That means, the matrix report shows Col 1, 3 and 5 with gap in between the Columns.

There is no Column Visibility property in matrix report.

Please help me as I am looking to solve this issue for a long time now.

Thanks,

S Suresh

I have not been able to solve this issue either. I am not sure if it's a design intent or a bug, but it is frustrating.

On one report i actually had to put multiple matrix side by side, using the same dataset, grouping, etc, and hid the entire matrix. It's messy, but it does the trick.

BobP

|||

Having 6 columns in your matrix, suggest they map on to 6 columns in your source query and you have a static group.

If your columns have no further nesting then I suggest switching to using a table as you can achieve equivalent results. When you highlight a column in a table and change it's visibility you don't get the gap.

If that is not possible then you can get around this by pivoting the data in your query so that rather than having 6 measure columns you get 2 columns with MeasureType and MeasureValue. You should then be able to group the matrix columns by MeasureType, then, based on your parameter selection, filter the 3 unwanted measures in the source query.

And that will definately work.

|||

Thanks Adam. But my 6 columns are populated with values from dimensions. Can you tell me if there is any solution to hide column in matrix?

Thanks,

S Suresh

|||

Thanks Bob. I already messed up with multiple matrix to fill the rows.

Thanks,

S Suresh

|||

No, you cannot hide a column in a matrix and have it reclaim it's space.

BobP

|||

Suresh,

What I suggested is possible as I've already done it. When you say "my columns are populated from dimensions" what do you actually mean?

On the Layout tab do you see 1 column or 6 i.e. is this a dynamic group or a static group?

It doesn't matter if they are coming from different dimesions, you can just manufacture calculated members and measures within your MDX query. This requires you to stop using the query designer and switch to custom MDX view. Then you use syntax such as:

Code Snippet

WITH

MEMBER [Measures].[MyMeasure] AS 'SOME MDX here'

MEMBER [SomeOtherDimension].[MyMember] AS 'Some MDX here'

SELECT {[Measures].[MyMeasure]} ON 0

FROM [YourCube]

WHERE (...)

Post some sample MDX with a brief explanation of the dimensions and the parameters you wish to use to control visibility of the columns and I'll show you what I mean.

Hide Certain Parameters Dynamically

We have a number of reports which are used by both employees and
administrators with multiple parameters. In many of these reports we have
some parameters unique to the employees which we would like to automatically
set through URL access for our employees and either hide or set them as
read-only so an employee cannot view someone else's data. However, we want
to allow the administrators to change these values so they can view data from
any employee.
So, is there any way to dynamically hide a single parameter while still
showing the remaining ones, or to dynamically make a single parameter
read-only without creating a custom front end? I don't need to know how to
pass default values, just how to programmatically change what parameters are
hidden / read-only.
Thanks in advance.
DavidDavid,
It isn't possible to hide a parameter or make it readonly. A possible
solution for this problem is to create two new reports. One for the employees
and one for the administartors. Both reports get the proper parameters which
they may change. In both reports you include an subreport, the original one
with all parameters. Now you can link the parameters from the report to the
subreport. In teh case for the employees this meens that some parameters of
your original report will have an fixed value.
This solution will also prevent employees from 'trying' out the parameters
with URL Access.
Jan Pieter Posthuma
"David Siebert" wrote:
> We have a number of reports which are used by both employees and
> administrators with multiple parameters. In many of these reports we have
> some parameters unique to the employees which we would like to automatically
> set through URL access for our employees and either hide or set them as
> read-only so an employee cannot view someone else's data. However, we want
> to allow the administrators to change these values so they can view data from
> any employee.
> So, is there any way to dynamically hide a single parameter while still
> showing the remaining ones, or to dynamically make a single parameter
> read-only without creating a custom front end? I don't need to know how to
> pass default values, just how to programmatically change what parameters are
> hidden / read-only.
> Thanks in advance.
> David|||Thanks for the reply, I think I may have found a way that will work for our
needs using linked reports. I created a linked report to the original, and
hid any parameters that the employee does not need to change. It solves the
problem of having to maintain and edit 2 reports when changes are made, and
appears to have solved my issue with being able to change parameter settings
for the 2 separate versions.
"Jan Pieter Posthuma" wrote:
> David,
> It isn't possible to hide a parameter or make it readonly. A possible
> solution for this problem is to create two new reports. One for the employees
> and one for the administartors. Both reports get the proper parameters which
> they may change. In both reports you include an subreport, the original one
> with all parameters. Now you can link the parameters from the report to the
> subreport. In teh case for the employees this meens that some parameters of
> your original report will have an fixed value.
> This solution will also prevent employees from 'trying' out the parameters
> with URL Access.
> Jan Pieter Posthuma
> "David Siebert" wrote:
> > We have a number of reports which are used by both employees and
> > administrators with multiple parameters. In many of these reports we have
> > some parameters unique to the employees which we would like to automatically
> > set through URL access for our employees and either hide or set them as
> > read-only so an employee cannot view someone else's data. However, we want
> > to allow the administrators to change these values so they can view data from
> > any employee.
> >
> > So, is there any way to dynamically hide a single parameter while still
> > showing the remaining ones, or to dynamically make a single parameter
> > read-only without creating a custom front end? I don't need to know how to
> > pass default values, just how to programmatically change what parameters are
> > hidden / read-only.
> >
> > Thanks in advance.
> >
> > David

Monday, March 26, 2012

Hide / Disable Report Parameter

Hi

I am using reporting services 2005. (sql server 2005 Sp2).

I have two parameters on the reports. Both parameter are not related to each other.

If user selects first parameter value I want to Hide or Disable second parameter drop down.

Is it possible in Reporting services?

Thanks for everyone's help.

Regards

Swam

I am guessing a big NO

You could simply not use the 2nd parameter in the report

and have a text with "2nd parameter will not be used if 1st parameter is used"

|||

Swam wrote:

If user selects first parameter value I want to Hide or Disable second parameter drop down.

You can't do that, but what you can do is make the default value and even the *contents* of the second parameter dependant on what is selected in the first parameter. I would have the second dropdown default to null or an empty string if a value was selected in the first dropdown.

|||Thanks for your help..|||Thanks for your help....

Hidden/Read-only parameters in Report Designer

This question was never clearly answered, so here's what works for me:
In Report Designer:
To make a parameter read-only and hidden, leave the Prompt box blank.
To make a parameter hidden but not read-only, type a space in the Prompt box.
If there's another way, please let me know.
Chrissie"To make a parameter hidden but not read-only, type a space in the Prompt
box."
I can't get this to work... it then seems to put in the name of the param as
the prompt.
Are you sure about this? Have you applied the service patch? Just
checking?
Thanks for any help,
Alan Smith.
"Chrissie" <Chrissie@.discussions.microsoft.com> wrote in message
news:D002CF70-3C1E-4EFA-9EBB-4D2CAAD5EECC@.microsoft.com...
> This question was never clearly answered, so here's what works for me:
> In Report Designer:
> To make a parameter read-only and hidden, leave the Prompt box blank.
> To make a parameter hidden but not read-only, type a space in the Prompt
box.
> If there's another way, please let me know.
> Chrissie|||We don't support hidden parameters in Report Designer even in SP1. This is a server-side only
feature.
--
Thanks.
Donovan R. Smith
Software Test Lead
This posting is provided "AS IS" with no warranties, and confers no rights.
"Alan Smith" <nospam@.nospam.com> wrote in message news:unxCBuRiEHA.1040@.TK2MSFTNGP09.phx.gbl...
> "To make a parameter hidden but not read-only, type a space in the Prompt
> box."
> I can't get this to work... it then seems to put in the name of the param as
> the prompt.
> Are you sure about this? Have you applied the service patch? Just
> checking?
> Thanks for any help,
> Alan Smith.
> "Chrissie" <Chrissie@.discussions.microsoft.com> wrote in message
> news:D002CF70-3C1E-4EFA-9EBB-4D2CAAD5EECC@.microsoft.com...
> > This question was never clearly answered, so here's what works for me:
> >
> > In Report Designer:
> > To make a parameter read-only and hidden, leave the Prompt box blank.
> > To make a parameter hidden but not read-only, type a space in the Prompt
> box.
> >
> > If there's another way, please let me know.
> > Chrissie
>

Hidden vs. Internal Parameters -- Got to be a better way...

We have an application that gets a report's parameters and parameter values.
We're using SQL Server 2005. The problem is that we need a couple of the
report's parameters to be non-prompting AND not read-only.
In our application, we dynamically build the UI based on the parameters and
parameter values retrieved from the report, but we only want to display
parameters that are PromptUser = true and not hidden and not read-only.
Here's the code:
ReportingService.ReportingService2005 rs = new
ReportingService.ReportingService2005();
rs.Credentials = System.Net.CredentialCache.DefaultCredentials;
string historyID = null;
bool forRendering = true;
ReportingService.ParameterValue[] values = null;
ReportingService.DataSourceCredentials[] credentials = null;
ReportingService.ReportParameter[] parameters = null;
parameters = rs.GetReportParameters(sReportAndPath, historyID, forRendering,
values, credentials);
if ((parameters != null) && (parameters.Length > 0))
{
foreach (ReportingService.ReportParameter rp in parameters)
{
if (rp.PromptUser)
{
// Display parameter and parameter default values on screen
// Only display parameters that are NOT internal AND NOT hidden
// PromptUser property takes care of the internal
// hidden parameters appear to have a PromptUser = true
}
}
}
How can we do this?
If we set the parameter to internal, then it doesn't display, but we get an
error later when we try to update the parameter value (because it's
read-only). If we set the parameter to hidden, then it gets displayed on
screen because the PromptUser property is true.
Basically, we want to be able to change the parameter value (thus NOT
read-only), but, at the same time, not display on screen (PromptUser = false).
Hope this makes sense.
Any suggestions?I will be very interested in this answer. I have had it work but only after
messing around with the parameters in report manager. I would be interested
in your type of app that dynamically builds the UI. That is something that
we want to do.
can I contact you by email to discuss ... or can you post here.
"steggun" wrote:
> We have an application that gets a report's parameters and parameter values.
> We're using SQL Server 2005. The problem is that we need a couple of the
> report's parameters to be non-prompting AND not read-only.
> In our application, we dynamically build the UI based on the parameters and
> parameter values retrieved from the report, but we only want to display
> parameters that are PromptUser = true and not hidden and not read-only.
> Here's the code:
>
> ReportingService.ReportingService2005 rs = new
> ReportingService.ReportingService2005();
> rs.Credentials = System.Net.CredentialCache.DefaultCredentials;
> string historyID = null;
> bool forRendering = true;
> ReportingService.ParameterValue[] values = null;
> ReportingService.DataSourceCredentials[] credentials = null;
> ReportingService.ReportParameter[] parameters = null;
> parameters = rs.GetReportParameters(sReportAndPath, historyID, forRendering,
> values, credentials);
> if ((parameters != null) && (parameters.Length > 0))
> {
> foreach (ReportingService.ReportParameter rp in parameters)
> {
> if (rp.PromptUser)
> {
> // Display parameter and parameter default values on screen
> // Only display parameters that are NOT internal AND NOT hidden
> // PromptUser property takes care of the internal
> // hidden parameters appear to have a PromptUser = true
> }
> }
> }
>
> How can we do this?
> If we set the parameter to internal, then it doesn't display, but we get an
> error later when we try to update the parameter value (because it's
> read-only). If we set the parameter to hidden, then it gets displayed on
> screen because the PromptUser property is true.
> Basically, we want to be able to change the parameter value (thus NOT
> read-only), but, at the same time, not display on screen (PromptUser => false).
> Hope this makes sense.
> Any suggestions?
>
>|||"steggun" wrote:
> We have an application that gets a report's parameters and parameter values.
> We're using SQL Server 2005. The problem is that we need a couple of the
> report's parameters to be non-prompting AND not read-only.
> In our application, we dynamically build the UI based on the parameters and
> parameter values retrieved from the report, but we only want to display
> parameters that are PromptUser = true and not hidden and not read-only.
> Here's the code:
>
> ReportingService.ReportingService2005 rs = new
> ReportingService.ReportingService2005();
> rs.Credentials = System.Net.CredentialCache.DefaultCredentials;
> string historyID = null;
> bool forRendering = true;
> ReportingService.ParameterValue[] values = null;
> ReportingService.DataSourceCredentials[] credentials = null;
> ReportingService.ReportParameter[] parameters = null;
> parameters = rs.GetReportParameters(sReportAndPath, historyID, forRendering,
> values, credentials);
> if ((parameters != null) && (parameters.Length > 0))
> {
> foreach (ReportingService.ReportParameter rp in parameters)
> {
> if (rp.PromptUser)
> {
> // Display parameter and parameter default values on screen
> // Only display parameters that are NOT internal AND NOT hidden
> // PromptUser property takes care of the internal
> // hidden parameters appear to have a PromptUser = true
> }
> }
> }
>
> How can we do this?
> If we set the parameter to internal, then it doesn't display, but we get an
> error later when we try to update the parameter value (because it's
> read-only). If we set the parameter to hidden, then it gets displayed on
> screen because the PromptUser property is true.
> Basically, we want to be able to change the parameter value (thus NOT
> read-only), but, at the same time, not display on screen (PromptUser => false).
> Hope this makes sense.
> Any suggestions?
>
>|||What I have found is the a hidden parameter and an actual parameter to
be displayed are only different based on the prompt. An internal's
promptuser will be false and there will be no prompt.
If you remember in RS2000, you had to go into the Report Server
Interface and set the parameters promptuser to true and clear out the
prompt. Although a "hidden" indicator is now available in the IDE for
RS2005, the identification through the web service seems not to have
changed.
So, if you look for rp.promptuser && (rp.Prompt.Length > 0), you will
get the correct parameters to display in the UI. If you want to set
the hidden parameters, obmit the (rp.Prompt.Length > 0).
Hopes this helps.
steggun wrote:
> We have an application that gets a report's parameters and parameter values.
> We're using SQL Server 2005. The problem is that we need a couple of the
> report's parameters to be non-prompting AND not read-only.
> In our application, we dynamically build the UI based on the parameters and
> parameter values retrieved from the report, but we only want to display
> parameters that are PromptUser = true and not hidden and not read-only.
> Here's the code:
>
> ReportingService.ReportingService2005 rs = new
> ReportingService.ReportingService2005();
> rs.Credentials = System.Net.CredentialCache.DefaultCredentials;
> string historyID = null;
> bool forRendering = true;
> ReportingService.ParameterValue[] values = null;
> ReportingService.DataSourceCredentials[] credentials = null;
> ReportingService.ReportParameter[] parameters = null;
> parameters = rs.GetReportParameters(sReportAndPath, historyID, forRendering,
> values, credentials);
> if ((parameters != null) && (parameters.Length > 0))
> {
> foreach (ReportingService.ReportParameter rp in parameters)
> {
> if (rp.PromptUser)
> {
> // Display parameter and parameter default values on screen
> // Only display parameters that are NOT internal AND NOT hidden
> // PromptUser property takes care of the internal
> // hidden parameters appear to have a PromptUser = true
> }
> }
> }
>
> How can we do this?
> If we set the parameter to internal, then it doesn't display, but we get an
> error later when we try to update the parameter value (because it's
> read-only). If we set the parameter to hidden, then it gets displayed on
> screen because the PromptUser property is true.
> Basically, we want to be able to change the parameter value (thus NOT
> read-only), but, at the same time, not display on screen (PromptUser => false).
> Hope this makes sense.
> Any suggestions?

Hidden vs. Internal Parameters -- Got to be a better way...

We have an application that gets a report's parameters and parameter values. We're using SQL Server 2005. The problem is that we need a couple of the report's parameters to be non-prompting AND not read-only.

In our application, we dynamically build the UI based on the parameters and parameter values retrieved from the report, but we only want to display parameters that are PromptUser = true and not hidden and not read-only. Here's the code:

ReportingService.ReportingService2005 rs = new ReportingService.ReportingService2005();
rs.Credentials = System.Net.CredentialCache.DefaultCredentials;

string historyID = null;
bool forRendering = true;
ReportingService.ParameterValue[] values = null;
ReportingService.DataSourceCredentials[] credentials = null;
ReportingService.ReportParameter[] parameters = null;

parameters = rs.GetReportParameters(sReportAndPath, historyID, forRendering, values, credentials);

if ((parameters != null) && (parameters.Length > 0))
{
foreach (ReportingService.ReportParameter rp in parameters)
{
if (rp.PromptUser)
{
// Display parameter and parameter default values on screen
// Only display parameters that are NOT internal AND NOT hidden
// PromptUser property takes care of the internal
// hidden parameters appear to have a PromptUser = true
}
}
}

How can we do this?

If we set the parameter to internal, then it doesn't display, but we get an error later when we try to update the parameter value (because it's read-only). If we set the parameter to hidden, then it gets displayed on screen because the PromptUser property is true.

Basically, we want to be able to change the parameter value (thus NOT read-only), but, at the same time, not display on screen (PromptUser = false).

Hope this makes sense.

Any suggestions?

If the parameter is hidden, string.IsNullOrEmpty(rp.Prompt) == true && rp.PromptUser == true.sql

hidden report parameters

Hi, my report has 3 parameters, 2 of which I don't want displayed since I
will set these programatically. I am unable to successfully make these
parameters hidden. I have tried the following suggested solutions:
1-) when parameter 'hidden' option is selected
error: "The given key was not present in the dictionary"
2-) when parameter 'prompt' option is selected with
prompt label set to empty
error: "The report parameter is read-only and cannot be
modified"
3-) when parameter 'prompt' option is selected with
prompt label set to one space.
no error, but parameters show up on report w/out labels.
4-) modify the RDL XML to leave an empty prompt
attribute - i.e. <prompt></prompt>
error: "The given key was not present in the dictionary"
I am running SQL 2005 June CTP. Reporting Services
version is 9.00.1187.00.
Thanks for any insight you can provide.
--steveEver discover problem. Some more information, we are trying to use RDL older
version and using in CTP2005 version and that is what is causing the error.
"stark" wrote:
> Hi, my report has 3 parameters, 2 of which I don't want displayed since I
> will set these programatically. I am unable to successfully make these
> parameters hidden. I have tried the following suggested solutions:
> 1-) when parameter 'hidden' option is selected
> error: "The given key was not present in the dictionary"
> 2-) when parameter 'prompt' option is selected with
> prompt label set to empty
> error: "The report parameter is read-only and cannot be
> modified"
> 3-) when parameter 'prompt' option is selected with
> prompt label set to one space.
> no error, but parameters show up on report w/out labels.
> 4-) modify the RDL XML to leave an empty prompt
> attribute - i.e. <prompt></prompt>
> error: "The given key was not present in the dictionary"
> I am running SQL 2005 June CTP. Reporting Services
> version is 9.00.1187.00.
> Thanks for any insight you can provide.
> --steve
>sql

Hidden Parrameters

Hi,
I want to send to my Report hidden parameters by Url.
I read that in order to do so I need to check the Prompt User checkbox
and clear the Prompt string.
But I can't find the Prompt User checkbox in the Report Parameters window.
I installed SP1, but still I can't find this checkbox.
Where is it?
Thanks,
LimorHi Limor,
You can define a parameter as a hidden parameter on the Report Server where
you deploy it.
Unfortunately this is a minus point for RS since the hidden parameters are
first introduced with Service Pack 1
You just go to the Report Properties Tab on the Report Server for that report.
Select Parameters from the left menu.
When you click it then the list of parameters will be displayed. You will
see the "Prompt User" checkbox there.
Eralper
http://www.kodyaz.com
"Limor Bellison" wrote:
> Hi,
> I want to send to my Report hidden parameters by Url.
> I read that in order to do so I need to check the Prompt User checkbox
> and clear the Prompt string.
> But I can't find the Prompt User checkbox in the Report Parameters window.
> I installed SP1, but still I can't find this checkbox.
> Where is it?
> Thanks,
> Limor
>|||Hi eralper,
Thanx for your fast response.
I did exactly what you told me and get into the Parameters window,
but there is no "Prompt User" checkbox.
Do you want me to send you a print screen of this window to your email?
Limor
"eralper" wrote:
> Hi Limor,
> You can define a parameter as a hidden parameter on the Report Server where
> you deploy it.
> Unfortunately this is a minus point for RS since the hidden parameters are
> first introduced with Service Pack 1
> You just go to the Report Properties Tab on the Report Server for that report.
> Select Parameters from the left menu.
> When you click it then the list of parameters will be displayed. You will
> see the "Prompt User" checkbox there.
> Eralper
> http://www.kodyaz.com
>
> "Limor Bellison" wrote:
> > Hi,
> > I want to send to my Report hidden parameters by Url.
> > I read that in order to do so I need to check the Prompt User checkbox
> > and clear the Prompt string.
> > But I can't find the Prompt User checkbox in the Report Parameters window.
> > I installed SP1, but still I can't find this checkbox.
> > Where is it?
> >
> > Thanks,
> >
> > Limor
> >|||Hi Limor,
I added a post at http://www.kodyaz.com/ShowPost.aspx?PostID=291 about this
subject and attached two images. One for the settings and the other is for
sending the hidden parameter by url
"Limor Bellison" wrote:
> Hi eralper,
> Thanx for your fast response.
> I did exactly what you told me and get into the Parameters window,
> but there is no "Prompt User" checkbox.
> Do you want me to send you a print screen of this window to your email?
> Limor
>
> "eralper" wrote:
> > Hi Limor,
> >
> > You can define a parameter as a hidden parameter on the Report Server where
> > you deploy it.
> >
> > Unfortunately this is a minus point for RS since the hidden parameters are
> > first introduced with Service Pack 1
> >
> > You just go to the Report Properties Tab on the Report Server for that report.
> > Select Parameters from the left menu.
> > When you click it then the list of parameters will be displayed. You will
> > see the "Prompt User" checkbox there.
> >
> > Eralper
> > http://www.kodyaz.com
> >
> >
> >
> > "Limor Bellison" wrote:
> >
> > > Hi,
> > > I want to send to my Report hidden parameters by Url.
> > > I read that in order to do so I need to check the Prompt User checkbox
> > > and clear the Prompt string.
> > > But I can't find the Prompt User checkbox in the Report Parameters window.
> > > I installed SP1, but still I can't find this checkbox.
> > > Where is it?
> > >
> > > Thanks,
> > >
> > > Limor
> > >|||Thank you, this is exactly what I needed.
My mistake was that I was trying to do it from the visual studio instead of
the Report Manager. Now it's working.
Thanx,
Limor
"eralper" wrote:
> Hi Limor,
> I added a post at http://www.kodyaz.com/ShowPost.aspx?PostID=291 about this
> subject and attached two images. One for the settings and the other is for
> sending the hidden parameter by url
>
> "Limor Bellison" wrote:
> > Hi eralper,
> > Thanx for your fast response.
> > I did exactly what you told me and get into the Parameters window,
> > but there is no "Prompt User" checkbox.
> > Do you want me to send you a print screen of this window to your email?
> >
> > Limor
> >
> >
> > "eralper" wrote:
> >
> > > Hi Limor,
> > >
> > > You can define a parameter as a hidden parameter on the Report Server where
> > > you deploy it.
> > >
> > > Unfortunately this is a minus point for RS since the hidden parameters are
> > > first introduced with Service Pack 1
> > >
> > > You just go to the Report Properties Tab on the Report Server for that report.
> > > Select Parameters from the left menu.
> > > When you click it then the list of parameters will be displayed. You will
> > > see the "Prompt User" checkbox there.
> > >
> > > Eralper
> > > http://www.kodyaz.com
> > >
> > >
> > >
> > > "Limor Bellison" wrote:
> > >
> > > > Hi,
> > > > I want to send to my Report hidden parameters by Url.
> > > > I read that in order to do so I need to check the Prompt User checkbox
> > > > and clear the Prompt string.
> > > > But I can't find the Prompt User checkbox in the Report Parameters window.
> > > > I installed SP1, but still I can't find this checkbox.
> > > > Where is it?
> > > >
> > > > Thanks,
> > > >
> > > > Limor
> > > >

Hidden Parameters in SQL Server 2000 Reporting Services.

Hi all,

I am having a problem. I know of hidden parameters in SQL 2005 RS, but I need to have this functionality as well for SQL 2000 RS. I read on the Net that MS SQL 2000 RS Service Pack 1 adds this functionality. I have installed SP4 for SQL 2000, then I installed RS SP1 on my laptop, but I don't see that functionality in VS 2003 Enterprise Architect. I even installed RS SP2 on my other machine, but still no joy. Am I missing something here or is Microsoft lying about this functionality? My client will be upgrading to SQL 2005 sometime in the near future (if they don't change their minds again), but I need to implement this kind of functionality now. I can't wait for them to upgrade to SQL 2005. This parameter I need to hide in the reports is necessary to ensure the reports show data by specific department. I'll implement it in such a way that when they call the report from the web application, I'll pass the departmentID to the report via the query string.

P.S. It is not possible for me to achieve this using JOINs in the queries. The parameter lists themselves depend on this value.

Thanks a lot in advance for this

Ciao,
Hi there everyone.

I found the "solution" to this problem. You cannot set the hidden property of a parameter from within visual studio 2003 for SQL 2000 RS. You'll have to set it using the Report Manager. This is done in the "Properties" section under "Parameters" for the specific report. There is a checkbox for "Prompt user" which must be de-selected and the parameter will be invisible. A user must then select a default value for the parameter (which can be changed using the querystring when the parameter is called from an application). The query prompt must also be made to null.

This, to me, is very silly. But at least that is the solution.

Hope this helps you guys out there.

Eduard K.
|||

Hi Eduard,

I was experiencing the same problem. The solution as proposed using the Report Manager works indeed. However, I have to update my reports quit frequently and dont want to go to the Report Manager each time I deploy my reports. So here is the solution.

First remove the parameter from your report and deploy it. (This clears the parameter on the report server)

Then create the parameter again but leave the Prompt in VS2003 for the parameter empty. Deploy the report.

Because the prompt field is empty the report server will create the parameter but (and I checked this after deploying) the checkbox 'Prompt user' for the parameter in question in unchecked.

I hope this helps you to

Greetz

sql

Hidden Parameters in SQL Server 2000 Reporting Services.

Hi all,

I am having a problem. I know of hidden parameters in SQL 2005 RS, but I need to have this functionality as well for SQL 2000 RS. I read on the Net that MS SQL 2000 RS Service Pack 1 adds this functionality. I have installed SP4 for SQL 2000, then I installed RS SP1 on my laptop, but I don't see that functionality in VS 2003 Enterprise Architect. I even installed RS SP2 on my other machine, but still no joy. Am I missing something here or is Microsoft lying about this functionality? My client will be upgrading to SQL 2005 sometime in the near future (if they don't change their minds again), but I need to implement this kind of functionality now. I can't wait for them to upgrade to SQL 2005. This parameter I need to hide in the reports is necessary to ensure the reports show data by specific department. I'll implement it in such a way that when they call the report from the web application, I'll pass the departmentID to the report via the query string.

P.S. It is not possible for me to achieve this using JOINs in the queries. The parameter lists themselves depend on this value.

Thanks a lot in advance for this

Ciao,
Hi there everyone.

I found the "solution" to this problem. You cannot set the hidden property of a parameter from within visual studio 2003 for SQL 2000 RS. You'll have to set it using the Report Manager. This is done in the "Properties" section under "Parameters" for the specific report. There is a checkbox for "Prompt user" which must be de-selected and the parameter will be invisible. A user must then select a default value for the parameter (which can be changed using the querystring when the parameter is called from an application). The query prompt must also be made to null.

This, to me, is very silly. But at least that is the solution.

Hope this helps you guys out there.

Eduard K.
|||

Hi Eduard,

I was experiencing the same problem. The solution as proposed using the Report Manager works indeed. However, I have to update my reports quit frequently and dont want to go to the Report Manager each time I deploy my reports. So here is the solution.

First remove the parameter from your report and deploy it. (This clears the parameter on the report server)

Then create the parameter again but leave the Prompt in VS2003 for the parameter empty. Deploy the report.

Because the prompt field is empty the report server will create the parameter but (and I checked this after deploying) the checkbox 'Prompt user' for the parameter in question in unchecked.

I hope this helps you to

Greetz

Hidden parameters error (SP1)

I'm having problems with executing a report with a hidden parameter. For the
record, I've got SP1 installed.
I have a report with a date range that a user can modify:
From - defaults to previous business day
To - also defaults to previous business day
I also have a parameter called CurrentUserID (an integer) which is a user ID
that exists in a table called tblUser. I want this parameter to be hidden
from the user.
In Report Manager, I've gone into Properties, then Parameters, and set the
following for the CurrentUserID parameter:
Has Default - not ticked
Default Value - blank
Prompt User - ticked
Prompt String - blank
In the URL for the report, I add the following at the end:
&CurrentUserID=1083
where 1083 is a UserID I know should return some records in my test report.
However, I'm getting the following error:
This report requires a default or user-defined value for the report
parameter 'CurrentUserID'. To run or subscribe to this report, you must
provide a parameter value. (rsReportParameterValueNotSet)
I have tried the report again, this time with the CurrentUserID parameter
displayed, and entering the user ID 1083, and this time the report works
fine, so I know the stored procedure is not the problem.
Any suggestions to get this hidden parameter functionality to work would be
greatly appreciated.
Many thanks.
--
Jadranka Krapic
DBA
Stargate Technologies
(www.stargatetech.com.au)just give it a (non-used) default value fe -1
"Jadranka" wrote:
> I'm having problems with executing a report with a hidden parameter. For the
> record, I've got SP1 installed.
> I have a report with a date range that a user can modify:
> From - defaults to previous business day
> To - also defaults to previous business day
> I also have a parameter called CurrentUserID (an integer) which is a user ID
> that exists in a table called tblUser. I want this parameter to be hidden
> from the user.
> In Report Manager, I've gone into Properties, then Parameters, and set the
> following for the CurrentUserID parameter:
> Has Default - not ticked
> Default Value - blank
> Prompt User - ticked
> Prompt String - blank
> In the URL for the report, I add the following at the end:
> &CurrentUserID=1083
> where 1083 is a UserID I know should return some records in my test report.
> However, I'm getting the following error:
> This report requires a default or user-defined value for the report
> parameter 'CurrentUserID'. To run or subscribe to this report, you must
> provide a parameter value. (rsReportParameterValueNotSet)
> I have tried the report again, this time with the CurrentUserID parameter
> displayed, and entering the user ID 1083, and this time the report works
> fine, so I know the stored procedure is not the problem.
> Any suggestions to get this hidden parameter functionality to work would be
> greatly appreciated.
> Many thanks.
> --
> Jadranka Krapic
> DBA
> Stargate Technologies
> (www.stargatetech.com.au)|||Along the same lines, I am creating an interface to an client application to
launch reports. I need a way to be able to set a parameter from within the
application AND allow the developer to configure this setting so the report
can be deployed with no Report Manager configuration necessary. If I clear
the prompt from the report designer and deploy, the parameter then becomes
'read-only' and I cannot set it from code.
The only work around that I can find is to go in to Report Manager and turn
ON the Prompt User, then clear the Prompt text and then adapt for that in
code. This works fine except that it means I have to go to each of the 100
client's ReportManagers and configure this report this way. With 50 reports
with hidden parameters at 100 clients, that is just not possible.
Any suggestions?
"Antoon" wrote:
> just give it a (non-used) default value fe -1
> "Jadranka" wrote:
> > I'm having problems with executing a report with a hidden parameter. For the
> > record, I've got SP1 installed.
> >
> > I have a report with a date range that a user can modify:
> > From - defaults to previous business day
> > To - also defaults to previous business day
> >
> > I also have a parameter called CurrentUserID (an integer) which is a user ID
> > that exists in a table called tblUser. I want this parameter to be hidden
> > from the user.
> >
> > In Report Manager, I've gone into Properties, then Parameters, and set the
> > following for the CurrentUserID parameter:
> > Has Default - not ticked
> > Default Value - blank
> > Prompt User - ticked
> > Prompt String - blank
> >
> > In the URL for the report, I add the following at the end:
> > &CurrentUserID=1083
> > where 1083 is a UserID I know should return some records in my test report.
> >
> > However, I'm getting the following error:
> > This report requires a default or user-defined value for the report
> > parameter 'CurrentUserID'. To run or subscribe to this report, you must
> > provide a parameter value. (rsReportParameterValueNotSet)
> >
> > I have tried the report again, this time with the CurrentUserID parameter
> > displayed, and entering the user ID 1083, and this time the report works
> > fine, so I know the stored procedure is not the problem.
> >
> > Any suggestions to get this hidden parameter functionality to work would be
> > greatly appreciated.
> >
> > Many thanks.
> > --
> > Jadranka Krapic
> > DBA
> > Stargate Technologies
> > (www.stargatetech.com.au)|||Well, it's not clean but you could have a look at what exactly changes in the
reports (xml) when you change the settings in de report manager, and then
write a small program to make that change for your reports.
I hope they are going to fix this in RS2005
"rbowlin" wrote:
> Along the same lines, I am creating an interface to an client application to
> launch reports. I need a way to be able to set a parameter from within the
> application AND allow the developer to configure this setting so the report
> can be deployed with no Report Manager configuration necessary. If I clear
> the prompt from the report designer and deploy, the parameter then becomes
> 'read-only' and I cannot set it from code.
> The only work around that I can find is to go in to Report Manager and turn
> ON the Prompt User, then clear the Prompt text and then adapt for that in
> code. This works fine except that it means I have to go to each of the 100
> client's ReportManagers and configure this report this way. With 50 reports
> with hidden parameters at 100 clients, that is just not possible.
> Any suggestions?
> "Antoon" wrote:
> > just give it a (non-used) default value fe -1
> >
> > "Jadranka" wrote:
> >
> > > I'm having problems with executing a report with a hidden parameter. For the
> > > record, I've got SP1 installed.
> > >
> > > I have a report with a date range that a user can modify:
> > > From - defaults to previous business day
> > > To - also defaults to previous business day
> > >
> > > I also have a parameter called CurrentUserID (an integer) which is a user ID
> > > that exists in a table called tblUser. I want this parameter to be hidden
> > > from the user.
> > >
> > > In Report Manager, I've gone into Properties, then Parameters, and set the
> > > following for the CurrentUserID parameter:
> > > Has Default - not ticked
> > > Default Value - blank
> > > Prompt User - ticked
> > > Prompt String - blank
> > >
> > > In the URL for the report, I add the following at the end:
> > > &CurrentUserID=1083
> > > where 1083 is a UserID I know should return some records in my test report.
> > >
> > > However, I'm getting the following error:
> > > This report requires a default or user-defined value for the report
> > > parameter 'CurrentUserID'. To run or subscribe to this report, you must
> > > provide a parameter value. (rsReportParameterValueNotSet)
> > >
> > > I have tried the report again, this time with the CurrentUserID parameter
> > > displayed, and entering the user ID 1083, and this time the report works
> > > fine, so I know the stored procedure is not the problem.
> > >
> > > Any suggestions to get this hidden parameter functionality to work would be
> > > greatly appreciated.
> > >
> > > Many thanks.
> > > --
> > > Jadranka Krapic
> > > DBA
> > > Stargate Technologies
> > > (www.stargatetech.com.au)|||Thanks for your response.
I've tried the suggestion to set a non-used default value. The report now
loads error-free, however, it comes back with no data even though I've added
&CurrentUserID=1083 to the end of the URL (1083 is a user ID that should
return 3 records).
I've added a text box onto the report to show what's in the CurrentUserID
parameter when I run the report with &CurrentUserID=1083 in the URL. However,
it keeps showing the -1 I've set as the default. It doesn't appear to notice
the fact that I want to override the -1 default with my own user ID.
Any ideas?
Thanks.
--
Jadranka Krapic
DBA
Stargate Technologies
(www.stargatetech.com.au)
"Antoon" wrote:
> Well, it's not clean but you could have a look at what exactly changes in the
> reports (xml) when you change the settings in de report manager, and then
> write a small program to make that change for your reports.
> I hope they are going to fix this in RS2005
> "rbowlin" wrote:
> > Along the same lines, I am creating an interface to an client application to
> > launch reports. I need a way to be able to set a parameter from within the
> > application AND allow the developer to configure this setting so the report
> > can be deployed with no Report Manager configuration necessary. If I clear
> > the prompt from the report designer and deploy, the parameter then becomes
> > 'read-only' and I cannot set it from code.
> >
> > The only work around that I can find is to go in to Report Manager and turn
> > ON the Prompt User, then clear the Prompt text and then adapt for that in
> > code. This works fine except that it means I have to go to each of the 100
> > client's ReportManagers and configure this report this way. With 50 reports
> > with hidden parameters at 100 clients, that is just not possible.
> >
> > Any suggestions?
> >
> > "Antoon" wrote:
> >
> > > just give it a (non-used) default value fe -1
> > >
> > > "Jadranka" wrote:
> > >
> > > > I'm having problems with executing a report with a hidden parameter. For the
> > > > record, I've got SP1 installed.
> > > >
> > > > I have a report with a date range that a user can modify:
> > > > From - defaults to previous business day
> > > > To - also defaults to previous business day
> > > >
> > > > I also have a parameter called CurrentUserID (an integer) which is a user ID
> > > > that exists in a table called tblUser. I want this parameter to be hidden
> > > > from the user.
> > > >
> > > > In Report Manager, I've gone into Properties, then Parameters, and set the
> > > > following for the CurrentUserID parameter:
> > > > Has Default - not ticked
> > > > Default Value - blank
> > > > Prompt User - ticked
> > > > Prompt String - blank
> > > >
> > > > In the URL for the report, I add the following at the end:
> > > > &CurrentUserID=1083
> > > > where 1083 is a UserID I know should return some records in my test report.
> > > >
> > > > However, I'm getting the following error:
> > > > This report requires a default or user-defined value for the report
> > > > parameter 'CurrentUserID'. To run or subscribe to this report, you must
> > > > provide a parameter value. (rsReportParameterValueNotSet)
> > > >
> > > > I have tried the report again, this time with the CurrentUserID parameter
> > > > displayed, and entering the user ID 1083, and this time the report works
> > > > fine, so I know the stored procedure is not the problem.
> > > >
> > > > Any suggestions to get this hidden parameter functionality to work would be
> > > > greatly appreciated.
> > > >
> > > > Many thanks.
> > > > --
> > > > Jadranka Krapic
> > > > DBA
> > > > Stargate Technologies
> > > > (www.stargatetech.com.au)|||So you have: a default value, you've checked the box "prompt user" and have
left the prompt value blank?
If this is the case it should work.
"Jadranka" wrote:
> Thanks for your response.
> I've tried the suggestion to set a non-used default value. The report now
> loads error-free, however, it comes back with no data even though I've added
> &CurrentUserID=1083 to the end of the URL (1083 is a user ID that should
> return 3 records).
> I've added a text box onto the report to show what's in the CurrentUserID
> parameter when I run the report with &CurrentUserID=1083 in the URL. However,
> it keeps showing the -1 I've set as the default. It doesn't appear to notice
> the fact that I want to override the -1 default with my own user ID.
> Any ideas?
> Thanks.
> --
> Jadranka Krapic
> DBA
> Stargate Technologies
> (www.stargatetech.com.au)
>
> "Antoon" wrote:
> > Well, it's not clean but you could have a look at what exactly changes in the
> > reports (xml) when you change the settings in de report manager, and then
> > write a small program to make that change for your reports.
> > I hope they are going to fix this in RS2005
> >
> > "rbowlin" wrote:
> >
> > > Along the same lines, I am creating an interface to an client application to
> > > launch reports. I need a way to be able to set a parameter from within the
> > > application AND allow the developer to configure this setting so the report
> > > can be deployed with no Report Manager configuration necessary. If I clear
> > > the prompt from the report designer and deploy, the parameter then becomes
> > > 'read-only' and I cannot set it from code.
> > >
> > > The only work around that I can find is to go in to Report Manager and turn
> > > ON the Prompt User, then clear the Prompt text and then adapt for that in
> > > code. This works fine except that it means I have to go to each of the 100
> > > client's ReportManagers and configure this report this way. With 50 reports
> > > with hidden parameters at 100 clients, that is just not possible.
> > >
> > > Any suggestions?
> > >
> > > "Antoon" wrote:
> > >
> > > > just give it a (non-used) default value fe -1
> > > >
> > > > "Jadranka" wrote:
> > > >
> > > > > I'm having problems with executing a report with a hidden parameter. For the
> > > > > record, I've got SP1 installed.
> > > > >
> > > > > I have a report with a date range that a user can modify:
> > > > > From - defaults to previous business day
> > > > > To - also defaults to previous business day
> > > > >
> > > > > I also have a parameter called CurrentUserID (an integer) which is a user ID
> > > > > that exists in a table called tblUser. I want this parameter to be hidden
> > > > > from the user.
> > > > >
> > > > > In Report Manager, I've gone into Properties, then Parameters, and set the
> > > > > following for the CurrentUserID parameter:
> > > > > Has Default - not ticked
> > > > > Default Value - blank
> > > > > Prompt User - ticked
> > > > > Prompt String - blank
> > > > >
> > > > > In the URL for the report, I add the following at the end:
> > > > > &CurrentUserID=1083
> > > > > where 1083 is a UserID I know should return some records in my test report.
> > > > >
> > > > > However, I'm getting the following error:
> > > > > This report requires a default or user-defined value for the report
> > > > > parameter 'CurrentUserID'. To run or subscribe to this report, you must
> > > > > provide a parameter value. (rsReportParameterValueNotSet)
> > > > >
> > > > > I have tried the report again, this time with the CurrentUserID parameter
> > > > > displayed, and entering the user ID 1083, and this time the report works
> > > > > fine, so I know the stored procedure is not the problem.
> > > > >
> > > > > Any suggestions to get this hidden parameter functionality to work would be
> > > > > greatly appreciated.
> > > > >
> > > > > Many thanks.
> > > > > --
> > > > > Jadranka Krapic
> > > > > DBA
> > > > > Stargate Technologies
> > > > > (www.stargatetech.com.au)|||Yep, that's correct.
If I put my ID of 1083 in the default just to see if it works, my 3 records
come back fine. But when I put -1 as the default, and add the parameter to
the end of my URL (&CurrentUserID=1083), it doesn't.
--
Jadranka Krapic
DBA
Stargate Technologies
(www.stargatetech.com.au)
"Antoon" wrote:
> So you have: a default value, you've checked the box "prompt user" and have
> left the prompt value blank?
> If this is the case it should work.
> "Jadranka" wrote:
> > Thanks for your response.
> >
> > I've tried the suggestion to set a non-used default value. The report now
> > loads error-free, however, it comes back with no data even though I've added
> > &CurrentUserID=1083 to the end of the URL (1083 is a user ID that should
> > return 3 records).
> >
> > I've added a text box onto the report to show what's in the CurrentUserID
> > parameter when I run the report with &CurrentUserID=1083 in the URL. However,
> > it keeps showing the -1 I've set as the default. It doesn't appear to notice
> > the fact that I want to override the -1 default with my own user ID.
> >
> > Any ideas?
> >
> > Thanks.
> > --
> > Jadranka Krapic
> > DBA
> > Stargate Technologies
> > (www.stargatetech.com.au)
> >
> >
> > "Antoon" wrote:
> >
> > > Well, it's not clean but you could have a look at what exactly changes in the
> > > reports (xml) when you change the settings in de report manager, and then
> > > write a small program to make that change for your reports.
> > > I hope they are going to fix this in RS2005
> > >
> > > "rbowlin" wrote:
> > >
> > > > Along the same lines, I am creating an interface to an client application to
> > > > launch reports. I need a way to be able to set a parameter from within the
> > > > application AND allow the developer to configure this setting so the report
> > > > can be deployed with no Report Manager configuration necessary. If I clear
> > > > the prompt from the report designer and deploy, the parameter then becomes
> > > > 'read-only' and I cannot set it from code.
> > > >
> > > > The only work around that I can find is to go in to Report Manager and turn
> > > > ON the Prompt User, then clear the Prompt text and then adapt for that in
> > > > code. This works fine except that it means I have to go to each of the 100
> > > > client's ReportManagers and configure this report this way. With 50 reports
> > > > with hidden parameters at 100 clients, that is just not possible.
> > > >
> > > > Any suggestions?
> > > >
> > > > "Antoon" wrote:
> > > >
> > > > > just give it a (non-used) default value fe -1
> > > > >
> > > > > "Jadranka" wrote:
> > > > >
> > > > > > I'm having problems with executing a report with a hidden parameter. For the
> > > > > > record, I've got SP1 installed.
> > > > > >
> > > > > > I have a report with a date range that a user can modify:
> > > > > > From - defaults to previous business day
> > > > > > To - also defaults to previous business day
> > > > > >
> > > > > > I also have a parameter called CurrentUserID (an integer) which is a user ID
> > > > > > that exists in a table called tblUser. I want this parameter to be hidden
> > > > > > from the user.
> > > > > >
> > > > > > In Report Manager, I've gone into Properties, then Parameters, and set the
> > > > > > following for the CurrentUserID parameter:
> > > > > > Has Default - not ticked
> > > > > > Default Value - blank
> > > > > > Prompt User - ticked
> > > > > > Prompt String - blank
> > > > > >
> > > > > > In the URL for the report, I add the following at the end:
> > > > > > &CurrentUserID=1083
> > > > > > where 1083 is a UserID I know should return some records in my test report.
> > > > > >
> > > > > > However, I'm getting the following error:
> > > > > > This report requires a default or user-defined value for the report
> > > > > > parameter 'CurrentUserID'. To run or subscribe to this report, you must
> > > > > > provide a parameter value. (rsReportParameterValueNotSet)
> > > > > >
> > > > > > I have tried the report again, this time with the CurrentUserID parameter
> > > > > > displayed, and entering the user ID 1083, and this time the report works
> > > > > > fine, so I know the stored procedure is not the problem.
> > > > > >
> > > > > > Any suggestions to get this hidden parameter functionality to work would be
> > > > > > greatly appreciated.
> > > > > >
> > > > > > Many thanks.
> > > > > > --
> > > > > > Jadranka Krapic
> > > > > > DBA
> > > > > > Stargate Technologies
> > > > > > (www.stargatetech.com.au)|||can you give the complete url
"Jadranka" wrote:
> Yep, that's correct.
> If I put my ID of 1083 in the default just to see if it works, my 3 records
> come back fine. But when I put -1 as the default, and add the parameter to
> the end of my URL (&CurrentUserID=1083), it doesn't.
> --
> Jadranka Krapic
> DBA
> Stargate Technologies
> (www.stargatetech.com.au)
>
> "Antoon" wrote:
> > So you have: a default value, you've checked the box "prompt user" and have
> > left the prompt value blank?
> >
> > If this is the case it should work.
> >
> > "Jadranka" wrote:
> >
> > > Thanks for your response.
> > >
> > > I've tried the suggestion to set a non-used default value. The report now
> > > loads error-free, however, it comes back with no data even though I've added
> > > &CurrentUserID=1083 to the end of the URL (1083 is a user ID that should
> > > return 3 records).
> > >
> > > I've added a text box onto the report to show what's in the CurrentUserID
> > > parameter when I run the report with &CurrentUserID=1083 in the URL. However,
> > > it keeps showing the -1 I've set as the default. It doesn't appear to notice
> > > the fact that I want to override the -1 default with my own user ID.
> > >
> > > Any ideas?
> > >
> > > Thanks.
> > > --
> > > Jadranka Krapic
> > > DBA
> > > Stargate Technologies
> > > (www.stargatetech.com.au)
> > >
> > >
> > > "Antoon" wrote:
> > >
> > > > Well, it's not clean but you could have a look at what exactly changes in the
> > > > reports (xml) when you change the settings in de report manager, and then
> > > > write a small program to make that change for your reports.
> > > > I hope they are going to fix this in RS2005
> > > >
> > > > "rbowlin" wrote:
> > > >
> > > > > Along the same lines, I am creating an interface to an client application to
> > > > > launch reports. I need a way to be able to set a parameter from within the
> > > > > application AND allow the developer to configure this setting so the report
> > > > > can be deployed with no Report Manager configuration necessary. If I clear
> > > > > the prompt from the report designer and deploy, the parameter then becomes
> > > > > 'read-only' and I cannot set it from code.
> > > > >
> > > > > The only work around that I can find is to go in to Report Manager and turn
> > > > > ON the Prompt User, then clear the Prompt text and then adapt for that in
> > > > > code. This works fine except that it means I have to go to each of the 100
> > > > > client's ReportManagers and configure this report this way. With 50 reports
> > > > > with hidden parameters at 100 clients, that is just not possible.
> > > > >
> > > > > Any suggestions?
> > > > >
> > > > > "Antoon" wrote:
> > > > >
> > > > > > just give it a (non-used) default value fe -1
> > > > > >
> > > > > > "Jadranka" wrote:
> > > > > >
> > > > > > > I'm having problems with executing a report with a hidden parameter. For the
> > > > > > > record, I've got SP1 installed.
> > > > > > >
> > > > > > > I have a report with a date range that a user can modify:
> > > > > > > From - defaults to previous business day
> > > > > > > To - also defaults to previous business day
> > > > > > >
> > > > > > > I also have a parameter called CurrentUserID (an integer) which is a user ID
> > > > > > > that exists in a table called tblUser. I want this parameter to be hidden
> > > > > > > from the user.
> > > > > > >
> > > > > > > In Report Manager, I've gone into Properties, then Parameters, and set the
> > > > > > > following for the CurrentUserID parameter:
> > > > > > > Has Default - not ticked
> > > > > > > Default Value - blank
> > > > > > > Prompt User - ticked
> > > > > > > Prompt String - blank
> > > > > > >
> > > > > > > In the URL for the report, I add the following at the end:
> > > > > > > &CurrentUserID=1083
> > > > > > > where 1083 is a UserID I know should return some records in my test report.
> > > > > > >
> > > > > > > However, I'm getting the following error:
> > > > > > > This report requires a default or user-defined value for the report
> > > > > > > parameter 'CurrentUserID'. To run or subscribe to this report, you must
> > > > > > > provide a parameter value. (rsReportParameterValueNotSet)
> > > > > > >
> > > > > > > I have tried the report again, this time with the CurrentUserID parameter
> > > > > > > displayed, and entering the user ID 1083, and this time the report works
> > > > > > > fine, so I know the stored procedure is not the problem.
> > > > > > >
> > > > > > > Any suggestions to get this hidden parameter functionality to work would be
> > > > > > > greatly appreciated.
> > > > > > >
> > > > > > > Many thanks.
> > > > > > > --
> > > > > > > Jadranka Krapic
> > > > > > > DBA
> > > > > > > Stargate Technologies
> > > > > > > (www.stargatetech.com.au)|||Sure...URL when viewing the report via Report Manager is as follows
http://sqldev/Reports/Pages/Report.aspx?ItemPath=%2fRAMSReports%2frptFilesSentForSettlementRM_UserTest&CurrentUserID=1083
'&CurrentUserID=1083' is the user ID that, when used with the below
defaults, I know should return 3 records.
I have a number of parameters for this report (along with the troublesome
CurrentUserID) - all are displayed to the user and are changeable by them
except CurrentUserID:
Parameter Name Data Type Has Default Default Value
From DateTime Yes 1/03/2005 12:00:00 AM
To DateTime Yes 31/03/2005 12:00:00 AM
Channel Integer Yes 0
OrigState String Yes (ALL)
OriginatorID Integer Yes 0
SAM_FBM String Yes (ALL)
ReportAs String Yes Real-time
CurrentUserID Integer Yes -1
For CurrentUserID, Prompt User is ticked and Prompt String is blank.
Thanks.
--
Jadranka Krapic
DBA
Stargate Technologies
(www.stargatetech.com.au)
"Antoon" wrote:
> can you give the complete url
> "Jadranka" wrote:
> > Yep, that's correct.
> >
> > If I put my ID of 1083 in the default just to see if it works, my 3 records
> > come back fine. But when I put -1 as the default, and add the parameter to
> > the end of my URL (&CurrentUserID=1083), it doesn't.
> > --
> > Jadranka Krapic
> > DBA
> > Stargate Technologies
> > (www.stargatetech.com.au)
> >
> >
> > "Antoon" wrote:
> >
> > > So you have: a default value, you've checked the box "prompt user" and have
> > > left the prompt value blank?
> > >
> > > If this is the case it should work.
> > >
> > > "Jadranka" wrote:
> > >
> > > > Thanks for your response.
> > > >
> > > > I've tried the suggestion to set a non-used default value. The report now
> > > > loads error-free, however, it comes back with no data even though I've added
> > > > &CurrentUserID=1083 to the end of the URL (1083 is a user ID that should
> > > > return 3 records).
> > > >
> > > > I've added a text box onto the report to show what's in the CurrentUserID
> > > > parameter when I run the report with &CurrentUserID=1083 in the URL. However,
> > > > it keeps showing the -1 I've set as the default. It doesn't appear to notice
> > > > the fact that I want to override the -1 default with my own user ID.
> > > >
> > > > Any ideas?
> > > >
> > > > Thanks.
> > > > --
> > > > Jadranka Krapic
> > > > DBA
> > > > Stargate Technologies
> > > > (www.stargatetech.com.au)
> > > >
> > > >
> > > > "Antoon" wrote:
> > > >
> > > > > Well, it's not clean but you could have a look at what exactly changes in the
> > > > > reports (xml) when you change the settings in de report manager, and then
> > > > > write a small program to make that change for your reports.
> > > > > I hope they are going to fix this in RS2005
> > > > >
> > > > > "rbowlin" wrote:
> > > > >
> > > > > > Along the same lines, I am creating an interface to an client application to
> > > > > > launch reports. I need a way to be able to set a parameter from within the
> > > > > > application AND allow the developer to configure this setting so the report
> > > > > > can be deployed with no Report Manager configuration necessary. If I clear
> > > > > > the prompt from the report designer and deploy, the parameter then becomes
> > > > > > 'read-only' and I cannot set it from code.
> > > > > >
> > > > > > The only work around that I can find is to go in to Report Manager and turn
> > > > > > ON the Prompt User, then clear the Prompt text and then adapt for that in
> > > > > > code. This works fine except that it means I have to go to each of the 100
> > > > > > client's ReportManagers and configure this report this way. With 50 reports
> > > > > > with hidden parameters at 100 clients, that is just not possible.
> > > > > >
> > > > > > Any suggestions?
> > > > > >
> > > > > > "Antoon" wrote:
> > > > > >
> > > > > > > just give it a (non-used) default value fe -1
> > > > > > >
> > > > > > > "Jadranka" wrote:
> > > > > > >
> > > > > > > > I'm having problems with executing a report with a hidden parameter. For the
> > > > > > > > record, I've got SP1 installed.
> > > > > > > >
> > > > > > > > I have a report with a date range that a user can modify:
> > > > > > > > From - defaults to previous business day
> > > > > > > > To - also defaults to previous business day
> > > > > > > >
> > > > > > > > I also have a parameter called CurrentUserID (an integer) which is a user ID
> > > > > > > > that exists in a table called tblUser. I want this parameter to be hidden
> > > > > > > > from the user.
> > > > > > > >
> > > > > > > > In Report Manager, I've gone into Properties, then Parameters, and set the
> > > > > > > > following for the CurrentUserID parameter:
> > > > > > > > Has Default - not ticked
> > > > > > > > Default Value - blank
> > > > > > > > Prompt User - ticked
> > > > > > > > Prompt String - blank
> > > > > > > >
> > > > > > > > In the URL for the report, I add the following at the end:
> > > > > > > > &CurrentUserID=1083
> > > > > > > > where 1083 is a UserID I know should return some records in my test report.
> > > > > > > >
> > > > > > > > However, I'm getting the following error:
> > > > > > > > This report requires a default or user-defined value for the report
> > > > > > > > parameter 'CurrentUserID'. To run or subscribe to this report, you must
> > > > > > > > provide a parameter value. (rsReportParameterValueNotSet)
> > > > > > > >
> > > > > > > > I have tried the report again, this time with the CurrentUserID parameter
> > > > > > > > displayed, and entering the user ID 1083, and this time the report works
> > > > > > > > fine, so I know the stored procedure is not the problem.
> > > > > > > >
> > > > > > > > Any suggestions to get this hidden parameter functionality to work would be
> > > > > > > > greatly appreciated.
> > > > > > > >
> > > > > > > > Many thanks.
> > > > > > > > --
> > > > > > > > Jadranka Krapic
> > > > > > > > DBA
> > > > > > > > Stargate Technologies
> > > > > > > > (www.stargatetech.com.au)|||Perhaps you could try:
http://sqldev/Reports?%2fRAMSReports%2frptFilesSentForSettlementRM_UserTest&CurrentUserID=1083
"Jadranka" wrote:
> Sure...URL when viewing the report via Report Manager is as follows:
> http://sqldev/Reports/Pages/Report.aspx?ItemPath=%2fRAMSReports%2frptFilesSentForSettlementRM_UserTest&CurrentUserID=1083
> '&CurrentUserID=1083' is the user ID that, when used with the below
> defaults, I know should return 3 records.
> I have a number of parameters for this report (along with the troublesome
> CurrentUserID) - all are displayed to the user and are changeable by them
> except CurrentUserID:
> Parameter Name Data Type Has Default Default Value
> From DateTime Yes 1/03/2005 12:00:00 AM
> To DateTime Yes 31/03/2005 12:00:00 AM
> Channel Integer Yes 0
> OrigState String Yes (ALL)
> OriginatorID Integer Yes 0
> SAM_FBM String Yes (ALL)
> ReportAs String Yes Real-time
> CurrentUserID Integer Yes -1
> For CurrentUserID, Prompt User is ticked and Prompt String is blank.
> Thanks.
> --
> Jadranka Krapic
> DBA
> Stargate Technologies
> (www.stargatetech.com.au)
>
> "Antoon" wrote:
> > can you give the complete url
> >
> > "Jadranka" wrote:
> >
> > > Yep, that's correct.
> > >
> > > If I put my ID of 1083 in the default just to see if it works, my 3 records
> > > come back fine. But when I put -1 as the default, and add the parameter to
> > > the end of my URL (&CurrentUserID=1083), it doesn't.
> > > --
> > > Jadranka Krapic
> > > DBA
> > > Stargate Technologies
> > > (www.stargatetech.com.au)
> > >
> > >
> > > "Antoon" wrote:
> > >
> > > > So you have: a default value, you've checked the box "prompt user" and have
> > > > left the prompt value blank?
> > > >
> > > > If this is the case it should work.
> > > >
> > > > "Jadranka" wrote:
> > > >
> > > > > Thanks for your response.
> > > > >
> > > > > I've tried the suggestion to set a non-used default value. The report now
> > > > > loads error-free, however, it comes back with no data even though I've added
> > > > > &CurrentUserID=1083 to the end of the URL (1083 is a user ID that should
> > > > > return 3 records).
> > > > >
> > > > > I've added a text box onto the report to show what's in the CurrentUserID
> > > > > parameter when I run the report with &CurrentUserID=1083 in the URL. However,
> > > > > it keeps showing the -1 I've set as the default. It doesn't appear to notice
> > > > > the fact that I want to override the -1 default with my own user ID.
> > > > >
> > > > > Any ideas?
> > > > >
> > > > > Thanks.
> > > > > --
> > > > > Jadranka Krapic
> > > > > DBA
> > > > > Stargate Technologies
> > > > > (www.stargatetech.com.au)
> > > > >
> > > > >
> > > > > "Antoon" wrote:
> > > > >
> > > > > > Well, it's not clean but you could have a look at what exactly changes in the
> > > > > > reports (xml) when you change the settings in de report manager, and then
> > > > > > write a small program to make that change for your reports.
> > > > > > I hope they are going to fix this in RS2005
> > > > > >
> > > > > > "rbowlin" wrote:
> > > > > >
> > > > > > > Along the same lines, I am creating an interface to an client application to
> > > > > > > launch reports. I need a way to be able to set a parameter from within the
> > > > > > > application AND allow the developer to configure this setting so the report
> > > > > > > can be deployed with no Report Manager configuration necessary. If I clear
> > > > > > > the prompt from the report designer and deploy, the parameter then becomes
> > > > > > > 'read-only' and I cannot set it from code.
> > > > > > >
> > > > > > > The only work around that I can find is to go in to Report Manager and turn
> > > > > > > ON the Prompt User, then clear the Prompt text and then adapt for that in
> > > > > > > code. This works fine except that it means I have to go to each of the 100
> > > > > > > client's ReportManagers and configure this report this way. With 50 reports
> > > > > > > with hidden parameters at 100 clients, that is just not possible.
> > > > > > >
> > > > > > > Any suggestions?
> > > > > > >
> > > > > > > "Antoon" wrote:
> > > > > > >
> > > > > > > > just give it a (non-used) default value fe -1
> > > > > > > >
> > > > > > > > "Jadranka" wrote:
> > > > > > > >
> > > > > > > > > I'm having problems with executing a report with a hidden parameter. For the
> > > > > > > > > record, I've got SP1 installed.
> > > > > > > > >
> > > > > > > > > I have a report with a date range that a user can modify:
> > > > > > > > > From - defaults to previous business day
> > > > > > > > > To - also defaults to previous business day
> > > > > > > > >
> > > > > > > > > I also have a parameter called CurrentUserID (an integer) which is a user ID
> > > > > > > > > that exists in a table called tblUser. I want this parameter to be hidden
> > > > > > > > > from the user.
> > > > > > > > >
> > > > > > > > > In Report Manager, I've gone into Properties, then Parameters, and set the
> > > > > > > > > following for the CurrentUserID parameter:
> > > > > > > > > Has Default - not ticked
> > > > > > > > > Default Value - blank
> > > > > > > > > Prompt User - ticked
> > > > > > > > > Prompt String - blank
> > > > > > > > >
> > > > > > > > > In the URL for the report, I add the following at the end:
> > > > > > > > > &CurrentUserID=1083
> > > > > > > > > where 1083 is a UserID I know should return some records in my test report.
> > > > > > > > >
> > > > > > > > > However, I'm getting the following error:
> > > > > > > > > This report requires a default or user-defined value for the report
> > > > > > > > > parameter 'CurrentUserID'. To run or subscribe to this report, you must
> > > > > > > > > provide a parameter value. (rsReportParameterValueNotSet)
> > > > > > > > >
> > > > > > > > > I have tried the report again, this time with the CurrentUserID parameter
> > > > > > > > > displayed, and entering the user ID 1083, and this time the report works
> > > > > > > > > fine, so I know the stored procedure is not the problem.
> > > > > > > > >
> > > > > > > > > Any suggestions to get this hidden parameter functionality to work would be
> > > > > > > > > greatly appreciated.
> > > > > > > > >
> > > > > > > > > Many thanks.
> > > > > > > > > --
> > > > > > > > > Jadranka Krapic
> > > > > > > > > DBA
> > > > > > > > > Stargate Technologies
> > > > > > > > > (www.stargatetech.com.au)|||Hi Antoon,
I tried your suggested URL, but that always defaulted back to the Report
Manager Home page (http://sqldev/Reports/Pages/Folder.aspx).
However, I then tried going through Report Server
(http://sqldev/Reportserver?%2fRAMSReports%2frptFilesSentForSettlementRM_UserTest&CurrentUserID=1083),
and hey presto - IT WORKED! - I get the 3 records I am expecting. The
CurrentUserID parameter is hidden, and my test text box I placed on the
report to check what was in CurrentUserID is now correctly showing my user ID
of 1083. I think that now I can work with this.
Many thanks for your assistance Antoon. I (and I'm sure the client of this
project) really appreciate you taking the time to help out.
Thank you again.
--
Jadranka Krapic
DBA
Stargate Technologies
(www.stargatetech.com.au)
"Antoon" wrote:
> Perhaps you could try:
> http://sqldev/Reports?%2fRAMSReports%2frptFilesSentForSettlementRM_UserTest&CurrentUserID=1083
> "Jadranka" wrote:
> > Sure...URL when viewing the report via Report Manager is as follows:
> > http://sqldev/Reports/Pages/Report.aspx?ItemPath=%2fRAMSReports%2frptFilesSentForSettlementRM_UserTest&CurrentUserID=1083
> >
> > '&CurrentUserID=1083' is the user ID that, when used with the below
> > defaults, I know should return 3 records.
> >
> > I have a number of parameters for this report (along with the troublesome
> > CurrentUserID) - all are displayed to the user and are changeable by them
> > except CurrentUserID:
> >
> > Parameter Name Data Type Has Default Default Value
> > From DateTime Yes 1/03/2005 12:00:00 AM
> > To DateTime Yes 31/03/2005 12:00:00 AM
> > Channel Integer Yes 0
> > OrigState String Yes (ALL)
> > OriginatorID Integer Yes 0
> > SAM_FBM String Yes (ALL)
> > ReportAs String Yes Real-time
> > CurrentUserID Integer Yes -1
> >
> > For CurrentUserID, Prompt User is ticked and Prompt String is blank.
> >
> > Thanks.
> > --
> > Jadranka Krapic
> > DBA
> > Stargate Technologies
> > (www.stargatetech.com.au)
> >
> >
> > "Antoon" wrote:
> >
> > > can you give the complete url
> > >
> > > "Jadranka" wrote:
> > >
> > > > Yep, that's correct.
> > > >
> > > > If I put my ID of 1083 in the default just to see if it works, my 3 records
> > > > come back fine. But when I put -1 as the default, and add the parameter to
> > > > the end of my URL (&CurrentUserID=1083), it doesn't.
> > > > --
> > > > Jadranka Krapic
> > > > DBA
> > > > Stargate Technologies
> > > > (www.stargatetech.com.au)
> > > >
> > > >
> > > > "Antoon" wrote:
> > > >
> > > > > So you have: a default value, you've checked the box "prompt user" and have
> > > > > left the prompt value blank?
> > > > >
> > > > > If this is the case it should work.
> > > > >
> > > > > "Jadranka" wrote:
> > > > >
> > > > > > Thanks for your response.
> > > > > >
> > > > > > I've tried the suggestion to set a non-used default value. The report now
> > > > > > loads error-free, however, it comes back with no data even though I've added
> > > > > > &CurrentUserID=1083 to the end of the URL (1083 is a user ID that should
> > > > > > return 3 records).
> > > > > >
> > > > > > I've added a text box onto the report to show what's in the CurrentUserID
> > > > > > parameter when I run the report with &CurrentUserID=1083 in the URL. However,
> > > > > > it keeps showing the -1 I've set as the default. It doesn't appear to notice
> > > > > > the fact that I want to override the -1 default with my own user ID.
> > > > > >
> > > > > > Any ideas?
> > > > > >
> > > > > > Thanks.
> > > > > > --
> > > > > > Jadranka Krapic
> > > > > > DBA
> > > > > > Stargate Technologies
> > > > > > (www.stargatetech.com.au)
> > > > > >
> > > > > >
> > > > > > "Antoon" wrote:
> > > > > >
> > > > > > > Well, it's not clean but you could have a look at what exactly changes in the
> > > > > > > reports (xml) when you change the settings in de report manager, and then
> > > > > > > write a small program to make that change for your reports.
> > > > > > > I hope they are going to fix this in RS2005
> > > > > > >
> > > > > > > "rbowlin" wrote:
> > > > > > >
> > > > > > > > Along the same lines, I am creating an interface to an client application to
> > > > > > > > launch reports. I need a way to be able to set a parameter from within the
> > > > > > > > application AND allow the developer to configure this setting so the report
> > > > > > > > can be deployed with no Report Manager configuration necessary. If I clear
> > > > > > > > the prompt from the report designer and deploy, the parameter then becomes
> > > > > > > > 'read-only' and I cannot set it from code.
> > > > > > > >
> > > > > > > > The only work around that I can find is to go in to Report Manager and turn
> > > > > > > > ON the Prompt User, then clear the Prompt text and then adapt for that in
> > > > > > > > code. This works fine except that it means I have to go to each of the 100
> > > > > > > > client's ReportManagers and configure this report this way. With 50 reports
> > > > > > > > with hidden parameters at 100 clients, that is just not possible.
> > > > > > > >
> > > > > > > > Any suggestions?
> > > > > > > >
> > > > > > > > "Antoon" wrote:
> > > > > > > >
> > > > > > > > > just give it a (non-used) default value fe -1
> > > > > > > > >
> > > > > > > > > "Jadranka" wrote:
> > > > > > > > >
> > > > > > > > > > I'm having problems with executing a report with a hidden parameter. For the
> > > > > > > > > > record, I've got SP1 installed.
> > > > > > > > > >
> > > > > > > > > > I have a report with a date range that a user can modify:
> > > > > > > > > > From - defaults to previous business day
> > > > > > > > > > To - also defaults to previous business day
> > > > > > > > > >
> > > > > > > > > > I also have a parameter called CurrentUserID (an integer) which is a user ID
> > > > > > > > > > that exists in a table called tblUser. I want this parameter to be hidden
> > > > > > > > > > from the user.
> > > > > > > > > >
> > > > > > > > > > In Report Manager, I've gone into Properties, then Parameters, and set the
> > > > > > > > > > following for the CurrentUserID parameter:
> > > > > > > > > > Has Default - not ticked
> > > > > > > > > > Default Value - blank
> > > > > > > > > > Prompt User - ticked
> > > > > > > > > > Prompt String - blank
> > > > > > > > > >
> > > > > > > > > > In the URL for the report, I add the following at the end:
> > > > > > > > > > &CurrentUserID=1083
> > > > > > > > > > where 1083 is a UserID I know should return some records in my test report.
> > > > > > > > > >
> > > > > > > > > > However, I'm getting the following error:
> > > > > > > > > > This report requires a default or user-defined value for the report
> > > > > > > > > > parameter 'CurrentUserID'. To run or subscribe to this report, you must
> > > > > > > > > > provide a parameter value. (rsReportParameterValueNotSet)
> > > > > > > > > >
> > > > > > > > > > I have tried the report again, this time with the CurrentUserID parameter
> > > > > > > > > > displayed, and entering the user ID 1083, and this time the report works
> > > > > > > > > > fine, so I know the stored procedure is not the problem.
> > > > > > > > > >
> > > > > > > > > > Any suggestions to get this hidden parameter functionality to work would be
> > > > > > > > > > greatly appreciated.
> > > > > > > > > >
> > > > > > > > > > Many thanks.
> > > > > > > > > > --
> > > > > > > > > > Jadranka Krapic
> > > > > > > > > > DBA
> > > > > > > > > > Stargate Technologies
> > > > > > > > > > (www.stargatetech.com.au)