Thanks,
MikeDid you get the right data with the report created by the Wizard? After you deleted all the generated fields, what did you replace them with? Does your report contain a repeating data region such as a Table?
Thanks,
Albert
Showing posts with label generates. Show all posts
Showing posts with label generates. Show all posts
Monday, March 26, 2012
Report only generates 1 page output
I'm fairly new to Reporting Services, so I'm sure this is a dumb question. I have a stored proc that returns 38 rows that I am using in a report. The report is fairly simple, with no page headers or footers. I used the Report Wizard to create the report, but ended up deleting all the generated fields and started with a blank report. Now the report only generates 1 page of output. Any ideas?
Report only generates 1 page output
I'm fairly new to Reporting Services, so I'm sure this is a dumb question. I have a stored proc that returns 38 rows that I am using in a report. The report is fairly simple, with no page headers or footers. I used the Report Wizard to create the report, but ended up deleting all the generated fields and started with a blank report. Now the report only generates 1 page of output. Any ideas?
Thanks,
MikeDid you get the right data with the report created by the Wizard? After you deleted all the generated fields, what did you replace them with? Does your report contain a repeating data region such as a Table?
Thanks,
Albert
Monday, March 12, 2012
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
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
Friday, March 9, 2012
Report Manager and screen readers
Hi,
One of our developers uses JAWS 5.1. He's able to navigate to a report using Report Manager, but once he generates it, he can only read the toolbar (where the Export options are, etc). He can't move the virtual cursor into the main report area; JAWS just goes silent.
Any ideas? Does Report Manager not support it or can we change something in our setup? We're using Reporting Services SP2 with SQL Server 2000.
One of our developers uses JAWS 5.1. He's able to navigate to a report using Report Manager, but once he generates it, he can only read the toolbar (where the Export options are, etc). He can't move the virtual cursor into the main report area; JAWS just goes silent.
Any ideas? Does Report Manager not support it or can we change something in our setup? We're using Reporting Services SP2 with SQL Server 2000.
That's not good. I'm following up internally on this right now. It may take a little time to get a response out to you because of the Christmas season and people's availability.
-Lukasz
This posting is provided "AS IS" with no warranties, and confers no rights.
I have followed up internally. I am told that we used Jaws for Windows 7.0 for accessibility testing of SQL Server 2005. I didn't see the issue you're reporting come through our triage process, so I would believe that the newer version of the tool supports the HTML we output.
Can you give the newer version a try and let me know by responding to this thread if the problem is resolved?
Thanks,
-Lukasz
This posting is provided "AS IS" with no warranties, and confers no rights.
Report Manager and screen readers
Hi,
One of our developers uses JAWS 5.1. He's able to navigate to a report using Report Manager, but once he generates it, he can only read the toolbar (where the Export options are, etc). He can't move the virtual cursor into the main report area; JAWS just goes silent.
Any ideas? Does Report Manager not support it or can we change something in our setup? We're using Reporting Services SP2 with SQL Server 2000.
One of our developers uses JAWS 5.1. He's able to navigate to a report using Report Manager, but once he generates it, he can only read the toolbar (where the Export options are, etc). He can't move the virtual cursor into the main report area; JAWS just goes silent.
Any ideas? Does Report Manager not support it or can we change something in our setup? We're using Reporting Services SP2 with SQL Server 2000.
That's not good. I'm following up internally on this right now. It may take a little time to get a response out to you because of the Christmas season and people's availability.
-Lukasz
This posting is provided "AS IS" with no warranties, and confers no rights.
I have followed up internally. I am told that we used Jaws for Windows 7.0 for accessibility testing of SQL Server 2005. I didn't see the issue you're reporting come through our triage process, so I would believe that the newer version of the tool supports the HTML we output.
Can you give the newer version a try and let me know by responding to this thread if the problem is resolved?
Thanks,
-Lukasz
This posting is provided "AS IS" with no warranties, and confers no rights.
Tuesday, February 21, 2012
Report generates incorrect results
Hey, after tinkering around with this VB 2005/Crystal setup for a while, I finally narrowed down the issue with the problem I'm having.
Using the SQL query Crystal gives me, I am trying to use VB.NET to pull data from a DSN server and into a DataSet, which I am trying to merge with the rpt file using the report.SetDataSource option. The problem is, with that particular query, the results generated pages in the report in the THOUSANDS. Typically, this report never goes over 10 pages. The thing is that when I generate the report within Crystal itself, it's fine... 10 pages or less.
After some fooling around with the VB code, I found that the problem was in the query! It seems that when I pull certain fields and inject them into the report, it systematically loads every possible value from those fields into each group (company tickets), and with so many fields this happens with, there becomes a compound effect. So what was 50+ bloat pages then becomes thousands.
I am wondering what the issue could possibly be with the query Crystal gives me (which works in Crystal) that when I try to bind the same data from a DataSet with the rpt template, it inflates the report with garbage data. Anyone have any similar occurrances or suggestions?Bump|||Maybe is how Crystal evaluates the records (whilereading, beforerading??) or maybe somehow one field was moved a detail section and before was on a header. I assume queries are the same...
Robert
Using the SQL query Crystal gives me, I am trying to use VB.NET to pull data from a DSN server and into a DataSet, which I am trying to merge with the rpt file using the report.SetDataSource option. The problem is, with that particular query, the results generated pages in the report in the THOUSANDS. Typically, this report never goes over 10 pages. The thing is that when I generate the report within Crystal itself, it's fine... 10 pages or less.
After some fooling around with the VB code, I found that the problem was in the query! It seems that when I pull certain fields and inject them into the report, it systematically loads every possible value from those fields into each group (company tickets), and with so many fields this happens with, there becomes a compound effect. So what was 50+ bloat pages then becomes thousands.
I am wondering what the issue could possibly be with the query Crystal gives me (which works in Crystal) that when I try to bind the same data from a DataSet with the rpt template, it inflates the report with garbage data. Anyone have any similar occurrances or suggestions?Bump|||Maybe is how Crystal evaluates the records (whilereading, beforerading??) or maybe somehow one field was moved a detail section and before was on a header. I assume queries are the same...
Robert
Subscribe to:
Posts (Atom)