Reporting Services Toolbar & version

Hi All,

1. Whether I'm working on in Layout, Data or Preview (Reporting Services 2005) for any report

the toolbars I select disappear when I click on close. In Tools, Customize, I have check marks by: Formatting, Query designer, Layou,Build and Standard among a few others. I tried the reset button but no help as well.

What am I missing? Should they be visible and not grayed out?

2. Also, Is there an easy way to tell what verion/service pack level SQl server 2005 and of MSSRS 2005 I am running?

Thanks in Advance !

>Scott

http://i55.photobucket.com/albums/g121/Farsight38/toolbars.jpg

These should be all of your toolbars.

To get the versin of SQL server 2005, execute the following query:

select @.@.version

Reporting Services SP1 Designer Cache Problem

Reporting Service SP1 provides an option to cache the data during
design time for preview, which seems to be making the preview to take
lot longer time than pre SP1.
This is what Reporting Services SP1 is doing:
During preview it is making a call to SQL and in between it is writing
into report data file, which is taking longer time just because it is
reading and writing into data file before even rendering.
Why can't it cache the data after it gets the entire data instead of
holding the sql connection or after rendering?
One of my reports is used to take 10 secs prior to SP1 now it is
taking 6 mins.
After turning of the configuration to false we started getting the
report in 10 secs.
Is there any resolution for this?
Thanks
RI have a couple of questions. Does this type of performance difference
occur for all reports or just this one? What is the structure of the data:
number of rows returned, etc. I would expect caching to take longer but not
in the magnitude you are describing.
The report is cached and rendered as we get the data (it is not buffered).
On the surface it seems quite in efficient to render the report and then
potentially round trip to the server again. Buffering is an issue since we
do not know the size of result set in advance.
--
Bruce Johnson [MSFT]
Microsoft SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"am_i_dotnet" <am_i_dotnet@.hotmail.com> wrote in message
news:ac7b2754.0407151240.2374c78b@.posting.google.com...
> Reporting Service SP1 provides an option to cache the data during
> design time for preview, which seems to be making the preview to take
> lot longer time than pre SP1.
> This is what Reporting Services SP1 is doing:
> During preview it is making a call to SQL and in between it is writing
> into report data file, which is taking longer time just because it is
> reading and writing into data file before even rendering.
> Why can't it cache the data after it gets the entire data instead of
> holding the sql connection or after rendering?
> One of my reports is used to take 10 secs prior to SP1 now it is
> taking 6 mins.
> After turning of the configuration to false we started getting the
> report in 10 secs.
> Is there any resolution for this?
> Thanks
> R|||There are around 20000+ records in this report and the report is in
tabular format.
I may not agree with you on "The report is cached and rendered as we
get the data". Because I observed the data file keep growing when I
tried to preview the report and report showed up only after the entire
data file created.
I know it is inefficient to make second round trip to server just to
cache the data but do we have any thoughts on using the data in the
report. I mean first render the report and cache the data
asynchronously from report data.
Thanks
R
"Bruce Johnson [MSFT]" <brucejoh@.online.microsoft.com> wrote in message news:<#dyED4qaEHA.3684@.TK2MSFTNGP09.phx.gbl>...
> I have a couple of questions. Does this type of performance difference
> occur for all reports or just this one? What is the structure of the data:
> number of rows returned, etc. I would expect caching to take longer but not
> in the magnitude you are describing.
> The report is cached and rendered as we get the data (it is not buffered).
> On the surface it seems quite in efficient to render the report and then
> potentially round trip to the server again. Buffering is an issue since we
> do not know the size of result set in advance.
> --
> Bruce Johnson [MSFT]
> Microsoft SQL Server Reporting Services
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
> "am_i_dotnet" <am_i_dotnet@.hotmail.com> wrote in message
> news:ac7b2754.0407151240.2374c78b@.posting.google.com...
> > Reporting Service SP1 provides an option to cache the data during
> > design time for preview, which seems to be making the preview to take
> > lot longer time than pre SP1.
> >
> > This is what Reporting Services SP1 is doing:
> > During preview it is making a call to SQL and in between it is writing
> > into report data file, which is taking longer time just because it is
> > reading and writing into data file before even rendering.
> >
> > Why can't it cache the data after it gets the entire data instead of
> > holding the sql connection or after rendering?
> >
> > One of my reports is used to take 10 secs prior to SP1 now it is
> > taking 6 mins.
> >
> > After turning of the configuration to false we started getting the
> > report in 10 secs.
> >
> > Is there any resolution for this?
> >
> > Thanks
> > R

reporting services print preview

Why whenever I create a report that is more than 1 page long, do I get a
blank page between every page of my report? In VS for example if I
create a 3 page report, I get a 6 page report and every other page is
blank on the print preview.
How do you prevent this?
Cheers,
Mike
*** Sent via Developersdex http://www.examnotes.net ***Check that your page margins are correct.
If you have overshot your page margins with a table or object then you will
get this.
Immy
"Mike P" <mike.parr@.gmail.com> wrote in message
news:eynAtgDeGHA.1208@.TK2MSFTNGP02.phx.gbl...
> Why whenever I create a report that is more than 1 page long, do I get a
> blank page between every page of my report? In VS for example if I
> create a 3 page report, I get a 6 page report and every other page is
> blank on the print preview.
> How do you prevent this?
>
> Cheers,
> Mike
>
> *** Sent via Developersdex http://www.examnotes.net ***

Reporting Services parameters not in correct order

Hi,

SQL Server Reporting Services 2005.

I have 13 parameters, ordered correctly within the Report Parameter screen.

When displayed in the Preview tab they are all ordered correctly, but when viewed in the application the first 4 are at the top but ordered incorrectly. The remainder are ordered correctly.

I have tried reordering, saving, deploying, viewing and then doing the same but in the correct order without any success.

Please can someone suggest how I can get the parameters to appear in the correct order within the application?

Thanking you,

dwemh

dwemh

Do you mean the alignment of report parameters within ReportViewer

control parameters area? If so, may be custom control for parameters

setting is worth developing. As I know, GetReportParameters() web method returns parameter collection, saving original order.

|||

The parameters are displayed in the order they appear on the report parameters page in the report designer tool. If you have previously published the report, you may need to delete it and replublish for any order changes to be reflected on the server.

Other than that, parameters are always layed out left to right, top to bottom by default (this adapts to your globalization settings). If that doesn't meet you needs, you'll need to follow Anatoly's advice and provide a custom application to display them how you want them.

-Lukasz

|||

Well. this bring me closer to a question I had since days.. Can we have more than 2 parameters displayed in a single row on report (when browsed ). The parameters by default - seems to be lined up in an array of 2 columns, ad N rows - which is frustrating because so much of space is left blank (space just left of <View Report> button.

How did you managed to get 4 parameters in one single row ?

Thanks for ideas.

|||

Yup, can only have 2 columns in our UI and we don't expose a property to set the number of columns. I've added a design change request to our internal system to try to get this addressed.

Right now, the only way you can get more parameters is to build a custom UI.

-Lukasz

sql

Reporting services in 2005

Hi,

How do i get the "Data" "Layout" and "Preview" tabs in the report designer like displayed in Brian Welckers video "Report Authoring Tips and Tricks"

http://msdn.microsoft.com/msdntv/episode.aspx?xml=episodes/en/20050609SQLServerBW/manifest.xml

When I add a report to my project, all I get is the layout view.

When I click the menu Reports -> Data Dources, all I get is a list of my DataSources from my main project, I have no ability to Add a SQL server source, or OLEDB source, or even write a SQL statement like in the video.

Did I miss something I need when installing?

:-)It sounds like you need to install the "Workstation Components" from the SQL Server 2005 disk on the dev machine you're working on. A quick way to check is to look for the Business Intelligence Projects in the Add New Project dialogue, if it's not there, you need to install them.|||

When you use Visual Studio 2005 and SQL Server 2005 Reporting Services together, you have 2 options for desiging reports:
1) Using the WinForms or WebForms ReportViewer control in you application.
2) Using the Report Designer that installs with the workstation components of SQL Server 2005.

For #1 - you're actually adding an embedded report to your application. You need to provide data to the report that you author. This is the cause you're running into.

For #2 - if you want to publish a report to the report server, Peter is right, you'll need to install the Report Designer. The report designer includes the 3 panes for data, layout, and preview that you are accustomed to see in SQL Server 2000 Reporting Services.

Hope that helps,
-Lukasz

|||hello,
I have VS2005 installed along with RS 2000. I have developed reports using the report wizard. I have also uploaded the reports to the report server which is in a different location.
Now, my problem is when i use report viewer control to access the reports in the report server, I get this error message.

The attempt to connect to the report server failed. Check your connection information and that the report server is a compatible version.

The request failed with HTTP status 404: Not Found.|||

Hello,

I do have designer installed, but still it's abig difference between Woelcker's Training Designer Screen and mine.

For example, I don't see the image of the tables and joins.

Thanks,

Seva Akkerman

|||I just watched (a lot of) this video. When he set his list to be multi-value, his preview rendered with the select all.

In mine, I can set a multi-value parameter; but it won't show up until I deploy to the server.

Does anyone know what causes that?

Reporting services in 2005

Hi,

How do i get the "Data" "Layout" and "Preview" tabs in the report designer like displayed in Brian Welckers video "Report Authoring Tips and Tricks"

http://msdn.microsoft.com/msdntv/episode.aspx?xml=episodes/en/20050609SQLServerBW/manifest.xml

When I add a report to my project, all I get is the layout view.

When I click the menu Reports -> Data Dources, all I get is a list of my DataSources from my main project, I have no ability to Add a SQL server source, or OLEDB source, or even write a SQL statement like in the video.

Did I miss something I need when installing?

:-)It sounds like you need to install the "Workstation Components" from the SQL Server 2005 disk on the dev machine you're working on. A quick way to check is to look for the Business Intelligence Projects in the Add New Project dialogue, if it's not there, you need to install them.|||

When you use Visual Studio 2005 and SQL Server 2005 Reporting Services together, you have 2 options for desiging reports:
1) Using the WinForms or WebForms ReportViewer control in you application.
2) Using the Report Designer that installs with the workstation components of SQL Server 2005.

For #1 - you're actually adding an embedded report to your application. You need to provide data to the report that you author. This is the cause you're running into.

For #2 - if you want to publish a report to the report server, Peter is right, you'll need to install the Report Designer. The report designer includes the 3 panes for data, layout, and preview that you are accustomed to see in SQL Server 2000 Reporting Services.

Hope that helps,
-Lukasz

|||hello,
I have VS2005 installed along with RS 2000. I have developed reports using the report wizard. I have also uploaded the reports to the report server which is in a different location.
Now, my problem is when i use report viewer control to access the reports in the report server, I get this error message.

The

attempt to connect to the report server failed. Check your connection

information and that the report server is a compatible version.

The

request failed with HTTP status 404: Not Found.|||

Hello,

I do have designer installed, but still it's abig difference between Woelcker's Training Designer Screen and mine.

For example, I don't see the image of the tables and joins.

Thanks,

Seva Akkerman

|||I just watched (a lot of) this video. When he set his list to be multi-value, his preview rendered with the select all.

In mine, I can set a multi-value parameter; but it won't show up until I deploy to the server.

Does anyone know what causes that?

Reporting services in 2005

Hi,

How do i get the "Data" "Layout" and "Preview" tabs in the report designer like displayed in Brian Welckers video "Report Authoring Tips and Tricks"

http://msdn.microsoft.com/msdntv/episode.aspx?xml=episodes/en/20050609SQLServerBW/manifest.xml

When I add a report to my project, all I get is the layout view.

When I click the menu Reports -> Data Dources, all I get is a list of my DataSources from my main project, I have no ability to Add a SQL server source, or OLEDB source, or even write a SQL statement like in the video.

Did I miss something I need when installing?

:-)It sounds like you need to install the "Workstation Components" from the SQL Server 2005 disk on the dev machine you're working on. A quick way to check is to look for the Business Intelligence Projects in the Add New Project dialogue, if it's not there, you need to install them.|||

When you use Visual Studio 2005 and SQL Server 2005 Reporting Services together, you have 2 options for desiging reports:
1) Using the WinForms or WebForms ReportViewer control in you application.
2) Using the Report Designer that installs with the workstation components of SQL Server 2005.

For #1 - you're actually adding an embedded report to your application. You need to provide data to the report that you author. This is the cause you're running into.

For #2 - if you want to publish a report to the report server, Peter is right, you'll need to install the Report Designer. The report designer includes the 3 panes for data, layout, and preview that you are accustomed to see in SQL Server 2000 Reporting Services.

Hope that helps,
-Lukasz

|||hello,
I have VS2005 installed along with RS 2000. I have developed reports using the report wizard. I have also uploaded the reports to the report server which is in a different location.
Now, my problem is when i use report viewer control to access the reports in the report server, I get this error message.

The

attempt to connect to the report server failed. Check your connection

information and that the report server is a compatible version.

The

request failed with HTTP status 404: Not Found.|||

Hello,

I do have designer installed, but still it's abig difference between Woelcker's Training Designer Screen and mine.

For example, I don't see the image of the tables and joins.

Thanks,

Seva Akkerman

|||I just watched (a lot of) this video. When he set his list to be multi-value, his preview rendered with the select all.

In mine, I can set a multi-value parameter; but it won't show up until I deploy to the server.

Does anyone know what causes that?

Reporting services in 2005

Hi,

How do i get the "Data" "Layout" and "Preview" tabs in the report designer like displayed in Brian Welckers video "Report Authoring Tips and Tricks"

http://msdn.microsoft.com/msdntv/episode.aspx?xml=episodes/en/20050609SQLServerBW/manifest.xml

When I add a report to my project, all I get is the layout view.

When I click the menu Reports -> Data Dources, all I get is a list of my DataSources from my main project, I have no ability to Add a SQL server source, or OLEDB source, or even write a SQL statement like in the video.

Did I miss something I need when installing?

:-)It sounds like you need to install the "Workstation Components" from the SQL Server 2005 disk on the dev machine you're working on. A quick way to check is to look for the Business Intelligence Projects in the Add New Project dialogue, if it's not there, you need to install them.|||

When you use Visual Studio 2005 and SQL Server 2005 Reporting Services together, you have 2 options for desiging reports:
1) Using the WinForms or WebForms ReportViewer control in you application.
2) Using the Report Designer that installs with the workstation components of SQL Server 2005.

For #1 - you're actually adding an embedded report to your application. You need to provide data to the report that you author. This is the cause you're running into.

For #2 - if you want to publish a report to the report server, Peter is right, you'll need to install the Report Designer. The report designer includes the 3 panes for data, layout, and preview that you are accustomed to see in SQL Server 2000 Reporting Services.

Hope that helps,
-Lukasz

|||hello,
I have VS2005 installed along with RS 2000. I have developed reports using the report wizard. I have also uploaded the reports to the report server which is in a different location.
Now, my problem is when i use report viewer control to access the reports in the report server, I get this error message.

The

attempt to connect to the report server failed. Check your connection

information and that the report server is a compatible version.

The

request failed with HTTP status 404: Not Found.|||

Hello,

I do have designer installed, but still it's abig difference between Woelcker's Training Designer Screen and mine.

For example, I don't see the image of the tables and joins.

Thanks,

Seva Akkerman

|||I just watched (a lot of) this video. When he set his list to be multi-value, his preview rendered with the select all.

In mine, I can set a multi-value parameter; but it won't show up until I deploy to the server.

Does anyone know what causes that?

Reporting Services error message -- please help?

Hi

I'm getting the following error message when I go to the preview tab:

An error has occurred during report processing.

Cannot read the next data row for the data set DataSet1.

What does this mean, and how can I fix it?

Have you looked at the Report Execution Timeout setting. This is the same error I get when I run a report that takes longer to run than I have set the timeout to be.

Reporting Services Error After Formatting Report

I created a drill-down report from a cube in Analysis Services using the report wizard. When I preview the report, the columns are not wide enough to view the data without the data getting wrapped around to the next line (the number 51,520,384.92 does not display on a single line). When I try to change the column width and then preview the report, I get a fatal error and Visual Studio closes. I had the same problem when I tried to change the number format to display 2 decimal places and preview the report. However, the number format worked if I saved my changes before previewing the report. Unfortunately this does not work for column width. Is there a work around for this? If I can't format my reports I'll have to use another application.

I can format reports without any problems when I create them manually, but it would be nice to use the wizard for the easier reports.|||I believe this issue has been fixed in the upcoming SP1 release of SQL Server 2005.

Reporting Services Error After Formatting Report

I created a drill-down report from a cube in Analysis Services using the report wizard. When I preview the report, the columns are not wide enough to view the data without the data getting wrapped around to the next line (the number 51,520,384.92 does not display on a single line). When I try to change the column width and then preview the report, I get a fatal error and Visual Studio closes. I had the same problem when I tried to change the number format to display 2 decimal places and preview the report. However, the number format worked if I saved my changes before previewing the report. Unfortunately this does not work for column width. Is there a work around for this? If I can't format my reports I'll have to use another application.

I can format reports without any problems when I create them manually, but it would be nice to use the wizard for the easier reports.|||I believe this issue has been fixed in the upcoming SP1 release of SQL Server 2005.

Reporting Services Error -- Could not find stored procedure 'spPM_ProjectManager'

Hi All,

I built this report same way like the other reports but in different database. When preview in visual stuodio, it is fine. When deploy to the server, I got this message:

Report Services Error

An error has occurred during report processing. (rsProcessingAborted) Get Online Help Query execution failed for data set 'ProjectManager'. (rsErrorExecutingCommand) Get Online Help Could not find stored procedure 'spPM_ReportManager'.

Do you know what cause the error?

Thanks in advance for your help!

Rabbie

Basically the error message is telling you it cant find the stored procedure. I would verify that the shared datasource this report is using in the designer is deployed to the reporting server. If it does exist, I would redeploy it anyway just in case.|||

Somehow the shared datasource's xml file missing initial catalog key/value pair in <ConnectString> tag. Even redeploy the shared datasource, xml file still did not change. I had to go to the server to change the value.

Thanks for your tip, Jonathan!

|||is the s.p. in the new db?

REPORTING SERVICES ERROR

Hi,
I am using tables from different db's in my report. When i preView the
report from reporting Services, it works fine. BUt when I deployed it and
tehn viewed from IE, I got the following error:
Reporting Services Erro
----
An error has occurred during report processing. (rsProcessingAborted) Get
Online Help
Query execution failed for data set 'ItemsInSprintNotInBofLogs'.
(rsErrorExecutingCommand) Get Online Help
Invalid object name 'EVEREST_TII.dbo.SubAgent'.
Any ideas?
Thanks
--
pmudDid you redefine the datasources for both of your db's after you
deployed? Scroll down and click all the OK and Apply buttons? I know
these are obvious things but they're usually what I find when my people
run into that error.

Reporting Services Error

Hello. I Do a report with a matrix, the report until the preview work
correctly, but when I publish it show me the next error
JIT debugging failed with the following error: Access Denied
JIT debugging was initiated by the user acount 'NT AUTHORITY\Servicio de
red'.
Check the documentation index for 'Just-in-time debugging, errors' for more
information.
htp://go.microsoft.com/fwlink/events.asp
I make the report again, publish it after every small change and I find that
it fail after I put a groups of rows in the matrix, but in the preview, it
dont show me any warning or errors, only fail after I publish it.
for better reference: the report use a shared data source and is publised in
a Windows 2003 server. the server test is a Windows 2000 Advance Server, SQL
2000, and .NET 2003Are you using any custom .dll files in this report? What else is it
referencing? It is clear that you have a permissions/security issue. The
designer will bypass code level security checks so it is not good for testing
this.. that would explain why you only get the error on deployed reports.
Bret Updegraff
http://bretup.spaces.live.com/
"UsuarioNovato" wrote:
> Hello. I Do a report with a matrix, the report until the preview work
> correctly, but when I publish it show me the next error
> JIT debugging failed with the following error: Access Denied
> JIT debugging was initiated by the user acount 'NT AUTHORITY\Servicio de
> red'.
> Check the documentation index for 'Just-in-time debugging, errors' for more
> information.
> htp://go.microsoft.com/fwlink/events.asp
>
> I make the report again, publish it after every small change and I find that
> it fail after I put a groups of rows in the matrix, but in the preview, it
> dont show me any warning or errors, only fail after I publish it.
> for better reference: the report use a shared data source and is publised in
> a Windows 2003 server. the server test is a Windows 2000 Advance Server, SQL
> 2000, and .NET 2003
>
>