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 box. Show all posts
Showing posts with label box. Show all posts
Friday, March 30, 2012
Hide in list view
Within Report Manager you can check the 'Hide in list view' box for any
report within a folder, but then that report can still be viewed within that
folder if you select the 'Show Details' button on the folder header. I
expected the Show Details button not to be available for report users, but it
is. Is there another way of hiding a report within a folder?DKN,
You can modify the role assignments to prevent a user from navigating
the folder hierarchy.
Andy Potter
report within a folder, but then that report can still be viewed within that
folder if you select the 'Show Details' button on the folder header. I
expected the Show Details button not to be available for report users, but it
is. Is there another way of hiding a report within a folder?DKN,
You can modify the role assignments to prevent a user from navigating
the folder hierarchy.
Andy Potter
Monday, March 26, 2012
Hidden table details row and whitespace issue.
I have a table in a list box with more than one detail row..conditionally hidden based on some criteria..Is there any way to get rid of all the white space generated in the report viewer
From http://www.developmentnow.com/g/115_2004_12_0_29_0/sql-server-reporting-services.ht
Posted via DevelopmentNow.com Group
http://www.developmentnow.comOn Jul 24, 12:56 am, sash<she...@.hotmail.com> wrote:
> I have a table in a list box with more than one detail row..conditionally hidden based on some criteria..Is there any way to get rid of all the white space generated in the report viewer.
> Fromhttp://www.developmentnow.com/g/115_2004_12_0_29_0/sql-server-reporti...
> Posted via DevelopmentNow.com Groupshttp://www.developmentnow.com
There are not very many options available in this scenario. If you
haven't already selected decrease to accommodate contents in the
properties of the table control, I would suggest doing that first. The
most effective way to handle this is to manage it in the stored
procedure/query that sources the report. That way you can pass the
criteria back to the stored procedure and it can decide rather to
return a particular row in the returned dataset. Hope this helps.
Regards,
Enrique Martinez
Sr. Software Consultantsql
From http://www.developmentnow.com/g/115_2004_12_0_29_0/sql-server-reporting-services.ht
Posted via DevelopmentNow.com Group
http://www.developmentnow.comOn Jul 24, 12:56 am, sash<she...@.hotmail.com> wrote:
> I have a table in a list box with more than one detail row..conditionally hidden based on some criteria..Is there any way to get rid of all the white space generated in the report viewer.
> Fromhttp://www.developmentnow.com/g/115_2004_12_0_29_0/sql-server-reporti...
> Posted via DevelopmentNow.com Groupshttp://www.developmentnow.com
There are not very many options available in this scenario. If you
haven't already selected decrease to accommodate contents in the
properties of the table control, I would suggest doing that first. The
most effective way to handle this is to manage it in the stored
procedure/query that sources the report. That way you can pass the
criteria back to the stored procedure and it can decide rather to
return a particular row in the returned dataset. Hope this helps.
Regards,
Enrique Martinez
Sr. Software Consultantsql
Hidden Property - "Deserialization failed: is not a Valid Value" E
If I add an expression to the visibility property on a text box, table row,
etc.. and then remove that same expression, I get the following error message
in preview:
"deserialization failed: is not a valid value..."
I get an option to edit the XML code. When I look at the code, I find the
<Hidden /> tag. But get this, there is no </Hidden> tag. Apparently, VS is
removing only one side of the Hidden tag when I delete the expression.
I used to be able to edit the code, but now I can't even edit the code to
take the remaining tag out. With this error my rdl file became, for all
intents and purposes, corrupt. Luckily I had posted it to a dev Report
Manager site earlier and was able to recover it.
Has anyone seen this?
Also, not being able to close VS2005 because of the the "Modal Dialog
Open..." box is killing me. Anyone have a solution to that yet besides
killing the devenv process?
Thanks in Advance,
bsod55I just had a similar error - I had to open the file and remove the Hidden
tags. In the IDE I right clicked on the file and selected Open from the menu
- this gave me the XML version and allowed me to remove the tags.
--
mal
"bsod55" wrote:
> If I add an expression to the visibility property on a text box, table row,
> etc.. and then remove that same expression, I get the following error message
> in preview:
> "deserialization failed: is not a valid value..."
> I get an option to edit the XML code. When I look at the code, I find the
> <Hidden /> tag. But get this, there is no </Hidden> tag. Apparently, VS is
> removing only one side of the Hidden tag when I delete the expression.
> I used to be able to edit the code, but now I can't even edit the code to
> take the remaining tag out. With this error my rdl file became, for all
> intents and purposes, corrupt. Luckily I had posted it to a dev Report
> Manager site earlier and was able to recover it.
> Has anyone seen this?
> Also, not being able to close VS2005 because of the the "Modal Dialog
> Open..." box is killing me. Anyone have a solution to that yet besides
> killing the devenv process?
> Thanks in Advance,
> bsod55
etc.. and then remove that same expression, I get the following error message
in preview:
"deserialization failed: is not a valid value..."
I get an option to edit the XML code. When I look at the code, I find the
<Hidden /> tag. But get this, there is no </Hidden> tag. Apparently, VS is
removing only one side of the Hidden tag when I delete the expression.
I used to be able to edit the code, but now I can't even edit the code to
take the remaining tag out. With this error my rdl file became, for all
intents and purposes, corrupt. Luckily I had posted it to a dev Report
Manager site earlier and was able to recover it.
Has anyone seen this?
Also, not being able to close VS2005 because of the the "Modal Dialog
Open..." box is killing me. Anyone have a solution to that yet besides
killing the devenv process?
Thanks in Advance,
bsod55I just had a similar error - I had to open the file and remove the Hidden
tags. In the IDE I right clicked on the file and selected Open from the menu
- this gave me the XML version and allowed me to remove the tags.
--
mal
"bsod55" wrote:
> If I add an expression to the visibility property on a text box, table row,
> etc.. and then remove that same expression, I get the following error message
> in preview:
> "deserialization failed: is not a valid value..."
> I get an option to edit the XML code. When I look at the code, I find the
> <Hidden /> tag. But get this, there is no </Hidden> tag. Apparently, VS is
> removing only one side of the Hidden tag when I delete the expression.
> I used to be able to edit the code, but now I can't even edit the code to
> take the remaining tag out. With this error my rdl file became, for all
> intents and purposes, corrupt. Luckily I had posted it to a dev Report
> Manager site earlier and was able to recover it.
> Has anyone seen this?
> Also, not being able to close VS2005 because of the the "Modal Dialog
> Open..." box is killing me. Anyone have a solution to that yet besides
> killing the devenv process?
> Thanks in Advance,
> bsod55
Monday, March 12, 2012
heres a challenge for you all.
Ok, here's the problem. I have CA's Unicenter ServiceIT Enterprise Edition 5.0 running on a production box that has NT4 (SP6) and SQL server 2000 running on it.
Just before we continue, this is about backing up the database that ServiceIT connects to.
I know that you can schedule EM to make backup's of a specific database over a certain time, but this is part of the problem. What i have since discovered is that ServiceIT will not run on a database backed up and restored by EM.
It will however run on the restored backup created through the dos command pdm_backup (comes with ServiceIT).
What i am trying to figure out is to try a find a way that i can run a dos prompt command to do the following tasks at a specific time of day:
Stop the Paradigm Server Daemons (service)
Run a DBCC CHECKDB on the database AHDTEST50.
If there are no errors, create a verbose backup using the dos command pdm_backup -v -fC:\backup\[todaysdate]
If there are errors run a script to correct them, then run a backup
Restart the Paradigm Server DaemonsSchedule a batch file?|||can you set a batch file to do all of the above though?|||Only generating filenames with today's date (yyyymmdd) is usually a pain in batch (regional settings stuff like that) so I have a tendency to use a parameter instead. Next, I don't know how to check for errors the verbose backup might give; is there a log-file, would it suffice to do a find on it? I should think there's a way to cover that, so, other than that: I'd give it a go.|||Could you use something like:CREATE PROCEDURE Backup_ServiceIT
AS
DECLARE @.cBackup VARCHAR(500)
SET @.cBackup = pdm_backup -v -fC:\backup\' + Convert(CHAR(8), GetDate(), 112)
EXECUTE @.rc = master.dbo.xp_cmdshell 'NET STOP <paradigm service name>'
if 0 = @.rc DBCC CHECKDB ('AHDTEST50')
if 0 = @.@.error EXECUTE @.rc = master.dbo.xp_cmdshell @.cBackup
if 0 <> @.rc EXECUTE @.rc = master.dbo.xp_cmdshell '<fix error batch file>'
EXECUTE @.rc = master.dbo.xp_cmdshell 'NET START <paradigm service name>'
RETURN
GO-PatP|||Hey...when did you add your location?
http://www.ifb.net/webit/inveruri.htm
Just before we continue, this is about backing up the database that ServiceIT connects to.
I know that you can schedule EM to make backup's of a specific database over a certain time, but this is part of the problem. What i have since discovered is that ServiceIT will not run on a database backed up and restored by EM.
It will however run on the restored backup created through the dos command pdm_backup (comes with ServiceIT).
What i am trying to figure out is to try a find a way that i can run a dos prompt command to do the following tasks at a specific time of day:
Stop the Paradigm Server Daemons (service)
Run a DBCC CHECKDB on the database AHDTEST50.
If there are no errors, create a verbose backup using the dos command pdm_backup -v -fC:\backup\[todaysdate]
If there are errors run a script to correct them, then run a backup
Restart the Paradigm Server DaemonsSchedule a batch file?|||can you set a batch file to do all of the above though?|||Only generating filenames with today's date (yyyymmdd) is usually a pain in batch (regional settings stuff like that) so I have a tendency to use a parameter instead. Next, I don't know how to check for errors the verbose backup might give; is there a log-file, would it suffice to do a find on it? I should think there's a way to cover that, so, other than that: I'd give it a go.|||Could you use something like:CREATE PROCEDURE Backup_ServiceIT
AS
DECLARE @.cBackup VARCHAR(500)
SET @.cBackup = pdm_backup -v -fC:\backup\' + Convert(CHAR(8), GetDate(), 112)
EXECUTE @.rc = master.dbo.xp_cmdshell 'NET STOP <paradigm service name>'
if 0 = @.rc DBCC CHECKDB ('AHDTEST50')
if 0 = @.@.error EXECUTE @.rc = master.dbo.xp_cmdshell @.cBackup
if 0 <> @.rc EXECUTE @.rc = master.dbo.xp_cmdshell '<fix error batch file>'
EXECUTE @.rc = master.dbo.xp_cmdshell 'NET START <paradigm service name>'
RETURN
GO-PatP|||Hey...when did you add your location?
http://www.ifb.net/webit/inveruri.htm
Subscribe to:
Posts (Atom)