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
Showing posts with label sp1. Show all posts
Showing posts with label sp1. Show all posts
Friday, March 30, 2012
Hide Parameter with SP1
Installed SP1, still finding not possible to hide a parameter. Can someone provide the process please. The parameter is an ID that is send via URL to the report server. I created a Report Parameter for it, then created a queary parameter setting that to the incoming value of the Report Parameter. Help pleaseYou can hide a paremeter after you have deployed your report.
But hiding a parameter disallow you to pass any value to this parameter
through the URL!!!
The parameter is not simply hide to the user, is also completly inaccessible
to the user through any URL, but just available to the administrator to
change the default value of the parameter.
"Eddie" <Eddie@.discussions.microsoft.com> a écrit dans le message de
news:A077DD43-D64A-43DC-9D95-761106A4214E@.microsoft.com...
> Installed SP1, still finding not possible to hide a parameter. Can someone
provide the process please. The parameter is an ID that is send via URL to
the report server. I created a Report Parameter for it, then created a
queary parameter setting that to the incoming value of the Report Parameter.
Help please|||According to another post by Brian Welcker,
"This is onlt supported on the server. In Report Manager, leave the 'prompt
user' checkbox checked but clear our the prompt string. This should not
prompt the user but still allow you to specify them via URL."
with SP1, you should be able to specify in URL
"Jéjé" wrote:
> You can hide a paremeter after you have deployed your report.
> But hiding a parameter disallow you to pass any value to this parameter
> through the URL!!!
> The parameter is not simply hide to the user, is also completly inaccessible
> to the user through any URL, but just available to the administrator to
> change the default value of the parameter.
>
> "Eddie" <Eddie@.discussions.microsoft.com> a écrit dans le message de
> news:A077DD43-D64A-43DC-9D95-761106A4214E@.microsoft.com...
> > Installed SP1, still finding not possible to hide a parameter. Can someone
> provide the process please. The parameter is an ID that is send via URL to
> the report server. I created a Report Parameter for it, then created a
> queary parameter setting that to the incoming value of the Report Parameter.
> Help please
>
>|||From the SP1 Read Me:
4.3.1 Hiding Parameters in a Published Report
In Report Manager, you can now set parameter properties in a way that allows you to achieve two objectives simultaneously:
Hide the parameter fields in a published report.
Specify a parameter value at run time (for example, through a subscription that is used to trigger report execution and delivery).
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.
"Jéjé" wrote:
> You can hide a paremeter after you have deployed your report.
> But hiding a parameter disallow you to pass any value to this parameter
> through the URL!!!
> The parameter is not simply hide to the user, is also completly inaccessible
> to the user through any URL, but just available to the administrator to
> change the default value of the parameter.
>
> "Eddie" <Eddie@.discussions.microsoft.com> a écrit dans le message de
> news:A077DD43-D64A-43DC-9D95-761106A4214E@.microsoft.com...
> > Installed SP1, still finding not possible to hide a parameter. Can someone
> provide the process please. The parameter is an ID that is send via URL to
> the report server. I created a Report Parameter for it, then created a
> queary parameter setting that to the incoming value of the Report Parameter.
> Help please
>
>|||mmmm...
I'll test this.
maybe this doesn't works for me because I have a default value.
"Eddie" <Eddie@.discussions.microsoft.com> a écrit dans le message de
news:A3AD4330-FF88-46BD-97B8-58AB215F4507@.microsoft.com...
> From the SP1 Read Me:
> 4.3.1 Hiding Parameters in a Published Report
> In Report Manager, you can now set parameter properties in a way that
allows you to achieve two objectives simultaneously:
> Hide the parameter fields in a published report.
> Specify a parameter value at run time (for example, through a subscription
that is used to trigger report execution and delivery).
> 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.
>
> "Jéjé" wrote:
> > You can hide a paremeter after you have deployed your report.
> > But hiding a parameter disallow you to pass any value to this parameter
> > through the URL!!!
> > The parameter is not simply hide to the user, is also completly
inaccessible
> > to the user through any URL, but just available to the administrator to
> > change the default value of the parameter.
> >
> >
> > "Eddie" <Eddie@.discussions.microsoft.com> a écrit dans le message de
> > news:A077DD43-D64A-43DC-9D95-761106A4214E@.microsoft.com...
> > > Installed SP1, still finding not possible to hide a parameter. Can
someone
> > provide the process please. The parameter is an ID that is send via URL
to
> > the report server. I created a Report Parameter for it, then created a
> > queary parameter setting that to the incoming value of the Report
Parameter.
> > Help please
> >
> >
> >|||Ok..
Now i have to create a subscription with specific parameters for this subscription and then i should uncheck Promt User checkbox?
Is that right?
The result report i'll use the parameter without problems?
"Eddie" wrote:
> From the SP1 Read Me:
> 4.3.1 Hiding Parameters in a Published Report
> In Report Manager, you can now set parameter properties in a way that allows you to achieve two objectives simultaneously:
> Hide the parameter fields in a published report.
> Specify a parameter value at run time (for example, through a subscription that is used to trigger report execution and delivery).
> 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.
But hiding a parameter disallow you to pass any value to this parameter
through the URL!!!
The parameter is not simply hide to the user, is also completly inaccessible
to the user through any URL, but just available to the administrator to
change the default value of the parameter.
"Eddie" <Eddie@.discussions.microsoft.com> a écrit dans le message de
news:A077DD43-D64A-43DC-9D95-761106A4214E@.microsoft.com...
> Installed SP1, still finding not possible to hide a parameter. Can someone
provide the process please. The parameter is an ID that is send via URL to
the report server. I created a Report Parameter for it, then created a
queary parameter setting that to the incoming value of the Report Parameter.
Help please|||According to another post by Brian Welcker,
"This is onlt supported on the server. In Report Manager, leave the 'prompt
user' checkbox checked but clear our the prompt string. This should not
prompt the user but still allow you to specify them via URL."
with SP1, you should be able to specify in URL
"Jéjé" wrote:
> You can hide a paremeter after you have deployed your report.
> But hiding a parameter disallow you to pass any value to this parameter
> through the URL!!!
> The parameter is not simply hide to the user, is also completly inaccessible
> to the user through any URL, but just available to the administrator to
> change the default value of the parameter.
>
> "Eddie" <Eddie@.discussions.microsoft.com> a écrit dans le message de
> news:A077DD43-D64A-43DC-9D95-761106A4214E@.microsoft.com...
> > Installed SP1, still finding not possible to hide a parameter. Can someone
> provide the process please. The parameter is an ID that is send via URL to
> the report server. I created a Report Parameter for it, then created a
> queary parameter setting that to the incoming value of the Report Parameter.
> Help please
>
>|||From the SP1 Read Me:
4.3.1 Hiding Parameters in a Published Report
In Report Manager, you can now set parameter properties in a way that allows you to achieve two objectives simultaneously:
Hide the parameter fields in a published report.
Specify a parameter value at run time (for example, through a subscription that is used to trigger report execution and delivery).
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.
"Jéjé" wrote:
> You can hide a paremeter after you have deployed your report.
> But hiding a parameter disallow you to pass any value to this parameter
> through the URL!!!
> The parameter is not simply hide to the user, is also completly inaccessible
> to the user through any URL, but just available to the administrator to
> change the default value of the parameter.
>
> "Eddie" <Eddie@.discussions.microsoft.com> a écrit dans le message de
> news:A077DD43-D64A-43DC-9D95-761106A4214E@.microsoft.com...
> > Installed SP1, still finding not possible to hide a parameter. Can someone
> provide the process please. The parameter is an ID that is send via URL to
> the report server. I created a Report Parameter for it, then created a
> queary parameter setting that to the incoming value of the Report Parameter.
> Help please
>
>|||mmmm...
I'll test this.
maybe this doesn't works for me because I have a default value.
"Eddie" <Eddie@.discussions.microsoft.com> a écrit dans le message de
news:A3AD4330-FF88-46BD-97B8-58AB215F4507@.microsoft.com...
> From the SP1 Read Me:
> 4.3.1 Hiding Parameters in a Published Report
> In Report Manager, you can now set parameter properties in a way that
allows you to achieve two objectives simultaneously:
> Hide the parameter fields in a published report.
> Specify a parameter value at run time (for example, through a subscription
that is used to trigger report execution and delivery).
> 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.
>
> "Jéjé" wrote:
> > You can hide a paremeter after you have deployed your report.
> > But hiding a parameter disallow you to pass any value to this parameter
> > through the URL!!!
> > The parameter is not simply hide to the user, is also completly
inaccessible
> > to the user through any URL, but just available to the administrator to
> > change the default value of the parameter.
> >
> >
> > "Eddie" <Eddie@.discussions.microsoft.com> a écrit dans le message de
> > news:A077DD43-D64A-43DC-9D95-761106A4214E@.microsoft.com...
> > > Installed SP1, still finding not possible to hide a parameter. Can
someone
> > provide the process please. The parameter is an ID that is send via URL
to
> > the report server. I created a Report Parameter for it, then created a
> > queary parameter setting that to the incoming value of the Report
Parameter.
> > Help please
> >
> >
> >|||Ok..
Now i have to create a subscription with specific parameters for this subscription and then i should uncheck Promt User checkbox?
Is that right?
The result report i'll use the parameter without problems?
"Eddie" wrote:
> From the SP1 Read Me:
> 4.3.1 Hiding Parameters in a Published Report
> In Report Manager, you can now set parameter properties in a way that allows you to achieve two objectives simultaneously:
> Hide the parameter fields in a published report.
> Specify a parameter value at run time (for example, through a subscription that is used to trigger report execution and delivery).
> 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.
Monday, March 26, 2012
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)
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)
Friday, March 23, 2012
Hidden Parameters and Default Values
I am using RS SP1, and to use a hidden parameter that is NOT read
only, after uploading the report into report manager.. at this stage
the report works FINE, with all the other parameters (not hidden)
working, they are combinations of query based lookups with query based
defaults, and ones with defaults by an expression in the report.
However after i go into the properties of the report in report
manager, to the parameters tab, and set the check box of my hidden
parameter ON, and set the prompt to an empty string (so its a hidden
but not readonly parameter).. then save that
THEN
my other parameters whose DEFAULT values were written by an expression
in the report - NO LONGER WORK
arrgh,
anybody got a solution?
the only work around i can think of is have a DUMMY SQL call that
basically just selects the value of my expression. (since the
parameters whose default values are based on a query rather than
expression still work)
Karli'm sure this is a bug..
whenever i have a default value for a parameter (that isn't pulldown)
that is calculated with an expression , weather it is based on a query,
or just a pure expression, all works fine, until you go to report
manager, and change anything in the parameters (i'm changing an
unrelated parmeter to be hidden (readable but not visible), when you
apply, all the default value calculations cease to work :(
Karl Prosser wrote:
> I am using RS SP1, and to use a hidden parameter that is NOT read
> only, after uploading the report into report manager.. at this stage
> the report works FINE, with all the other parameters (not hidden)
> working, they are combinations of query based lookups with query
based
> defaults, and ones with defaults by an expression in the report.
> However after i go into the properties of the report in report
> manager, to the parameters tab, and set the check box of my hidden
> parameter ON, and set the prompt to an empty string (so its a hidden
> but not readonly parameter).. then save that
> THEN
> my other parameters whose DEFAULT values were written by an
expression
> in the report - NO LONGER WORK
> arrgh,
> anybody got a solution?
> the only work around i can think of is have a DUMMY SQL call that
> basically just selects the value of my expression. (since the
> parameters whose default values are based on a query rather than
> expression still work)
> Karlsql
only, after uploading the report into report manager.. at this stage
the report works FINE, with all the other parameters (not hidden)
working, they are combinations of query based lookups with query based
defaults, and ones with defaults by an expression in the report.
However after i go into the properties of the report in report
manager, to the parameters tab, and set the check box of my hidden
parameter ON, and set the prompt to an empty string (so its a hidden
but not readonly parameter).. then save that
THEN
my other parameters whose DEFAULT values were written by an expression
in the report - NO LONGER WORK
arrgh,
anybody got a solution?
the only work around i can think of is have a DUMMY SQL call that
basically just selects the value of my expression. (since the
parameters whose default values are based on a query rather than
expression still work)
Karli'm sure this is a bug..
whenever i have a default value for a parameter (that isn't pulldown)
that is calculated with an expression , weather it is based on a query,
or just a pure expression, all works fine, until you go to report
manager, and change anything in the parameters (i'm changing an
unrelated parmeter to be hidden (readable but not visible), when you
apply, all the default value calculations cease to work :(
Karl Prosser wrote:
> I am using RS SP1, and to use a hidden parameter that is NOT read
> only, after uploading the report into report manager.. at this stage
> the report works FINE, with all the other parameters (not hidden)
> working, they are combinations of query based lookups with query
based
> defaults, and ones with defaults by an expression in the report.
> However after i go into the properties of the report in report
> manager, to the parameters tab, and set the check box of my hidden
> parameter ON, and set the prompt to an empty string (so its a hidden
> but not readonly parameter).. then save that
> THEN
> my other parameters whose DEFAULT values were written by an
expression
> in the report - NO LONGER WORK
> arrgh,
> anybody got a solution?
> the only work around i can think of is have a DUMMY SQL call that
> basically just selects the value of my expression. (since the
> parameters whose default values are based on a query rather than
> expression still work)
> Karlsql
Wednesday, March 21, 2012
hi pf usage
Hi all,
I have a 2-node SQL2000 SP4 cluster running on Server 2003 SP1 with 8GB RAM.
I have enabled AWE & PAE. The performance monitor shows a constant usage of
7.55GB of on the pagefile. Is this normal'
TIA!Yo have SP4. Did you apply KB 899761?
http://support.microsoft.com/kb/899761/
FIX: Not all memory is available when AWE is enabled on a computer that is
running a 32-bit version of SQL Server 2000 SP4
Use Performance Monitor to look into
SQLServer:Memory Manager - Total Server Memory (KB)
to verify SQL Server is using all the memory you are giving to it
Ben Nevarez, MCDBA, OCP
Database Administrator
"param@.community.nospam" wrote:
> Hi all,
> I have a 2-node SQL2000 SP4 cluster running on Server 2003 SP1 with 8GB RAM.
> I have enabled AWE & PAE. The performance monitor shows a constant usage of
> 7.55GB of on the pagefile. Is this normal'
> TIA!
>
>|||Yes, I have SP4 and have applied that hotfix. Perfmon shows 7534008 KB. What
could be up?
Thanks
"Ben Nevarez" <BenNevarez@.discussions.microsoft.com> wrote in message
news:81D4043B-3C8B-466C-A3E0-A5F3826E3F40@.microsoft.com...
> Yo have SP4. Did you apply KB 899761?
> http://support.microsoft.com/kb/899761/
> FIX: Not all memory is available when AWE is enabled on a computer that is
> running a 32-bit version of SQL Server 2000 SP4
> Use Performance Monitor to look into
> SQLServer:Memory Manager - Total Server Memory (KB)
> to verify SQL Server is using all the memory you are giving to it
> Ben Nevarez, MCDBA, OCP
> Database Administrator
>
> "param@.community.nospam" wrote:
>> Hi all,
>> I have a 2-node SQL2000 SP4 cluster running on Server 2003 SP1 with 8GB
>> RAM.
>> I have enabled AWE & PAE. The performance monitor shows a constant usage
>> of
>> 7.55GB of on the pagefile. Is this normal'
>> TIA!
>>|||OK, here is the weird part. I checked my 2nd node of the cluster and its PF
usage is only at about 400MB. What is weird is that I am running an
Active-Active mixed cluster. Server1 is running SQL2000 SP4 and has the
issue with high memory usage. Server2 is running SQL2005 SP1 and seems fine
on memory usage. Both the servers are identical machines.
TIA!
"Ben Nevarez" <BenNevarez@.discussions.microsoft.com> wrote in message
news:81D4043B-3C8B-466C-A3E0-A5F3826E3F40@.microsoft.com...
> Yo have SP4. Did you apply KB 899761?
> http://support.microsoft.com/kb/899761/
> FIX: Not all memory is available when AWE is enabled on a computer that is
> running a 32-bit version of SQL Server 2000 SP4
> Use Performance Monitor to look into
> SQLServer:Memory Manager - Total Server Memory (KB)
> to verify SQL Server is using all the memory you are giving to it
> Ben Nevarez, MCDBA, OCP
> Database Administrator
>
> "param@.community.nospam" wrote:
>> Hi all,
>> I have a 2-node SQL2000 SP4 cluster running on Server 2003 SP1 with 8GB
>> RAM.
>> I have enabled AWE & PAE. The performance monitor shows a constant usage
>> of
>> 7.55GB of on the pagefile. Is this normal'
>> TIA!
>>
I have a 2-node SQL2000 SP4 cluster running on Server 2003 SP1 with 8GB RAM.
I have enabled AWE & PAE. The performance monitor shows a constant usage of
7.55GB of on the pagefile. Is this normal'
TIA!Yo have SP4. Did you apply KB 899761?
http://support.microsoft.com/kb/899761/
FIX: Not all memory is available when AWE is enabled on a computer that is
running a 32-bit version of SQL Server 2000 SP4
Use Performance Monitor to look into
SQLServer:Memory Manager - Total Server Memory (KB)
to verify SQL Server is using all the memory you are giving to it
Ben Nevarez, MCDBA, OCP
Database Administrator
"param@.community.nospam" wrote:
> Hi all,
> I have a 2-node SQL2000 SP4 cluster running on Server 2003 SP1 with 8GB RAM.
> I have enabled AWE & PAE. The performance monitor shows a constant usage of
> 7.55GB of on the pagefile. Is this normal'
> TIA!
>
>|||Yes, I have SP4 and have applied that hotfix. Perfmon shows 7534008 KB. What
could be up?
Thanks
"Ben Nevarez" <BenNevarez@.discussions.microsoft.com> wrote in message
news:81D4043B-3C8B-466C-A3E0-A5F3826E3F40@.microsoft.com...
> Yo have SP4. Did you apply KB 899761?
> http://support.microsoft.com/kb/899761/
> FIX: Not all memory is available when AWE is enabled on a computer that is
> running a 32-bit version of SQL Server 2000 SP4
> Use Performance Monitor to look into
> SQLServer:Memory Manager - Total Server Memory (KB)
> to verify SQL Server is using all the memory you are giving to it
> Ben Nevarez, MCDBA, OCP
> Database Administrator
>
> "param@.community.nospam" wrote:
>> Hi all,
>> I have a 2-node SQL2000 SP4 cluster running on Server 2003 SP1 with 8GB
>> RAM.
>> I have enabled AWE & PAE. The performance monitor shows a constant usage
>> of
>> 7.55GB of on the pagefile. Is this normal'
>> TIA!
>>|||OK, here is the weird part. I checked my 2nd node of the cluster and its PF
usage is only at about 400MB. What is weird is that I am running an
Active-Active mixed cluster. Server1 is running SQL2000 SP4 and has the
issue with high memory usage. Server2 is running SQL2005 SP1 and seems fine
on memory usage. Both the servers are identical machines.
TIA!
"Ben Nevarez" <BenNevarez@.discussions.microsoft.com> wrote in message
news:81D4043B-3C8B-466C-A3E0-A5F3826E3F40@.microsoft.com...
> Yo have SP4. Did you apply KB 899761?
> http://support.microsoft.com/kb/899761/
> FIX: Not all memory is available when AWE is enabled on a computer that is
> running a 32-bit version of SQL Server 2000 SP4
> Use Performance Monitor to look into
> SQLServer:Memory Manager - Total Server Memory (KB)
> to verify SQL Server is using all the memory you are giving to it
> Ben Nevarez, MCDBA, OCP
> Database Administrator
>
> "param@.community.nospam" wrote:
>> Hi all,
>> I have a 2-node SQL2000 SP4 cluster running on Server 2003 SP1 with 8GB
>> RAM.
>> I have enabled AWE & PAE. The performance monitor shows a constant usage
>> of
>> 7.55GB of on the pagefile. Is this normal'
>> TIA!
>>
Monday, March 12, 2012
Hep! Printing Error from client (browser)
We have 2 servers with RS:
1.SQL RS 2000 SP3a
2.SQL RS 2005 SP1
When we try to use client side printing in SQL 2000 RS we getting error "An error occured during printing '0x8007F304' ".
When we try to use client side printing (from the same client PC) in SQL 2005 RS, it print fine without any problem
Thank you,
Lenn
Please check this posts
http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=247869&SiteID=1
|||That post refering to installing SQL2005 SP1 to fix printing problem. We have SQL2005 SP1 installed on 2005 server, but reports are not prints when RS running to SQL 2000 server!!
Thanks,
Lenn
Subscribe to:
Posts (Atom)