How to make you reports load faster ?

Any ideas how to make reports faster when returning lots fo rows?
I know you would need to work on your sql query etc..
Or maybe cache it.

But i'm thinking of having a kind of middle tier thing that sits between your sql database and the reports itself.

Any ideas would be appreciated

Dear rote,

Caching is certainly one option. Search the sql books online for Report Caching, Execution Snapshots and Report History.

If possible, keep your report server on a different machine. Adding memory will help increase performance.

http://www.microsoft.com/technet/prodtechnol/sql/2005/pspsqlrs.mspx#E6NAC

HTH,
Suprotim Agarwal

--
http://www.dotnetcurry.com
--

|||

RS comes with two middle tier elements of its own: snapshots and caching <s>. Do either of these meet your needs?

>L<

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 setup of report

Hello all
I made some reports at my machine. Now i installed Sql Server Reporting
Services on other machine which is production machine. I want to make
an installable or setup or any package to install created reports. Can
anyone help me how to do this?
I gone through Publish sample reports, i tried to publish my one
report, but it shows some error. In the script i dont know what to put
infront of parentFolder. can any one help me.
Thanks & Regards
RajThe server should be something like
http://yourservername/ReportServer
If you want the report in my reports...use
My Reports/Yourfoldername
and for data sources
My Reports/Data Sources
replace My Reports with whatever directory under RS you wish your reports to
be deployed ( and that you have permission to do.)
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.
"Raj" wrote:
> Hello all
> I made some reports at my machine. Now i installed Sql Server Reporting
> Services on other machine which is production machine. I want to make
> an installable or setup or any package to install created reports. Can
> anyone help me how to do this?
> I gone through Publish sample reports, i tried to publish my one
> report, but it shows some error. In the script i dont know what to put
> infront of parentFolder. can any one help me.
>
> Thanks & Regards
> Raj
>

How to make reports available to clients

I have designed some reports using MS Reporting Services. I want to make
those available to some of my clients. What that procedure is called and how
would I do that.
Thank you in advance.You can download the microsoft code which lets you embed a report
viewer object in your .net web pages which is the easiest way.
Or you can write a custom interface and in your code behind render the
report with code.
"RA" <rchaudhary-nospam@.storis.com> wrote in message news:<OYJ$eLsWEHA.2576@.TK2MSFTNGP10.phx.gbl>...
> I have designed some reports using MS Reporting Services. I want to make
> those available to some of my clients. What that procedure is called and how
> would I do that.
>
> Thank you in advance.

How to make data sets of one report also available for other reports?

Hi, all experts here,

Thank you very much for your kind attention.

I am building reports on SQL Server 2005 Reporting Services.

I am having a question about how to make the data sets of one report for other reports as well within the same report project? As we may need to use the same data sets for report parameters settings. Really need help for that.

Thanks a lot in advance for any guidance and help for that.

With best regards,

Yours sincerely,

In one report, you can use the same dataset for parameters and the body of the report. But currently it's not possible to reuse the datasets of one report for other reports. It is on our wishlist for a future release.|||

Hi, Fang, thanks a lot for your information.

With best regards,

Yours sincerely,

how to make a 'my reports' folder

Hi,
I am having some trouble getting the 'My Reports' folder to appear for all
users. The docs just say that as long as the user exists as a windows user
and the 'My Reports' option is ticked in 'Site Settings', ReportServer
should just create a 'My Reports' folder the first time a user logs onto the
ReportServer. But this is not working for all users. About half of the
users have the 'My Reports' folder created. So I need to know how to create
them manually, or at least some workaround to get each user a 'My Reports'
folder!
I don't see any difference between the user accts (other than the names).
Thanks,
LanceLance,
Have you checked to ensure all users are are included in the "My Reports"
role - or in some custom role that includes the required permissions.
Regards,
Rob Labbé, MCP, MCAD, MCSD, MCT
Lead Architect/Trainer
Fidelis
Blog: http://spaces.msn.com/members/roblabbe
"Lance" <lance@.[nospam]keayweb.com> wrote in message
news:11849vnplj1n02@.corp.supernews.com...
> Hi,
> I am having some trouble getting the 'My Reports' folder to appear for all
> users. The docs just say that as long as the user exists as a windows
> user
> and the 'My Reports' option is ticked in 'Site Settings', ReportServer
> should just create a 'My Reports' folder the first time a user logs onto
> the
> ReportServer. But this is not working for all users. About half of the
> users have the 'My Reports' folder created. So I need to know how to
> create
> them manually, or at least some workaround to get each user a 'My Reports'
> folder!
> I don't see any difference between the user accts (other than the names).
> Thanks,
> Lance
>|||Hi,
Thanks for the reply, but I am a bit confused about it! Maybe if I explain
a bit more about the setup: The ReportServer is set up with no common
reports. Each user can *only* view the reports in their own 'My Reports'
folder. As such each user *must* have a 'My Reports' folder! (obviously)
Here is how the server is set up:
* There are the standard 'Item-level' roles and an additional one,
'Viewer' - which is a limited acct, that just allows the user to 'view
folders' and 'view reports'. None of the non-admin users can create
reports.
* The 'System Roles' are the standard 'System Administrator' and 'System
User' - the 'System User' has the 'View report server properties' and 'View
shared schedules' tasks.
* The 'Enable My Reports to support user-owned folders for publishing and
running personalized reports.' checkbox is checked in the 'Reporst Server'
'Site Settings'. The 'Choose the role to apply to each user's My Reports
folder' dropdown is 'Viewer'
To set up for a new user:
* Each new user is added to the 'Users' group on the server (windows 2000
server).
* The user logs in, and a 'My Reports' folder should be created.
But mostly, a 'My Reports' folder is *not* created. Or perhaps just not
shown. I don't know how to check whether there is a 'My Reports' folder for
the user - I am thinking that there is a value in the DB somewhere that
tells me...
I was experimenting with a dozen new users, and the docs say that as soon as
a windows user logs in, a 'My Reports' folder should be created. I tried
both creating a 'System Role' for the user and *not* creating a system role,
but the creation of the 'My Reports' folder seems to occur randomly. I say
*seem*, as I am sure that I am missing a step or something, as I confess
that I find the role assignment somewhat confusing. But I'm new, and I am
sure I'll get used to it...
In response to your kindly answer:
So, from my limited understanding, the 'My Reports' role is an 'item-level'
role; I can only seem to assign to this at the report level (ie an 'item')
*not* to a user. But if the 'My Reports' folder is not being created, I
can't assign this 'tiem-level' role to it!
In short: I am still stuck with some users having a 'My Reports' folder and
most users *not* having one!
Thanks,
Lance
> Lance,
> Have you checked to ensure all users are are included in the "My Reports"
> role - or in some custom role that includes the required permissions.
> Regards,
>
> --
> Rob Labbé, MCP, MCAD, MCSD, MCT
> Lead Architect/Trainer
> Fidelis
> Blog: http://spaces.msn.com/members/roblabbe
> "Lance" <lance@.[nospam]keayweb.com> wrote in message
> news:11849vnplj1n02@.corp.supernews.com...
> > Hi,
> > I am having some trouble getting the 'My Reports' folder to appear for
all
> > users. The docs just say that as long as the user exists as a windows
> > user
> > and the 'My Reports' option is ticked in 'Site Settings', ReportServer
> > should just create a 'My Reports' folder the first time a user logs onto
> > the
> > ReportServer. But this is not working for all users. About half of the
> > users have the 'My Reports' folder created. So I need to know how to
> > create
> > them manually, or at least some workaround to get each user a 'My
Reports'
> > folder!
> >
> > I don't see any difference between the user accts (other than the
names).
> >
> > Thanks,
> > Lance
> >
> >
>|||Hi,
I was just nosing around the DB, and I noticed that all the users are in the
'users' table, but the user accounts don't appear in the 'PolicyUserRole'
table, and hence there are not any policies for them.
I don't know if this helps any or just confuses...
And there aren't any application events in the log on the server, either.
"Lance" <lance@.[nospam]keayweb.com> wrote in message
news:11869vtmjhs8i08@.corp.supernews.com...
> Hi,
> Thanks for the reply, but I am a bit confused about it! Maybe if I
explain
> a bit more about the setup: The ReportServer is set up with no common
> reports. Each user can *only* view the reports in their own 'My Reports'
> folder. As such each user *must* have a 'My Reports' folder! (obviously)
> Here is how the server is set up:
> * There are the standard 'Item-level' roles and an additional one,
> 'Viewer' - which is a limited acct, that just allows the user to 'view
> folders' and 'view reports'. None of the non-admin users can create
> reports.
> * The 'System Roles' are the standard 'System Administrator' and 'System
> User' - the 'System User' has the 'View report server properties' and
'View
> shared schedules' tasks.
> * The 'Enable My Reports to support user-owned folders for publishing and
> running personalized reports.' checkbox is checked in the 'Reporst Server'
> 'Site Settings'. The 'Choose the role to apply to each user's My Reports
> folder' dropdown is 'Viewer'
> To set up for a new user:
> * Each new user is added to the 'Users' group on the server (windows 2000
> server).
> * The user logs in, and a 'My Reports' folder should be created.
> But mostly, a 'My Reports' folder is *not* created. Or perhaps just not
> shown. I don't know how to check whether there is a 'My Reports' folder
for
> the user - I am thinking that there is a value in the DB somewhere that
> tells me...
> I was experimenting with a dozen new users, and the docs say that as soon
as
> a windows user logs in, a 'My Reports' folder should be created. I tried
> both creating a 'System Role' for the user and *not* creating a system
role,
> but the creation of the 'My Reports' folder seems to occur randomly. I
say
> *seem*, as I am sure that I am missing a step or something, as I confess
> that I find the role assignment somewhat confusing. But I'm new, and I am
> sure I'll get used to it...
>
> In response to your kindly answer:
> So, from my limited understanding, the 'My Reports' role is an
'item-level'
> role; I can only seem to assign to this at the report level (ie an 'item')
> *not* to a user. But if the 'My Reports' folder is not being created, I
> can't assign this 'tiem-level' role to it!
>
> In short: I am still stuck with some users having a 'My Reports' folder
and
> most users *not* having one!
> Thanks,
> Lance
>
>
> > Lance,
> >
> > Have you checked to ensure all users are are included in the "My
Reports"
> > role - or in some custom role that includes the required permissions.
> >
> > Regards,
> >
> >
> > --
> > Rob Labbé, MCP, MCAD, MCSD, MCT
> > Lead Architect/Trainer
> > Fidelis
> >
> > Blog: http://spaces.msn.com/members/roblabbe
> >
> > "Lance" <lance@.[nospam]keayweb.com> wrote in message
> > news:11849vnplj1n02@.corp.supernews.com...
> > > Hi,
> > > I am having some trouble getting the 'My Reports' folder to appear for
> all
> > > users. The docs just say that as long as the user exists as a windows
> > > user
> > > and the 'My Reports' option is ticked in 'Site Settings', ReportServer
> > > should just create a 'My Reports' folder the first time a user logs
onto
> > > the
> > > ReportServer. But this is not working for all users. About half of
the
> > > users have the 'My Reports' folder created. So I need to know how to
> > > create
> > > them manually, or at least some workaround to get each user a 'My
> Reports'
> > > folder!
> > >
> > > I don't see any difference between the user accts (other than the
> names).
> > >
> > > Thanks,
> > > Lance
> > >
> > >
> >
> >
>sql

How to make a File Share Subscription running on Vista?

I recently migrate to Vista. I had a bunch of reports with file share subscriptions that were running fine on XP.

After installing reporting services on vista (that part only was a challenge), I re-created my subscriptions using the report manager. As expected, when a subscription is executed, the ‘last run’ column shows the last time the report output has been delivered to the file share and the ‘status’ column shows ‘New Subscription’. I thought that this was the signature of a successfully configured subscription.

But surprisingly, there is nothing in the file share. The directory is empty. Anybody has an idea why? Anybody knows how I could possibly find information on my system to find the cause of the problem?

Also, in report manager – after spending hours to figure that I had to run IE in admin mode to see the content of the web app - I cannot delete subscriptions. After selecting the subscription and pressing the delete button I get a JavaScript error and nothing happens. Any trick I could use to get rid of the unused subscriptions (other than using the Reporting Services API).

Thanks,

Dom.

Hi Dom,

There are a few things here.

1. You mention that the subscription executed successfully as the "Last Run" column is updated. In that event the "Status" column should also be updated to something like "The file was successfully saved...." or "Failure writing file....", etc and not remain as "New Subscritpion".

2. Can you check if the fileshare has adequate permissions for the owner of the sunscription?

3. I'm not aware of the JavaScript error and using SOAP API(DeleteSubscription) would be the best way to go about it.

Thanks,
Sharmila

|||

Hi Sharmila,

Thanks for your reply. You are absolutely right; the status column shouldn't say 'new subscription' but 'the file was successfully ...'. Good call!

I checked the file share permissions and unless I am missing something I think the permissions are ok. Everything is running on the same machine (reporting services, sql server 2005 enterprise edition trial and the shared folder).

Let’s say my machine name is ‘ka’ and the user name is ‘boom’.Boom is an admin on the machine (remember I am running Vista).The owner of the subscription is ‘ka\boom’ and the file share delivery extension is set with ‘ka\boom’ and his password.

On the same machine, I have a shared folder and the owner permissions are given to ‘ka\boom’.

I have another machine running XP on my local network with reporting services.I tried to configure a subscription on the XP machine with a file share delivery pointing to the shared folder on my machine running Vista.The result is the same, the status column keep saying ‘new subscription’ while the last run column gets updated correctly.

Finally, yes I did use the soap api to get rid of the undesired subscriptions.

Thanks again,

Dom.

|||

Can you include the logs specifically around the time the subscription fired?

Thanks,
Sharmila

|||

I re-configured the whole thing today in order to get good log files for you and this time I got a different error message in the ‘status’ column of the report manager. I got: “Failure writing file Test.pdf : An impersonation error occurred using the security context of the current user.”

I zipped all the log files I could think might help to solve the problem. You can get the package at: http://dchoquette.aaafly.com/logs/log_files.zip

Let me know if you need more logs to diagnose the problem.

I created the subscription at 11:03 am today (February 22^nd, 2007) and the subscription fired at 11:10 am.

I am going to start looking on my side for answers related to that new error message that I got.

Thanks for you help.

|||

I was puzzled before that the "Status" column was not updated even though the subscription executed successfully. It makes sense now that both the "Last Run" and "Status" columns are updated. It looks like a permission issue to me. I do not have enough info from the logs. You need to send the report server service log of this format(Eg: ReportServerService__02_13_2007_14_38_32.log).

Thanks,

Sharmila

|||

I just updated the zip file, you can get it at the same location. It now contains the log file you requested and I briefly saw permission problems around 11:10 am. Not sure what is the cause though. I didn’t know there was a ReportServerService AND a ReportServerServiceMain in the logs directory :)

Let me know if you find out why I have that permission issue.

|||

Talking to the developer here, it looks like it could be two things:

1. RS Windows service account does not have enough rights.

2. Are you seeing this only on your Vista machine? Have you tried on a different machine?

Thanks,
Sharmila

|||

The RS Windows service is running under the ‘Local System account’ and the option ‘Allow service to interact with desktop’ is unchecked.This must be the default configuration because I do not remember changing the log on settings.

Yes I only experience this problem on Vista.The exact same subscription configuration is working fine on another machine running XP.

Thanks for helping me, I really appreciate it.

|||

To narrow down and track the real issue, can you try using different accounts for the RS Windows service to see if that works?

Thanks,
Sharmila

|||

I couldn't repro this in house and so was wondering if you have the latest released SP2 installed(not CTP3)? See if that makes a difference.

Thanks,

Sharmila

|||

I tried to change the log on account of the reporting services window service. I configured it with an administrator account on my machine. When I tried to create a file share subscription to test I got the following error message:

A subscription delivery error has occurred. (rsDeliveryError) Get Online Help

	The report server cannot decrypt the symmetric key used to access sensitive or encrypted data in a report server database. You must either restore a backup key or delete all encrypted content. Check the documentation for more information. (rsReportServerDisabled) (rsRPCError) Get Online Help
	Bad Data. (Exception from HRESULT: 0x80090005)

Not sure what to do to get that other problem out of the way. I changed the log on account of reporting services back to ‘local system account’ and now I can create the file share subscription but it still gives me the same error:

“Failure writing file Test.pdf : An impersonation error occurred using the security context of the current user.”

Concerning which service pack I have installed, I checked the digital signature of the executable I installed on my system and the Singing time is ‘Saturday, December 09, 2006 4:12:36 AM’. Hopefully you can tell if it is the latest release of SP2 and not CTP3.

Thanks,

Dom.

|||

It looks like you have CTP3. Check out the post about the release of SP2.

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

Thanks,

Sharmila

|||

I installed the new release of SP2 and I still get the same error. That's it, I give up :) ... I wrote a custom delivery extension that is writing the report output in a directory and it is working fine for my needs.

I had a question concerning the delivery extensions if you don't mind. Do you know if it is possible to reuse the fonctionality of the built-in email delivery extension from the custom delivery extension I wrote? If so, do you have a link to a page explaining how to do so?

Thanks a lot for your help, you have been very helpful.

Dom

How to make a File Share Subscription running on Vista?

I recently migrate to Vista. I had a bunch of reports with file share subscriptions that were running fine on XP.

After installing reporting services on vista (that part only was a challenge), I re-created my subscriptions using the report manager. As expected, when a subscription is executed, the ‘last run’ column shows the last time the report output has been delivered to the file share and the ‘status’ column shows ‘New Subscription’. I thought that this was the signature of a successfully configured subscription.

But surprisingly, there is nothing in the file share. The directory is empty. Anybody has an idea why? Anybody knows how I could possibly find information on my system to find the cause of the problem?

Also, in report manager – after spending hours to figure that I had to run IE in admin mode to see the content of the web app - I cannot delete subscriptions. After selecting the subscription and pressing the delete button I get a JavaScript error and nothing happens. Any trick I could use to get rid of the unused subscriptions (other than using the Reporting Services API).

Thanks,

Dom.

Hi Dom,

There are a few things here.

1. You mention that the subscription executed successfully as the "Last Run" column is updated. In that event the "Status" column should also be updated to something like "The file was successfully saved...." or "Failure writing file....", etc and not remain as "New Subscritpion".

2. Can you check if the fileshare has adequate permissions for the owner of the sunscription?

3. I'm not aware of the JavaScript error and using SOAP API(DeleteSubscription) would be the best way to go about it.

Thanks,
Sharmila

|||

Hi Sharmila,

Thanks for your reply. You are absolutely right; the status column shouldn't say 'new subscription' but 'the file was successfully ...'. Good call!

I checked the file share permissions and unless I am missing something I think the permissions are ok. Everything is running on the same machine (reporting services, sql server 2005 enterprise edition trial and the shared folder).

Let’s say my machine name is ‘ka’ and the user name is ‘boom’. Boom is an admin on the machine (remember I am running Vista).The owner of the subscription is ‘ka\boom’ and the file share delivery extension is set with ‘ka\boom’ and his password.

On the same machine, I have a shared folder and the owner permissions are given to ‘ka\boom’.

I have another machine running XP on my local network with reporting services.I tried to configure a subscription on the XP machine with a file share delivery pointing to the shared folder on my machine running Vista.The result is the same, the status column keep saying ‘new subscription’ while the last run column gets updated correctly.

Finally, yes I did use the soap api to get rid of the undesired subscriptions.

Thanks again,

Dom.

|||

Can you include the logs specifically around the time the subscription fired?

Thanks,
Sharmila

|||

I re-configured the whole thing today in order to get good log files for you and this time I got a different error message in the ‘status’ column of the report manager. I got: “Failure writing file Test.pdf : An impersonation error occurred using the security context of the current user.”

I zipped all the log files I could think might help to solve the problem. You can get the package at: http://dchoquette.aaafly.com/logs/log_files.zip

Let me know if you need more logs to diagnose the problem.

I created the subscription at 11:03 am today (February 22^nd, 2007) and the subscription fired at 11:10 am.

I am going to start looking on my side for answers related to that new error message that I got.

Thanks for you help.

|||

I was puzzled before that the "Status" column was not updated even though the subscription executed successfully. It makes sense now that both the "Last Run" and "Status" columns are updated. It looks like a permission issue to me. I do not have enough info from the logs. You need to send the report server service log of this format(Eg: ReportServerService__02_13_2007_14_38_32.log).

Thanks,

Sharmila

|||

I just updated the zip file, you can get it at the same location. It now contains the log file you requested and I briefly saw permission problems around 11:10 am. Not sure what is the cause though. I didn’t know there was a ReportServerService AND a ReportServerServiceMain in the logs directory :)

Let me know if you find out why I have that permission issue.

|||

Talking to the developer here, it looks like it could be two things:

1. RS Windows service account does not have enough rights.

2. Are you seeing this only on your Vista machine? Have you tried on a different machine?

Thanks,
Sharmila

|||

The RS Windows service is running under the ‘Local System account’ and the option ‘Allow service to interact with desktop’ is unchecked. This must be the default configuration because I do not remember changing the log on settings.

Yes I only experience this problem on Vista.The exact same subscription configuration is working fine on another machine running XP.

Thanks for helping me, I really appreciate it.

|||

To narrow down and track the real issue, can you try using different accounts for the RS Windows service to see if that works?

Thanks,
Sharmila

|||

I couldn't repro this in house and so was wondering if you have the latest released SP2 installed(not CTP3)? See if that makes a difference.

Thanks,

Sharmila

|||

I tried to change the log on account of the reporting services window service. I configured it with an administrator account on my machine. When I tried to create a file share subscription to test I got the following error message:

A subscription delivery error has occurred. (rsDeliveryError) Get Online Help

	The report server cannot decrypt the symmetric key used to access sensitive or encrypted data in a report server database. You must either restore a backup key or delete all encrypted content. Check the documentation for more information. (rsReportServerDisabled) (rsRPCError) Get Online Help
	Bad Data. (Exception from HRESULT: 0x80090005)

Not sure what to do to get that other problem out of the way. I changed the log on account of reporting services back to ‘local system account’ and now I can create the file share subscription but it still gives me the same error:

“Failure writing file Test.pdf : An impersonation error occurred using the security context of the current user.”

Concerning which service pack I have installed, I checked the digital signature of the executable I installed on my system and the Singing time is ‘Saturday, December 09, 2006 4:12:36 AM’. Hopefully you can tell if it is the latest release of SP2 and not CTP3.

Thanks,

Dom.

|||

It looks like you have CTP3. Check out the post about the release of SP2.

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

Thanks,

Sharmila

|||

I installed the new release of SP2 and I still get the same error. That's it, I give up :) ... I wrote a custom delivery extension that is writing the report output in a directory and it is working fine for my needs.

I had a question concerning the delivery extensions if you don't mind. Do you know if it is possible to reuse the fonctionality of the built-in email delivery extension from the custom delivery extension I wrote? If so, do you have a link to a page explaining how to do so?

Thanks a lot for your help, you have been very helpful.

Dom

sql

How to Localize Prompt String in Reporting Services

Hi,
I am working on SQL Reports using Microsoft SQL Server 2005 Reporting
Services.
These reports are intended to deploy in multilingual environment, for
that purpose, each and every thing has to be localized based on
culture.
1- I am able to localized the field labels by loading custom assembly
using expression .
2- But unable to localize the prompt strings.
3- In Report Designer, Report->Report Parameters, the text given for
prompt does not evaluate the expression, if given "=User!Language", it
prints as it is, next to the prompt for respective parameter.
Is there any way or workaround to localize the prompt string at
runtime?
Thanx in advance,
HariomOn 8 loka, 17:28, hariompandey...@.gmail.com wrote:
> Hi,
> I am working onSQLReports using MicrosoftSQLServer2005Reporting
> Services.
> These reports are intended to deploy in multilingual environment, for
> that purpose, each and every thing has to be localized based on
> culture.
> 1- I am able to localized the field labels by loading custom assembly
> using expression .
> 2- But unable tolocalizethepromptstrings.
> 3- InReportDesigner,Report->ReportParameters, the text given forpromptdoes not evaluate the expression, if given "=User!Language", it
> prints as it is, next to thepromptfor respectiveparameter.
> Is there any way or workaround tolocalizethepromptstring at
> runtime?
> Thanx in advance,
> Hariom
Hi Hariom,
Our company has customers all around the world. The localization
support in Reporting Services 2005 is not so good at the moment. Like
you did we also built a custom assembly to localize report fields.
We even built a custom HTTP module to localize the Report Manager to
any language (Microsoft provides few satellite assemblies to localize
it for few languages but not nearly enough, and you can't create your
own assembly, I asked Microsoft Gold partner support about it).
So what we do is that we go through each component on the web page and
check using reflection whether it has a Text property. If it does we
get the text and replace it with another text in another language.
This works great for Report Manager application.
Unfortunately this approach does not work with report parameter prompt
texts. Even if you change the Text property of these components, they
still render the text that is defined in the RDL for the prompt.
So to answer your question, after very extensive search we have not
found any way to localize them at runtime. We had to build a tool that
translates RDL files to different languages.
Best regards,
Juho Salo

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 list all history/snapshots of a given report

We are running SSRS2005 and produce multiple reports.

Our users need history report data so we set up snapshots executions to run weekly.

How do we display the list of these historical snapshots to the users for selection?

Currently we code:

http://myserver/Reports/Pages/Report.aspx?ItemPath=/myreports/Available+Floor+Space&rs:Command=Render&SelectedTabId=SnapshotsTab

That is not preferred as the user is presented the Report Manager interface and can go use other functionality such as subscriptions etc... that we do not support.

Is there (a) a way to suppress the Report Manager controls? or (b)another way to list the snapshots executed given a report name( maybe by querying the report server database?) or (c) code http://myserver/Reportserver/?/myreports/Available+Floor+Space&rs:Command=Render&? to get the history listing?

Thanks

Hi,

The best way is to use Reporting Services Web Services.

You need to add a Web Reference to your Reporting Server and name it <ReferenceName>. Once it is setup you can call the web services using the <ReferenceName>.

In your class first you need to add the "using" statement....

using <NameSpace>.<ReferenceName>.

then in the code you can use...

ReportingService rs = new ReportingService();

rs.Credentials = <your credentials>;

ReportHistorySnapshot[] historySnapshotList = rs.ListReportHistory(<report name>);

Hope this will help you.

Thanks.

Hammad

How to link new primary key column instead of old primary key column on existing

The earlier developer, developed reports very complex formatting reports, may be he was spend lot of time on formatting. Each report is fetching data from 7 to 8 tables. All are working fine. He did very good job. He didnt used Stored Procedures in it. For Complex reports SP are giving better performance as of my knowledge. Recently I joined in the organization they assigned me reports part.

Now the problem is

Recently the database was changed accordingly their convenience. He was developed reports using old database. In the old database one table they added one new column and assigned primary key, old primary key column as set to non-key column. Now I need to link the new primary column instead of old primary key column. I dont know how to change this one, I tried verify database command. But no luck. I check report export. I am confusing on that. Can you please help me to solve this one?



Thanks in advance

NadaI believe you have been answered on another forum.