Report pages - reduce render time

Is there a way to minimize the number of pages obtained from a report. My report has more than 9000 pages. I want to minimize the number of pages as it would fasten the rendering of the report in excel,pdf formats. how would one do this? is there any expression?. your help is very much appreciated. I am tearing my hair to minimize the time taken to render a report.! help pls!

Thanks,

You say the report is 9000 pages, so what did you have in mind when you say "minimize the number of pages" -- it seems like you already know how big the report is.

If you only need to see some of the 9000 pages at a time, or only certain people need to see certain pages, you should filter the data (preferably at the data source) with parameters and/or UserId.

Report not rending via web service

I'm somewhat new to reporting services and have used a web service call to
render my reports in my asp.net applications in the past. All the reports
thus far have been Excel, and I've used the same method for calling these
reports from some sample code I found online. This has worked great up till
now.
I have a report I want to render in PDF. I've plugged in the correct values
in my code and the browser will try and download the PDF but returns a "File
is damaged and could not be displayed". I tried rending in Excel and I get
"This file is not in a recognizable format". I've compared my code to past
projects and everything looks good. The only difference with this report is
I used a list control with textboxes instead of a table which I've used on
all past reports. If anyone has a suggestion on what causes these error
message, please reply. Thanks.I figured it out. There was a <httpModules> tag in my web.config that was
causing this problem. I built another project to call my report with a
"clean" web.config and it works fine.
"jweesies" wrote:
> I'm somewhat new to reporting services and have used a web service call to
> render my reports in my asp.net applications in the past. All the reports
> thus far have been Excel, and I've used the same method for calling these
> reports from some sample code I found online. This has worked great up till
> now.
> I have a report I want to render in PDF. I've plugged in the correct values
> in my code and the browser will try and download the PDF but returns a "File
> is damaged and could not be displayed". I tried rending in Excel and I get
> "This file is not in a recognizable format". I've compared my code to past
> projects and everything looks good. The only difference with this report is
> I used a list control with textboxes instead of a table which I've used on
> all past reports. If anyone has a suggestion on what causes these error
> message, please reply. Thanks.

report manager execution problem

Hello!
I have a problem making the report manager create a snopshot of a report.
It generates the report if the execution option is set to "Render this
report with the most recent data", but does not generate otherwise.
I left it over night to finish a snapshot, and it still gave me the error
that the report is not ready for viewing.
I have limited permissions on the server and on the datasource DB. I have
publisher's permissions on the server and query select and store procedure
execute permissions on the DB.
I have set up the datasource to use stored Credentials, since the DB is on a
different server.
What can I do?
Thanks for your help.Hello!
Never mind the last question.
It suddenly started generating the snapshot.
But the thin is, that when I click on "VIEW" to view the report it gives me
the following error:
An internal error occurred on the report server. See the error log for more
details. (rsInternalError) Get Online Help
EXECUTE permission denied on object 'sp_verify_job_identifiers', database
'msdb', owner 'dbo'. SELECT permission denied on object 'sysjobs', database
'msdb', owner 'dbo'. EXECUTE permission denied on object
'xp_sqlagent_enum_jobs', database 'master', owner 'dbo'.
But If I go to history I can view the snapshot.
How do I make te snapshot appear on the screen when I click "VIEW"?
Thanks
"Anton" wrote:
> Hello!
> I have a problem making the report manager create a snopshot of a report.
> It generates the report if the execution option is set to "Render this
> report with the most recent data", but does not generate otherwise.
> I left it over night to finish a snapshot, and it still gave me the error
> that the report is not ready for viewing.
> I have limited permissions on the server and on the datasource DB. I have
> publisher's permissions on the server and query select and store procedure
> execute permissions on the DB.
> I have set up the datasource to use stored Credentials, since the DB is on a
> different server.
> What can I do?
> Thanks for your help.|||This fixed My Problem
Solution
The problem is occurring due to missing permissions on the SQL server. This can occur because the database was restored or moved as the permissions are applied during installation by default. The following query can be run to apply the correct permissions. This query does not need to be run on a specific database, just open Management Studio and select ?new query? from the file menu:
USE master
GO
GRANT EXECUTE ON master.dbo.xp_sqlagent_notify TO RSExecRole
GO
GRANT EXECUTE ON master.dbo.xp_sqlagent_enum_jobs TO RSExecRole
GO
GRANT EXECUTE ON master.dbo.xp_sqlagent_is_starting TO RSExecRole
GO
USE msdb
GO
-- Permissions for SQL Agent SP's
GRANT EXECUTE ON msdb.dbo.sp_help_category TO RSExecRole
GO
GRANT EXECUTE ON msdb.dbo.sp_add_category TO RSExecRole
GO
GRANT EXECUTE ON msdb.dbo.sp_add_job TO RSExecRole
GO
GRANT EXECUTE ON msdb.dbo.sp_add_jobserver TO RSExecRole
GO
GRANT EXECUTE ON msdb.dbo.sp_add_jobstep TO RSExecRole
GO
GRANT EXECUTE ON msdb.dbo.sp_add_jobschedule TO RSExecRole
GO
GRANT EXECUTE ON msdb.dbo.sp_help_job TO RSExecRole
GO
GRANT EXECUTE ON msdb.dbo.sp_delete_job TO RSExecRole
GO
GRANT EXECUTE ON msdb.dbo.sp_help_jobschedule TO RSExecRole
GO
GRANT EXECUTE ON msdb.dbo.sp_verify_job_identifiers TO RSExecRole
GO
GRANT SELECT ON msdb.dbo.sysjobs TO RSExecRole
GO
GRANT SELECT ON msdb.dbo.syscategories TO RSExecRole
GO
No restart is required, once the above query has been run Delivery Schedules will function correctly.
From http://www.developmentnow.com/g/115_2005_6_0_0_534593/report-manager-execution-problem.ht
Posted via DevelopmentNow.com Group
http://www.developmentnow.com