Reporting Services Aesthetics Question

Hello,

I am currently in process of authoring a report that generates rows and then it gives the users options to drill down into a subreport. Each time a user drills down into the subreport, the page refreshes, displays the top of the page and then jumps down to the row that was expanded. This isn't too bad for the first time or so, but it gets annoying really fast.

Is this a bug or is this just how RS handles drilling down in a subreport?

More than likely, what you see is what you get.

You may want to submit feedback to Microsoft here so that possibly they will fix it, or you will see improvement in SQL 2008:

https://connect.microsoft.com/SQLServer/feedback/

|||I was afraid of that. Thanks for your reply!

Reporting Services 2005 report in Outlook 2007

I have a Reporting Services 2005 report that is emailed to users. I
created/formatted the report based on how it looked in Outlook 2003 which
all of our users had at that time. The report is wide, but just fit in the
email window when it was full size. Now I have a user who has been
converted to Outlook 2007 and he emailed me a copy of the report he received
in Outlook 2007 and it looks like it reduced the column sizes; it does not
fill the entire email window and wraps the wording on most lines because the
column sizes have been reduced.
The report is:
Delivered by: Report Server E-mail
Include Report is checked
Render Format is Web archive
Any ideas on how I can fix this?
Thanks in advance.
--
DJansonOn Feb 9, 12:50 pm, DJanson <DJan...@.discussions.microsoft.com> wrote:
> I have a Reporting Services 2005 report that is emailed to users. I
> created/formatted the report based on how it looked in Outlook 2003 which
> all of our users had at that time. The report is wide, but just fit in theemailwindow when it was full size. Now I have a user who has been
> converted to Outlook 2007 and he emailed me a copy of the report he received
> in Outlook 2007 and it looks like it reduced thecolumnsizes; it does not
> fill the entireemailwindow and wraps the wording on most lines because thecolumnsizes have been reduced.
> The report is:
> Delivered by: Report ServerE-mail
> Include Report is checked
> Render Format isWebarchive
> Any ideas on how I can fix this?
> Thanks in advance.
> --
> DJanson
I am having the same issue, but I do not have a solution.|||On Mar 15, 1:13 am, mjcarrab...@.gmail.com wrote:
> On Feb 9, 12:50 pm, DJanson <DJan...@.discussions.microsoft.com> wrote:
>
>
> > I have a Reporting Services 2005 report that is emailed to users. I
> > created/formatted the report based on how it looked inOutlook2003 which
> > all of our users had at that time. The report is wide, but just fit in theemailwindow when it was full size. Now I have a user who has been
> > converted toOutlook2007 and he emailed me a copy of the report he received
> > inOutlook2007 and it looks like it reduced thecolumnsizes; it does not
> > fill the entireemailwindow and wraps the wording on most lines because thecolumnsizes have been reduced.
> > The report is:
> > Delivered by: Report ServerE-mail
> > Include Report is checked
> > Render Format isWebarchive
> > Any ideas on how I can fix this?
> > Thanks in advance.
> > --
> > DJanson
> I am having the same issue, but I do not have a solution.- Hide quoted text -
> - Show quoted text -
Does anyone have a fix for this? My report is squished to one narrow
column in Outlook 2007, but renders fine when viewed in Outlook 2003.
Thanks.
-Joe|||I have the same problem is driving me mad. I have a half fix by adding
a long transparent gif image into the report. This makes the table
bigger. Bear in mind that the actual image file needs to be the right
size, you can't just resize it in Visual Studio.
Problem is that if the report runs to 2 pages the second page gets
squished again because the image is at the top :(
Please help!|||Apparently, us five are not the only ones having this issue. Someone reported
it to MS Feedback. Microsoft's typical response: "We are currently
investigating this issue." and the item is marked as "Closed".
How does Microsoft re-define "Closed" to mean they are currently looking
into the issue? They must have some GREAT pull with the folks over at
Wikipedia!
--
Todd C

reporting services (client or server) ad-hoc user created reports?

Hi,
I would like to allow my users to create report templates and save them.
The reports should get their data from my business objects. I'm not really
sure where to begin with this.. I image that i'll need to setup reporting
services.
Currently I have rdlc client reports and report viewer. I don't mind moving
to server reports if required, but i'd like to continue to use the viewer to
display them in my application.
Has anyone else done this?
Thanks
Andyhey Andy
have you had a look at Report Builder? This is really what this is
for.
Dianne
On Apr 26, 8:50 am, Andy <A...@.discussions.microsoft.com> wrote:
> Hi,
> I would like to allow my users to create report templates and save them.
> The reports should get their data from my business objects. I'm not really
> sure where to begin with this.. I image that i'll need to setupreportingservices.
> Currently I have rdlc client reports and report viewer. I don't mind moving
> to server reports if required, but i'd like to continue to use the viewer to
> display them in my application.
> Has anyone else done this?
> Thanks
> Andy|||On Apr 26, 5:55 pm, jewelfire <jewelfi...@.gmail.com> wrote:
> hey Andy
> have you had a look at Report Builder? This is really what this is
> for.
Yes, but I'm at the point where I still need to learn how to build the
model for use in report builder. As I said, I'm just starting with
this.. and only one book I found spends any time on ad-hoc reports,
and only one chapter.

Reporting Service seems to "go to sleep" after a while...

My reporting server seems to go to sleep after some time of non-use. This is affecting the users who create reports at the start of the day. A report that takes 1 second to generate takes 11 seconds on first hit in the morning. After the initial "wake up" call, the report server generates the reports normally without any delay. Can I keep it awake the whole time? Is there a setting somewhere?

Is there an error generated? What tells you that the report has gone to "sleep"?|||

No error. Just the delay. It's not the report that goes to sleep, its the reporting service. As I said, a report that takes 1 second to generate takes 11 seconds on first hit if the reporting server hasn't been used for a while.

I searched this forum and found other posts similar to mine. It seems that you need to change the shutdown timeout of the App Pool of the reporting service and/or create a snapshot of a dummy report each hour or so.

Any other suggestions beside these?

|||

>> any other suggestions

Those *are* the right answers, usually. ( examples: http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1056458&SiteID=1 or http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=703914&SiteID=1)

Are you saying you already tried this advice and it did not work for you, or that you don't want to follow those instructions for some reason <s>?

>L<

|||

I tried both and they aren't working. When I run a report in the morning, it still takes a long time to "wake up". I then look at Event Log of the reporting server to discover that an entry has just been made saying that reporting services has been activated. It should already be activated according to those other posts.

I've got reporting services creating a snapshot of a dummy report every hour and I've set the background thread in IIS to shutdown after 2 days, so I'm doing everything those other posts suggest. Still no go.

|||

OK. This might be a stupid question but... could overnight patching or maintenance procedures of any type that might require a reboot, or even just a shut down of ASP.NET, be involved here?

>L<

|||

I don't think the web server / reporting server shuts down each night. I believe it is constantly turned on.

I had a look at how the snapshot works. It seems to create an SQL job, which runs on a schedule. This would mean the snapshot has nothing to do with ASP.NET and the IIS worker process, which I think it is the culprit. Maybe I need something to constantly download a dummy report on the web server to keep the web service alive? How could I do that?

|||

To tell you the truth, I didn't even understand why you were creating a snapshot on the hour (did you find that part in the instructions somewhere? ) I ws sure the worker thread thing was what you needed to do. (I know you said you set the background thread -- are you sure you did the right thing for the application pool that reporting services is using?)

As far as how you can download a dummy report, sure you can do that various kludgey ways with a bunch of work -- but that seems like a depressing idea, doesn't it <s>?

Can you describe exactly what you did re " I've set the background thread in IIS to shutdown after 2 days" and under what OS/version of IIS ?

>L<

|||

One of the forum posts suggested to create a snapshot.

Reporting Services is running on Windows Server 2003 on IIS 6.

There are two virtual directories under "Default Website": Reports and ReportServer. The application pool for each is "ReportServer". But the application pool for "Default Website" is "DefaultAppPool". Maybe that's a problem?

Going to the properties window of the "ReportServer" app pool, in the Performance tab, there is an option "Shut down worker process after being idle for (time in minutes)". This was 20 minutes and I changed it to 2880 minutes (2 days).

In the "Recycling" tab (the first tab) there is a "Recycle worker process (in minutes)" option which is set to 1740 (if that helps).

Everytime the report server wakes up, an entry in the Event Log is created with the text:

The ReportServer service has been activated.

The report server seems to deactivate a lot during the day, not just in the mornings. Maybe it's something to do with the fact that Default Web Site has a different app pool than the two reporting services virtual directories that sit under it?

|||

I suppose you could change the values for the default web site/app pool also but you shouldn't need to.

Try unchecking the Recycle worker process option altogether. **

Are you absolutely sure that the event log says "has been activated" rather than "started" or "started successfully" each time? Are you *sure* <g>? because this message shouldn't be happening multiple times... and doesn't mean what you are interpreting it to mean...

** Look: I'm pretty sure that, in spite of the fact that you think it's the "reportserver service" and are seeing that message, that what you are seeing is due to recompiling of the app instance for the web application.

... but, just in case, if it is really the service, I assume you have also checked to make sure that the service startup type is Automatic?

>L<

|||

I had copied and pasted the Event Log message into my post, and it happens multiple times a day. I checked the Service and it's set to "Automatic".

Before I set it to 2 days, I had originally tried unchecking the Recycle worker process altogether, but the same thing.

In the meantime, I've set up a little console application that runs on the server via Windows Scheduler every 15 minutes. It uses the Reporting Services Web Service to download one of the AdventureWorks sample reports before closing. This seems to be a good interim solution, albeit not ideal.

We are eventually going to upgrade to Reporting Services 2005, so maybe that will help.

|||

Oh!!! I am terribly sorry for having wasted your time on the event log message. I had no idea that you were in RS 2000. I am sure that the messages might be different there.

>L<

|||

I'm going to refer the problem to Microsoft Support and see if I can get any further with this

|||

I think that's a good idea. I hope you get further than this...

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

... I believe the solution posted there is specific to RS 2005 but at least it is a cogent explanation of the IIS component of the issue <s>.

Good luck,

>L<

Reporting Service seems to "go to sleep" after a while...

My reporting server seems to go to sleep after some time of non-use. This is affecting the users who create reports at the start of the day. A report that takes 1 second to generate takes 11 seconds on first hit in the morning. After the initial "wake up" call, the report server generates the reports normally without any delay. Can I keep it awake the whole time? Is there a setting somewhere?

Is there an error generated? What tells you that the report has gone to "sleep"?|||

No error. Just the delay. It's not the report that goes to sleep, its the reporting service. As I said, a report that takes 1 second to generate takes 11 seconds on first hit if the reporting server hasn't been used for a while.

I searched this forum and found other posts similar to mine. It seems that you need to change the shutdown timeout of the App Pool of the reporting service and/or create a snapshot of a dummy report each hour or so.

Any other suggestions beside these?

|||

>> any other suggestions

Those *are* the right answers, usually. ( examples: http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1056458&SiteID=1 or http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=703914&SiteID=1)

Are you saying you already tried this advice and it did not work for you, or that you don't want to follow those instructions for some reason <s>?

>L<

|||

I tried both and they aren't working. When I run a report in the morning, it still takes a long time to "wake up". I then look at Event Log of the reporting server to discover that an entry has just been made saying that reporting services has been activated. It should already be activated according to those other posts.

I've got reporting services creating a snapshot of a dummy report every hour and I've set the background thread in IIS to shutdown after 2 days, so I'm doing everything those other posts suggest. Still no go.

|||

OK. This might be a stupid question but... could overnight patching or maintenance procedures of any type that might require a reboot, or even just a shut down of ASP.NET, be involved here?

>L<

|||

I don't think the web server / reporting server shuts down each night. I believe it is constantly turned on.

I had a look at how the snapshot works. It seems to create an SQL job, which runs on a schedule. This would mean the snapshot has nothing to do with ASP.NET and the IIS worker process, which I think it is the culprit. Maybe I need something to constantly download a dummy report on the web server to keep the web service alive? How could I do that?

|||

To tell you the truth, I didn't even understand why you were creating a snapshot on the hour (did you find that part in the instructions somewhere? ) I ws sure the worker thread thing was what you needed to do. (I know you said you set the background thread -- are you sure you did the right thing for the application pool that reporting services is using?)

As far as how you can download a dummy report, sure you can do that various kludgey ways with a bunch of work -- but that seems like a depressing idea, doesn't it <s>?

Can you describe exactly what you did re " I've set the background thread in IIS to shutdown after 2 days" and under what OS/version of IIS ?

>L<

|||

One of the forum posts suggested to create a snapshot.

Reporting Services is running on Windows Server 2003 on IIS 6.

There are two virtual directories under "Default Website": Reports and ReportServer. The application pool for each is "ReportServer". But the application pool for "Default Website" is "DefaultAppPool". Maybe that's a problem?

Going to the properties window of the "ReportServer" app pool, in the Performance tab, there is an option "Shut down worker process after being idle for (time in minutes)". This was 20 minutes and I changed it to 2880 minutes (2 days).

In the "Recycling" tab (the first tab) there is a "Recycle worker process (in minutes)" option which is set to 1740 (if that helps).

Everytime the report server wakes up, an entry in the Event Log is created with the text:

The ReportServer service has been activated.

The report server seems to deactivate a lot during the day, not just in the mornings. Maybe it's something to do with the fact that Default Web Site has a different app pool than the two reporting services virtual directories that sit under it?

|||

I suppose you could change the values for the default web site/app pool also but you shouldn't need to.

Try unchecking the Recycle worker process option altogether. **

Are you absolutely sure that the event log says "has been activated" rather than "started" or "started successfully" each time? Are you *sure* <g>? because this message shouldn't be happening multiple times... and doesn't mean what you are interpreting it to mean...

** Look: I'm pretty sure that, in spite of the fact that you think it's the "reportserver service" and are seeing that message, that what you are seeing is due to recompiling of the app instance for the web application.

... but, just in case, if it is really the service, I assume you have also checked to make sure that the service startup type is Automatic?

>L<

|||

I had copied and pasted the Event Log message into my post, and it happens multiple times a day. I checked the Service and it's set to "Automatic".

Before I set it to 2 days, I had originally tried unchecking the Recycle worker process altogether, but the same thing.

In the meantime, I've set up a little console application that runs on the server via Windows Scheduler every 15 minutes. It uses the Reporting Services Web Service to download one of the AdventureWorks sample reports before closing. This seems to be a good interim solution, albeit not ideal.

We are eventually going to upgrade to Reporting Services 2005, so maybe that will help.

|||

Oh!!! I am terribly sorry for having wasted your time on the event log message. I had no idea that you were in RS 2000. I am sure that the messages might be different there.

>L<

|||

I'm going to refer the problem to Microsoft Support and see if I can get any further with this

|||

I think that's a good idea. I hope you get further than this...

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

... I believe the solution posted there is specific to RS 2005 but at least it is a cogent explanation of the IIS component of the issue <s>.

Good luck,

>L<

Reporting Service seems to "go to sleep" after a while...

My reporting server seems to go to sleep after some time of non-use. This is affecting the users who create reports at the start of the day. A report that takes 1 second to generate takes 11 seconds on first hit in the morning. After the initial "wake up" call, the report server generates the reports normally without any delay. Can I keep it awake the whole time? Is there a setting somewhere?

Is there an error generated? What tells you that the report has gone to "sleep"?|||

No error. Just the delay. It's not the report that goes to sleep, its the reporting service. As I said, a report that takes 1 second to generate takes 11 seconds on first hit if the reporting server hasn't been used for a while.

I searched this forum and found other posts similar to mine. It seems that you need to change the shutdown timeout of the App Pool of the reporting service and/or create a snapshot of a dummy report each hour or so.

Any other suggestions beside these?

|||

>> any other suggestions

Those *are* the right answers, usually. ( examples: http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1056458&SiteID=1 or http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=703914&SiteID=1)

Are you saying you already tried this advice and it did not work for you, or that you don't want to follow those instructions for some reason <s>?

>L<

|||

I tried both and they aren't working. When I run a report in the morning, it still takes a long time to "wake up". I then look at Event Log of the reporting server to discover that an entry has just been made saying that reporting services has been activated. It should already be activated according to those other posts.

I've got reporting services creating a snapshot of a dummy report every hour and I've set the background thread in IIS to shutdown after 2 days, so I'm doing everything those other posts suggest. Still no go.

|||

OK. This might be a stupid question but... could overnight patching or maintenance procedures of any type that might require a reboot, or even just a shut down of ASP.NET, be involved here?

>L<

|||

I don't think the web server / reporting server shuts down each night. I believe it is constantly turned on.

I had a look at how the snapshot works. It seems to create an SQL job, which runs on a schedule. This would mean the snapshot has nothing to do with ASP.NET and the IIS worker process, which I think it is the culprit. Maybe I need something to constantly download a dummy report on the web server to keep the web service alive? How could I do that?

|||

To tell you the truth, I didn't even understand why you were creating a snapshot on the hour (did you find that part in the instructions somewhere? ) I ws sure the worker thread thing was what you needed to do. (I know you said you set the background thread -- are you sure you did the right thing for the application pool that reporting services is using?)

As far as how you can download a dummy report, sure you can do that various kludgey ways with a bunch of work -- but that seems like a depressing idea, doesn't it <s>?

Can you describe exactly what you did re " I've set the background thread in IIS to shutdown after 2 days" and under what OS/version of IIS ?

>L<

|||

One of the forum posts suggested to create a snapshot.

Reporting Services is running on Windows Server 2003 on IIS 6.

There are two virtual directories under "Default Website": Reports and ReportServer. The application pool for each is "ReportServer". But the application pool for "Default Website" is "DefaultAppPool". Maybe that's a problem?

Going to the properties window of the "ReportServer" app pool, in the Performance tab, there is an option "Shut down worker process after being idle for (time in minutes)". This was 20 minutes and I changed it to 2880 minutes (2 days).

In the "Recycling" tab (the first tab) there is a "Recycle worker process (in minutes)" option which is set to 1740 (if that helps).

Everytime the report server wakes up, an entry in the Event Log is created with the text:

The ReportServer service has been activated.

The report server seems to deactivate a lot during the day, not just in the mornings. Maybe it's something to do with the fact that Default Web Site has a different app pool than the two reporting services virtual directories that sit under it?

|||

I suppose you could change the values for the default web site/app pool also but you shouldn't need to.

Try unchecking the Recycle worker process option altogether. **

Are you absolutely sure that the event log says "has been activated" rather than "started" or "started successfully" each time? Are you *sure* <g>? because this message shouldn't be happening multiple times... and doesn't mean what you are interpreting it to mean...

** Look: I'm pretty sure that, in spite of the fact that you think it's the "reportserver service" and are seeing that message, that what you are seeing is due to recompiling of the app instance for the web application.

... but, just in case, if it is really the service, I assume you have also checked to make sure that the service startup type is Automatic?

>L<

|||

I had copied and pasted the Event Log message into my post, and it happens multiple times a day. I checked the Service and it's set to "Automatic".

Before I set it to 2 days, I had originally tried unchecking the Recycle worker process altogether, but the same thing.

In the meantime, I've set up a little console application that runs on the server via Windows Scheduler every 15 minutes. It uses the Reporting Services Web Service to download one of the AdventureWorks sample reports before closing. This seems to be a good interim solution, albeit not ideal.

We are eventually going to upgrade to Reporting Services 2005, so maybe that will help.

|||

Oh!!! I am terribly sorry for having wasted your time on the event log message. I had no idea that you were in RS 2000. I am sure that the messages might be different there.

>L<

|||

I'm going to refer the problem to Microsoft Support and see if I can get any further with this

|||

I think that's a good idea. I hope you get further than this...

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

... I believe the solution posted there is specific to RS 2005 but at least it is a cogent explanation of the IIS component of the issue <s>.

Good luck,

>L<

Reporting Service seems to "go to sleep" after a while...

My reporting server seems to go to sleep after some time of non-use. This is affecting the users who create reports at the start of the day. A report that takes 1 second to generate takes 11 seconds on first hit in the morning. After the initial "wake up" call, the report server generates the reports normally without any delay. Can I keep it awake the whole time? Is there a setting somewhere?

Is there an error generated? What tells you that the report has gone to "sleep"?|||

No error. Just the delay. It's not the report that goes to sleep, its the reporting service. As I said, a report that takes 1 second to generate takes 11 seconds on first hit if the reporting server hasn't been used for a while.

I searched this forum and found other posts similar to mine. It seems that you need to change the shutdown timeout of the App Pool of the reporting service and/or create a snapshot of a dummy report each hour or so.

Any other suggestions beside these?

|||

>> any other suggestions

Those *are* the right answers, usually. ( examples: http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1056458&SiteID=1 or http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=703914&SiteID=1)

Are you saying you already tried this advice and it did not work for you, or that you don't want to follow those instructions for some reason <s>?

>L<

|||

I tried both and they aren't working. When I run a report in the morning, it still takes a long time to "wake up". I then look at Event Log of the reporting server to discover that an entry has just been made saying that reporting services has been activated. It should already be activated according to those other posts.

I've got reporting services creating a snapshot of a dummy report every hour and I've set the background thread in IIS to shutdown after 2 days, so I'm doing everything those other posts suggest. Still no go.

|||

OK. This might be a stupid question but... could overnight patching or maintenance procedures of any type that might require a reboot, or even just a shut down of ASP.NET, be involved here?

>L<

|||

I don't think the web server / reporting server shuts down each night. I believe it is constantly turned on.

I had a look at how the snapshot works. It seems to create an SQL job, which runs on a schedule. This would mean the snapshot has nothing to do with ASP.NET and the IIS worker process, which I think it is the culprit. Maybe I need something to constantly download a dummy report on the web server to keep the web service alive? How could I do that?

|||

To tell you the truth, I didn't even understand why you were creating a snapshot on the hour (did you find that part in the instructions somewhere? ) I ws sure the worker thread thing was what you needed to do. (I know you said you set the background thread -- are you sure you did the right thing for the application pool that reporting services is using?)

As far as how you can download a dummy report, sure you can do that various kludgey ways with a bunch of work -- but that seems like a depressing idea, doesn't it <s>?

Can you describe exactly what you did re " I've set the background thread in IIS to shutdown after 2 days" and under what OS/version of IIS ?

>L<

|||

One of the forum posts suggested to create a snapshot.

Reporting Services is running on Windows Server 2003 on IIS 6.

There are two virtual directories under "Default Website": Reports and ReportServer. The application pool for each is "ReportServer". But the application pool for "Default Website" is "DefaultAppPool". Maybe that's a problem?

Going to the properties window of the "ReportServer" app pool, in the Performance tab, there is an option "Shut down worker process after being idle for (time in minutes)". This was 20 minutes and I changed it to 2880 minutes (2 days).

In the "Recycling" tab (the first tab) there is a "Recycle worker process (in minutes)" option which is set to 1740 (if that helps).

Everytime the report server wakes up, an entry in the Event Log is created with the text:

The ReportServer service has been activated.

The report server seems to deactivate a lot during the day, not just in the mornings. Maybe it's something to do with the fact that Default Web Site has a different app pool than the two reporting services virtual directories that sit under it?

|||

I suppose you could change the values for the default web site/app pool also but you shouldn't need to.

Try unchecking the Recycle worker process option altogether. **

Are you absolutely sure that the event log says "has been activated" rather than "started" or "started successfully" each time? Are you *sure* <g>? because this message shouldn't be happening multiple times... and doesn't mean what you are interpreting it to mean...

** Look: I'm pretty sure that, in spite of the fact that you think it's the "reportserver service" and are seeing that message, that what you are seeing is due to recompiling of the app instance for the web application.

... but, just in case, if it is really the service, I assume you have also checked to make sure that the service startup type is Automatic?

>L<

|||

I had copied and pasted the Event Log message into my post, and it happens multiple times a day. I checked the Service and it's set to "Automatic".

Before I set it to 2 days, I had originally tried unchecking the Recycle worker process altogether, but the same thing.

In the meantime, I've set up a little console application that runs on the server via Windows Scheduler every 15 minutes. It uses the Reporting Services Web Service to download one of the AdventureWorks sample reports before closing. This seems to be a good interim solution, albeit not ideal.

We are eventually going to upgrade to Reporting Services 2005, so maybe that will help.

|||

Oh!!! I am terribly sorry for having wasted your time on the event log message. I had no idea that you were in RS 2000. I am sure that the messages might be different there.

>L<

|||

I'm going to refer the problem to Microsoft Support and see if I can get any further with this

|||

I think that's a good idea. I hope you get further than this...

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

... I believe the solution posted there is specific to RS 2005 but at least it is a cogent explanation of the IIS component of the issue <s>.

Good luck,

>L<

Reporting Service seems to "go to sleep" after a while...

My reporting server seems to go to sleep after some time of non-use. This is affecting the users who create reports at the start of the day. A report that takes 1 second to generate takes 11 seconds on first hit in the morning. After the initial "wake up" call, the report server generates the reports normally without any delay. Can I keep it awake the whole time? Is there a setting somewhere?

Is there an error generated? What tells you that the report has gone to "sleep"?|||

No error. Just the delay. It's not the report that goes to sleep, its the reporting service. As I said, a report that takes 1 second to generate takes 11 seconds on first hit if the reporting server hasn't been used for a while.

I searched this forum and found other posts similar to mine. It seems that you need to change the shutdown timeout of the App Pool of the reporting service and/or create a snapshot of a dummy report each hour or so.

Any other suggestions beside these?

|||

>> any other suggestions

Those *are* the right answers, usually. ( examples: http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1056458&SiteID=1 or http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=703914&SiteID=1)

Are you saying you already tried this advice and it did not work for you, or that you don't want to follow those instructions for some reason <s>?

>L<

|||

I tried both and they aren't working. When I run a report in the morning, it still takes a long time to "wake up". I then look at Event Log of the reporting server to discover that an entry has just been made saying that reporting services has been activated. It should already be activated according to those other posts.

I've got reporting services creating a snapshot of a dummy report every hour and I've set the background thread in IIS to shutdown after 2 days, so I'm doing everything those other posts suggest. Still no go.

|||

OK. This might be a stupid question but... could overnight patching or maintenance procedures of any type that might require a reboot, or even just a shut down of ASP.NET, be involved here?

>L<

|||

I don't think the web server / reporting server shuts down each night. I believe it is constantly turned on.

I had a look at how the snapshot works. It seems to create an SQL job, which runs on a schedule. This would mean the snapshot has nothing to do with ASP.NET and the IIS worker process, which I think it is the culprit. Maybe I need something to constantly download a dummy report on the web server to keep the web service alive? How could I do that?

|||

To tell you the truth, I didn't even understand why you were creating a snapshot on the hour (did you find that part in the instructions somewhere? ) I ws sure the worker thread thing was what you needed to do. (I know you said you set the background thread -- are you sure you did the right thing for the application pool that reporting services is using?)

As far as how you can download a dummy report, sure you can do that various kludgey ways with a bunch of work -- but that seems like a depressing idea, doesn't it <s>?

Can you describe exactly what you did re " I've set the background thread in IIS to shutdown after 2 days" and under what OS/version of IIS ?

>L<

|||

One of the forum posts suggested to create a snapshot.

Reporting Services is running on Windows Server 2003 on IIS 6.

There are two virtual directories under "Default Website": Reports and ReportServer. The application pool for each is "ReportServer". But the application pool for "Default Website" is "DefaultAppPool". Maybe that's a problem?

Going to the properties window of the "ReportServer" app pool, in the Performance tab, there is an option "Shut down worker process after being idle for (time in minutes)". This was 20 minutes and I changed it to 2880 minutes (2 days).

In the "Recycling" tab (the first tab) there is a "Recycle worker process (in minutes)" option which is set to 1740 (if that helps).

Everytime the report server wakes up, an entry in the Event Log is created with the text:

The ReportServer service has been activated.

The report server seems to deactivate a lot during the day, not just in the mornings. Maybe it's something to do with the fact that Default Web Site has a different app pool than the two reporting services virtual directories that sit under it?

|||

I suppose you could change the values for the default web site/app pool also but you shouldn't need to.

Try unchecking the Recycle worker process option altogether. **

Are you absolutely sure that the event log says "has been activated" rather than "started" or "started successfully" each time? Are you *sure* <g>? because this message shouldn't be happening multiple times... and doesn't mean what you are interpreting it to mean...

** Look: I'm pretty sure that, in spite of the fact that you think it's the "reportserver service" and are seeing that message, that what you are seeing is due to recompiling of the app instance for the web application.

... but, just in case, if it is really the service, I assume you have also checked to make sure that the service startup type is Automatic?

>L<

|||

I had copied and pasted the Event Log message into my post, and it happens multiple times a day. I checked the Service and it's set to "Automatic".

Before I set it to 2 days, I had originally tried unchecking the Recycle worker process altogether, but the same thing.

In the meantime, I've set up a little console application that runs on the server via Windows Scheduler every 15 minutes. It uses the Reporting Services Web Service to download one of the AdventureWorks sample reports before closing. This seems to be a good interim solution, albeit not ideal.

We are eventually going to upgrade to Reporting Services 2005, so maybe that will help.

|||

Oh!!! I am terribly sorry for having wasted your time on the event log message. I had no idea that you were in RS 2000. I am sure that the messages might be different there.

>L<

|||

I'm going to refer the problem to Microsoft Support and see if I can get any further with this

|||

I think that's a good idea. I hope you get further than this...

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

... I believe the solution posted there is specific to RS 2005 but at least it is a cogent explanation of the IIS component of the issue <s>.

Good luck,

>L<

Reporting Server.

Hi,
We are using a live database and want to set up a Reporting Server(Read-Only
for Users) for processing queries.
Is there any 3rd party software producing the effect
of Transactional Replication, being easy to set up and maintain ?
Any links to good step by step guides for Transactional Replication will
also be appreciated. I suspect it's a difficult job to set up and maintain
Transactional Replication, but I may give it a try.
Regards.
Sezgin
Hi
You may want to use replication if you don't want medium/high latency on
updating your data, but if you can copy with a longer difference between the
data in your reporting database and the live system check out log shipping.
There was a couple of articles on this in SQL Server Professional Magazine
http://tinyurl.com/4ez3l
http://tinyurl.com/6rdth
You may also want to check out the simple log shipping solution in the
resource kit.
John
"Sezgin Rafet" wrote:

> Hi,
> We are using a live database and want to set up a Reporting Server(Read-Only
> for Users) for processing queries.
> Is there any 3rd party software producing the effect
> of Transactional Replication, being easy to set up and maintain ?
> Any links to good step by step guides for Transactional Replication will
> also be appreciated. I suspect it's a difficult job to set up and maintain
> Transactional Replication, but I may give it a try.
>
> Regards.
> Sezgin
>
>
|||Thanks for the reply.
I did a short research on the Internet.
3 products attracted my attention:
DoubleTake from NSI Software
SonaSafe for SQL Server from Sonasoft
WANSync / WANSyncHA from XOsoft
Any comments on these products from people who have used them will be
appreciated.
Regards.
Sezgin
"John Bell" <jbellnewsposts@.hotmail.com> wrote in message
news:E352112A-4412-43A6-86A3-3EB0F4F6DCC6@.microsoft.com...[vbcol=seagreen]
> Hi
> You may want to use replication if you don't want medium/high latency on
> updating your data, but if you can copy with a longer difference between
> the
> data in your reporting database and the live system check out log
> shipping.
> There was a couple of articles on this in SQL Server Professional Magazine
> http://tinyurl.com/4ez3l
> http://tinyurl.com/6rdth
> You may also want to check out the simple log shipping solution in the
> resource kit.
> John
> "Sezgin Rafet" wrote:
|||You should also look at Neverfail (www.neverfailgroup.com) I used this
in a previous company and seemed to work for us for SQL and their
Exchange product kicks A**
Pete
Sezgin Rafet wrote:[vbcol=seagreen]
> Thanks for the reply.
> I did a short research on the Internet.
> 3 products attracted my attention:
> DoubleTake from NSI Software
> SonaSafe for SQL Server from Sonasoft
> WANSync / WANSyncHA from XOsoft
>
> Any comments on these products from people who have used them will be
> appreciated.
>
> Regards.
> Sezgin
>
> "John Bell" <jbellnewsposts@.hotmail.com> wrote in message
> news:E352112A-4412-43A6-86A3-3EB0F4F6DCC6@.microsoft.com...
|||Hi
I have not tried any of the third party applications but the no cost option
would be to use what is in the Resource Kit or use the method described by
SQL Server Pro. With SQL 2005 you will get database mirroring.
John
"Sezgin Rafet" wrote:

> Thanks for the reply.
> I did a short research on the Internet.
> 3 products attracted my attention:
> DoubleTake from NSI Software
> SonaSafe for SQL Server from Sonasoft
> WANSync / WANSyncHA from XOsoft
>
> Any comments on these products from people who have used them will be
> appreciated.
>
> Regards.
> Sezgin
>
> "John Bell" <jbellnewsposts@.hotmail.com> wrote in message
> news:E352112A-4412-43A6-86A3-3EB0F4F6DCC6@.microsoft.com...
>
>

Reporting Server.

Hi,
We are using a live database and want to set up a Reporting Server(Read-Only
for Users) for processing queries.
Is there any 3rd party software producing the effect
of Transactional Replication, being easy to set up and maintain ?
Any links to good step by step guides for Transactional Replication will
also be appreciated. I suspect it's a difficult job to set up and maintain
Transactional Replication, but I may give it a try.
Regards.
SezginHi
You may want to use replication if you don't want medium/high latency on
updating your data, but if you can copy with a longer difference between the
data in your reporting database and the live system check out log shipping.
There was a couple of articles on this in SQL Server Professional Magazine
http://tinyurl.com/4ez3l
http://tinyurl.com/6rdth
You may also want to check out the simple log shipping solution in the
resource kit.
John
"Sezgin Rafet" wrote:

> Hi,
> We are using a live database and want to set up a Reporting Server(Read-On
ly
> for Users) for processing queries.
> Is there any 3rd party software producing the effect
> of Transactional Replication, being easy to set up and maintain ?
> Any links to good step by step guides for Transactional Replication will
> also be appreciated. I suspect it's a difficult job to set up and maintain
> Transactional Replication, but I may give it a try.
>
> Regards.
> Sezgin
>
>|||Thanks for the reply.
I did a short research on the Internet.
3 products attracted my attention:
DoubleTake from NSI Software
SonaSafe for SQL Server from Sonasoft
WANSync / WANSyncHA from XOsoft
Any comments on these products from people who have used them will be
appreciated.
Regards.
Sezgin
"John Bell" <jbellnewsposts@.hotmail.com> wrote in message
news:E352112A-4412-43A6-86A3-3EB0F4F6DCC6@.microsoft.com...[vbcol=seagreen]
> Hi
> You may want to use replication if you don't want medium/high latency on
> updating your data, but if you can copy with a longer difference between
> the
> data in your reporting database and the live system check out log
> shipping.
> There was a couple of articles on this in SQL Server Professional Magazine
> http://tinyurl.com/4ez3l
> http://tinyurl.com/6rdth
> You may also want to check out the simple log shipping solution in the
> resource kit.
> John
> "Sezgin Rafet" wrote:
>|||You should also look at Neverfail (www.neverfailgroup.com) I used this
in a previous company and seemed to work for us for SQL and their
Exchange product kicks A**
Pete
Sezgin Rafet wrote:[vbcol=seagreen]
> Thanks for the reply.
> I did a short research on the Internet.
> 3 products attracted my attention:
> DoubleTake from NSI Software
> SonaSafe for SQL Server from Sonasoft
> WANSync / WANSyncHA from XOsoft
>
> Any comments on these products from people who have used them will be
> appreciated.
>
> Regards.
> Sezgin
>
> "John Bell" <jbellnewsposts@.hotmail.com> wrote in message
> news:E352112A-4412-43A6-86A3-3EB0F4F6DCC6@.microsoft.com...|||Hi
I have not tried any of the third party applications but the no cost option
would be to use what is in the Resource Kit or use the method described by
SQL Server Pro. With SQL 2005 you will get database mirroring.
John
"Sezgin Rafet" wrote:

> Thanks for the reply.
> I did a short research on the Internet.
> 3 products attracted my attention:
> DoubleTake from NSI Software
> SonaSafe for SQL Server from Sonasoft
> WANSync / WANSyncHA from XOsoft
>
> Any comments on these products from people who have used them will be
> appreciated.
>
> Regards.
> Sezgin
>
> "John Bell" <jbellnewsposts@.hotmail.com> wrote in message
> news:E352112A-4412-43A6-86A3-3EB0F4F6DCC6@.microsoft.com...
>
>

Reporting Server.

Hi,
We are using a live database and want to set up a Reporting Server(Read-Only
for Users) for processing queries.
Is there any 3rd party software producing the effect
of Transactional Replication, being easy to set up and maintain ?
Any links to good step by step guides for Transactional Replication will
also be appreciated. I suspect it's a difficult job to set up and maintain
Transactional Replication, but I may give it a try.
Regards.
SezginHi
You may want to use replication if you don't want medium/high latency on
updating your data, but if you can copy with a longer difference between the
data in your reporting database and the live system check out log shipping.
There was a couple of articles on this in SQL Server Professional Magazine
http://tinyurl.com/4ez3l
http://tinyurl.com/6rdth
You may also want to check out the simple log shipping solution in the
resource kit.
John
"Sezgin Rafet" wrote:
> Hi,
> We are using a live database and want to set up a Reporting Server(Read-Only
> for Users) for processing queries.
> Is there any 3rd party software producing the effect
> of Transactional Replication, being easy to set up and maintain ?
> Any links to good step by step guides for Transactional Replication will
> also be appreciated. I suspect it's a difficult job to set up and maintain
> Transactional Replication, but I may give it a try.
>
> Regards.
> Sezgin
>
>|||Thanks for the reply.
I did a short research on the Internet.
3 products attracted my attention:
DoubleTake from NSI Software
SonaSafe for SQL Server from Sonasoft
WANSync / WANSyncHA from XOsoft
Any comments on these products from people who have used them will be
appreciated.
Regards.
Sezgin
"John Bell" <jbellnewsposts@.hotmail.com> wrote in message
news:E352112A-4412-43A6-86A3-3EB0F4F6DCC6@.microsoft.com...
> Hi
> You may want to use replication if you don't want medium/high latency on
> updating your data, but if you can copy with a longer difference between
> the
> data in your reporting database and the live system check out log
> shipping.
> There was a couple of articles on this in SQL Server Professional Magazine
> http://tinyurl.com/4ez3l
> http://tinyurl.com/6rdth
> You may also want to check out the simple log shipping solution in the
> resource kit.
> John
> "Sezgin Rafet" wrote:
>> Hi,
>> We are using a live database and want to set up a Reporting
>> Server(Read-Only
>> for Users) for processing queries.
>> Is there any 3rd party software producing the effect
>> of Transactional Replication, being easy to set up and maintain ?
>> Any links to good step by step guides for Transactional Replication will
>> also be appreciated. I suspect it's a difficult job to set up and
>> maintain
>> Transactional Replication, but I may give it a try.
>>
>> Regards.
>> Sezgin
>>|||You should also look at Neverfail (www.neverfailgroup.com) I used this
in a previous company and seemed to work for us for SQL and their
Exchange product kicks A**
Pete
Sezgin Rafet wrote:
> Thanks for the reply.
> I did a short research on the Internet.
> 3 products attracted my attention:
> DoubleTake from NSI Software
> SonaSafe for SQL Server from Sonasoft
> WANSync / WANSyncHA from XOsoft
>
> Any comments on these products from people who have used them will be
> appreciated.
>
> Regards.
> Sezgin
>
> "John Bell" <jbellnewsposts@.hotmail.com> wrote in message
> news:E352112A-4412-43A6-86A3-3EB0F4F6DCC6@.microsoft.com...
> > Hi
> >
> > You may want to use replication if you don't want medium/high latency on
> > updating your data, but if you can copy with a longer difference between
> > the
> > data in your reporting database and the live system check out log
> > shipping.
> >
> > There was a couple of articles on this in SQL Server Professional Magazine
> > http://tinyurl.com/4ez3l
> > http://tinyurl.com/6rdth
> >
> > You may also want to check out the simple log shipping solution in the
> > resource kit.
> >
> > John
> >
> > "Sezgin Rafet" wrote:
> >
> >>
> >> Hi,
> >>
> >> We are using a live database and want to set up a Reporting
> >> Server(Read-Only
> >> for Users) for processing queries.
> >>
> >> Is there any 3rd party software producing the effect
> >> of Transactional Replication, being easy to set up and maintain ?
> >>
> >> Any links to good step by step guides for Transactional Replication will
> >> also be appreciated. I suspect it's a difficult job to set up and
> >> maintain
> >> Transactional Replication, but I may give it a try.
> >>
> >>
> >> Regards.
> >>
> >> Sezgin
> >>
> >>
> >>|||Hi
I have not tried any of the third party applications but the no cost option
would be to use what is in the Resource Kit or use the method described by
SQL Server Pro. With SQL 2005 you will get database mirroring.
John
"Sezgin Rafet" wrote:
> Thanks for the reply.
> I did a short research on the Internet.
> 3 products attracted my attention:
> DoubleTake from NSI Software
> SonaSafe for SQL Server from Sonasoft
> WANSync / WANSyncHA from XOsoft
>
> Any comments on these products from people who have used them will be
> appreciated.
>
> Regards.
> Sezgin
>
> "John Bell" <jbellnewsposts@.hotmail.com> wrote in message
> news:E352112A-4412-43A6-86A3-3EB0F4F6DCC6@.microsoft.com...
> > Hi
> >
> > You may want to use replication if you don't want medium/high latency on
> > updating your data, but if you can copy with a longer difference between
> > the
> > data in your reporting database and the live system check out log
> > shipping.
> >
> > There was a couple of articles on this in SQL Server Professional Magazine
> > http://tinyurl.com/4ez3l
> > http://tinyurl.com/6rdth
> >
> > You may also want to check out the simple log shipping solution in the
> > resource kit.
> >
> > John
> >
> > "Sezgin Rafet" wrote:
> >
> >>
> >> Hi,
> >>
> >> We are using a live database and want to set up a Reporting
> >> Server(Read-Only
> >> for Users) for processing queries.
> >>
> >> Is there any 3rd party software producing the effect
> >> of Transactional Replication, being easy to set up and maintain ?
> >>
> >> Any links to good step by step guides for Transactional Replication will
> >> also be appreciated. I suspect it's a difficult job to set up and
> >> maintain
> >> Transactional Replication, but I may give it a try.
> >>
> >>
> >> Regards.
> >>
> >> Sezgin
> >>
> >>
> >>
>
>

Reporting server and Active directory authentication

Hi!
Does anybody know how one can prevent users from accessing some
reports on the report server website using active directory? I have an
active directory with all the users and I would like to use this to
enable / disable users from viewing and accessing reports.
Cheers ErikOn Jan 30, 1:12 am, e...@.liffner.se wrote:
> Hi!
> Does anybody know how one can prevent users from accessing some
> reports on the report server website using active directory? I have an
> active directory with all the users and I would like to use this to
> enable / disable users from viewing and accessing reports.
> Cheers Erik
Hi Erik,
You should be able to set up securtiy via the report manager website.
Permissions can be set for folders or individually for reports. If
you look at the properties and go to the security tab, you will see
the users who have permission to access the object. To start with, you
should see the user 'BUILTIN\Administrators' as Content Manager.
Here you can add new users with different roles, or create you own
roles.
Is that what you are looking for?
Rowen

reporting package for sql

Howdy all. I just started a new job and am suddenly having to write queries
for users on the fly and put the results into Excel. I was thinking about
denormalizing the db(although there isn't really much normalization now)
into just a few tables that users would be able to understand and be able to
query for themselves. Then have some great tool that would be able to do
queries and export to Excel. Perhaps using drag and drop, check boxes, etc.
Is there such a tool already for SQL?
TIA, Chris
If you need reporting capabilities I would suggest you look into the new
reporting services for SQL Server.
http://www.microsoft.com/sql/reporting/default.asp
Andrew J. Kelly SQL MVP
"chris" <chris@.noemail.com> wrote in message
news:uA0XQgyHEHA.348@.tk2msftngp13.phx.gbl...
> Howdy all. I just started a new job and am suddenly having to write
queries
> for users on the fly and put the results into Excel. I was thinking about
> denormalizing the db(although there isn't really much normalization now)
> into just a few tables that users would be able to understand and be able
to
> query for themselves. Then have some great tool that would be able to do
> queries and export to Excel. Perhaps using drag and drop, check boxes,
etc.
> Is there such a tool already for SQL?
> TIA, Chris
>
|||IMHO, the *LAST* thing you want to do is open up the database so your
employees can have a free-for-all.
Aaron Bertrand
SQL Server MVP
http://www.aspfaq.com/
"chris" <chris@.noemail.com> wrote in message
news:uA0XQgyHEHA.348@.tk2msftngp13.phx.gbl...
> Howdy all. I just started a new job and am suddenly having to write
> queries
> for users on the fly and put the results into Excel. I was thinking about
> denormalizing the db(although there isn't really much normalization now)
> into just a few tables that users would be able to understand and be able
> to
> query for themselves. Then have some great tool that would be able to do
> queries and export to Excel. Perhaps using drag and drop, check boxes,
> etc.
> Is there such a tool already for SQL?
> TIA, Chris
>
|||Thats why I would do it on a reporting only, denormalized db.
"Aaron Bertrand [MVP]" <aaron@.TRASHaspfaq.com> wrote in message
news:#ovEUy2HEHA.3432@.tk2msftngp13.phx.gbl...
> IMHO, the *LAST* thing you want to do is open up the database so your
> employees can have a free-for-all.
> --
> Aaron Bertrand
> SQL Server MVP
> http://www.aspfaq.com/
>
> "chris" <chris@.noemail.com> wrote in message
> news:uA0XQgyHEHA.348@.tk2msftngp13.phx.gbl...
about
able
>

reporting package for sql

Howdy all. I just started a new job and am suddenly having to write queries
for users on the fly and put the results into Excel. I was thinking about
denormalizing the db(although there isn't really much normalization now)
into just a few tables that users would be able to understand and be able to
query for themselves. Then have some great tool that would be able to do
queries and export to Excel. Perhaps using drag and drop, check boxes, etc.
Is there such a tool already for SQL?
TIA, ChrisIf you need reporting capabilities I would suggest you look into the new
reporting services for SQL Server.
http://www.microsoft.com/sql/reporting/default.asp
--
Andrew J. Kelly SQL MVP
"chris" <chris@.noemail.com> wrote in message
news:uA0XQgyHEHA.348@.tk2msftngp13.phx.gbl...
> Howdy all. I just started a new job and am suddenly having to write
queries
> for users on the fly and put the results into Excel. I was thinking about
> denormalizing the db(although there isn't really much normalization now)
> into just a few tables that users would be able to understand and be able
to
> query for themselves. Then have some great tool that would be able to do
> queries and export to Excel. Perhaps using drag and drop, check boxes,
etc.
> Is there such a tool already for SQL?
> TIA, Chris
>|||IMHO, the *LAST* thing you want to do is open up the database so your
employees can have a free-for-all.
--
Aaron Bertrand
SQL Server MVP
http://www.aspfaq.com/
"chris" <chris@.noemail.com> wrote in message
news:uA0XQgyHEHA.348@.tk2msftngp13.phx.gbl...
> Howdy all. I just started a new job and am suddenly having to write
> queries
> for users on the fly and put the results into Excel. I was thinking about
> denormalizing the db(although there isn't really much normalization now)
> into just a few tables that users would be able to understand and be able
> to
> query for themselves. Then have some great tool that would be able to do
> queries and export to Excel. Perhaps using drag and drop, check boxes,
> etc.
> Is there such a tool already for SQL?
> TIA, Chris
>|||Thats why I would do it on a reporting only, denormalized db.
"Aaron Bertrand [MVP]" <aaron@.TRASHaspfaq.com> wrote in message
news:#ovEUy2HEHA.3432@.tk2msftngp13.phx.gbl...
> IMHO, the *LAST* thing you want to do is open up the database so your
> employees can have a free-for-all.
> --
> Aaron Bertrand
> SQL Server MVP
> http://www.aspfaq.com/
>
> "chris" <chris@.noemail.com> wrote in message
> news:uA0XQgyHEHA.348@.tk2msftngp13.phx.gbl...
> > Howdy all. I just started a new job and am suddenly having to write
> > queries
> > for users on the fly and put the results into Excel. I was thinking
about
> > denormalizing the db(although there isn't really much normalization now)
> > into just a few tables that users would be able to understand and be
able
> > to
> > query for themselves. Then have some great tool that would be able to do
> > queries and export to Excel. Perhaps using drag and drop, check boxes,
> > etc.
> > Is there such a tool already for SQL?
> >
> > TIA, Chris
> >
> >
>

reporting package for sql

Howdy all. I just started a new job and am suddenly having to write queries
for users on the fly and put the results into Excel. I was thinking about
denormalizing the db(although there isn't really much normalization now)
into just a few tables that users would be able to understand and be able to
query for themselves. Then have some great tool that would be able to do
queries and export to Excel. Perhaps using drag and drop, check boxes, etc.
Is there such a tool already for SQL?
TIA, ChrisIf you need reporting capabilities I would suggest you look into the new
reporting services for SQL Server.
http://www.microsoft.com/sql/reporting/default.asp
Andrew J. Kelly SQL MVP
"chris" <chris@.noemail.com> wrote in message
news:uA0XQgyHEHA.348@.tk2msftngp13.phx.gbl...
> Howdy all. I just started a new job and am suddenly having to write
queries
> for users on the fly and put the results into Excel. I was thinking about
> denormalizing the db(although there isn't really much normalization now)
> into just a few tables that users would be able to understand and be able
to
> query for themselves. Then have some great tool that would be able to do
> queries and export to Excel. Perhaps using drag and drop, check boxes,
etc.
> Is there such a tool already for SQL?
> TIA, Chris
>|||IMHO, the *LAST* thing you want to do is open up the database so your
employees can have a free-for-all.
Aaron Bertrand
SQL Server MVP
http://www.aspfaq.com/
"chris" <chris@.noemail.com> wrote in message
news:uA0XQgyHEHA.348@.tk2msftngp13.phx.gbl...
> Howdy all. I just started a new job and am suddenly having to write
> queries
> for users on the fly and put the results into Excel. I was thinking about
> denormalizing the db(although there isn't really much normalization now)
> into just a few tables that users would be able to understand and be able
> to
> query for themselves. Then have some great tool that would be able to do
> queries and export to Excel. Perhaps using drag and drop, check boxes,
> etc.
> Is there such a tool already for SQL?
> TIA, Chris
>|||Thats why I would do it on a reporting only, denormalized db.
"Aaron Bertrand [MVP]" <aaron@.TRASHaspfaq.com> wrote in message
news:#ovEUy2HEHA.3432@.tk2msftngp13.phx.gbl...
> IMHO, the *LAST* thing you want to do is open up the database so your
> employees can have a free-for-all.
> --
> Aaron Bertrand
> SQL Server MVP
> http://www.aspfaq.com/
>
> "chris" <chris@.noemail.com> wrote in message
> news:uA0XQgyHEHA.348@.tk2msftngp13.phx.gbl...
about
able
>