report caching

here is the deal- i have a bunch of reports to which i need to add a generic
caching plan. i know how to do this through the report manager web
interface on a per-report-basis. my problem is that i am lazy and don't
want to click through every single report individually setting up the
caching plan. is there a way to do this across all reports in a directory?
please tell me there is...
tia,
jtOn May 4, 5:13 pm, "JTL" <j...@.clickstreamtech.com> wrote:
> here is the deal- i have a bunch of reports to which i need to add a generic
> caching plan. i know how to do this through the report manager web
> interface on a per-report-basis. my problem is that i am lazy and don't
> want to click through every single report individually setting up the
> caching plan. is there a way to do this across all reports in a directory?
> please tell me there is...
> tia,
> jt
As far as I know, aside from modifying the caching plan one report at
a time, there is no other way to change the caching plan. Sorry I
could not be of greater assistance.
Regards,
Enrique Martinez
Sr. Software Consultant|||Hello,
You can perform operations on a report server through the use of the rs
utility (RS.exe).
In this way you can programmatically administer a report server using
Microsoft Visual Basic scripts.
I think this is only way to automate setting configuration for many reports.
Regards,
Radoslaw Lebkowski
MCTS
U¿ytkownik "JTL" <jt@.clickstreamtech.com> napisa³ w wiadomo¶ci
news:O3wJllpjHHA.588@.TK2MSFTNGP06.phx.gbl...
> here is the deal- i have a bunch of reports to which i need to add a
> generic caching plan. i know how to do this through the report manager
> web interface on a per-report-basis. my problem is that i am lazy and
> don't want to click through every single report individually setting up
> the caching plan. is there a way to do this across all reports in a
> directory? please tell me there is...
> tia,
> jt
>sql

Report against oracle with multiple statements

hello developers!!!!!

How I have to do a Report against oracle with multiple statements?

I need execute multiple SQL statements in the generic query designer with an oracle connection.

thanks

Maybe I'm missing something, but couldn't you just define multiple datasets in the report with one query per dataset?

If the queries have interdependencies, you could look into moving them into a stored procedure and calling the stored procedure from SSRS. You should find several threads on the regular SSRS forum (http://forums.microsoft.com/MSDN/ShowForum.aspx?ForumID=82&SiteID=1) discussing how to call Oracle stored procedures from SSRS.

-- Robert

|||

Robert -- slightly off topic but do you have any idea why the Query Designer would be really slow loading tables from Oracle?

There are two threads on this subject:

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=324176&SiteID=1

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=2019689&SiteID=1

...maybe this deserved looking at for a fix in Katmai if it's not already done... is there an issue with multiple connections for each table that is being added or something?

Thanks in advance,

>L<

|||The query designer is actually a VS component, not an RS component. It might use the OLE DB provider but I'm not 100% certain.

|||

Thanks Brian. I might have known that the query designer was a shared component, but I haven't heard of anybody complaining about its speed except in this (report design) context.

As far as whether the query designer uses OLE DB or not... it can, and does, and when it does it is apparently fast -- against the same data.

It's just when these guys are accessing Oracle and their specified connection to this data source is *not* an OLE DB connection that they see the problem. (10-15 minutes to add a table in the designer ?!? Yuck...) I was thinking maybe the designer was trying to make a separate connection every time they pressed that "Add" button.

>L<

|||

Well, I know this won't really resolve the issue, but the shared VS query designer component is actually only supported for a particular set of OLEDB providers, as described in the following KB article:

http://support.microsoft.com/default.aspx?scid=kb;en-us;811241

? Microsoft OLE DB Provider for SQL Server
? Microsoft Jet 4.0 OLE DB Provider
? Microsoft OLE DB Provider for Oracle

It is not supported for any other providers.

-- Robert

|||

Thanks for going the extra mile, Robert <s>. That totally makes sense. I will refer them to this post and stop worrying that the query designer has a bug <g>.

>L<

Report against oracle with multiple statements

hello developers!!!!!

How I have to do a Report against oracle with multiple statements?

I need execute multiple SQL statements in the generic query designer with an oracle connection.

thanks

Maybe I'm missing something, but couldn't you just define multiple datasets in the report with one query per dataset?

If the queries have interdependencies, you could look into moving them into a stored procedure and calling the stored procedure from SSRS. You should find several threads on the regular SSRS forum (http://forums.microsoft.com/MSDN/ShowForum.aspx?ForumID=82&SiteID=1) discussing how to call Oracle stored procedures from SSRS.

-- Robert

|||

Robert -- slightly off topic but do you have any idea why the Query Designer would be really slow loading tables from Oracle?

There are two threads on this subject:

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=324176&SiteID=1

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=2019689&SiteID=1

...maybe this deserved looking at for a fix in Katmai if it's not already done... is there an issue with multiple connections for each table that is being added or something?

Thanks in advance,

>L<

|||The query designer is actually a VS component, not an RS component. It might use the OLE DB provider but I'm not 100% certain.

|||

Thanks Brian. I might have known that the query designer was a shared component, but I haven't heard of anybody complaining about its speed except in this (report design) context.

As far as whether the query designer uses OLE DB or not... it can, and does, and when it does it is apparently fast -- against the same data.

It's just when these guys are accessing Oracle and their specified connection to this data source is *not* an OLE DB connection that they see the problem. (10-15 minutes to add a table in the designer ?!? Yuck...) I was thinking maybe the designer was trying to make a separate connection every time they pressed that "Add" button.

>L<

|||

Well, I know this won't really resolve the issue, but the shared VS query designer component is actually only supported for a particular set of OLEDB providers, as described in the following KB article:

http://support.microsoft.com/default.aspx?scid=kb;en-us;811241

? Microsoft OLE DB Provider for SQL Server
? Microsoft Jet 4.0 OLE DB Provider
? Microsoft OLE DB Provider for Oracle

It is not supported for any other providers.

-- Robert

|||

Thanks for going the extra mile, Robert <s>. That totally makes sense. I will refer them to this post and stop worrying that the query designer has a bug <g>.

>L<

Report against oracle with multiple statements

hello developers!!!!!

How I have to do a Report against oracle with multiple statements?

I need execute multiple SQL statements in the generic query designer with an oracle connection.

thanks

Maybe I'm missing something, but couldn't you just define multiple datasets in the report with one query per dataset?

If the queries have interdependencies, you could look into moving them into a stored procedure and calling the stored procedure from SSRS. You should find several threads on the regular SSRS forum (http://forums.microsoft.com/MSDN/ShowForum.aspx?ForumID=82&SiteID=1) discussing how to call Oracle stored procedures from SSRS.

-- Robert

|||

Robert -- slightly off topic but do you have any idea why the Query Designer would be really slow loading tables from Oracle?

There are two threads on this subject:

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=324176&SiteID=1

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=2019689&SiteID=1

...maybe this deserved looking at for a fix in Katmai if it's not already done... is there an issue with multiple connections for each table that is being added or something?

Thanks in advance,

>L<

|||The query designer is actually a VS component, not an RS component. It might use the OLE DB provider but I'm not 100% certain.

|||

Thanks Brian. I might have known that the query designer was a shared component, but I haven't heard of anybody complaining about its speed except in this (report design) context.

As far as whether the query designer uses OLE DB or not... it can, and does, and when it does it is apparently fast -- against the same data.

It's just when these guys are accessing Oracle and their specified connection to this data source is *not* an OLE DB connection that they see the problem. (10-15 minutes to add a table in the designer ?!? Yuck...) I was thinking maybe the designer was trying to make a separate connection every time they pressed that "Add" button.

>L<

|||

Well, I know this won't really resolve the issue, but the shared VS query designer component is actually only supported for a particular set of OLEDB providers, as described in the following KB article:

http://support.microsoft.com/default.aspx?scid=kb;en-us;811241

? Microsoft OLE DB Provider for SQL Server
? Microsoft Jet 4.0 OLE DB Provider
? Microsoft OLE DB Provider for Oracle

It is not supported for any other providers.

-- Robert

|||

Thanks for going the extra mile, Robert <s>. That totally makes sense. I will refer them to this post and stop worrying that the query designer has a bug <g>.

>L<

Report against oracle with multiple statements

hello developers!!!!!

How I have to do a Report against oracle with multiple statements?

I need execute multiple SQL statements in the generic query designer with an oracle connection.

thanks

Maybe I'm missing something, but couldn't you just define multiple datasets in the report with one query per dataset?

If the queries have interdependencies, you could look into moving them into a stored procedure and calling the stored procedure from SSRS. You should find several threads on the regular SSRS forum (http://forums.microsoft.com/MSDN/ShowForum.aspx?ForumID=82&SiteID=1) discussing how to call Oracle stored procedures from SSRS.

-- Robert

|||

Robert -- slightly off topic but do you have any idea why the Query Designer would be really slow loading tables from Oracle?

There are two threads on this subject:

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=324176&SiteID=1

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=2019689&SiteID=1

...maybe this deserved looking at for a fix in Katmai if it's not already done... is there an issue with multiple connections for each table that is being added or something?

Thanks in advance,

>L<

|||The query designer is actually a VS component, not an RS component. It might use the OLE DB provider but I'm not 100% certain.

|||

Thanks Brian. I might have known that the query designer was a shared component, but I haven't heard of anybody complaining about its speed except in this (report design) context.

As far as whether the query designer uses OLE DB or not... it can, and does, and when it does it is apparently fast -- against the same data.

It's just when these guys are accessing Oracle and their specified connection to this data source is *not* an OLE DB connection that they see the problem. (10-15 minutes to add a table in the designer ?!? Yuck...) I was thinking maybe the designer was trying to make a separate connection every time they pressed that "Add" button.

>L<

|||

Well, I know this won't really resolve the issue, but the shared VS query designer component is actually only supported for a particular set of OLEDB providers, as described in the following KB article:

http://support.microsoft.com/default.aspx?scid=kb;en-us;811241

? Microsoft OLE DB Provider for SQL Server
? Microsoft Jet 4.0 OLE DB Provider
? Microsoft OLE DB Provider for Oracle

It is not supported for any other providers.

-- Robert

|||

Thanks for going the extra mile, Robert <s>. That totally makes sense. I will refer them to this post and stop worrying that the query designer has a bug <g>.

>L<