Historical tables, partitioning or what?

I have about 45000 records in a CSV file, which I am using as HTTP request parameters to query a website and store some results in a database. This is the kind of application which runs 24/7, so database grows really quickly. Every insert fires up a trigger, which has to look for some old records based on some criteria and modify the last inserted record. My client is crazy about performance on this one and suggested to move the old records into another table, which has exactly the same structure, but would serve as a historical table only (used to generate reports, statistics, etc.), whilst the original table would store only the latest rows (so no more than 45k at a given time, whereas the historical table may grow to millions of records). Is this a good idea? Having the performance in mind and the fact that there's that trigger - it has to run as quickly as possible - I might second that idea. Is it good or bad? What do you think?

I read a similar post here, which mentioned SQL Server 2005 partitioning, I might as well try this, although I never used it before.

I think you should use the archive table and partition it with 2005s new capabilities. This will allow you to easily administer the table(s). Heres a good link on 2005 partitioning. http://msdn2.microsoft.com/en-us/library/ms345146.aspx If you use a seperate archive table, you can create good indexes that will really speed queries. The only bad thing is that if you insert new records into it often, it could be slow. So, you might want to only insert new archive records during off-peak time if possible.
Tim|||I would caution to have the absolute minimal indexes on the archive table. In some situations, it may be efficient to create an index just for a report, and then remove the index as soon as the report is complete.|||Thanks for your comments. I read about SQL Server 2005's partitioning feature and find it very interesting (and useful, I think), but the application in question runs on the Express Edition currently with possible switch to a higher version, but doubtfuly the Enterprise one, so partitioning is out of the question, unfortunately. I will hopefuly use it when I will work on some enterprise level application in the future.

Hierarchical parameters

Hi all,
does anyone know if it is possible within sql server 2000 to create
dependent parameters ? Eg : i have one parameter "City". If a user selects a
ceratin city, i would want to see the other parameter "Street" being filled
with alle the available streets...
I thought i read somewhere that this is possible in sql server 2005, but I'm
not quite sure...
Thanks!Yes you can have cascading parameters... TO do this
1. Create a dataset which populates the second parameter...ie
select Streetname, streetid from mytable where City = @.city
Where city is the name of your city parameter...
2. Then in the Report Parameters window create the Street parameter, and
have it use the new dataset
3. Ensure the Street parameter comes AFTER the CITY parameter in the
parameter list...
Then you can use both City and Streetname in your dataset query to populate
the report...
Hope this helps
--
Wayne Snyder MCDBA, SQL Server MVP
Mariner, Charlotte, NC
I support the Professional Association for SQL Server ( PASS) and it''s
community of SQL Professionals.
"Koen" wrote:
> Hi all,
> does anyone know if it is possible within sql server 2000 to create
> dependent parameters ? Eg : i have one parameter "City". If a user selects a
> ceratin city, i would want to see the other parameter "Street" being filled
> with alle the available streets...
> I thought i read somewhere that this is possible in sql server 2005, but I'm
> not quite sure...
> Thanks!|||Thanks Wayne,
gonna try it out later this day...
Koen
"Wayne Snyder" wrote:
> Yes you can have cascading parameters... TO do this
> 1. Create a dataset which populates the second parameter...ie
> select Streetname, streetid from mytable where City = @.city
> Where city is the name of your city parameter...
> 2. Then in the Report Parameters window create the Street parameter, and
> have it use the new dataset
> 3. Ensure the Street parameter comes AFTER the CITY parameter in the
> parameter list...
> Then you can use both City and Streetname in your dataset query to populate
> the report...
> Hope this helps
> --
> Wayne Snyder MCDBA, SQL Server MVP
> Mariner, Charlotte, NC
> I support the Professional Association for SQL Server ( PASS) and it''s
> community of SQL Professionals.
>
> "Koen" wrote:
> > Hi all,
> >
> > does anyone know if it is possible within sql server 2000 to create
> > dependent parameters ? Eg : i have one parameter "City". If a user selects a
> > ceratin city, i would want to see the other parameter "Street" being filled
> > with alle the available streets...
> >
> > I thought i read somewhere that this is possible in sql server 2005, but I'm
> > not quite sure...
> >
> > Thanks!

Hiding/Showing Columns based on Parameters

I have a report that has a matrix in it. It is a multidimensional report with
drill down effects resulting from an MDX query. It has 2 columns (measures).
I have created a parameter in order to hide/show a column. I have written the
following expression for the Visibility property of my Heading and Field
Values of a column:
=iif(Parameters!Show.Value="Measures_COUNT",True, False)
What happens is: My column heading and the values both disappear (appears
blank) but the column remains there. i.e the column width doesnt become zero.
Has someone faced a similar problem' I could not find an expression for the
"width" property of my textboxes so that I could set them to zero.
Also, what I would like to get done:
User selects a list of fields from a page that will act as a filter for my
report data (i.e. where clause of the query ) can i modify my MDX query of
the report to take these values into account?
Also, the user selects a list of fields that he/she wants appearing in the
report. Can i pass these fields to the report and manipulate the columns at
run time. This is what i was trying to achieve by hiding/showing columns?
Thanks,
RishitHi,
The "width" property for a textbox can be founf by expanding the "size"
property. In order to do what you want to do you have to do the following:
Set the visibility of the column - not the individual fields that make up
the column.
Hope this helps.
"Rishit" wrote:
> I have a report that has a matrix in it. It is a multidimensional report with
> drill down effects resulting from an MDX query. It has 2 columns (measures).
> I have created a parameter in order to hide/show a column. I have written the
> following expression for the Visibility property of my Heading and Field
> Values of a column:
> =iif(Parameters!Show.Value="Measures_COUNT",True, False)
> What happens is: My column heading and the values both disappear (appears
> blank) but the column remains there. i.e the column width doesnt become zero.
> Has someone faced a similar problem' I could not find an expression for the
> "width" property of my textboxes so that I could set them to zero.
> Also, what I would like to get done:
> User selects a list of fields from a page that will act as a filter for my
> report data (i.e. where clause of the query ) can i modify my MDX query of
> the report to take these values into account?
> Also, the user selects a list of fields that he/she wants appearing in the
> report. Can i pass these fields to the report and manipulate the columns at
> run time. This is what i was trying to achieve by hiding/showing columns?
> Thanks,
> Rishit|||I'm sorry. I am not that familiar with using matrices and didn't realise they
are handled differently. Please let me know if you find an answer.
"Rishit" wrote:
> Hi,
> I checked the properties for the matrix column. The Visibility propert isnt
> present. Besides, the Width property of the field cannot be set to zero using
> an expression. It doesnt allow width to be set to zero thru an expression.
> Mithun
> "Andrew Byrne" wrote:
> > Hi,
> >
> > The "width" property for a textbox can be founf by expanding the "size"
> > property. In order to do what you want to do you have to do the following:
> >
> > Set the visibility of the column - not the individual fields that make up
> > the column.
> >
> >
> >
> > Hope this helps.
> >
> > "Rishit" wrote:
> >
> > > I have a report that has a matrix in it. It is a multidimensional report with
> > > drill down effects resulting from an MDX query. It has 2 columns (measures).
> > > I have created a parameter in order to hide/show a column. I have written the
> > > following expression for the Visibility property of my Heading and Field
> > > Values of a column:
> > > =iif(Parameters!Show.Value="Measures_COUNT",True, False)
> > > What happens is: My column heading and the values both disappear (appears
> > > blank) but the column remains there. i.e the column width doesnt become zero.
> > > Has someone faced a similar problem' I could not find an expression for the
> > > "width" property of my textboxes so that I could set them to zero.
> > >
> > > Also, what I would like to get done:
> > > User selects a list of fields from a page that will act as a filter for my
> > > report data (i.e. where clause of the query ) can i modify my MDX query of
> > > the report to take these values into account?
> > > Also, the user selects a list of fields that he/she wants appearing in the
> > > report. Can i pass these fields to the report and manipulate the columns at
> > > run time. This is what i was trying to achieve by hiding/showing columns?
> > >
> > > Thanks,
> > > Rishit|||you must go to the properties pane of the Matrix itself. Then go to
groupings. Go to the column grouping properties for visibility. Put your
coditional statement there.
"Andrew Byrne" wrote:
> I'm sorry. I am not that familiar with using matrices and didn't realise they
> are handled differently. Please let me know if you find an answer.
> "Rishit" wrote:
> > Hi,
> > I checked the properties for the matrix column. The Visibility propert isnt
> > present. Besides, the Width property of the field cannot be set to zero using
> > an expression. It doesnt allow width to be set to zero thru an expression.
> >
> > Mithun
> >
> > "Andrew Byrne" wrote:
> >
> > > Hi,
> > >
> > > The "width" property for a textbox can be founf by expanding the "size"
> > > property. In order to do what you want to do you have to do the following:
> > >
> > > Set the visibility of the column - not the individual fields that make up
> > > the column.
> > >
> > >
> > >
> > > Hope this helps.
> > >
> > > "Rishit" wrote:
> > >
> > > > I have a report that has a matrix in it. It is a multidimensional report with
> > > > drill down effects resulting from an MDX query. It has 2 columns (measures).
> > > > I have created a parameter in order to hide/show a column. I have written the
> > > > following expression for the Visibility property of my Heading and Field
> > > > Values of a column:
> > > > =iif(Parameters!Show.Value="Measures_COUNT",True, False)
> > > > What happens is: My column heading and the values both disappear (appears
> > > > blank) but the column remains there. i.e the column width doesnt become zero.
> > > > Has someone faced a similar problem' I could not find an expression for the
> > > > "width" property of my textboxes so that I could set them to zero.
> > > >
> > > > Also, what I would like to get done:
> > > > User selects a list of fields from a page that will act as a filter for my
> > > > report data (i.e. where clause of the query ) can i modify my MDX query of
> > > > the report to take these values into account?
> > > > Also, the user selects a list of fields that he/she wants appearing in the
> > > > report. Can i pass these fields to the report and manipulate the columns at
> > > > run time. This is what i was trying to achieve by hiding/showing columns?
> > > >
> > > > Thanks,
> > > > Rishit

Hiding UserID parameter

In my report I am using 4 parameters i.e UID, LocationID, StartDate and
EndDate.
I am passing the UID parameter to a report in a URL. Based on UID, Locations
will be displayed. I don't want to Show UID on the report parameters header,
But I want to show all other parameters on the report, so that the user can
select locations and StartDate and EndDate.
I have tried &rc:Parameters=false, but this is hiding all the parameters.
I want to Hide only one parameter i.e UID
Please help.Hi,
when you define your paramters within the "Report Parameters"-Window
leave the "Prompt" field of the UID empty.
So it won't be presented to the user parameter but it's still
accessible within your reports.
By the way, if you want to use the current login user (often NT
account) then you could also use the RS internal User!UserID variable.
best regards
BB|||Hi BB
Many thnx for your quick response.
I have applied your logic.
when the "Prompt" field of the UID empty, it does allow for saving the
report and follwoing error is coming
"c:\documents and settings\dimpu\my documents\visual studio
projects\fsreports\CustomerReport.rdl The report parameter â'UIDâ' has a
DefaultValue that has both or neither of the following: Values and
DataSetReference. DefaultValue must have exactly one of these elements."
So I have selected a default value for UserID. then it is ok and retrieving
data for that default userid.
But we can not pass a different user through URL.
Suppose the default value for the UserID =100
I want to pass UserID = 101 through URL
then the following error is coming
The report parameter 'UserID' is read-only and cannot be modified.
(rsReadOnlyReportParameter) Get Online Help
"BB_Reporting" wrote:
> Hi,
> when you define your paramters within the "Report Parameters"-Window
> leave the "Prompt" field of the UID empty.
> So it won't be presented to the user parameter but it's still
> accessible within your reports.
> By the way, if you want to use the current login user (often NT
> account) then you could also use the RS internal User!UserID variable.
> best regards
> BB
>|||After you have removed your Promt of UID, please, add a "dummy" value
to List e.g 100 as well as an default value "100". That should work...
cheers
BB|||After you deploy the report, go to the Report Manager and view the parameters
for the report. For the UID parameter, make sure the Prompt String is empty
and that Prompt User is checked. This should fix the problem. When you set
the Prompt String to empty from VS, it sets Prompt User to unchecked when
deployed.
"dimpu" wrote:
> Hi BB
> Many thnx for your quick response.
> I have applied your logic.
> when the "Prompt" field of the UID empty, it does allow for saving the
> report and follwoing error is coming
> "c:\documents and settings\dimpu\my documents\visual studio
> projects\fsreports\CustomerReport.rdl The report parameter â'UIDâ' has a
> DefaultValue that has both or neither of the following: Values and
> DataSetReference. DefaultValue must have exactly one of these elements."
> So I have selected a default value for UserID. then it is ok and retrieving
> data for that default userid.
> But we can not pass a different user through URL.
> Suppose the default value for the UserID =100
> I want to pass UserID = 101 through URL
> then the following error is coming
> The report parameter 'UserID' is read-only and cannot be modified.
> (rsReadOnlyReportParameter) Get Online Help
>
>
> "BB_Reporting" wrote:
> > Hi,
> >
> > when you define your paramters within the "Report Parameters"-Window
> > leave the "Prompt" field of the UID empty.
> >
> > So it won't be presented to the user parameter but it's still
> > accessible within your reports.
> >
> > By the way, if you want to use the current login user (often NT
> > account) then you could also use the RS internal User!UserID variable.
> >
> > best regards
> >
> > BB
> >
> >|||can you set the Prompt String from another parameter?
IIF(Parameter!A="A",Paramter!B.PromptString="",Paramter!B.PromptString="Something")?
"David Siebert" <DavidSiebert@.discussions.microsoft.com> wrote in message
news:4168C1A3-5098-4E43-BC86-01AAA8E40ED9@.microsoft.com...
> After you deploy the report, go to the Report Manager and view the
> parameters
> for the report. For the UID parameter, make sure the Prompt String is
> empty
> and that Prompt User is checked. This should fix the problem. When you
> set
> the Prompt String to empty from VS, it sets Prompt User to unchecked when
> deployed.
> "dimpu" wrote:
>> Hi BB
>> Many thnx for your quick response.
>> I have applied your logic.
>> when the "Prompt" field of the UID empty, it does allow for saving the
>> report and follwoing error is coming
>> "c:\documents and settings\dimpu\my documents\visual studio
>> projects\fsreports\CustomerReport.rdl The report parameter 'UID' has a
>> DefaultValue that has both or neither of the following: Values and
>> DataSetReference. DefaultValue must have exactly one of these elements."
>> So I have selected a default value for UserID. then it is ok and
>> retrieving
>> data for that default userid.
>> But we can not pass a different user through URL.
>> Suppose the default value for the UserID =100
>> I want to pass UserID = 101 through URL
>> then the following error is coming
>> The report parameter 'UserID' is read-only and cannot be modified.
>> (rsReadOnlyReportParameter) Get Online Help
>>
>>
>> "BB_Reporting" wrote:
>> > Hi,
>> >
>> > when you define your paramters within the "Report Parameters"-Window
>> > leave the "Prompt" field of the UID empty.
>> >
>> > So it won't be presented to the user parameter but it's still
>> > accessible within your reports.
>> >
>> > By the way, if you want to use the current login user (often NT
>> > account) then you could also use the RS internal User!UserID variable.
>> >
>> > best regards
>> >
>> > BB
>> >
>> >|||Thnx David, Solved this problem now.
"David Siebert" wrote:
> After you deploy the report, go to the Report Manager and view the parameters
> for the report. For the UID parameter, make sure the Prompt String is empty
> and that Prompt User is checked. This should fix the problem. When you set
> the Prompt String to empty from VS, it sets Prompt User to unchecked when
> deployed.
> "dimpu" wrote:
> > Hi BB
> >
> > Many thnx for your quick response.
> >
> > I have applied your logic.
> >
> > when the "Prompt" field of the UID empty, it does allow for saving the
> > report and follwoing error is coming
> >
> > "c:\documents and settings\dimpu\my documents\visual studio
> > projects\fsreports\CustomerReport.rdl The report parameter â'UIDâ' has a
> > DefaultValue that has both or neither of the following: Values and
> > DataSetReference. DefaultValue must have exactly one of these elements."
> >
> > So I have selected a default value for UserID. then it is ok and retrieving
> > data for that default userid.
> >
> > But we can not pass a different user through URL.
> >
> > Suppose the default value for the UserID =100
> >
> > I want to pass UserID = 101 through URL
> >
> > then the following error is coming
> >
> > The report parameter 'UserID' is read-only and cannot be modified.
> > (rsReadOnlyReportParameter) Get Online Help
> >
> >
> >
> >
> >
> > "BB_Reporting" wrote:
> >
> > > Hi,
> > >
> > > when you define your paramters within the "Report Parameters"-Window
> > > leave the "Prompt" field of the UID empty.
> > >
> > > So it won't be presented to the user parameter but it's still
> > > accessible within your reports.
> > >
> > > By the way, if you want to use the current login user (often NT
> > > account) then you could also use the RS internal User!UserID variable.
> > >
> > > best regards
> > >
> > > BB
> > >
> > >

Hiding the report parameters when i click on the View report button

hi All,
i am working in SQL reporting services 2005, i have requirement that i
need to show all the report parameters in the report layout and user
can enter or select the values when i click on the view report button,
the report parameters should be hided. i am not sure that we could hide
the report parameters when i click on the view report button.
anyone knows how to implement this. please let me know.
Thank you in advance.
VinodAny idea on the below issue!!!!
thanks
Vinod
Vinod wrote:
> hi All,
>
> i am working in SQL reporting services 2005, i have requirement that i
> need to show all the report parameters in the report layout and user
> can enter or select the values when i click on the view report button,
> the report parameters should be hided. i am not sure that we could hide
> the report parameters when i click on the view report button.
> anyone knows how to implement this. please let me know.
> Thank you in advance.
> Vinod

Hiding SOME parameters in the parameter toolbar

I am using the ReportViewer.dll in a ASP.NET web application. The report
being displayed takes 2 parameters. One of these is programmatically set. I
would like the user to select values only for the other parameter. So when
displaying the report within the control, can I just show the second
parameter on the toolbar and hide the first one?
The Parameters toolbar property in the ReportViewer control corresponds to
the 'Parameters' URL access parameter, which hides/displays the entire
parameter toolbar
(http://msdn.microsoft.com/library/default.asp?url=/library/en-us/RSPROG/htm/rsp_prog_urlaccess_959e.asp). Umm, is that bad news?OK I solved the problem...You just type in a blank string for the Prompt
value...
"Aparna" wrote:
> I am using the ReportViewer.dll in a ASP.NET web application. The report
> being displayed takes 2 parameters. One of these is programmatically set. I
> would like the user to select values only for the other parameter. So when
> displaying the report within the control, can I just show the second
> parameter on the toolbar and hide the first one?
> The Parameters toolbar property in the ReportViewer control corresponds to
> the 'Parameters' URL access parameter, which hides/displays the entire
> parameter toolbar
> (http://msdn.microsoft.com/library/default.asp?url=/library/en-us/RSPROG/htm/rsp_prog_urlaccess_959e.asp). Umm, is that bad news?|||On Wed, 26 Jan 2005 12:21:03 -0800, Aparna
<Aparna@.discussions.microsoft.com> wrote:
>OK I solved the problem...You just type in a blank string for the Prompt
>value...
>
How exactly does one "type in" a blank string? :)))
>"Aparna" wrote:
>> I am using the ReportViewer.dll in a ASP.NET web application. The report
>> being displayed takes 2 parameters. One of these is programmatically set. I
>> would like the user to select values only for the other parameter. So when
>> displaying the report within the control, can I just show the second
>> parameter on the toolbar and hide the first one?
>> The Parameters toolbar property in the ReportViewer control corresponds to
>> the 'Parameters' URL access parameter, which hides/displays the entire
>> parameter toolbar
>> (http://msdn.microsoft.com/library/default.asp?url=/library/en-us/RSPROG/htm/rsp_prog_urlaccess_959e.asp). Umm, is that bad news?|||haha...Not quite sure...However, it turns out my excitement was in vain...If
the prompt value is not specified, then the paratmeter becomes Read-only..So,
if you programatically want to assign values to it, you are out of luck! The
only way to set the value of that parameter is via the parameter property
page. So my orginal problem still stands...SOMEBODY HELLLP...
"Usenet User" wrote:
> On Wed, 26 Jan 2005 12:21:03 -0800, Aparna
> <Aparna@.discussions.microsoft.com> wrote:
> >OK I solved the problem...You just type in a blank string for the Prompt
> >value...
> >
> How exactly does one "type in" a blank string? :)))
>
> >"Aparna" wrote:
> >
> >> I am using the ReportViewer.dll in a ASP.NET web application. The report
> >> being displayed takes 2 parameters. One of these is programmatically set. I
> >> would like the user to select values only for the other parameter. So when
> >> displaying the report within the control, can I just show the second
> >> parameter on the toolbar and hide the first one?
> >>
> >> The Parameters toolbar property in the ReportViewer control corresponds to
> >> the 'Parameters' URL access parameter, which hides/displays the entire
> >> parameter toolbar
> >> (http://msdn.microsoft.com/library/default.asp?url=/library/en-us/RSPROG/htm/rsp_prog_urlaccess_959e.asp). Umm, is that bad news?
>

Hiding Report Parameters ToolBar

Hi,
I am generating report using stored procedures. I am passing values to the
SP parameters for the report through URL. When I generate the report, the
parameters are being displayed in a toolbar at the top of the report. Is
there any way I can hide the parameter toolbox or parameter list while
generating the report.
Regards,
Sudhakara.T.P.Have you set the Report Parameters to Hidden?
daw
"Sudhakara.T.P." wrote:
> Hi,
> I am generating report using stored procedures. I am passing values to the
> SP parameters for the report through URL. When I generate the report, the
> parameters are being displayed in a toolbar at the top of the report. Is
> there any way I can hide the parameter toolbox or parameter list while
> generating the report.
> Regards,
> Sudhakara.T.P.|||Hi,
I just experienced the same issue for my reports and I found out there
is plenty of ways to work it out. Share with you my findings. Many thanks to
SSRS experts!!
1) Create a custom CSS file at \MSSQL\Reporting
Services\ReportServer\Styles\. Modify the .ToolbarRefresh or
.ToolbarParameters etc. Change display:inline to display:none. This is to
hide certain items/icons at Toolbar which is not frequently used. Then, set
your access url like :
http://server/reportserver?/reportname&rc:Stylesheet=MyStyle (without the
.css extension)
More reference at
http://blogs.msdn.com/bimusings/archive/2005/07/08/436887.aspx
2) Add &rc:Toolbar=false after your report url to hide the entire toolbar.
3) Add &rc:Parameters=false / &rc:Parameters=Collapsed after your report
url to hide parameters list only.
4) Clear the checkbox of Prompt User through Report
Manager>Properties>Parameters.
HTH.
regards,
sammy
"daw" wrote:
> Have you set the Report Parameters to Hidden?
> daw
> "Sudhakara.T.P." wrote:
> > Hi,
> > I am generating report using stored procedures. I am passing values to the
> > SP parameters for the report through URL. When I generate the report, the
> > parameters are being displayed in a toolbar at the top of the report. Is
> > there any way I can hide the parameter toolbox or parameter list while
> > generating the report.
> >
> > Regards,
> > Sudhakara.T.P.

Hiding report parameters

Hi,
Is there way to hide parameters passed from the URL and show parameters in a
report? Some people suggested me to use &rc:Parameters=false, this is not
working for me, I have 2 parameters passed via URL and 3 parameters in the
report, &rc:Parameters=false will hide all.
TIAhi Raymond,
On the Reports menu bar click report and then select Parameters. Select the
Hidden check box. Select this option if the parameter value should not appear
on the report. Although hidden parameters do not appear on a report, they can
be set in other ways (for example, in subscriptions and through URLs).
Regards,
--
http://www.Designing-Systems.com
Email. Support@.Designing-Systems.com
----
"Raymond Du" wrote:
> Hi,
> Is there way to hide parameters passed from the URL and show parameters in a
> report? Some people suggested me to use &rc:Parameters=false, this is not
> working for me, I have 2 parameters passed via URL and 3 parameters in the
> report, &rc:Parameters=false will hide all.
> TIA
>
>

Hiding Report Parameters

I have a report with 3 parameters (Run Date, Branch, and Account Manager #).
We are using this report to show 3 different views (Corporate, Branch, and
Account Manager) and want to hide/disable the parameters that are not
required.
If the user wants to view the Corporate View, only the Run Date parameter is
to be displayed. The Branch and Account Manager # are defaulted to All using
the URL.
If the user wants to view the Branch View, only the Run Date and Branch
parameters are to be displayed. The Account Manager # is defaulted to All
using the URL.
Is it possible to hide these parameters in SQL Reporting Services 2000 using
the URL passed to the report?
If not, are there other ways?Yes. Push the report to a directory then create linked reports in 3
separate folders (corp, branch, acctMgr). You can specify whether or not
the parameter is hidden when you set up the linked report. You can then
grant the appropriate privileges on each of the three folders (don't grant
privileges to the three roles below on the primary report).
HTH
-Tim
"rwhitelaw" <rwhitelaw@.discussions.microsoft.com> wrote in message
news:FA85FF28-8F64-4FAC-80E1-8644629997CA@.microsoft.com...
>I have a report with 3 parameters (Run Date, Branch, and Account Manager
>#).
> We are using this report to show 3 different views (Corporate, Branch, and
> Account Manager) and want to hide/disable the parameters that are not
> required.
> If the user wants to view the Corporate View, only the Run Date parameter
> is
> to be displayed. The Branch and Account Manager # are defaulted to All
> using
> the URL.
> If the user wants to view the Branch View, only the Run Date and Branch
> parameters are to be displayed. The Account Manager # is defaulted to All
> using the URL.
> Is it possible to hide these parameters in SQL Reporting Services 2000
> using
> the URL passed to the report?
> If not, are there other ways?

Hiding Report Parameter UI - Still Using Parameters for Dynamic Column Sorting

Hello!
We are using a SortBy parameter and a Direction parameter for our report.
We are using dynamic sorting to allow the user to click on a column header
and sort that column. A click checks whether or not it is sorted asc or
desc and if it is, it changes the sorting to the direction it isn't
currently sorting. This functionality works perfect, but we do not want to
allow the users to sort using the parameter ui drop-down boxes. If we
removing the promt from the report designer it gives an error saying that
the parameter is read only and the report errors out. If we try to uncheck
the prompt box in report manager, it gives the same errors. We want to use
these parameters for sorting within the report, but we do not wish to have
the UI there as dropdowns. Is there a way to correct this? We appreciate
your help!UI seems to be confusing. You could try to use my script:
http://blogs.msdn.com/levs/archive/2004/07/20.aspx
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"jrennard" <jrennard3@.schneidercorp.com> wrote in message
news:unAnIkUhEHA.3664@.TK2MSFTNGP11.phx.gbl...
> Hello!
> We are using a SortBy parameter and a Direction parameter for our report.
> We are using dynamic sorting to allow the user to click on a column header
> and sort that column. A click checks whether or not it is sorted asc or
> desc and if it is, it changes the sorting to the direction it isn't
> currently sorting. This functionality works perfect, but we do not want
> to
> allow the users to sort using the parameter ui drop-down boxes. If we
> removing the promt from the report designer it gives an error saying that
> the parameter is read only and the report errors out. If we try to
> uncheck
> the prompt box in report manager, it gives the same errors. We want to
> use
> these parameters for sorting within the report, but we do not wish to have
> the UI there as dropdowns. Is there a way to correct this? We appreciate
> your help!
>|||That worked great.
Exactly what I was looking for.
I do have another question. Do you have a script, or know of a script that
will remove duplicate values from a filter UI? We have a bunch of clients
and when we pull in query values for the filter to filter by client it
duplicates clients within the list because on the same query we have
multiple users that are associated with the same client. A script to remove
those duplicates would be very sweet. Let me know what you think. Thanks
again! Great script!
"Lev Semenets [MSFT]" <levs@.microsoft.com> wrote in message
news:OBB0FcVhEHA.1276@.TK2MSFTNGP09.phx.gbl...
> UI seems to be confusing. You could try to use my script:
> http://blogs.msdn.com/levs/archive/2004/07/20.aspx
> --
> This posting is provided "AS IS" with no warranties, and confers no
rights.
> "jrennard" <jrennard3@.schneidercorp.com> wrote in message
> news:unAnIkUhEHA.3664@.TK2MSFTNGP11.phx.gbl...
> > Hello!
> >
> > We are using a SortBy parameter and a Direction parameter for our
report.
> > We are using dynamic sorting to allow the user to click on a column
header
> > and sort that column. A click checks whether or not it is sorted asc or
> > desc and if it is, it changes the sorting to the direction it isn't
> > currently sorting. This functionality works perfect, but we do not want
> > to
> > allow the users to sort using the parameter ui drop-down boxes. If we
> > removing the promt from the report designer it gives an error saying
that
> > the parameter is read only and the report errors out. If we try to
> > uncheck
> > the prompt box in report manager, it gives the same errors. We want to
> > use
> > these parameters for sorting within the report, but we do not wish to
have
> > the UI there as dropdowns. Is there a way to correct this? We
appreciate
> > your help!
> >
> >
>

Hiding parts of the report

Hello All,
I have to generate a report based on parameters. And each part of the
report depends based a particular set of parameters.
Is there a way to hide the parts of the report that i dont need to show
?
Thankx
BofoDid you look into the Visibility.Hidden property of reportitems? You can use
expressions based on parameter values to statically or dynamically hide
certain areas of a report.
More information can be found here:
*
http://msdn.microsoft.com/library/en-us/RShowto/htm/hrs_designer_v1_3kq5.asp
*
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/RSCREATE/htm/rcr_creating_dc_v1_0rc7.asp
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"Win2003InstallIssues" <bofobofo@.yahoo.com> wrote in message
news:1107047048.476551.144590@.c13g2000cwb.googlegroups.com...
> Hello All,
> I have to generate a report based on parameters. And each part of the
> report depends based a particular set of parameters.
> Is there a way to hide the parts of the report that i dont need to show
> ?
>
> Thankx
> Bofo
>|||Hello Robert,
I am partially successful in using the Hiding/hidden properties.
Here is the issue.
I have 7 diff parameters to my report, 2 main groups say A and B to gen
Areport and Breport
if the user enters any of the fields of Group A, the ReportB should not
appear and vice-versa.
Now I tried using the parameter.value of the Group B to hide Breport.
But to no avail. I can still see the Textbox label.
I can hide the table cos I created dummy fields in Select and use them
as the Labels for the table columns.
But what I need is something that will hide the entire part of the
report.
Any Ideas on how to go about it ?
Thx|||Finally got it.
This is the expr.
=iif((Parameters!param1.Value + Parameters!param2.Value +
Parameters!param3.Value +
Parameters!4.Value)="", TRUE, FALSE)
Rgds
Bofo

Hiding Parameters in Report

Assume I have a report with 5 parameters.Based on a parameter , Is it possible to hide another parameter in the report.I tried doing but ended in vain. Because the Report parameters I add belong to the ReportViewer toolbar, I'm unable to hide the parameter based on the selection of another parameter.

Can anyone help me out in this regard? Is it possible to hide a Report parameter based on the value selected in another parameter(drop-down menu for example....)

Hi,

If your parameter is query based, you will have to make your query return no rows. There is no property in the reporting parameters to set the parameter to disabled at runtime.

HTH, Jens Suessmeyer.

http://www.sqlserver2005.de

Hiding Parameters in Report

I'm using a URL to execute reports and I wish to have the parameters not displayed to the user. However, when I either uncheck the Promt User box or delete the prompt string, I get an error stating read only parameters can not be changed.
We have installed SP1 on the server so I thought this issue had been fixed.
TIA for any help.
Dave
--
Posted using Wimdows.net NntpNews Component -
Post Made from http://www.SqlJunkies.com/newsgroups Our newsgroup engine supports Post Alerts, Ratings, and Searching.If you don't want any parameters displayed to the user, add
rc:Parameters=false to the URL.
If you want only some of the parameters displayed, then for those that
should be hidden, make sure "Prompt User" is checked and the prompt string
is empty.
--
This posting is provided "AS IS" with no warranties, and confers no rights
"SqlJunkies User" <User@.-NOSPAM-SqlJunkies.com> wrote in message
news:OA03nKUXEHA.2520@.TK2MSFTNGP12.phx.gbl...
> I'm using a URL to execute reports and I wish to have the parameters not
displayed to the user. However, when I either uncheck the Promt User box or
delete the prompt string, I get an error stating read only parameters can
not be changed.
> We have installed SP1 on the server so I thought this issue had been
fixed.
> TIA for any help.
> Dave
> --
> Posted using Wimdows.net NntpNews Component -
> Post Made from http://www.SqlJunkies.com/newsgroups Our newsgroup engine
supports Post Alerts, Ratings, and Searching.

Hiding Parameters

Is it easy to hide the parameters of a report? Im using the ReportViewer tag in asp.net and I have my own parameters that I am passing into my report. But when the report renders, it shows the default parameters that look terrible in my application.

I was wondering if there was a way to only have my own parameters showing?

Thanks in advance everyone
man, just after I posted this I found the exact thing I wanted, the code is as follows:

reportViewer.Parameters = Microsoft.Samples.ReportingServices.ReportViewer.multiState.False;

Hiding Parameters

I have a popup window which shows the report. I don't want user to modify
the parameter of the displayed report.
how can i hide the parameter list.
I am familiar with rc:ToolBar = false while invoking the report how can i
disable parameter from being changed
thxtry setting the parameter(s) to be "Hidden" in the report properties applet
"nkg" wrote:
> I have a popup window which shows the report. I don't want user to modify
> the parameter of the displayed report.
> how can i hide the parameter list.
> I am familiar with rc:ToolBar = false while invoking the report how can i
> disable parameter from being changed
> thx
>
>|||thx
"Carl Henthorn" <CarlHenthorn@.discussions.microsoft.com> wrote in message
news:41752B0A-DB95-4B08-A3E3-04F51EA97686@.microsoft.com...
> try setting the parameter(s) to be "Hidden" in the report properties
> applet
> "nkg" wrote:
>> I have a popup window which shows the report. I don't want user to modify
>> the parameter of the displayed report.
>> how can i hide the parameter list.
>> I am familiar with rc:ToolBar = false while invoking the report how can i
>> disable parameter from being changed
>> thx
>>

hiding parameters

I'm using the included ReportViewer sample (basically it just just loads the
reporting services report page in an ifram), and I'd like to set report
parameters for the report by my ASP.NET application which houses the report.
Is there any way to have my app set the parameter, without prompting the
user?
--JasonI added a helper method to the ReportViewer:
public void SetQueryParameter(
string ParameterName,
string ParameterValue)
{
SetParameter(ParameterName,ParameterValue);
}
To set a parameter value then is as easy as:
rv.SetQueryParameter("SalesOrderNumber", "SO6003");
HTH,
--
Scott
http://www.OdeToCode.com/blogs/scott/
On Thu, 21 Oct 2004 10:55:24 -0400, "Jason W. Nadal"
<jnadal@.comcast.net> wrote:
>I'm using the included ReportViewer sample (basically it just just loads the
>reporting services report page in an ifram), and I'd like to set report
>parameters for the report by my ASP.NET application which houses the report.
>Is there any way to have my app set the parameter, without prompting the
>user?
>--Jason
>|||Scott,
Thanks a ton -- I wasn't sure if that method would just be used for the
parameters for the reportservices UI or for the reports. That helped a
great deal!
--Jason
"Scott Allen" <bitmask@.[nospam].fred.net> wrote in message
news:qmlfn050dor01d5ailc98qvlejmn2tl0rh@.4ax.com...
> I added a helper method to the ReportViewer:
> public void SetQueryParameter(
> string ParameterName,
> string ParameterValue)
> {
> SetParameter(ParameterName,ParameterValue);
> }
>
> To set a parameter value then is as easy as:
> rv.SetQueryParameter("SalesOrderNumber", "SO6003");
> HTH,
> --
> Scott
> http://www.OdeToCode.com/blogs/scott/
> On Thu, 21 Oct 2004 10:55:24 -0400, "Jason W. Nadal"
> <jnadal@.comcast.net> wrote:
> >I'm using the included ReportViewer sample (basically it just just loads
the
> >reporting services report page in an ifram), and I'd like to set report
> >parameters for the report by my ASP.NET application which houses the
report.
> >Is there any way to have my app set the parameter, without prompting the
> >user?
> >
> >--Jason
> >
>|||What name space is the "SetParameter" method a member of?
I get a compile error when I tried to copy and paste as is.
Thanks!!
Spo
"Scott Allen" wrote:
> I added a helper method to the ReportViewer:
> public void SetQueryParameter(
> string ParameterName,
> string ParameterValue)
> {
> SetParameter(ParameterName,ParameterValue);
> }
>
> To set a parameter value then is as easy as:
> rv.SetQueryParameter("SalesOrderNumber", "SO6003");
> HTH,
> --
> Scott
> http://www.OdeToCode.com/blogs/scott/
> On Thu, 21 Oct 2004 10:55:24 -0400, "Jason W. Nadal"
> <jnadal@.comcast.net> wrote:
> >I'm using the included ReportViewer sample (basically it just just loads the
> >reporting services report page in an ifram), and I'd like to set report
> >parameters for the report by my ASP.NET application which houses the report.
> >Is there any way to have my app set the parameter, without prompting the
> >user?
> >
> >--Jason
> >
>|||NEVER MIND.
I read this too quick the 1st time, i now understand what your doing.
Sorry and Thanks!
"iamspo" wrote:
> What name space is the "SetParameter" method a member of?
> I get a compile error when I tried to copy and paste as is.
> Thanks!!
> Spo
> "Scott Allen" wrote:
> > I added a helper method to the ReportViewer:
> >
> > public void SetQueryParameter(
> > string ParameterName,
> > string ParameterValue)
> > {
> > SetParameter(ParameterName,ParameterValue);
> > }
> >
> >
> > To set a parameter value then is as easy as:
> >
> > rv.SetQueryParameter("SalesOrderNumber", "SO6003");
> >
> > HTH,
> >
> > --
> > Scott
> > http://www.OdeToCode.com/blogs/scott/
> >
> > On Thu, 21 Oct 2004 10:55:24 -0400, "Jason W. Nadal"
> > <jnadal@.comcast.net> wrote:
> >
> > >I'm using the included ReportViewer sample (basically it just just loads the
> > >reporting services report page in an ifram), and I'd like to set report
> > >parameters for the report by my ASP.NET application which houses the report.
> > >Is there any way to have my app set the parameter, without prompting the
> > >user?
> > >
> > >--Jason
> > >
> >
> >

Hiding parameters

I have a report that has to show values in the Report Header section. This is
solved by creating parameters that gets the values from a dataset.
But I can't hide these parameters from the user. If I leave the promt field
empty it will become read only, but not hidden.
Is there a way of hiding these parameters?I beleive if you install SP1 for Reporting Services you can hide the header
(by not providing the prompt) but still be able to set the values...
--
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"karl" <karl@.discussions.microsoft.com> wrote in message
news:CD65FAC0-1860-4967-9333-3F894C8E23BF@.microsoft.com...
>I have a report that has to show values in the Report Header section. This
>is
> solved by creating parameters that gets the values from a dataset.
> But I can't hide these parameters from the user. If I leave the promt
> field
> empty it will become read only, but not hidden.
> Is there a way of hiding these parameters?|||Thanks.
But SP1 is already installed.
"Wayne Snyder" wrote:
> I beleive if you install SP1 for Reporting Services you can hide the header
> (by not providing the prompt) but still be able to set the values...
> --
> Wayne Snyder, MCDBA, SQL Server MVP
> Mariner, Charlotte, NC
> www.mariner-usa.com
> (Please respond only to the newsgroups.)
> I support the Professional Association of SQL Server (PASS) and it's
> community of SQL Server professionals.
> www.sqlpass.org
> "karl" <karl@.discussions.microsoft.com> wrote in message
> news:CD65FAC0-1860-4967-9333-3F894C8E23BF@.microsoft.com...
> >I have a report that has to show values in the Report Header section. This
> >is
> > solved by creating parameters that gets the values from a dataset.
> >
> > But I can't hide these parameters from the user. If I leave the promt
> > field
> > empty it will become read only, but not hidden.
> >
> > Is there a way of hiding these parameters?
>
>|||Karl - did you set the prompt to blank via the report manager or the
designer? You have to do it via the designer. I don't trust using the report
manager to set properties.
If you do it via the report designer - just leave the prompt blank. I have
had great success using this method.
=-Chris
"karl" <karl@.discussions.microsoft.com> wrote in message
news:CD65FAC0-1860-4967-9333-3F894C8E23BF@.microsoft.com...
>I have a report that has to show values in the Report Header section. This
>is
> solved by creating parameters that gets the values from a dataset.
> But I can't hide these parameters from the user. If I leave the promt
> field
> empty it will become read only, but not hidden.
> Is there a way of hiding these parameters?|||Thanks.
This is done in the Report Designer.
But since I now know that this should work, I'll just look around in my
solution to see if something is done wrong.
Thanks again.
Karl
"Christopher Conner" wrote:
> Karl - did you set the prompt to blank via the report manager or the
> designer? You have to do it via the designer. I don't trust using the report
> manager to set properties.
> If you do it via the report designer - just leave the prompt blank. I have
> had great success using this method.
> =-Chris
> "karl" <karl@.discussions.microsoft.com> wrote in message
> news:CD65FAC0-1860-4967-9333-3F894C8E23BF@.microsoft.com...
> >I have a report that has to show values in the Report Header section. This
> >is
> > solved by creating parameters that gets the values from a dataset.
> >
> > But I can't hide these parameters from the user. If I leave the promt
> > field
> > empty it will become read only, but not hidden.
> >
> > Is there a way of hiding these parameters?
>
>|||By the way...
I have the Report Server and SQL Server on two different servers.
Currently the SP1 is only installed on the Report Server (server).
Do I also need to install the SP1 on the server where SQL Server is located?
Karl
"karl" wrote:
> Thanks.
> This is done in the Report Designer.
> But since I now know that this should work, I'll just look around in my
> solution to see if something is done wrong.
> Thanks again.
>
> Karl
> "Christopher Conner" wrote:
> > Karl - did you set the prompt to blank via the report manager or the
> > designer? You have to do it via the designer. I don't trust using the report
> > manager to set properties.
> >
> > If you do it via the report designer - just leave the prompt blank. I have
> > had great success using this method.
> >
> > =-Chris
> >
> > "karl" <karl@.discussions.microsoft.com> wrote in message
> > news:CD65FAC0-1860-4967-9333-3F894C8E23BF@.microsoft.com...
> > >I have a report that has to show values in the Report Header section. This
> > >is
> > > solved by creating parameters that gets the values from a dataset.
> > >
> > > But I can't hide these parameters from the user. If I leave the promt
> > > field
> > > empty it will become read only, but not hidden.
> > >
> > > Is there a way of hiding these parameters?
> >
> >
> >|||The Report Server says Version 8.00.878.00.
And if I'm not wrong this is the correct number for SP1.
"karl" wrote:
> By the way...
> I have the Report Server and SQL Server on two different servers.
> Currently the SP1 is only installed on the Report Server (server).
> Do I also need to install the SP1 on the server where SQL Server is located?
>
> Karl
>
> "karl" wrote:
> > Thanks.
> >
> > This is done in the Report Designer.
> > But since I now know that this should work, I'll just look around in my
> > solution to see if something is done wrong.
> >
> > Thanks again.
> >
> >
> > Karl
> >
> > "Christopher Conner" wrote:
> >
> > > Karl - did you set the prompt to blank via the report manager or the
> > > designer? You have to do it via the designer. I don't trust using the report
> > > manager to set properties.
> > >
> > > If you do it via the report designer - just leave the prompt blank. I have
> > > had great success using this method.
> > >
> > > =-Chris
> > >
> > > "karl" <karl@.discussions.microsoft.com> wrote in message
> > > news:CD65FAC0-1860-4967-9333-3F894C8E23BF@.microsoft.com...
> > > >I have a report that has to show values in the Report Header section. This
> > > >is
> > > > solved by creating parameters that gets the values from a dataset.
> > > >
> > > > But I can't hide these parameters from the user. If I leave the promt
> > > > field
> > > > empty it will become read only, but not hidden.
> > > >
> > > > Is there a way of hiding these parameters?
> > >
> > >
> > >

Hiding Parameters

I want to hide 2 of the 5 parameters in my report. I figured out how to do
this by clearing out the Prompt in the Report Parameters and by setting my
default value. When I view my report via Report Manager, the parameters are
hiden like expected. When I try to override the parameter at run time with a
different value (via passing the value in the query string when using URL
access), then I get the error: "parameter is read-only and can not be
modified".
What do I need to do to fix my error?Hi dilworth,
Welcome to use MSDN Managed Newsgroup Support.
This is a by design issue in Reporting Services 2000. In Reporting Services
2005, you can Hide a Parameter in the Report Parameters Dialogbox.
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
==================================================This posting is provided "AS IS" with no warranties, and confers no rights.

hiding parameters

I keep seeing post saying that you can hide parameters and pass the values
through a querystring by clearing out the prompt string and unchecking prompt
user. However, when I try this i get an error saying the propery is read
only. Any Suggestions.
--
Thanks,
Danny BaderI too get this error if I leave the parameter prompt blank. I keep hearing
that you have to install SP1 to make this go away. I have SP2 installed and
it still happens. Does SP2 not have the SP1 fixes in it also? If not, is it
okay to install SP1 even though I already have SP2 installed?
Robert|||I have SP2 installed as well.
--
Thanks,
Danny Bader
"Robert RVRK" wrote:
> I too get this error if I leave the parameter prompt blank. I keep hearing
> that you have to install SP1 to make this go away. I have SP2 installed and
> it still happens. Does SP2 not have the SP1 fixes in it also? If not, is it
> okay to install SP1 even though I already have SP2 installed?
> Robert|||Hi Danny,
I think I might have found the solution. Instead of blanking out the
parameter prompt, enter a space for the parameter prompt. Supposedly this
will work when you view the report in the report viewer (but it won't in the
IDE, so don't give up until you've tried it in the viewer). I am going to go
try myself now...
Robert|||> through a querystring by clearing out the prompt string and unchecking prompt
> user.
Nope. Just clear the prompt string and DON'T uncheck the prompt user option.
--
Please mark the correct/helpful answers!|||you can do by following steps:
1. check "allow null"
2. Clear the prompt string
3. select "none" for default value
4. in report manager, check "prompt user", but clear the prompt string
so, this parameter will not appear in parameter panel
and you can pass value to this parameter through URL
"Danny Bader" wrote:
> I keep seeing post saying that you can hide parameters and pass the values
> through a querystring by clearing out the prompt string and unchecking prompt
> user. However, when I try this i get an error saying the propery is read
> only. Any Suggestions.
> --
> Thanks,
> Danny Bader

Hiding data regions based on Parameters

Hello all,
I have two parts in my report. Each part needs a diff set of
parameters.
Need a way to hide one of the 2 parts based on the parameters typed in
(like if they type in A or B or C i need to hide ReportX and vice-versa
if they type in D, E, F). Tried the table properties Visibility
properties but not much success.
Any ideas will be appreciated.
Thx
BofoI am able to get the thing working by using the following expression.
iif(Parameters!param1.Value="", TRUE, FALSE)
But the problem is I have 4 params like this.
I am trying to use the iif inside an iif. But havent had success yet.
Thx
Bofo|||iif(Parameters!param_numAvPrevia.Value="",
iif(Parameters!param_avPreviadesde.Value="",
iif(Parameters!param_avPreviaHasta.Value="",
iif(Parameters!param_estado.Value="", TRUE, FALSE), FALSE), FALSE),
FALSE)
trying the above expression. But no success yet.
I get the error saying its not a proper boolean value.|||finally Got it going.
Thought may help someone.
Here is the expr i am using for the Visibility.hidden
=iif((Parameters!param1.Value + Parameters!param2.Value +
Parameters!param3.Value +
Parameters!4.Value)="", TRUE, FALSE)
Rgds
Bofo|||finally Got it going.
Thought may help someone.
Here is the expr i am using for the Visibility.hidden
=iif((Parameters!param1.Value + Parameters!param2.Value +
Parameters!param3.Value +
Parameters!4.Value)="", TRUE, FALSE)
Rgds
Bofo