How to make textbox Invisible when viewed on screen but visible when printed?

I have a couple reports that have parameters on them. Problem is when the report is printed, the parameters are not displayed.

To solve this, I have added the selected values to the header section of the report in a text box. I now want to find away to hide these values when the report is being viewed on screen but visible when printed. Any suggestions are welcome. Thanks

Does anybody have any suggestions on this or a workaround. I want the user to be able to know the parameters they selected when they print the report.

Thanks

|||

Hello,

You could have another parameter called "Show Parameters" (defaulted to False), then set the visibility of your textbox based on this value. Of course, your users would have to check that box to show them before they printed/exported.

Hope this helps.

Jarret

|||Thanks, interesting and simple work around. I have implemented it. Let's see if the clients like it.

How to make OrderBy by Parameters

Hello All,
I need to make a select in a table, but i need to do a order by by
parameter.
Exemple:
SELECT * FROM CUSTOMERS
ORDER BY @.COLUMN
This select is a stored procedure.
@.Column is the name of the column in my table.
@.Column i need to send by parameter.
I need to make a dynamic sort, but i don't can to use EXEC(''), because of
SqlInject.
Somebody to know how to make this task?
Thanks.
Dexter"Dexter" <projenet@.yahoo.com.br> schrieb im Newsbeitrag
news:uPgavPERFHA.248@.TK2MSFTNGP15.phx.gbl...
> Hello All,
> I need to make a select in a table, but i need to do a order by by
> parameter.
> Exemple:
> SELECT * FROM CUSTOMERS
> ORDER BY @.COLUMN
> This select is a stored procedure.
> @.Column is the name of the column in my table.
> @.Column i need to send by parameter.
> I need to make a dynamic sort, but i don't can to use EXEC(''), because of
> SqlInject.
> Somebody to know how to make this task?
> Thanks.
> Dexter
>|||DOnt think there is prober way to do this without dynamic SQL:
http://www.sommarskog.se/dynamic_sql.html
HTH, Jens Suessmeyer.
http://www.sqlserver2005.de
--
"Dexter" <projenet@.yahoo.com.br> schrieb im Newsbeitrag
news:uPgavPERFHA.248@.TK2MSFTNGP15.phx.gbl...
> Hello All,
> I need to make a select in a table, but i need to do a order by by
> parameter.
> Exemple:
> SELECT * FROM CUSTOMERS
> ORDER BY @.COLUMN
> This select is a stored procedure.
> @.Column is the name of the column in my table.
> @.Column i need to send by parameter.
> I need to make a dynamic sort, but i don't can to use EXEC(''), because of
> SqlInject.
> Somebody to know how to make this task?
> Thanks.
> Dexter
>|||http://www.4guysfromrolla.com/webtech/010704-1.shtml
"Dexter" <projenet@.yahoo.com.br> wrote in message
news:uPgavPERFHA.248@.TK2MSFTNGP15.phx.gbl...
> Hello All,
> I need to make a select in a table, but i need to do a order by by
> parameter.
> Exemple:
> SELECT * FROM CUSTOMERS
> ORDER BY @.COLUMN
> This select is a stored procedure.
> @.Column is the name of the column in my table.
> @.Column i need to send by parameter.
> I need to make a dynamic sort, but i don't can to use EXEC(''), because of
> SqlInject.
> Somebody to know how to make this task?
> Thanks.
> Dexter
>|||How do I use a variable in an ORDER BY clause?
http://www.aspfaq.com/show.asp?id=2501
AMB
"Dexter" wrote:

> Hello All,
> I need to make a select in a table, but i need to do a order by by
> parameter.
> Exemple:
> SELECT * FROM CUSTOMERS
> ORDER BY @.COLUMN
> This select is a stored procedure.
> @.Column is the name of the column in my table.
> @.Column i need to send by parameter.
> I need to make a dynamic sort, but i don't can to use EXEC(''), because of
> SqlInject.
> Somebody to know how to make this task?
> Thanks.
> Dexter
>
>sql

How to make hiding the parameter row as default?

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

Thanks.

DanYeung

At the end of the URL, just set the paramaters to false, like so:

http://375868d/ReportServer/Pages/ReportViewer.aspx?/Exhumation/ops_samples_all&rcarameters=false

What is with the smiley face? It should be Parameters=false, not arameters=false...

|||

Set the parameter to false can only hide the value of the parameter. I want to hide the who section that shows all parameter names and values, and also the Preview Report button.

Thanks.

DanYeung

|||

I figured it out and wanted to share. In the Report Parameters dialog, check the Hidden checkbox for all parameters. The whole section will be hidden as default.

DanYeung

How to make Fields dynamic in a table column?

I am developing a single dynamic report in report designer and I have
a small problem. My report has several parameters and I use MDX to
query from a Cube(Analysis Services). Everything works fine until I
want a field in the report to change dynamically when a user changes a
parameter.
Example:
I have one parameter, dimension, which is a drop down list. If the
user chooses 'region' as the dimension, I want the Field!Region.Value
to be my field in the table column. If he chooses 'store' I want
Field!Store.Value to show instead of Region or any other dimension in
the column. Is there any way to make a report dynamic like this in
report designer?
At this moment I have to define fields with the same adress as the
database location: 'Store' has field expression like this -
[Customer].[Store].[MEMBER_CAPTION] and if I use this expression in
the dimension field when the user chooses 'Store' from the drop down
list, I`ll get all the results displayed in the table. This is what I
want to make more dynamic.
My simplyfied MDX query:
SELECT {[Measure].[Units Ordered]} on Columns,
{[Customer].[" + Parameters!Dimension.Value + "].Members} on Rows
from Orders
Does anyone have a solution to this problem?You can use the collection-based syntax for referencing field names in the
report layout. E.g.
=Fields(Parameters!DimensionSelection.Value).Value
Based on the actual parameter value, the field name will be determined at
report processing time.
-- Robert
This posting is provided "AS IS" with no warranties, and confers no rights.
"Oddvar Brennhovd" <oddvar.brennhovd@.isolutions.no> wrote in message
news:83475cf2.0502230717.48b871f6@.posting.google.com...
>I am developing a single dynamic report in report designer and I have
> a small problem. My report has several parameters and I use MDX to
> query from a Cube(Analysis Services). Everything works fine until I
> want a field in the report to change dynamically when a user changes a
> parameter.
> Example:
> I have one parameter, dimension, which is a drop down list. If the
> user chooses 'region' as the dimension, I want the Field!Region.Value
> to be my field in the table column. If he chooses 'store' I want
> Field!Store.Value to show instead of Region or any other dimension in
> the column. Is there any way to make a report dynamic like this in
> report designer?
> At this moment I have to define fields with the same adress as the
> database location: 'Store' has field expression like this -
> [Customer].[Store].[MEMBER_CAPTION] and if I use this expression in
> the dimension field when the user chooses 'Store' from the drop down
> list, I`ll get all the results displayed in the table. This is what I
> want to make more dynamic.
> My simplyfied MDX query:
> SELECT {[Measure].[Units Ordered]} on Columns,
> {[Customer].[" + Parameters!Dimension.Value + "].Members} on Rows
> from Orders
> Does anyone have a solution to this problem?|||Thank you. Now the problem is solved!

how to make a textbox invisible

hi
how can i make a textbox invisible ?
here is the scenario.
i have a textbox to remind user to select some parameters to view the graph.
once the user selects the paramteters - the graph shows up.
once the graph shows up -the textbox should disappear.
how can i do thatright click the text box, select Properties
click Advanced >>
in the Advanced Textbox Properties
click the Visibility tab
in the Initial visibility radio button group check the Visible radio button
and below check the Visibility can be toggled by another report item
in the Report item drop down list pick your chart
i haven't tried this, it's off the top of my head, but i hope it's a good
first step,
regards,
kowlasky
"RP" wrote:
> hi
> how can i make a textbox invisible ?
> here is the scenario.
> i have a textbox to remind user to select some parameters to view the graph.
> once the user selects the paramteters - the graph shows up.
> once the graph shows up -the textbox should disappear.
> how can i do that|||But we can only see textboxes in the dropdown of "visibility can be toggled
by another report item"
:-( any other suggestions ''''
Thanks
"kowalsky" wrote:
> right click the text box, select Properties
> click Advanced >>
> in the Advanced Textbox Properties
> click the Visibility tab
> in the Initial visibility radio button group check the Visible radio button
> and below check the Visibility can be toggled by another report item
> in the Report item drop down list pick your chart
> i haven't tried this, it's off the top of my head, but i hope it's a good
> first step,
> regards,
> kowlasky
>
> "RP" wrote:
> > hi
> > how can i make a textbox invisible ?
> > here is the scenario.
> > i have a textbox to remind user to select some parameters to view the graph.
> > once the user selects the paramteters - the graph shows up.
> > once the graph shows up -the textbox should disappear.
> > how can i do thatsql

How to make a report with parameters?

For example I have a database with employees with their cities. I need that
the report ask the user which CITY to show on the report?
--
LUIS ESTEBAN VALENCIA
MICROSOFT DCE 2.
MIEMBRO ACTIVO DE ALIANZADEVGo to the Reporting Services Books Online (Start > Microsoft SQL Server >
Reporting Services) and search for the word "parameters". It should give
you everything you need.
Cheers,
--
'(' Jeff A. Stucker
\
Business Intelligence
www.criadvantage.com
---
"Luis Esteban Valencia" <luisvalen@.haceb.com> wrote in message
news:OqlLjA62EHA.208@.TK2MSFTNGP12.phx.gbl...
> For example I have a database with employees with their cities. I need
> that
> the report ask the user which CITY to show on the report?
>
> --
> LUIS ESTEBAN VALENCIA
> MICROSOFT DCE 2.
> MIEMBRO ACTIVO DE ALIANZADEV
>

How to list reports, parameters, subcriptions for SQL 2000 with no

Hello,
I am really hoping someone can help me out, I don't have a lot of SQL or SQL
Reporting Services knowledge so please bear with me.
We use SQL 2000 Reporting Services at our office but the front end (web
interface) is not functioning (long story but we disabled OWA on the same box
and the SQL WI failed; turning OWA back on doesn't correct the problem).
Unfortunately we did not keep a listing of the available reports, their
parameters, the subscriptions or the schedules. This is our error and will
not happen going forward however I need to get this information; it looks
like we are going to have to rebuild it.
It is only the web interface itself that is broken, the back end is still
working properly and scheduled reports are being sent out. We just can't
modify anything.
Is it possible to retrieve this information? Where is it stored and how do
I get this information?
I saw a post somewhere that touched on this but I can't find it anywhere.
TIA,
NancyNancy,
Yes, it is possible to see the reports and their parameters. RS has a
ReportServer database that contains all of this information. You just need
to query the appropriate tables. For example, to see all of the reports
published to the Report Manager site, query the Catalog table in the
ReportServer database "Select *
from Catalog" presuming the list of report is not too long. The table names
are fairly well named so you should not have a problem determining where
information is stored. Obviously you will need to have read writes to the
ReportServer database to do this. Hope this helps.
"Nancy R" wrote:
> Hello,
> I am really hoping someone can help me out, I don't have a lot of SQL or SQL
> Reporting Services knowledge so please bear with me.
> We use SQL 2000 Reporting Services at our office but the front end (web
> interface) is not functioning (long story but we disabled OWA on the same box
> and the SQL WI failed; turning OWA back on doesn't correct the problem).
> Unfortunately we did not keep a listing of the available reports, their
> parameters, the subscriptions or the schedules. This is our error and will
> not happen going forward however I need to get this information; it looks
> like we are going to have to rebuild it.
> It is only the web interface itself that is broken, the back end is still
> working properly and scheduled reports are being sent out. We just can't
> modify anything.
> Is it possible to retrieve this information? Where is it stored and how do
> I get this information?
> I saw a post somewhere that touched on this but I can't find it anywhere.
> TIA,
> Nancy|||Hi,
This helps alot, thanks.
Now I have what is hopefully my last question: do I find these tables in a
db on the reporting server or on the backend SQL server we have?
Thanks again,
Nancy
"bsod55" wrote:
> Nancy,
> Yes, it is possible to see the reports and their parameters. RS has a
> ReportServer database that contains all of this information. You just need
> to query the appropriate tables. For example, to see all of the reports
> published to the Report Manager site, query the Catalog table in the
> ReportServer database "Select *
> from Catalog" presuming the list of report is not too long. The table names
> are fairly well named so you should not have a problem determining where
> information is stored. Obviously you will need to have read writes to the
> ReportServer database to do this. Hope this helps.
> "Nancy R" wrote:
> > Hello,
> >
> > I am really hoping someone can help me out, I don't have a lot of SQL or SQL
> > Reporting Services knowledge so please bear with me.
> >
> > We use SQL 2000 Reporting Services at our office but the front end (web
> > interface) is not functioning (long story but we disabled OWA on the same box
> > and the SQL WI failed; turning OWA back on doesn't correct the problem).
> >
> > Unfortunately we did not keep a listing of the available reports, their
> > parameters, the subscriptions or the schedules. This is our error and will
> > not happen going forward however I need to get this information; it looks
> > like we are going to have to rebuild it.
> >
> > It is only the web interface itself that is broken, the back end is still
> > working properly and scheduled reports are being sent out. We just can't
> > modify anything.
> >
> > Is it possible to retrieve this information? Where is it stored and how do
> > I get this information?
> >
> > I saw a post somewhere that touched on this but I can't find it anywhere.
> >
> > TIA,
> > Nancy|||It may depend on how things were set up inititally, on my SQL Server, I see
2 databases (ReportServer and ReportServerTempDB), Opening the
ReportServices icon in Management Studio shows the DataSources, Models, a
solution I created in VS.Net, User Folders and My Reports.
"Nancy R" <NancyR@.discussions.microsoft.com> wrote in message
news:57C20B42-9098-438F-89D6-8D63591F2E61@.microsoft.com...
> Hi,
> This helps alot, thanks.
> Now I have what is hopefully my last question: do I find these tables in
> a
> db on the reporting server or on the backend SQL server we have?
> Thanks again,
> Nancy
> "bsod55" wrote:
>> Nancy,
>> Yes, it is possible to see the reports and their parameters. RS has a
>> ReportServer database that contains all of this information. You just
>> need
>> to query the appropriate tables. For example, to see all of the reports
>> published to the Report Manager site, query the Catalog table in the
>> ReportServer database "Select *
>> from Catalog" presuming the list of report is not too long. The table
>> names
>> are fairly well named so you should not have a problem determining where
>> information is stored. Obviously you will need to have read writes to
>> the
>> ReportServer database to do this. Hope this helps.
>> "Nancy R" wrote:
>> > Hello,
>> >
>> > I am really hoping someone can help me out, I don't have a lot of SQL
>> > or SQL
>> > Reporting Services knowledge so please bear with me.
>> >
>> > We use SQL 2000 Reporting Services at our office but the front end (web
>> > interface) is not functioning (long story but we disabled OWA on the
>> > same box
>> > and the SQL WI failed; turning OWA back on doesn't correct the
>> > problem).
>> >
>> > Unfortunately we did not keep a listing of the available reports, their
>> > parameters, the subscriptions or the schedules. This is our error and
>> > will
>> > not happen going forward however I need to get this information; it
>> > looks
>> > like we are going to have to rebuild it.
>> >
>> > It is only the web interface itself that is broken, the back end is
>> > still
>> > working properly and scheduled reports are being sent out. We just
>> > can't
>> > modify anything.
>> >
>> > Is it possible to retrieve this information? Where is it stored and
>> > how do
>> > I get this information?
>> >
>> > I saw a post somewhere that touched on this but I can't find it
>> > anywhere.
>> >
>> > TIA,
>> > Nancy|||Microsoft do not recommend that you directly query the tables in the
ReportServer database. You should instead use the SSIS package and
reports that come provided as one of the Reporting Services samples.
These files (and instructions) can usually be found in C:\Program Files
\Microsoft SQL Server\90\Samples\Reporting Services\Report Samples
\Server Management Sample Reports but it will depend on your
installation path.
If you are going to query the ReportServer database directly then I'd
suggest you use the WITH (NOLOCK) directive in your query.
Regards,
Shane.
On Jun 12, 7:41 pm, bsod55 <bso...@.discussions.microsoft.com> wrote:
> Nancy,
> Yes, it is possible to see the reports and their parameters. RS has a
> ReportServer database that contains all of this information. You just need
> to query the appropriate tables. For example, to see all of the reports
> published to the Report Manager site, query the Catalog table in the
> ReportServer database "Select *
> from Catalog" presuming the list of report is not too long. The table names
> are fairly well named so you should not have a problem determining where
> information is stored. Obviously you will need to have read writes to the
> ReportServer database to do this. Hope this helps.
> "Nancy R" wrote:
> > Hello,
> > I am really hoping someone can help me out, I don't have a lot of SQL or SQL
> > Reporting Services knowledge so please bear with me.
> > We use SQL 2000 Reporting Services at our office but the front end (web
> > interface) is not functioning (long story but we disabled OWA on the same box
> > and the SQL WI failed; turning OWA back on doesn't correct the problem).
> > Unfortunately we did not keep a listing of the available reports, their
> > parameters, the subscriptions or the schedules. This is our error and will
> > not happen going forward however I need to get this information; it looks
> > like we are going to have to rebuild it.
> > It is only the web interface itself that is broken, the back end is still
> > working properly and scheduled reports are being sent out. We just can't
> > modify anything.
> > Is it possible to retrieve this information? Where is it stored and how do
> > I get this information?
> > I saw a post somewhere that touched on this but I can't find it anywhere.
> > TIA,
> > Nancy|||Hi Shane,
I don't have this folder, my path looks something like this: C:\Program
Files\Microsoft SQL Server\80 and I only have "RS Setup Bootstrap" and Tools
under this folder.
Should I be looking somewhere else for this?
Thanks,
Nancy
"shanejokeeffe" wrote:
> Microsoft do not recommend that you directly query the tables in the
> ReportServer database. You should instead use the SSIS package and
> reports that come provided as one of the Reporting Services samples.
> These files (and instructions) can usually be found in C:\Program Files
> \Microsoft SQL Server\90\Samples\Reporting Services\Report Samples
> \Server Management Sample Reports but it will depend on your
> installation path.
> If you are going to query the ReportServer database directly then I'd
> suggest you use the WITH (NOLOCK) directive in your query.
> Regards,
> Shane.
> On Jun 12, 7:41 pm, bsod55 <bso...@.discussions.microsoft.com> wrote:
> > Nancy,
> >
> > Yes, it is possible to see the reports and their parameters. RS has a
> > ReportServer database that contains all of this information. You just need
> > to query the appropriate tables. For example, to see all of the reports
> > published to the Report Manager site, query the Catalog table in the
> > ReportServer database "Select *
> > from Catalog" presuming the list of report is not too long. The table names
> > are fairly well named so you should not have a problem determining where
> > information is stored. Obviously you will need to have read writes to the
> > ReportServer database to do this. Hope this helps.
> >
> > "Nancy R" wrote:
> > > Hello,
> >
> > > I am really hoping someone can help me out, I don't have a lot of SQL or SQL
> > > Reporting Services knowledge so please bear with me.
> >
> > > We use SQL 2000 Reporting Services at our office but the front end (web
> > > interface) is not functioning (long story but we disabled OWA on the same box
> > > and the SQL WI failed; turning OWA back on doesn't correct the problem).
> >
> > > Unfortunately we did not keep a listing of the available reports, their
> > > parameters, the subscriptions or the schedules. This is our error and will
> > > not happen going forward however I need to get this information; it looks
> > > like we are going to have to rebuild it.
> >
> > > It is only the web interface itself that is broken, the back end is still
> > > working properly and scheduled reports are being sent out. We just can't
> > > modify anything.
> >
> > > Is it possible to retrieve this information? Where is it stored and how do
> > > I get this information?
> >
> > > I saw a post somewhere that touched on this but I can't find it anywhere.
> >
> > > TIA,
> > > Nancy
>
>|||Hi Nancy,
I'd wrongly assumed that this sample had also shipped with SQL Server
2000 Reporting Services. I just checked our old dev machine and
they're not there either so it looks like they're for SQL 2005 only.
It looks like your quickest option is the query the ReportServer
tables directly. Querying the tables directly should be ok once you
don't lock any of the tables with long running queries. Just bear in
mind that it's not a recommended practice.
Regards,
Shane.
On Jun 13, 2:11 pm, Nancy R <Nan...@.discussions.microsoft.com> wrote:
> Hi Shane,
> I don't have this folder, my path looks something like this: C:\Program
> Files\Microsoft SQL Server\80 and I only have "RS Setup Bootstrap" and Tools
> under this folder.
> Should I be looking somewhere else for this?
> Thanks,
> Nancy
> "shanejokeeffe" wrote:
> > Microsoft do not recommend that you directly query the tables in the
> > ReportServer database. You should instead use the SSIS package and
> > reports that come provided as one of the Reporting Services samples.
> > These files (and instructions) can usually be found in C:\Program Files
> > \Microsoft SQL Server\90\Samples\Reporting Services\Report Samples
> > \Server Management Sample Reports but it will depend on your
> > installation path.
> > If you are going to query the ReportServer database directly then I'd
> > suggest you use the WITH (NOLOCK) directive in your query.
> > Regards,
> > Shane.
> > On Jun 12, 7:41 pm, bsod55 <bso...@.discussions.microsoft.com> wrote:
> > > Nancy,
> > > Yes, it is possible to see the reports and their parameters. RS has a
> > > ReportServer database that contains all of this information. You just need
> > > to query the appropriate tables. For example, to see all of the reports
> > > published to the Report Manager site, query the Catalog table in the
> > > ReportServer database "Select *
> > > from Catalog" presuming the list of report is not too long. The table names
> > > are fairly well named so you should not have a problem determining where
> > > information is stored. Obviously you will need to have read writes to the
> > > ReportServer database to do this. Hope this helps.
> > > "Nancy R" wrote:
> > > > Hello,
> > > > I am really hoping someone can help me out, I don't have a lot of SQL or SQL
> > > > Reporting Services knowledge so please bear with me.
> > > > We use SQL 2000 Reporting Services at our office but the front end (web
> > > > interface) is not functioning (long story but we disabled OWA on the same box
> > > > and the SQL WI failed; turning OWA back on doesn't correct the problem).
> > > > Unfortunately we did not keep a listing of the available reports, their
> > > > parameters, the subscriptions or the schedules. This is our error and will
> > > > not happen going forward however I need to get this information; it looks
> > > > like we are going to have to rebuild it.
> > > > It is only the web interface itself that is broken, the back end is still
> > > > working properly and scheduled reports are being sent out. We just can't
> > > > modify anything.
> > > > Is it possible to retrieve this information? Where is it stored and how do
> > > > I get this information?
> > > > I saw a post somewhere that touched on this but I can't find it anywhere.
> > > > TIA,
> > > > Nancy|||Thanks everyone for your help, I appreciate it.
Nancy
"shanejokeeffe" wrote:
> Hi Nancy,
> I'd wrongly assumed that this sample had also shipped with SQL Server
> 2000 Reporting Services. I just checked our old dev machine and
> they're not there either so it looks like they're for SQL 2005 only.
> It looks like your quickest option is the query the ReportServer
> tables directly. Querying the tables directly should be ok once you
> don't lock any of the tables with long running queries. Just bear in
> mind that it's not a recommended practice.
> Regards,
> Shane.
>
> On Jun 13, 2:11 pm, Nancy R <Nan...@.discussions.microsoft.com> wrote:
> > Hi Shane,
> >
> > I don't have this folder, my path looks something like this: C:\Program
> > Files\Microsoft SQL Server\80 and I only have "RS Setup Bootstrap" and Tools
> > under this folder.
> >
> > Should I be looking somewhere else for this?
> >
> > Thanks,
> > Nancy
> >
> > "shanejokeeffe" wrote:
> > > Microsoft do not recommend that you directly query the tables in the
> > > ReportServer database. You should instead use the SSIS package and
> > > reports that come provided as one of the Reporting Services samples.
> > > These files (and instructions) can usually be found in C:\Program Files
> > > \Microsoft SQL Server\90\Samples\Reporting Services\Report Samples
> > > \Server Management Sample Reports but it will depend on your
> > > installation path.
> >
> > > If you are going to query the ReportServer database directly then I'd
> > > suggest you use the WITH (NOLOCK) directive in your query.
> >
> > > Regards,
> >
> > > Shane.
> >
> > > On Jun 12, 7:41 pm, bsod55 <bso...@.discussions.microsoft.com> wrote:
> > > > Nancy,
> >
> > > > Yes, it is possible to see the reports and their parameters. RS has a
> > > > ReportServer database that contains all of this information. You just need
> > > > to query the appropriate tables. For example, to see all of the reports
> > > > published to the Report Manager site, query the Catalog table in the
> > > > ReportServer database "Select *
> > > > from Catalog" presuming the list of report is not too long. The table names
> > > > are fairly well named so you should not have a problem determining where
> > > > information is stored. Obviously you will need to have read writes to the
> > > > ReportServer database to do this. Hope this helps.
> >
> > > > "Nancy R" wrote:
> > > > > Hello,
> >
> > > > > I am really hoping someone can help me out, I don't have a lot of SQL or SQL
> > > > > Reporting Services knowledge so please bear with me.
> >
> > > > > We use SQL 2000 Reporting Services at our office but the front end (web
> > > > > interface) is not functioning (long story but we disabled OWA on the same box
> > > > > and the SQL WI failed; turning OWA back on doesn't correct the problem).
> >
> > > > > Unfortunately we did not keep a listing of the available reports, their
> > > > > parameters, the subscriptions or the schedules. This is our error and will
> > > > > not happen going forward however I need to get this information; it looks
> > > > > like we are going to have to rebuild it.
> >
> > > > > It is only the web interface itself that is broken, the back end is still
> > > > > working properly and scheduled reports are being sent out. We just can't
> > > > > modify anything.
> >
> > > > > Is it possible to retrieve this information? Where is it stored and how do
> > > > > I get this information?
> >
> > > > > I saw a post somewhere that touched on this but I can't find it anywhere.
> >
> > > > > TIA,
> > > > > Nancy
>
>

how to link multiple datasets's parameters?

I created three datasets. Every one has the same parameter and I need to link
them together. How to do it?
Thx.You can create a global report parameter and link it to the parameters in
your query. See the sample Sales Invoice report included in the RS samples.
--
HTH,
---
Teo Lachev, MVP, MCSD, MCT
"Microsoft Reporting Services in Action"
"Applied Microsoft Analysis Services 2005"
Home page and blog: http://www.prologika.com/
---
"Mia" <Mia@.discussions.microsoft.com> wrote in message
news:5DD6DD82-8A1B-4C36-B6BC-13F2C3FF9554@.microsoft.com...
>I created three datasets. Every one has the same parameter and I need to
>link
> them together. How to do it?
> Thx.|||Where do I find these sample reports?
I can't find any mention of global report parameters in BOL
"Teo Lachev [MVP]" wrote:
> You can create a global report parameter and link it to the parameters in
> your query. See the sample Sales Invoice report included in the RS samples.
> --
> HTH,
> ---
> Teo Lachev, MVP, MCSD, MCT
> "Microsoft Reporting Services in Action"
> "Applied Microsoft Analysis Services 2005"
> Home page and blog: http://www.prologika.com/
> ---
> "Mia" <Mia@.discussions.microsoft.com> wrote in message
> news:5DD6DD82-8A1B-4C36-B6BC-13F2C3FF9554@.microsoft.com...
> >I created three datasets. Every one has the same parameter and I need to
> >link
> > them together. How to do it?
> >
> > Thx.
>
>|||Install the sample reports that come with RS. With RS 2000, there should be
a link to the installer in the Reporting Services group. I called them
"global" because they are report-level parameters.
--
HTH,
---
Teo Lachev, MVP, MCSD, MCT
"Microsoft Reporting Services in Action"
"Applied Microsoft Analysis Services 2005"
Home page and blog: http://www.prologika.com/
---
"David" <David@.discussions.microsoft.com> wrote in message
news:FF10B3A5-5E2E-487F-87A4-21CDD6C79F0D@.microsoft.com...
> Where do I find these sample reports?
> I can't find any mention of global report parameters in BOL
> "Teo Lachev [MVP]" wrote:
>> You can create a global report parameter and link it to the parameters in
>> your query. See the sample Sales Invoice report included in the RS
>> samples.
>> --
>> HTH,
>> ---
>> Teo Lachev, MVP, MCSD, MCT
>> "Microsoft Reporting Services in Action"
>> "Applied Microsoft Analysis Services 2005"
>> Home page and blog: http://www.prologika.com/
>> ---
>> "Mia" <Mia@.discussions.microsoft.com> wrote in message
>> news:5DD6DD82-8A1B-4C36-B6BC-13F2C3FF9554@.microsoft.com...
>> >I created three datasets. Every one has the same parameter and I need to
>> >link
>> > them together. How to do it?
>> >
>> > Thx.
>>|||OK, I have that report and opened it.
There is 2 datasets and each datasets as the same parameter name in the query.
Is the Global Report Paremeter, that you are refering to, this dialog box:
REPORT>REPORT PARAMETERS
If so, how do you go about linking this parameter to the parameters in your
query?
Normally, when you create the parameter in your query, it appears
automatically in this dialog box. But what do you do if it doesn't?
"Teo Lachev [MVP]" wrote:
> Install the sample reports that come with RS. With RS 2000, there should be
> a link to the installer in the Reporting Services group. I called them
> "global" because they are report-level parameters.
> --
> HTH,
> ---
> Teo Lachev, MVP, MCSD, MCT
> "Microsoft Reporting Services in Action"
> "Applied Microsoft Analysis Services 2005"
> Home page and blog: http://www.prologika.com/
> ---
> "David" <David@.discussions.microsoft.com> wrote in message
> news:FF10B3A5-5E2E-487F-87A4-21CDD6C79F0D@.microsoft.com...
> > Where do I find these sample reports?
> >
> > I can't find any mention of global report parameters in BOL
> >
> > "Teo Lachev [MVP]" wrote:
> >
> >> You can create a global report parameter and link it to the parameters in
> >> your query. See the sample Sales Invoice report included in the RS
> >> samples.
> >>
> >> --
> >> HTH,
> >> ---
> >> Teo Lachev, MVP, MCSD, MCT
> >> "Microsoft Reporting Services in Action"
> >> "Applied Microsoft Analysis Services 2005"
> >> Home page and blog: http://www.prologika.com/
> >> ---
> >> "Mia" <Mia@.discussions.microsoft.com> wrote in message
> >> news:5DD6DD82-8A1B-4C36-B6BC-13F2C3FF9554@.microsoft.com...
> >> >I created three datasets. Every one has the same parameter and I need to
> >> >link
> >> > them together. How to do it?
> >> >
> >> > Thx.
> >>
> >>
> >>
>
>|||1. You use a placeholder for this parameter in your dataset query, e.g.:
WHERE (SOH.SalesOrderNumber = @.SalesOrderNumber)
2. You open the dataset properties and in the Parameters tab you link the
query parameter to the report-level parameter, like so:
Name Value
-- ---
@.SalesOrder Header =Parameters!SalesOrderNumber.Value
--
HTH,
---
Teo Lachev, MVP, MCSD, MCT
"Microsoft Reporting Services in Action"
"Applied Microsoft Analysis Services 2005"
Home page and blog: http://www.prologika.com/
---
"David" <David@.discussions.microsoft.com> wrote in message
news:168C68E8-B032-4668-9AB3-A52EBB4E3342@.microsoft.com...
> OK, I have that report and opened it.
> There is 2 datasets and each datasets as the same parameter name in the
> query.
> Is the Global Report Paremeter, that you are refering to, this dialog box:
> REPORT>REPORT PARAMETERS
> If so, how do you go about linking this parameter to the parameters in
> your
> query?
>
> Normally, when you create the parameter in your query, it appears
> automatically in this dialog box. But what do you do if it doesn't?
>
> "Teo Lachev [MVP]" wrote:
>> Install the sample reports that come with RS. With RS 2000, there should
>> be
>> a link to the installer in the Reporting Services group. I called them
>> "global" because they are report-level parameters.
>> --
>> HTH,
>> ---
>> Teo Lachev, MVP, MCSD, MCT
>> "Microsoft Reporting Services in Action"
>> "Applied Microsoft Analysis Services 2005"
>> Home page and blog: http://www.prologika.com/
>> ---
>> "David" <David@.discussions.microsoft.com> wrote in message
>> news:FF10B3A5-5E2E-487F-87A4-21CDD6C79F0D@.microsoft.com...
>> > Where do I find these sample reports?
>> >
>> > I can't find any mention of global report parameters in BOL
>> >
>> > "Teo Lachev [MVP]" wrote:
>> >
>> >> You can create a global report parameter and link it to the parameters
>> >> in
>> >> your query. See the sample Sales Invoice report included in the RS
>> >> samples.
>> >>
>> >> --
>> >> HTH,
>> >> ---
>> >> Teo Lachev, MVP, MCSD, MCT
>> >> "Microsoft Reporting Services in Action"
>> >> "Applied Microsoft Analysis Services 2005"
>> >> Home page and blog: http://www.prologika.com/
>> >> ---
>> >> "Mia" <Mia@.discussions.microsoft.com> wrote in message
>> >> news:5DD6DD82-8A1B-4C36-B6BC-13F2C3FF9554@.microsoft.com...
>> >> >I created three datasets. Every one has the same parameter and I need
>> >> >to
>> >> >link
>> >> > them together. How to do it?
>> >> >
>> >> > Thx.
>> >>
>> >>
>> >>
>>|||Thank You!
Thank You!
Thank You!
I have been having a hell of a time trying to figure out the solution top
this problem.
I was developing a report that had the WHERE clause hard code with a value.
Once I completed development, I change the hard code to a parameter. RS would
not recognize it as a parameter and kept telling my variables were unbound.
I was all over the net and this forum trying to find the answer.
"Teo Lachev [MVP]" wrote:
> 1. You use a placeholder for this parameter in your dataset query, e.g.:
> WHERE (SOH.SalesOrderNumber = @.SalesOrderNumber)
> 2. You open the dataset properties and in the Parameters tab you link the
> query parameter to the report-level parameter, like so:
> Name Value
> -- ---
> @.SalesOrder Header =Parameters!SalesOrderNumber.Value
> --
> HTH,
> ---
> Teo Lachev, MVP, MCSD, MCT
> "Microsoft Reporting Services in Action"
> "Applied Microsoft Analysis Services 2005"
> Home page and blog: http://www.prologika.com/
> ---
> "David" <David@.discussions.microsoft.com> wrote in message
> news:168C68E8-B032-4668-9AB3-A52EBB4E3342@.microsoft.com...
> > OK, I have that report and opened it.
> >
> > There is 2 datasets and each datasets as the same parameter name in the
> > query.
> >
> > Is the Global Report Paremeter, that you are refering to, this dialog box:
> > REPORT>REPORT PARAMETERS
> >
> > If so, how do you go about linking this parameter to the parameters in
> > your
> > query?
> >
> >
> > Normally, when you create the parameter in your query, it appears
> > automatically in this dialog box. But what do you do if it doesn't?
> >
> >
> > "Teo Lachev [MVP]" wrote:
> >
> >> Install the sample reports that come with RS. With RS 2000, there should
> >> be
> >> a link to the installer in the Reporting Services group. I called them
> >> "global" because they are report-level parameters.
> >>
> >> --
> >> HTH,
> >> ---
> >> Teo Lachev, MVP, MCSD, MCT
> >> "Microsoft Reporting Services in Action"
> >> "Applied Microsoft Analysis Services 2005"
> >> Home page and blog: http://www.prologika.com/
> >> ---
> >> "David" <David@.discussions.microsoft.com> wrote in message
> >> news:FF10B3A5-5E2E-487F-87A4-21CDD6C79F0D@.microsoft.com...
> >> > Where do I find these sample reports?
> >> >
> >> > I can't find any mention of global report parameters in BOL
> >> >
> >> > "Teo Lachev [MVP]" wrote:
> >> >
> >> >> You can create a global report parameter and link it to the parameters
> >> >> in
> >> >> your query. See the sample Sales Invoice report included in the RS
> >> >> samples.
> >> >>
> >> >> --
> >> >> HTH,
> >> >> ---
> >> >> Teo Lachev, MVP, MCSD, MCT
> >> >> "Microsoft Reporting Services in Action"
> >> >> "Applied Microsoft Analysis Services 2005"
> >> >> Home page and blog: http://www.prologika.com/
> >> >> ---
> >> >> "Mia" <Mia@.discussions.microsoft.com> wrote in message
> >> >> news:5DD6DD82-8A1B-4C36-B6BC-13F2C3FF9554@.microsoft.com...
> >> >> >I created three datasets. Every one has the same parameter and I need
> >> >> >to
> >> >> >link
> >> >> > them together. How to do it?
> >> >> >
> >> >> > Thx.
> >> >>
> >> >>
> >> >>
> >>
> >>
> >>
>
>

How to launch package from a Windows Service

I'm developing a Windows Service to watch for an e-mail and then launch a package. It extracts some parameters from the e-mail that I then need to pass to the package. What is the best way to launch the package from the service? Should I run it in a new thread? I don't want the service to have to wait for the package to complete. How would I pass the parameters? Should I use dtexec? If the service fails or is stopped and the package is still running, it would terminate the package also, correct? Any way to avoid that? Thanks.Running the package inside the service process is faster, as you avoid overhead of creating new process per package. But running in DTEXEC gives you process isolation and reliability - the service stop or crash does not affect executing packages, and crash in one package execution does not affect other packages.

In both cases I would pass parameters via user variables. If you execute in process, you can set the variable using object model before executing. If you use DTEXEC, use /SET command line option to configure variables.|||Thanks Michael.