Anyone producing a large number of reports per day?

I'm evaluting Reporting Services for my client. They need to produce 5000+
reports per day, mainly output in PDF format. The PDF's are 6-8 pages long.
Does anyone have any experience of getting this kind of performance out of
SQL-RS?
They have an 8-processor 2.8Ghz server running SQL Server that will be the
Reporting Services server. It has 4gig of memory. Will it be up to the job?
Thanks,
Andy.I am able to render about 70reports (PDF format) in less than 10mins. Each
report has about 200 pages.
"Andy Smith" wrote:
> I'm evaluting Reporting Services for my client. They need to produce 5000+
> reports per day, mainly output in PDF format. The PDF's are 6-8 pages long.
> Does anyone have any experience of getting this kind of performance out of
> SQL-RS?
> They have an 8-processor 2.8Ghz server running SQL Server that will be the
> Reporting Services server. It has 4gig of memory. Will it be up to the job?
> Thanks,
> Andy.|||Don't forget to set boot.ini to use /3GB switch in order to take advantage
of the memory.
To verify RS can handle this load, consider using a test tool like
Application Center Test (ACT), part of Visual Studio, to run a Proof Of
Concept. Below is sample ACT script you might use to run such a test:
' --
CONSTANTS --
const ENABLE_DELAYS = True
const REQUESTBUFFERSIZE = 15000
const REPORTSERVERNAME = "localhost"
' --
' -- Think time variables - examples shows between 2-3 seconds
' --
const MIN_SLEEP_MSEC = 2000
const MAX_SLEEP_MSEC = 3000
' --
' -- Think time logic if desired
' --
Function RandomSleep()
if (NOT ENABLE_DELAYS) then
RandomSleep = 0
return
end if
Dim lMinSleep, lMaxSleep, lSleep
lMaxSleep = MAX_SLEEP_MSEC
lMinSleep = MIN_SLEEP_MSEC
' create a random int within our range
Call Randomize()
lSleep = Int((lMaxSleep - lMinSleep + 1) * Rnd(1) + lMinSleep)
' Test.Trace "Sleeping: " + Cstr(lSleep)
Call Test.Sleep(lSleep)
' return the delay time
RandomSleep = lSleep
End Function
Function SendGetRequest(reportServerUrl)
Dim oConnection, oRequest, oResponse, oHeaders, statusCode
Set oConnection = Test.CreateConnection(REPORTSERVERNAME, 80, false)
If (oConnection is Nothing) Then
Test.Trace "Error: Unable to create connection to server"
Else
' TODO: uncomment this after debugging
' Test.Trace(reportServerUrl)
Set oRequest = Test.CreateRequest
oRequest.ResponseBufferSize = REQUESTBUFFERSIZE
oRequest.Path = reportServerUrl
oRequest.Verb = "GET"
oRequest.HTTPVersion = "HTTP/1.1"
set oHeaders = oRequest.Headers
oHeaders.RemoveAll
oHeaders.Add "Accept", "image/gif, image/x-xbitmap, image/jpeg,
image/pjpeg, application/vnd.ms-excel, application/vnd.ms-powerpoint,
application/msword, */*"
oHeaders.Add "Accept-Language", "en-us"
oHeaders.Add "User-Agent", "Mozilla/4.0 (compatible; MSIE 6.0;
Windows NT 5.1; .NET CLR 1.0.3512; .NET CLR 1.1.4322)"
oHeaders.Add "Host", "(automatic)"
oHeaders.Add "Cookie", "(automatic)"
Set oResponse = oConnection.Send(oRequest)
If (oResponse is Nothing) Then
Test.Trace "Error: Failed to receive response for URL to " +
reportServerUrl
Else
statusCode = oResponse.ResultCode
'DEBUG
Test.Trace "Received: " + CStr(statusCode) + " for: " + REPORTSERVERNAME
+ reportServerUrl
' delay in case of errors - to avoid the snowball effect
' Test.Trace "Response code of: " + CStr(statusCode) + "
recieved for " + reportServerUrl
if (statusCode = 503) Then
Test.Trace "Server too busy error: " + CStr(statusCode) + "
recieved for " + reportServerUrl + " - Process Put To Sleep"
End If
End If
oConnection.Close
End If
End Function
Sub Main()
Dim Url
'--
'-- URL of report to call for test. This one calls report named "Simple"
located in dir /Benchmark
'-- passing in a parm of &RowNumber '--
Url ="/ReportServer?/Benchmark/Simple&RowNumber=20&rs:Command=Render&rc:Toolbar=false&rs:Format=PDF"
SendGetRequest(Url)
RandomSleep()
End Sub
Main
--
-- "This posting is provided 'AS IS' with no warranties, and confers no
rights."
jhmiller@.online.microsoft.com
"Raj Chandra" <RajChandra@.discussions.microsoft.com> wrote in message
news:C23DE604-F4E0-4F3E-BD7B-1C4516C1987C@.microsoft.com...
>I am able to render about 70reports (PDF format) in less than 10mins. Each
> report has about 200 pages.
> "Andy Smith" wrote:
>> I'm evaluting Reporting Services for my client. They need to produce
>> 5000+
>> reports per day, mainly output in PDF format. The PDF's are 6-8 pages
>> long.
>> Does anyone have any experience of getting this kind of performance out
>> of
>> SQL-RS?
>> They have an 8-processor 2.8Ghz server running SQL Server that will be
>> the
>> Reporting Services server. It has 4gig of memory. Will it be up to the
>> job?
>> Thanks,
>> Andy.sql

Anyone know if lineheight property works?

A client I'm producing several reports for wants the spacing between the
lines of text to be less and I haven't any ideas other than this property to
get it to happen.
Any suggestions would be AWESOME!
Thanks,
DiaDia
I use tables alot and the height property works very well in a table. You
can also adjust the distance between rows with the padding property.
"Dia" wrote:
> A client I'm producing several reports for wants the spacing between the
> lines of text to be less and I haven't any ideas other than this property to
> get it to happen.
> Any suggestions would be AWESOME!
> Thanks,
> Dia

Anyone have reports on Reports? (Things that go beyond the samples

Hi all,
I'd like to get a report on the reports that are deployed.
It would tell me things like this:
Report Name
DataSourceName
Connection String
Stored Procedures Called
Views/Tables Used (Probably can't be
shown if its calling a stored procedure)
Modified date
Modified Last by
Folder it is stored under in Report
ManagerFolder it is stored under in Report Manager (this is in the samples)
Last Run By
Last Run Date
Can this be done? Does anyone have it?
Are there any user created updates or changes to the samples that MSFT has
written?
KeithOn Jul 25, 1:32 pm, greenmtnsun
<greenmtn...@.discussions.microsoft.com> wrote:
> Hi all,
> I'd like to get a report on the reports that are deployed.
> It would tell me things like this:
> Report Name
> DataSourceName
> Connection String
> Stored Procedures Called
> Views/Tables Used (Probably can't be
> shown if its calling a stored procedure)
> Modified date
> Modified Last by
> Folder it is stored under in Report
> ManagerFolder it is stored under in Report Manager (this is in the samples)
> Last Run By
> Last Run Date
> Can this be done? Does anyone have it?
> Are there any user created updates or changes to the samples that MSFT has
> written?
> Keith
There are two useful tables under a database named
"ReportServer" (this is where the report server stuff is stored, like
history). Catalog and ExecutionLog are the tables and they can be
joined at reportid (execution log) and itemid (catalog). That way you
can pull the names of the report users, reports, and other fun stuff.
There are also some other valuable tables in that database, but I
don't use them that much.|||You are not supposed to access reporting services' database directly
(although you can with appropriate permission). Reporting services provides
web services to get the information the OP wants. reporting services' report
mamaner is an ggod example of an application consuming the web services to
get that kind of information. I believe the OP does not need to know more
information that report manager can show.
"Ayman" <aymantg@.gmail.com> wrote in message
news:1185386825.627743.70110@.q75g2000hsh.googlegroups.com...
> On Jul 25, 1:32 pm, greenmtnsun
> <greenmtn...@.discussions.microsoft.com> wrote:
>> Hi all,
>> I'd like to get a report on the reports that are deployed.
>> It would tell me things like this:
>> Report Name
>> DataSourceName
>> Connection String
>> Stored Procedures Called
>> Views/Tables Used (Probably can't be
>> shown if its calling a stored procedure)
>> Modified date
>> Modified Last by
>> Folder it is stored under in Report
>> ManagerFolder it is stored under in Report Manager (this is in the
>> samples)
>> Last Run By
>> Last Run Date
>> Can this be done? Does anyone have it?
>> Are there any user created updates or changes to the samples that MSFT
>> has
>> written?
>> Keith
> There are two useful tables under a database named
> "ReportServer" (this is where the report server stuff is stored, like
> history). Catalog and ExecutionLog are the tables and they can be
> joined at reportid (execution log) and itemid (catalog). That way you
> can pull the names of the report users, reports, and other fun stuff.
> There are also some other valuable tables in that database, but I
> don't use them that much.
>|||On Jul 25, 1:32 pm, greenmtnsun
<greenmtn...@.discussions.microsoft.com> wrote:
> Hi all,
> I'd like to get a report on the reports that are deployed.
> It would tell me things like this:
> Report Name
> DataSourceName
> Connection String
> Stored Procedures Called
> Views/Tables Used (Probably can't be
> shown if its calling a stored procedure)
> Modified date
> Modified Last by
> Folder it is stored under in Report
> ManagerFolder it is stored under in Report Manager (this is in the samples)
> Last Run By
> Last Run Date
> Can this be done? Does anyone have it?
> Are there any user created updates or changes to the samples that MSFT has
> written?
> Keith
If you have access to those databases, you can make your own custom
reports to show whatever you want. I have one set up to show
executions per user and which reports they executed. Others include,
most recent executions, total executions per report, etc. There is
much you can do in terms of custom reporting if you use the
ReportServer database that is created by default by SSRS.|||I have all the permissions I could ever need. If not, I'll give me them! :-)
Could you by chance share these reports you spoke of? My e-mail address is
keith underscore m underscore ramsey at yahoo dot com
I don't know if spam bots can get this address so I messed with it. _ is an
underscore. LOL.
I'd really appreciate it. They can show me how to get other peices of
information.
One thing I got frusted about was that at first blush I couldn't get an ID
number for a report to link from the RSExecutionLog to the RS databases. I
think the RSExecutionLog uses its own ID system. I hope I'm wrong. I also
don't know how they break out the connection string from things that are
encrypted.
"Ayman" wrote:
> On Jul 25, 1:32 pm, greenmtnsun
> <greenmtn...@.discussions.microsoft.com> wrote:
> > Hi all,
> >
> > I'd like to get a report on the reports that are deployed.
> >
> > It would tell me things like this:
> >
> > Report Name
> >
> > DataSourceName
> >
> > Connection String
> >
> > Stored Procedures Called
> >
> > Views/Tables Used (Probably can't be
> > shown if its calling a stored procedure)
> >
> > Modified date
> >
> > Modified Last by
> >
> > Folder it is stored under in Report
> > ManagerFolder it is stored under in Report Manager (this is in the samples)
> >
> > Last Run By
> >
> > Last Run Date
> >
> > Can this be done? Does anyone have it?
> >
> > Are there any user created updates or changes to the samples that MSFT has
> > written?
> >
> > Keith
> If you have access to those databases, you can make your own custom
> reports to show whatever you want. I have one set up to show
> executions per user and which reports they executed. Others include,
> most recent executions, total executions per report, etc. There is
> much you can do in terms of custom reporting if you use the
> ReportServer database that is created by default by SSRS.
>|||On Jul 26, 11:54 am, greenmtnsun
<greenmtn...@.discussions.microsoft.com> wrote:
> I have all the permissions I could ever need. If not, I'll give me them! :-)
> Could you by chance share these reports you spoke of? My e-mail address is
> keith underscore m underscore ramsey at yahoo dot com
> I don't know if spam bots can get this address so I messed with it. _ is an
> underscore. LOL.
> I'd really appreciate it. They can show me how to get other peices of
> information.
> One thing I got frusted about was that at first blush I couldn't get an ID
> number for a report to link from the RSExecutionLog to the RS databases. I
> think the RSExecutionLog uses its own ID system. I hope I'm wrong. I also
> don't know how they break out the connection string from things that are
> encrypted."Ayman" wrote:
> > On Jul 25, 1:32 pm, greenmtnsun
> > <greenmtn...@.discussions.microsoft.com> wrote:
> > > Hi all,
> > > I'd like to get a report on the reports that are deployed.
> > > It would tell me things like this:
> > > Report Name
> > > DataSourceName
> > > Connection String
> > > Stored Procedures Called
> > > Views/Tables Used (Probably can't be
> > > shown if its calling a stored procedure)
> > > Modified date
> > > Modified Last by
> > > Folder it is stored under in Report
> > > ManagerFolder it is stored under in Report Manager (this is in the samples)
> > > Last Run By
> > > Last Run Date
> > > Can this be done? Does anyone have it?
> > > Are there any user created updates or changes to the samples that MSFT has
> > > written?
> > > Keith
> > If you have access to those databases, you can make your own custom
> > reports to show whatever you want. I have one set up to show
> > executions per user and which reports they executed. Others include,
> > most recent executions, total executions per report, etc. There is
> > much you can do in terms of custom reporting if you use the
> > ReportServer database that is created by default by SSRS.
Here are the generic ones you can use. I posted them here to everyone
will benefit.
--Detailed
select el.username,c.name,el.timestart,el.timeend
executionlog el join
catalog c on el.reportid=c.itemid
order by timestart desc
--Reports used by user
select el.username,c.name, count(1)
from executionlog el join
catalog c on el.reportid=c.itemid
group by el.username,c.name
order by el.username,c.name
--Usage by Report
select c.name, count(1)
from executionlog el join
catalog c on el.reportid=c.itemid
group by c.name
order by count(1) desc
--Recent usages per user per report
select el.username,c.name,el.timestart,el.timeend
from executionlog el join
catalog c on el.reportid=c.itemid
where username =''INSERT IT HERE'
order by timestart desc
Hope that helps! You can put them in a report if you don't like to
see them in SSMS. By the way, it's a good way to track who has been
using the reports you developed for them! You last name sounds
Egyptian by the way.|||Thank you.
For the record, I am still looking for these to place in a report about
reports...
Connection String
Stored Procedures Called
Views/Tables Used (Probably can't be
shown if its calling a stored procedure)
Modified date
Modified Last by
"Ayman" wrote:
> On Jul 26, 11:54 am, greenmtnsun
> <greenmtn...@.discussions.microsoft.com> wrote:
> > I have all the permissions I could ever need. If not, I'll give me them! :-)
> >
> > Could you by chance share these reports you spoke of? My e-mail address is
> > keith underscore m underscore ramsey at yahoo dot com
> >
> > I don't know if spam bots can get this address so I messed with it. _ is an
> > underscore. LOL.
> >
> > I'd really appreciate it. They can show me how to get other peices of
> > information.
> >
> > One thing I got frusted about was that at first blush I couldn't get an ID
> > number for a report to link from the RSExecutionLog to the RS databases. I
> > think the RSExecutionLog uses its own ID system. I hope I'm wrong. I also
> > don't know how they break out the connection string from things that are
> > encrypted."Ayman" wrote:
> > > On Jul 25, 1:32 pm, greenmtnsun
> > > <greenmtn...@.discussions.microsoft.com> wrote:
> > > > Hi all,
> >
> > > > I'd like to get a report on the reports that are deployed.
> >
> > > > It would tell me things like this:
> >
> > > > Report Name
> >
> > > > DataSourceName
> >
> > > > Connection String
> >
> > > > Stored Procedures Called
> >
> > > > Views/Tables Used (Probably can't be
> > > > shown if its calling a stored procedure)
> >
> > > > Modified date
> >
> > > > Modified Last by
> >
> > > > Folder it is stored under in Report
> > > > ManagerFolder it is stored under in Report Manager (this is in the samples)
> >
> > > > Last Run By
> >
> > > > Last Run Date
> >
> > > > Can this be done? Does anyone have it?
> >
> > > > Are there any user created updates or changes to the samples that MSFT has
> > > > written?
> >
> > > > Keith
> >
> > > If you have access to those databases, you can make your own custom
> > > reports to show whatever you want. I have one set up to show
> > > executions per user and which reports they executed. Others include,
> > > most recent executions, total executions per report, etc. There is
> > > much you can do in terms of custom reporting if you use the
> > > ReportServer database that is created by default by SSRS.
> Here are the generic ones you can use. I posted them here to everyone
> will benefit.
> --Detailed
> select el.username,c.name,el.timestart,el.timeend
> executionlog el join
> catalog c on el.reportid=c.itemid
> order by timestart desc
> --Reports used by user
> select el.username,c.name, count(1)
> from executionlog el join
> catalog c on el.reportid=c.itemid
> group by el.username,c.name
> order by el.username,c.name
> --Usage by Report
> select c.name, count(1)
> from executionlog el join
> catalog c on el.reportid=c.itemid
> group by c.name
> order by count(1) desc
> --Recent usages per user per report
> select el.username,c.name,el.timestart,el.timeend
> from executionlog el join
> catalog c on el.reportid=c.itemid
> where username =''INSERT IT HERE'
> order by timestart desc
>
> Hope that helps! You can put them in a report if you don't like to
> see them in SSMS. By the way, it's a good way to track who has been
> using the reports you developed for them! You last name sounds
> Egyptian by the way.
>|||Since we're already into things you aren't supposed to do -
If you have a lot of reports and report execution records, look at the
indexing on the execution log file - by default, I don't think the
report ID is indexed (which seems odd, since it acts as a foreign key
to the catalog table...)

Anybody use the WinForms ReportViewer?

My issue is one-click printing using a programmed format. For example
I have reports that print landscape on legal paper.
I have not been able to do this from the web environment, and I'm
hoping that the WinForm ReportViewer control will allow me.
It should be simple enough to try this, but if anyone has done this yet
I would be happy to know.
JimI'm using it, and have a few reports working. However, I am now beating my
head against a wall trying to get a more complex label-printing program
going...
Walt Crosby
Walt.Crosby@.everydaywireless.com
<jhcorey@.yahoo.com> wrote in message
news:1139344808.488092.292340@.f14g2000cwb.googlegroups.com...
> My issue is one-click printing using a programmed format. For example
> I have reports that print landscape on legal paper.
> I have not been able to do this from the web environment, and I'm
> hoping that the WinForm ReportViewer control will allow me.
> It should be simple enough to try this, but if anyone has done this yet
> I would be happy to know.
> Jim
>

Anybody ever use Actuate e.Reports?

I have an interview tomorrow for a dba position and they make frequent mention of this Actuate e.Report stuff and it looks like Crystal Reports from the web site. Any opinions? Is it garbage? Should I run and hide or chase and embrace? If its crap, I can blow this off. I have a few more things cooking.Yes, I used Actuate e.report before. Similar to Crystal Report, you can design your own e report for the internet. Nothing special, same design and running same sql scripting. Nothing special to me.|||We use Actuate at my work. I'm just an intermediate developer myself, but some of the reports developed by our central IT folks are just incredible. It seems to be very powerful, but kind of a pain to learn.

Any tool to convert Cognos reports to SSRS?

Hi. We've got hundreds of Cognos reports and catalogs and we'd like to convert them to SSRS reports and models. Is there a tool to do this? We're converting our reporting to SSRS and need help. Thanks.I have not came across any tool to convert Cognos Catalog into SSRS Model.
We have to do it manually.
Although there is a tool from Cognos to convert Impromptu Catalog to Cognos ReportNet Model.

Nikul

Any tool to convert Cognos reports to SSRS?

Hi. We've got hundreds of Cognos reports and catalogs and we'd like to convert them to SSRS reports and models. Is there a tool to do this? We're converting our reporting to SSRS and need help. Thanks.I have not came across any tool to convert Cognos Catalog into SSRS Model.
We have to do it manually.
Although there is a tool from Cognos to convert Impromptu Catalog to Cognos ReportNet Model.

Nikul

Any tips for using large parameter lists

Our parts table has 5k records. I want to use part number as a parameter for one of my reports. Is there a way to do this and have the report generate in a reasonable amount of time?

Thanks

Create a new dataset on the Data tab with the query as "SELECT part_number from Parts" and name the dataset as, say DataSet2.

Go to Report (menu) -> Report Parameters

and add a new parameter and give the name, type and prompt.

Then under Available Values, select "From Query" radio button

select DataSet2 under Dataset, part_number under Value field

Shyam

|||Thats the problem.
It takes five minutes for the param list to render.|||

Maybe you can reduce the query time on SQL server by adding index (clustered preferably) to part_number column. This is the only solution to reduce the load time.

Shyam

Any Reporting Service Log experts out there?

We are working on developing some statistical reports to help us to better
undertand how our users are (or are not) leveraging our Reporting Services
implementation. We have been writing execution log data to a database based
on the Msft provided SSIS package that pulls data from the Report Server
database and I've discovered a hole in the information that I'm hoping
someone can help me fix.
We use data drive subscriptions pretty heavily which of course require
cached data credentials. In the "ExecutionLogs" table, these entries appear
as being requested by "System" and the user shows our proxy account. If you
review the "ReportServerService_..." log on the report server, you can see
the actual detail surrounding the processing of the subscription, but I can't
find a way to correlate these entries back to the ExecutionLog table. The
"ExecutionLogId" in the ExecutionLog table doesn't reference any of the
uniqueidentifiers that you see in the text ReportServerService log.
My end goal is to be able to update the User column in the ExecutionLog
table with the user who was the actual recipient of the report as identified
in the ReportServerService log file.
Anyone tackle this yet or have any ideas as to how it might be accomplished?I'll give you a big hint.. :)
Remember, you are not limited to just select statements in your datasets for
your reports.
I have a dataset that does INSERTS for my data driven reports... (since it
is data driven, you KNOW who the users are that are going to get the
reports)
cheers!
=-Chris
"KS" <ks@.community.nospam> wrote in message
news:C44736CF-304A-4478-98E9-01BDA5A7C0B2@.microsoft.com...
> We are working on developing some statistical reports to help us to better
> undertand how our users are (or are not) leveraging our Reporting Services
> implementation. We have been writing execution log data to a database
> based
> on the Msft provided SSIS package that pulls data from the Report Server
> database and I've discovered a hole in the information that I'm hoping
> someone can help me fix.
> We use data drive subscriptions pretty heavily which of course require
> cached data credentials. In the "ExecutionLogs" table, these entries
> appear
> as being requested by "System" and the user shows our proxy account. If
> you
> review the "ReportServerService_..." log on the report server, you can
> see
> the actual detail surrounding the processing of the subscription, but I
> can't
> find a way to correlate these entries back to the ExecutionLog table. The
> "ExecutionLogId" in the ExecutionLog table doesn't reference any of the
> uniqueidentifiers that you see in the text ReportServerService log.
> My end goal is to be able to update the User column in the ExecutionLog
> table with the user who was the actual recipient of the report as
> identified
> in the ReportServerService log file.
> Anyone tackle this yet or have any ideas as to how it might be
> accomplished?|||Thanks for the hint, Chris.
Unless I'm missing something, however, that still doesn't provide you with
the ability to cross reference the actual report delivery with the
ExecutionLog record to be able to access the other metrics that are being
captured (TimeDataRetrieval, TimeProcessing, TimeRendering, ByteCount,
RowCount...)
Need to find a way to accurately identify a specific data driven
subscription execution with the corresponding ExecutionLog entry.
Any other ideas? Like I said, all the necessary info is in
ReportServerServices_xxx.log, but I don't see how I can accurately tie that
back to the appropriate ExecutionLogId in the ExecutionLog table. The text
file inlcudes a number of uniqueidentifiers, but none of which match up to
the ExecutionLog. Can't go by exact time either as the text file is not
precise enough in the event of batch data driven subscription processing.
"Chris Conner" wrote:
> I'll give you a big hint.. :)
> Remember, you are not limited to just select statements in your datasets for
> your reports.
> I have a dataset that does INSERTS for my data driven reports... (since it
> is data driven, you KNOW who the users are that are going to get the
> reports)
> cheers!
> =-Chris
>
> "KS" <ks@.community.nospam> wrote in message
> news:C44736CF-304A-4478-98E9-01BDA5A7C0B2@.microsoft.com...
> > We are working on developing some statistical reports to help us to better
> > undertand how our users are (or are not) leveraging our Reporting Services
> > implementation. We have been writing execution log data to a database
> > based
> > on the Msft provided SSIS package that pulls data from the Report Server
> > database and I've discovered a hole in the information that I'm hoping
> > someone can help me fix.
> >
> > We use data drive subscriptions pretty heavily which of course require
> > cached data credentials. In the "ExecutionLogs" table, these entries
> > appear
> > as being requested by "System" and the user shows our proxy account. If
> > you
> > review the "ReportServerService_..." log on the report server, you can
> > see
> > the actual detail surrounding the processing of the subscription, but I
> > can't
> > find a way to correlate these entries back to the ExecutionLog table. The
> > "ExecutionLogId" in the ExecutionLog table doesn't reference any of the
> > uniqueidentifiers that you see in the text ReportServerService log.
> >
> > My end goal is to be able to update the User column in the ExecutionLog
> > table with the user who was the actual recipient of the report as
> > identified
> > in the ReportServerService log file.
> >
> > Anyone tackle this yet or have any ideas as to how it might be
> > accomplished?
>
>|||Hmm... this is a nice challenge.
Let's try this - forget the log for the moment - I know I could look this
up - but I'm not at a report server at the moment - does the report
Globals!ExecutionTime match the time stored in the ExectionLog? I mean, you
know the report name ...
Here is what I was thinking:
select name, b.executiontime
from reportserver.dbo.catalog c
inner join reportserver.dbo.executionlog ex
ON (c.ItemID = ex.ReportID)
inner join BobTable b on (c.name = b.ReportName)
where name = b.ReportName and b.executiontime between c.TimeStart and
c.TimeEnd
Where "BobTable" is your table that you store the report name and report
execution time when the report runs.
=-Chris
"KS" <ks@.community.nospam> wrote in message
news:2E0EE652-8A08-4D89-9DB3-50EB8B367FF6@.microsoft.com...
> Thanks for the hint, Chris.
> Unless I'm missing something, however, that still doesn't provide you with
> the ability to cross reference the actual report delivery with the
> ExecutionLog record to be able to access the other metrics that are being
> captured (TimeDataRetrieval, TimeProcessing, TimeRendering, ByteCount,
> RowCount...)
> Need to find a way to accurately identify a specific data driven
> subscription execution with the corresponding ExecutionLog entry.
> Any other ideas? Like I said, all the necessary info is in
> ReportServerServices_xxx.log, but I don't see how I can accurately tie
> that
> back to the appropriate ExecutionLogId in the ExecutionLog table. The
> text
> file inlcudes a number of uniqueidentifiers, but none of which match up to
> the ExecutionLog. Can't go by exact time either as the text file is not
> precise enough in the event of batch data driven subscription processing.
> "Chris Conner" wrote:
>> I'll give you a big hint.. :)
>> Remember, you are not limited to just select statements in your datasets
>> for
>> your reports.
>> I have a dataset that does INSERTS for my data driven reports... (since
>> it
>> is data driven, you KNOW who the users are that are going to get the
>> reports)
>> cheers!
>> =-Chris
>>
>> "KS" <ks@.community.nospam> wrote in message
>> news:C44736CF-304A-4478-98E9-01BDA5A7C0B2@.microsoft.com...
>> > We are working on developing some statistical reports to help us to
>> > better
>> > undertand how our users are (or are not) leveraging our Reporting
>> > Services
>> > implementation. We have been writing execution log data to a database
>> > based
>> > on the Msft provided SSIS package that pulls data from the Report
>> > Server
>> > database and I've discovered a hole in the information that I'm hoping
>> > someone can help me fix.
>> >
>> > We use data drive subscriptions pretty heavily which of course require
>> > cached data credentials. In the "ExecutionLogs" table, these entries
>> > appear
>> > as being requested by "System" and the user shows our proxy account.
>> > If
>> > you
>> > review the "ReportServerService_..." log on the report server, you can
>> > see
>> > the actual detail surrounding the processing of the subscription, but I
>> > can't
>> > find a way to correlate these entries back to the ExecutionLog table.
>> > The
>> > "ExecutionLogId" in the ExecutionLog table doesn't reference any of the
>> > uniqueidentifiers that you see in the text ReportServerService log.
>> >
>> > My end goal is to be able to update the User column in the ExecutionLog
>> > table with the user who was the actual recipient of the report as
>> > identified
>> > in the ReportServerService log file.
>> >
>> > Anyone tackle this yet or have any ideas as to how it might be
>> > accomplished?
>>

Any report runs once and then I have to log back in to my app

We have an asp.net app that calls the report server for our reports. We are
running into an issue we don't even understand why it's happening let alone
fixing it...
You can only run one report and then you have to logout of the app and log
back in to run another report. This is with any of our reports! They all
work but only the first report runs the first time. After that all of the
reports don't work. Logout and log back in and choose another report and it
works...?
Here's our code that is basically the same for every report...
dstDataSet = New DataSet
Dim strSPName As String = "spSRS_Appeal_TaxAgents"
'Passing the parameter to the SQL stored procedure
Dim aryParams(1) As SqlParameter
aryParams(0) = New SqlClient.SqlParameter("@.TaxYear", SqlDbType.Int)
aryParams(0).Value = CType(strTaxYear, Integer)
aryParams(1) = New SqlClient.SqlParameter("@.Cycle", SqlDbType.Int)
aryParams(1).Value = CType(strCycle, Integer)
Try
dstDataSet = SqlHelper.ExecuteDataset(cnnConn, strSPName,
aryParams)
Dim intCount As Integer = dstDataSet.Tables(0).Rows.Count
If intCount < 1 Then
lblInfo.Text = "Report records not found! Canceled operation."
Exit Sub
End If
Catch exn As Exception
lblInfo.Text = "Error. Failed to retrieve records! " & exn.Message
End Try
'Create the URL string to render this report from the SQL report
server
'SPParam is the parameter which is submitted to the SQL sotred
procedures
Dim str1, str2, str3, str4, strURL As String
str1 = "http://tennessee/reportserver?/astransc/AppealTaxAgents"
str2 = "&rs:Command=Render&rs:Format=PDF"
str3 = strTaxYear
str4 = strCycle
Dim strPath As New System.Text.StringBuilder
strPath.Append(str1)
strPath.Append(str2)
strPath.Append("&TaxYear=").Append(str3)
strPath.Append("&Cycle=").Append(str4)
strURL = strPath.ToString
Response.Redirect(strURL)
The report is in PDF format and when the report runs it pops up a form
asking if we want to open, save, or cancel the PDF file...
The programmer who wrote this doesn't have this issue on his machine.
However, on the test server this is occuring to us. In fact the programmer
asked for assistance because on his machine it on a rare occasion would not
create the PDF file but he couldn't find a cause for it. On our test server
it occurs like clock work. Log in, run one report (any of them) and then no
other report including the one you just called won't work until you log back
in....
In looking at the report server logs the subsequent requests are not even
making it to the report server? Any ideas? We were wondering if there was
something about the response.redirect? I can take the string created by
the code type it into a url address and it works every time?
Thanks,
KevinI have somewhat figured out what is occuring...
The viewstate is being clobbered when this is occuring (not entirely sure
how but suspect it is occuring because the redirect does not physically
change the page I am on, only creates a do you want to open, save, cancel
this PDF file dialog box). I can only assume that the response.redirect is
the cause now. I am going to figure out a way to accomplish this task.
Kevin
"Kevin" wrote:
> We have an asp.net app that calls the report server for our reports. We are
> running into an issue we don't even understand why it's happening let alone
> fixing it...
> You can only run one report and then you have to logout of the app and log
> back in to run another report. This is with any of our reports! They all
> work but only the first report runs the first time. After that all of the
> reports don't work. Logout and log back in and choose another report and it
> works...?
> Here's our code that is basically the same for every report...
> dstDataSet = New DataSet
> Dim strSPName As String = "spSRS_Appeal_TaxAgents"
> 'Passing the parameter to the SQL stored procedure
> Dim aryParams(1) As SqlParameter
> aryParams(0) = New SqlClient.SqlParameter("@.TaxYear", SqlDbType.Int)
> aryParams(0).Value = CType(strTaxYear, Integer)
> aryParams(1) = New SqlClient.SqlParameter("@.Cycle", SqlDbType.Int)
> aryParams(1).Value = CType(strCycle, Integer)
> Try
> dstDataSet = SqlHelper.ExecuteDataset(cnnConn, strSPName,
> aryParams)
> Dim intCount As Integer = dstDataSet.Tables(0).Rows.Count
> If intCount < 1 Then
> lblInfo.Text = "Report records not found! Canceled operation."
> Exit Sub
> End If
> Catch exn As Exception
> lblInfo.Text = "Error. Failed to retrieve records! " & exn.Message
> End Try
> 'Create the URL string to render this report from the SQL report
> server
> 'SPParam is the parameter which is submitted to the SQL sotred
> procedures
> Dim str1, str2, str3, str4, strURL As String
> str1 = "http://tennessee/reportserver?/astransc/AppealTaxAgents"
> str2 = "&rs:Command=Render&rs:Format=PDF"
> str3 = strTaxYear
> str4 = strCycle
> Dim strPath As New System.Text.StringBuilder
> strPath.Append(str1)
> strPath.Append(str2)
> strPath.Append("&TaxYear=").Append(str3)
> strPath.Append("&Cycle=").Append(str4)
> strURL = strPath.ToString
> Response.Redirect(strURL)
> The report is in PDF format and when the report runs it pops up a form
> asking if we want to open, save, or cancel the PDF file...
> The programmer who wrote this doesn't have this issue on his machine.
> However, on the test server this is occuring to us. In fact the programmer
> asked for assistance because on his machine it on a rare occasion would not
> create the PDF file but he couldn't find a cause for it. On our test server
> it occurs like clock work. Log in, run one report (any of them) and then no
> other report including the one you just called won't work until you log back
> in....
> In looking at the report server logs the subsequent requests are not even
> making it to the report server? Any ideas? We were wondering if there was
> something about the response.redirect? I can take the string created by
> the code type it into a url address and it works every time?
> Thanks,
> Kevin

Any news on different browsers?

I'm using the ReportViewer web control and RS 2005 and notice that
reports don't come close to rendering correctly in FireFox.
I had read posts concerning RS2000 and was thinking that maybe the new
release would be compatible with browsers other than IE.
Does anybody know of (1) any techniques to make the viewer work; or
(2) any news about
an upcoming release that would work?
Also, out of curiosity, has anybody tried this Report Viewer with IE7?
JimWe just upgraded to Reporting Services 2005 and I'm noticing the same thing:
serious rendering problems with reports in Firefox. Specifically:
1. Rendering sometimes ignores hard width values (in inches).
2. Some columns nearly disappear, data in them is not visible.
3. Report height is much less than specified (again, in inches).
I could live with work-arounds, but the fact that no one has even replied to
two separate queries on this subject makes me wonder if there are any.
On a more positive note, the toolbar now works in Firefox!
--
Software Engineer
Educational & Community Supports
University of Oregon
Eugene, OR 97403-1235
"jhcorey@.yahoo.com" wrote:
> I'm using the ReportViewer web control and RS 2005 and notice that
> reports don't come close to rendering correctly in FireFox.
> I had read posts concerning RS2000 and was thinking that maybe the new
> release would be compatible with browsers other than IE.
> Does anybody know of (1) any techniques to make the viewer work; or
> (2) any news about
> an upcoming release that would work?
> Also, out of curiosity, has anybody tried this Report Viewer with IE7?
> Jim
>

Any free reporting tool you recommend?

dun need sophisticated interactive reports, but just simple basic rigid reporting will do :D
looking for a simple tool for my end users. Crystal Reports a bit overkill....MS Access?
MS Excel?|||How about Reporting Services on SQL Server 2005

Regards
Kris Zywczyk|||yah, still trying out to set up the report server in SQL 2005, initial trial on the BI visio studio failed, dunno why.

Is the reporting services included in SQL 2005 express?|||What do you mean you want this for your users?

"are those rocks up ahead?"

"I don't know, but if they are, we all be dead"

OK, what movie.|||"No more rhymes now. I mean it!"

"Does anyone want a peanut?"|||"aaaaaaaaarrrrrrrrrrrrrgggggggggggggghhhhhhhhhh"

"What are you doing?"

"I think someone is following us"

"That would be inconcceivable"|||I personally love it when non-developers write production sql. I have project managers who do it for word merges. i have report writers who do not understand group by. It gives me plenty of things to fix and server slow downs to diagnose.|||"I'm not left-handed either."|||"How do you write women so well?"
"I think of a man, and I take away reason and accountability."|||"How do you write women so well?"
"I think of a man, and I take away reason and accountability."
Great !! :D