Reporting Services Select All

When Building a report in the Business Intelligence Studio /w a select parameter it gives you a select all option. When you publish the report to your report server you no longer have this option?Most likely, SP1 has been applied to your server and not to your client. See http://blogs.msdn.com/bwelcker/archive/2006/08/14/700189.aspx for the story of "Select All".sql

Reporting Services Render issues in IE

Hi

We are having an issue with reporting services when it is viewed in IE.

We can design the report in visual studio and it looks fine, however when we upload the report to reporting services it displays the report incorrectly (shown below)

http://static.flickr.com/103/298669551_7395fc946d.jpg

When it is print previewed it looks like this (which is the correct layout)

http://static.flickr.com/104/298669558_cfd56ffd0e.jpg

Any advice would be most appreciated!

Thanks Ross

Ross,

You're running into the differences between the renderers. Designer preview and print preview use a GDI-based renderer, while Report Manager uses an HTML-based renderer. There are some pretty significant differences in the way borders and other elements are handled.

Best advice I can give you is to decide which renderer is most important for each report, and make sure you get what you want for that renderer.

It may be possible to get a consistent result from both types of renderers with the use of rectangles to "freeze" report items.

|||

Mike

I posted this yesterday...

"We have a SQL Server 2005 database which holds all the companies scanned documents (in image fields). I have developed a report which allows the user to search for a contract and all relevant scanned documents are returned.

When I preview the report with Visual Studio Report Designer...SOME of the images are not displayed, I get the little red cross icon in the top left corner.

When viewed using Report Manager with a browser... the report displays ALL images... however, when I click on the print button and then the print preview button in Report Manager, some of the images do not appear (the same images that don't appear in the Report Designer preview).

Can anyone tell me why I can see all the images through Report Manager and my Browser (IE7), but only some of the images when in Report Designer preview or Print Preview? "

After reading your post above, I started thinking it could be a rendering issue. Have you got any more information?

Reporting Services Render issues in IE

Hi

We are having an issue with reporting services when it is viewed in IE.

We can design the report in visual studio and it looks fine, however when we upload the report to reporting services it displays the report incorrectly (shown below)

http://static.flickr.com/103/298669551_7395fc946d.jpg

When it is print previewed it looks like this (which is the correct layout)

http://static.flickr.com/104/298669558_cfd56ffd0e.jpg

Any advice would be most appreciated!

Thanks Ross

Ross,

You're running into the differences between the renderers. Designer preview and print preview use a GDI-based renderer, while Report Manager uses an HTML-based renderer. There are some pretty significant differences in the way borders and other elements are handled.

Best advice I can give you is to decide which renderer is most important for each report, and make sure you get what you want for that renderer.

It may be possible to get a consistent result from both types of renderers with the use of rectangles to "freeze" report items.

|||

Mike

I posted this yesterday...

"We have a SQL Server 2005 database which holds all the companies scanned documents (in image fields). I have developed a report which allows the user to search for a contract and all relevant scanned documents are returned.

When I preview the report with Visual Studio Report Designer...SOME of the images are not displayed, I get the little red cross icon in the top left corner.

When viewed using Report Manager with a browser... the report displays ALL images... however, when I click on the print button and then the print preview button in Report Manager, some of the images do not appear (the same images that don't appear in the Report Designer preview).

Can anyone tell me why I can see all the images through Report Manager and my Browser (IE7), but only some of the images when in Report Designer preview or Print Preview? "

After reading your post above, I started thinking it could be a rendering issue. Have you got any more information?

sql

Reporting Services Render issues in IE

Hi
We are having an issue with reporting services when it is viewed in IE.
We can design the report in visual studio and it looks fine, however
when we upload the report to reporting services it displays the report
incorrectly (shown below)
http://static.flickr.com/103/298669551_7395fc946d.jpg
When it is print previewed it looks like this (which is the correct
layout)
http://static.flickr.com/104/298669558_cfd56ffd0e.jpg
Any advice would be most appreciated!
Thanks RossI'd like to know more about this too.
I had a report with a chart and an image on it. The image was to the
right of the chart. When viewing the report it looked fine. However,
when it was print previewed, the image showed up right on top of the
chart. Made no sense.
However, i fixed this by making sure my report elements didn't overlap.
Is this happening in your case? Reporting services doesn't like reports
where the elements on it are either touching or overlapping. Try
spacing out some stuff.
-Kevin
ross.dargan@.gmail.com wrote:
> Hi
> We are having an issue with reporting services when it is viewed in IE.
> We can design the report in visual studio and it looks fine, however
> when we upload the report to reporting services it displays the report
> incorrectly (shown below)
> http://static.flickr.com/103/298669551_7395fc946d.jpg
> When it is print previewed it looks like this (which is the correct
> layout)
> http://static.flickr.com/104/298669558_cfd56ffd0e.jpg
> Any advice would be most appreciated!
> Thanks Ross

Reporting Services Question

I have an associate who needs Reporting Services 2005 installed. They do not
have a Visual Studio 2005 license of any kind. Does this normally go on a
desktop and if so, what is the minimum license required to remain compliant?
THANK YOU in advance!If you are talking about developing reports, no license is required for
that. The server where the reports are being deployed need a license. Also,
RS 2005 comes with its own version of VS so unless you are writing custom
assemblies you do not need to purchase VS 2005.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"KC" <KC@.discussions.microsoft.com> wrote in message
news:D2C95C4D-9B44-4C8E-B6F1-5D6BF24F8549@.microsoft.com...
>I have an associate who needs Reporting Services 2005 installed. They do
>not
> have a Visual Studio 2005 license of any kind. Does this normally go on a
> desktop and if so, what is the minimum license required to remain
> compliant?
> THANK YOU in advance!|||Thanks, Bruce. What Version of VS Studio is included? I am in charge of
maintaining compliance and it would be nice to be able to use SMS and at a
glance know if the install of Visual Studio is a full-blown license or
derived from a license such RS 2005.
"Bruce L-C [MVP]" wrote:
> If you are talking about developing reports, no license is required for
> that. The server where the reports are being deployed need a license. Also,
> RS 2005 comes with its own version of VS so unless you are writing custom
> assemblies you do not need to purchase VS 2005.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "KC" <KC@.discussions.microsoft.com> wrote in message
> news:D2C95C4D-9B44-4C8E-B6F1-5D6BF24F8549@.microsoft.com...
> >I have an associate who needs Reporting Services 2005 installed. They do
> >not
> > have a Visual Studio 2005 license of any kind. Does this normally go on a
> > desktop and if so, what is the minimum license required to remain
> > compliant?
> >
> > THANK YOU in advance!
>
>|||I have no idea what it will show up as. It is a special version of VS that
can only host the BI tools. If you have VS 2005 it will integrate with that
instead. That is how I am running.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"KC" <KC@.discussions.microsoft.com> wrote in message
news:3EB7D2E7-FEB2-47CA-9B88-2EC83B6CF1C9@.microsoft.com...
> Thanks, Bruce. What Version of VS Studio is included? I am in charge of
> maintaining compliance and it would be nice to be able to use SMS and at a
> glance know if the install of Visual Studio is a full-blown license or
> derived from a license such RS 2005.
> "Bruce L-C [MVP]" wrote:
>> If you are talking about developing reports, no license is required for
>> that. The server where the reports are being deployed need a license.
>> Also,
>> RS 2005 comes with its own version of VS so unless you are writing custom
>> assemblies you do not need to purchase VS 2005.
>>
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>> "KC" <KC@.discussions.microsoft.com> wrote in message
>> news:D2C95C4D-9B44-4C8E-B6F1-5D6BF24F8549@.microsoft.com...
>> >I have an associate who needs Reporting Services 2005 installed. They
>> >do
>> >not
>> > have a Visual Studio 2005 license of any kind. Does this normally go
>> > on a
>> > desktop and if so, what is the minimum license required to remain
>> > compliant?
>> >
>> > THANK YOU in advance!
>>

Reporting Services Project Problem

Hi
Every Time I Try To Start Any Type Of Report Server Project Out Of Visual
Studio 2005 I Get The Following Error:
Could not load file or assembly 'Microsoft.ReportingServices.Designer,
Version=9.0.242.0, Culture=neutral, PublicKeyToken=87987fvf5665vv91' or one
of its dependencies. The system cannot find the file specified.
I'm Running SQL Dev Server 2005
Any idea what I screwed up'
ThanksHello Tom,
If the project was built with an older version (Beta) of the .NET Runtime
then you need to have the version installed in order for your app to run.
The alternative is to rebuild the component using the newer .NET Runtime
and this would be the recommended thing to do. After that you should no
longer be getting this error.
If the issue persists, you may want to consider reinstall .Net 2.0 and
repair VS 2005 to test the situation.
Regards,
Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Partner Support
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
=====================================================
This posting is provided "AS IS" with no warranties, and confers no rights.
>From: "TomH" <tofoz2@.newsgroups.nospam>
>Subject: Reporting Services Project Problem
>Date: Mon, 23 Jan 2006 09:24:26 -0500
>Lines: 17
>X-Priority: 3
>X-MSMail-Priority: Normal
>X-Newsreader: Microsoft Outlook Express 6.00.2900.2670
>X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2670
>X-RFC2646: Format=Flowed; Original
>Message-ID: <#HWDziCIGHA.604@.TK2MSFTNGP14.phx.gbl>
>Newsgroups: microsoft.public.sqlserver.reportingsvcs
>NNTP-Posting-Host: 66.216.157.250.static.dejazzd.com 66.216.157.250
>Path: TK2MSFTNGXA02.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTNGP14.phx.gbl
>Xref: TK2MSFTNGXA02.phx.gbl microsoft.public.sqlserver.reportingsvcs:67308
>X-Tomcat-NG: microsoft.public.sqlserver.reportingsvcs
>Hi
>Every Time I Try To Start Any Type Of Report Server Project Out Of Visual
>Studio 2005 I Get The Following Error:
>Could not load file or assembly 'Microsoft.ReportingServices.Designer,
>Version=9.0.242.0, Culture=neutral, PublicKeyToken=87987fvf5665vv91' or one
>of its dependencies. The system cannot find the file specified.
>
>I'm Running SQL Dev Server 2005
>Any idea what I screwed up'
>Thanks
>
>|||Tom, I have the same problem. Was wondering if you were able to
resolve this issue?
Thanks,
Adam
TomH wrote:
> Hi
> Every Time I Try To Start Any Type Of Report Server Project Out Of Visual
> Studio 2005 I Get The Following Error:
> Could not load file or assembly 'Microsoft.ReportingServices.Designer,
> Version=9.0.242.0, Culture=neutral, PublicKeyToken=87987fvf5665vv91' or one
> of its dependencies. The system cannot find the file specified.
>
> I'm Running SQL Dev Server 2005
> Any idea what I screwed up'
> Thankssql

reporting services on windows xp

hi all
I've just installed visual studio 2005 and I can not find reporting services
on my Windows XP machine.
Is this expected or am I doing something wrong ? ( because on another
Windows Server 2000, I saw that was installed ok )
thank you very muchIt doesn't get installed with VS2005. only SQL2005... and no. not Express.
"Traian Stoian" <traian@.gironde.ro> wrote in message
news:O6B9$aQTGHA.5172@.TK2MSFTNGP12.phx.gbl...
> hi all
> I've just installed visual studio 2005 and I can not find reporting
> services on my Windows XP machine.
> Is this expected or am I doing something wrong ? ( because on another
> Windows Server 2000, I saw that was installed ok )
> thank you very much
>
>|||Hi
thank you for your quick reply
The problem aroused after I was working on a tutorial (
http://msdn2.microsoft.com/en-us/library/ms170056.aspx ), that is using
reporting services, after I installed Visaul Studio 2005 Proffessional on my
Windows XP machine.
I think that I need to have an Windows server OS with SQL2005 to work on
this tutorial.
Please tell me if am I right.
thank you again
Traian Stoian
"Chris Taylor" <ctaylor7480@.newsgroups.nospam> wrote in message
news:%23%23J5fjQTGHA.4960@.TK2MSFTNGP12.phx.gbl...
> It doesn't get installed with VS2005. only SQL2005... and no. not
Express.
> "Traian Stoian" <traian@.gironde.ro> wrote in message
> news:O6B9$aQTGHA.5172@.TK2MSFTNGP12.phx.gbl...
> > hi all
> > I've just installed visual studio 2005 and I can not find reporting
> > services on my Windows XP machine.
> > Is this expected or am I doing something wrong ? ( because on another
> > Windows Server 2000, I saw that was installed ok )
> >
> > thank you very much
> >
> >
> >
> >
>|||You can install SQL 2005 developer. The designer works without a database,
it is only when you deploy that you need the server around. You can preview
reports, design reports without RS server installed.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Traian Stoian" <traian@.gironde.ro> wrote in message
news:uHQ5LkaTGHA.5884@.TK2MSFTNGP14.phx.gbl...
> Hi
> thank you for your quick reply
> The problem aroused after I was working on a tutorial (
> http://msdn2.microsoft.com/en-us/library/ms170056.aspx ), that is using
> reporting services, after I installed Visaul Studio 2005 Proffessional on
> my
> Windows XP machine.
> I think that I need to have an Windows server OS with SQL2005 to work on
> this tutorial.
> Please tell me if am I right.
> thank you again
> Traian Stoian
> "Chris Taylor" <ctaylor7480@.newsgroups.nospam> wrote in message
> news:%23%23J5fjQTGHA.4960@.TK2MSFTNGP12.phx.gbl...
>> It doesn't get installed with VS2005. only SQL2005... and no. not
> Express.
>> "Traian Stoian" <traian@.gironde.ro> wrote in message
>> news:O6B9$aQTGHA.5172@.TK2MSFTNGP12.phx.gbl...
>> > hi all
>> > I've just installed visual studio 2005 and I can not find reporting
>> > services on my Windows XP machine.
>> > Is this expected or am I doing something wrong ? ( because on another
>> > Windows Server 2000, I saw that was installed ok )
>> >
>> > thank you very much
>> >
>> >
>> >
>> >
>>
>

Reporting Services on windows XP

I installed Reporting Services onto my SQL 2000 Developer edition on
windows XP.
I can create reports in visual studio .net .
However I do not have a Report Manager in Start->All
Programs->Microsoft SQL Server-> Reporting Services
I am going through the samples so I can use Reporting Services in the
current project I am working on.
This sample requires Reports Manager
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/RSAMPLES/htm/rss_tutorials_v1_575g.asp
Is there anyway I can do this using Windows XP with Sql 2k Developer?
Also is it right that I shouldn't have the Report Manager icon on XP
or perhaps my installation went wrong ?
Thanks,
yurpsReport Manager is a web site (ASP.Net application). There is no icon or menu
for it. Try going to //localhost in IE. The default when installing is that
Report Manager becomes your default website. Also, if you look at SQL Server
you should see two db. ReportServer and ReportServerTempDB
--
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"magister" <yurps@.yahoo.co.uk> wrote in message
news:984bebc3.0501031053.2ff7af87@.posting.google.com...
> I installed Reporting Services onto my SQL 2000 Developer edition on
> windows XP.
> I can create reports in visual studio .net .
> However I do not have a Report Manager in Start->All
> Programs->Microsoft SQL Server-> Reporting Services
> I am going through the samples so I can use Reporting Services in the
> current project I am working on.
> This sample requires Reports Manager
>
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/RSAMPLES/htm/rss_tutorials_v1_575g.asp
> Is there anyway I can do this using Windows XP with Sql 2k Developer?
> Also is it right that I shouldn't have the Report Manager icon on XP
> or perhaps my installation went wrong ?
> Thanks,
> yurps|||Thanks for the reply.
No I don't have these in //localhost or the 2 db ReportServer &
ReportServerTempDB
Should these be installed on winXP Pro sql 2k developer ?
I will run thru the install again, maybe I need to reboot.
Thanks,
Matt|||Most likely you do not have IIS running. IIS needs to be running prior to
the install in order to install the server components.
--
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"yurps" <yurps@.yahoo.co.uk> wrote in message
news:1104784807.181616.141330@.f14g2000cwb.googlegroups.com...
> Thanks for the reply.
> No I don't have these in //localhost or the 2 db ReportServer &
> ReportServerTempDB
> Should these be installed on winXP Pro sql 2k developer ?
> I will run thru the install again, maybe I need to reboot.
> Thanks,
> Matt
>|||Most definately not, I uninstalled Reporting Services. I checked the
webserver was sending pages, and then reinstalled reporting services.
No go! No Reports or ReportServer folders in Inetsvr/wwwroot or
virtual directories in the IIS management console.
I am installing Reporting Services Evaluation Edition would this be a
factor.
Also I don't have my op system running on the C:\ drive it is on D:\
Also my sql server isn't on local it has a name...
Any ideas. I'm really stumped. or perhaps I need to reinstall
everything. 8(
Bruce L-C [MVP] wrote:
> Most likely you do not have IIS running. IIS needs to be running
prior to
> the install in order to install the server components.
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "yurps" <yurps@.yahoo.co.uk> wrote in message
> news:1104784807.181616.141330@.f14g2000cwb.googlegroups.com...
> > Thanks for the reply.
> >
> > No I don't have these in //localhost or the 2 db ReportServer &
> > ReportServerTempDB
> >
> > Should these be installed on winXP Pro sql 2k developer ?
> >
> > I will run thru the install again, maybe I need to reboot.
> > Thanks,
> > Matt
> >|||You are not getting any error messages?
If SQL Server is not running as the default instance that could be causing a
problem. I seem to remember that you have to do something different if this
is the case. My guess is that it would be similar as if you had SQL Server
on a different server. Evaluation edition should be working with developer
edition of SQL Server.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"yurps" <yurps@.yahoo.co.uk> wrote in message
news:1104788095.554304.294910@.z14g2000cwz.googlegroups.com...
> Most definately not, I uninstalled Reporting Services. I checked the
> webserver was sending pages, and then reinstalled reporting services.
> No go! No Reports or ReportServer folders in Inetsvr/wwwroot or
> virtual directories in the IIS management console.
> I am installing Reporting Services Evaluation Edition would this be a
> factor.
> Also I don't have my op system running on the C:\ drive it is on D:\
> Also my sql server isn't on local it has a name...
> Any ideas. I'm really stumped. or perhaps I need to reinstall
> everything. 8(
> Bruce L-C [MVP] wrote:
> > Most likely you do not have IIS running. IIS needs to be running
> prior to
> > the install in order to install the server components.
> >
> > --
> > Bruce Loehle-Conger
> > MVP SQL Server Reporting Services
> >
> > "yurps" <yurps@.yahoo.co.uk> wrote in message
> > news:1104784807.181616.141330@.f14g2000cwb.googlegroups.com...
> > > Thanks for the reply.
> > >
> > > No I don't have these in //localhost or the 2 db ReportServer &
> > > ReportServerTempDB
> > >
> > > Should these be installed on winXP Pro sql 2k developer ?
> > >
> > > I will run thru the install again, maybe I need to reboot.
> > > Thanks,
> > > Matt
> > >
>|||Well I uninstalled SQL, that's the only way to make it run as a default
instance, if you don't set it up that way.
...but unfortunately that didn't do, still no /Reports or
/ReportServer
virtual directories.
Errors ? the only entry in Event Viewer for Application id
8128 :
Using 'xpstar.dll' version '2000.80.760' to execute extended stored
procedure 'sp_MSgetversion'.
Hope this all does waste all the time it was meant to save.
Thanks,
Matt
Bruce L-C [MVP] wrote:
> You are not getting any error messages?
> If SQL Server is not running as the default instance that could be
causing a
> problem. I seem to remember that you have to do something different
if this
> is the case. My guess is that it would be similar as if you had SQL
Server
> on a different server. Evaluation edition should be working with
developer
> edition of SQL Server.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "yurps" <yurps@.yahoo.co.uk> wrote in message
> news:1104788095.554304.294910@.z14g2000cwz.googlegroups.com...
> > Most definately not, I uninstalled Reporting Services. I checked
the
> > webserver was sending pages, and then reinstalled reporting
services.
> > No go! No Reports or ReportServer folders in Inetsvr/wwwroot or
> > virtual directories in the IIS management console.
> >
> > I am installing Reporting Services Evaluation Edition would this be
a
> > factor.
> >
> > Also I don't have my op system running on the C:\ drive it is on
D:\
> >
> > Also my sql server isn't on local it has a name...
> >
> > Any ideas. I'm really stumped. or perhaps I need to reinstall
> > everything. 8(
> >
> > Bruce L-C [MVP] wrote:
> > > Most likely you do not have IIS running. IIS needs to be running
> > prior to
> > > the install in order to install the server components.
> > >
> > > --
> > > Bruce Loehle-Conger
> > > MVP SQL Server Reporting Services
> > >
> > > "yurps" <yurps@.yahoo.co.uk> wrote in message
> > > news:1104784807.181616.141330@.f14g2000cwb.googlegroups.com...
> > > > Thanks for the reply.
> > > >
> > > > No I don't have these in //localhost or the 2 db ReportServer &
> > > > ReportServerTempDB
> > > >
> > > > Should these be installed on winXP Pro sql 2k developer ?
> > > >
> > > > I will run thru the install again, maybe I need to reboot.
> > > > Thanks,
> > > > Matt
> > > >
> >|||Hmm, the version seems wrong. What version do you get if you do a select
@.@.version? You need to have sp3a installed on SQL Server and at least the
version mentioned below is not that (but could be the dll has a different
version which is why I asked you to do a select @.@.version).
--
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"yurps" <yurps@.yahoo.co.uk> wrote in message
news:1104798771.519440.231600@.f14g2000cwb.googlegroups.com...
> Well I uninstalled SQL, that's the only way to make it run as a default
> instance, if you don't set it up that way.
> ...but unfortunately that didn't do, still no /Reports or
> /ReportServer
> virtual directories.
> Errors ? the only entry in Event Viewer for Application id
> 8128 :
> Using 'xpstar.dll' version '2000.80.760' to execute extended stored
> procedure 'sp_MSgetversion'.
> Hope this all does waste all the time it was meant to save.
> Thanks,
> Matt
>
> Bruce L-C [MVP] wrote:
> > You are not getting any error messages?
> >
> > If SQL Server is not running as the default instance that could be
> causing a
> > problem. I seem to remember that you have to do something different
> if this
> > is the case. My guess is that it would be similar as if you had SQL
> Server
> > on a different server. Evaluation edition should be working with
> developer
> > edition of SQL Server.
> >
> >
> > --
> > Bruce Loehle-Conger
> > MVP SQL Server Reporting Services
> >
> > "yurps" <yurps@.yahoo.co.uk> wrote in message
> > news:1104788095.554304.294910@.z14g2000cwz.googlegroups.com...
> > > Most definately not, I uninstalled Reporting Services. I checked
> the
> > > webserver was sending pages, and then reinstalled reporting
> services.
> > > No go! No Reports or ReportServer folders in Inetsvr/wwwroot or
> > > virtual directories in the IIS management console.
> > >
> > > I am installing Reporting Services Evaluation Edition would this be
> a
> > > factor.
> > >
> > > Also I don't have my op system running on the C:\ drive it is on
> D:\
> > >
> > > Also my sql server isn't on local it has a name...
> > >
> > > Any ideas. I'm really stumped. or perhaps I need to reinstall
> > > everything. 8(
> > >
> > > Bruce L-C [MVP] wrote:
> > > > Most likely you do not have IIS running. IIS needs to be running
> > > prior to
> > > > the install in order to install the server components.
> > > >
> > > > --
> > > > Bruce Loehle-Conger
> > > > MVP SQL Server Reporting Services
> > > >
> > > > "yurps" <yurps@.yahoo.co.uk> wrote in message
> > > > news:1104784807.181616.141330@.f14g2000cwb.googlegroups.com...
> > > > > Thanks for the reply.
> > > > >
> > > > > No I don't have these in //localhost or the 2 db ReportServer &
> > > > > ReportServerTempDB
> > > > >
> > > > > Should these be installed on winXP Pro sql 2k developer ?
> > > > >
> > > > > I will run thru the install again, maybe I need to reboot.
> > > > > Thanks,
> > > > > Matt
> > > > >
> > >
>

Reporting Services in Sql Server 2005 - how to access?

Hello,
I have worked with Reporting services (only a few times - still a beginner)
for sql server 2000, and I access it through Visual Studio 2003. My place
upgraded VS to VS2005, and I don't see an icon for reporting services.
Still using Sql Server 2000 though. But our MSDN subscriptoin finally gave
us Sql Server 2005 Enterprise(not installed yet).
So my question is if Reporting services comes with Sql Server 2005
Enterprise? If so, how to access?
While I am at it, is there a way to access Reporting Services for sql Server
2000 from VS2005 or am I limited to VS2003 for that?
Thanks,
RichRS 2000 is a framework 1.1 product (VS 2003 is also framework 1.1). RS 2005
is a framework 2.0 app (as VS 2005 is). RS 2000 report designer cannot be
hosted in VS 2005. The RS 2005 report designer is part of the SQL Server
2005 install media. If you have VS 2005 installed it will integrate with it.
If you do not have VS 2005 installed then it installs a version of VS 2005
just for the report designer (so if you don't not have VS 2005 you do not
have to buy it).
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Rich" <Rich@.discussions.microsoft.com> wrote in message
news:C3541818-7B91-45D3-BCA8-A7AE292A7A6A@.microsoft.com...
> Hello,
> I have worked with Reporting services (only a few times - still a
> beginner)
> for sql server 2000, and I access it through Visual Studio 2003. My place
> upgraded VS to VS2005, and I don't see an icon for reporting services.
> Still using Sql Server 2000 though. But our MSDN subscriptoin finally
> gave
> us Sql Server 2005 Enterprise(not installed yet).
> So my question is if Reporting services comes with Sql Server 2005
> Enterprise? If so, how to access?
> While I am at it, is there a way to access Reporting Services for sql
> Server
> 2000 from VS2005 or am I limited to VS2003 for that?
> Thanks,
> Rich|||Thanks for your reply. I think we have the delux MSDN subscription. Gives
us everything. So yes, we have VS2005 installed. After a big ToDo (next
month) we will install Sql Server 2005. So, I am understanding then, that RS
2005 will install as part of the sql Server 2005 (enterprise) install? Well,
I guess I will find out. I hope RS2005 isn't quite as finicky as RS2003
(sometimes I can't preview reports from within the designer with RS2003 - get
weird error messages).
Rich
"Bruce L-C [MVP]" wrote:
> RS 2000 is a framework 1.1 product (VS 2003 is also framework 1.1). RS 2005
> is a framework 2.0 app (as VS 2005 is). RS 2000 report designer cannot be
> hosted in VS 2005. The RS 2005 report designer is part of the SQL Server
> 2005 install media. If you have VS 2005 installed it will integrate with it.
> If you do not have VS 2005 installed then it installs a version of VS 2005
> just for the report designer (so if you don't not have VS 2005 you do not
> have to buy it).
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "Rich" <Rich@.discussions.microsoft.com> wrote in message
> news:C3541818-7B91-45D3-BCA8-A7AE292A7A6A@.microsoft.com...
> > Hello,
> >
> > I have worked with Reporting services (only a few times - still a
> > beginner)
> > for sql server 2000, and I access it through Visual Studio 2003. My place
> > upgraded VS to VS2005, and I don't see an icon for reporting services.
> > Still using Sql Server 2000 though. But our MSDN subscriptoin finally
> > gave
> > us Sql Server 2005 Enterprise(not installed yet).
> >
> > So my question is if Reporting services comes with Sql Server 2005
> > Enterprise? If so, how to access?
> >
> > While I am at it, is there a way to access Reporting Services for sql
> > Server
> > 2000 from VS2005 or am I limited to VS2003 for that?
> >
> > Thanks,
> > Rich
>
>|||You have to select to install RS on the server (just like you have to select
the other services like integration services, analysis services,etc). The
designer is a client install.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Rich" <Rich@.discussions.microsoft.com> wrote in message
news:5C71BA15-6565-467F-87E2-F839F731920C@.microsoft.com...
> Thanks for your reply. I think we have the delux MSDN subscription.
> Gives
> us everything. So yes, we have VS2005 installed. After a big ToDo (next
> month) we will install Sql Server 2005. So, I am understanding then, that
> RS
> 2005 will install as part of the sql Server 2005 (enterprise) install?
> Well,
> I guess I will find out. I hope RS2005 isn't quite as finicky as RS2003
> (sometimes I can't preview reports from within the designer with RS2003 -
> get
> weird error messages).
> Rich
> "Bruce L-C [MVP]" wrote:
>> RS 2000 is a framework 1.1 product (VS 2003 is also framework 1.1). RS
>> 2005
>> is a framework 2.0 app (as VS 2005 is). RS 2000 report designer cannot be
>> hosted in VS 2005. The RS 2005 report designer is part of the SQL Server
>> 2005 install media. If you have VS 2005 installed it will integrate with
>> it.
>> If you do not have VS 2005 installed then it installs a version of VS
>> 2005
>> just for the report designer (so if you don't not have VS 2005 you do not
>> have to buy it).
>>
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>> "Rich" <Rich@.discussions.microsoft.com> wrote in message
>> news:C3541818-7B91-45D3-BCA8-A7AE292A7A6A@.microsoft.com...
>> > Hello,
>> >
>> > I have worked with Reporting services (only a few times - still a
>> > beginner)
>> > for sql server 2000, and I access it through Visual Studio 2003. My
>> > place
>> > upgraded VS to VS2005, and I don't see an icon for reporting services.
>> > Still using Sql Server 2000 though. But our MSDN subscriptoin finally
>> > gave
>> > us Sql Server 2005 Enterprise(not installed yet).
>> >
>> > So my question is if Reporting services comes with Sql Server 2005
>> > Enterprise? If so, how to access?
>> >
>> > While I am at it, is there a way to access Reporting Services for sql
>> > Server
>> > 2000 from VS2005 or am I limited to VS2003 for that?
>> >
>> > Thanks,
>> > Rich
>>|||Thank you for that tip. I am glad that I asked. So after I install RS on
the server, then I guess I run setup on the workstation and select client
tools or something?
"Bruce L-C [MVP]" wrote:
> You have to select to install RS on the server (just like you have to select
> the other services like integration services, analysis services,etc). The
> designer is a client install.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "Rich" <Rich@.discussions.microsoft.com> wrote in message
> news:5C71BA15-6565-467F-87E2-F839F731920C@.microsoft.com...
> > Thanks for your reply. I think we have the delux MSDN subscription.
> > Gives
> > us everything. So yes, we have VS2005 installed. After a big ToDo (next
> > month) we will install Sql Server 2005. So, I am understanding then, that
> > RS
> > 2005 will install as part of the sql Server 2005 (enterprise) install?
> > Well,
> > I guess I will find out. I hope RS2005 isn't quite as finicky as RS2003
> > (sometimes I can't preview reports from within the designer with RS2003 -
> > get
> > weird error messages).
> >
> > Rich
> >
> > "Bruce L-C [MVP]" wrote:
> >
> >> RS 2000 is a framework 1.1 product (VS 2003 is also framework 1.1). RS
> >> 2005
> >> is a framework 2.0 app (as VS 2005 is). RS 2000 report designer cannot be
> >> hosted in VS 2005. The RS 2005 report designer is part of the SQL Server
> >> 2005 install media. If you have VS 2005 installed it will integrate with
> >> it.
> >> If you do not have VS 2005 installed then it installs a version of VS
> >> 2005
> >> just for the report designer (so if you don't not have VS 2005 you do not
> >> have to buy it).
> >>
> >>
> >> --
> >> Bruce Loehle-Conger
> >> MVP SQL Server Reporting Services
> >>
> >> "Rich" <Rich@.discussions.microsoft.com> wrote in message
> >> news:C3541818-7B91-45D3-BCA8-A7AE292A7A6A@.microsoft.com...
> >> > Hello,
> >> >
> >> > I have worked with Reporting services (only a few times - still a
> >> > beginner)
> >> > for sql server 2000, and I access it through Visual Studio 2003. My
> >> > place
> >> > upgraded VS to VS2005, and I don't see an icon for reporting services.
> >> > Still using Sql Server 2000 though. But our MSDN subscriptoin finally
> >> > gave
> >> > us Sql Server 2005 Enterprise(not installed yet).
> >> >
> >> > So my question is if Reporting services comes with Sql Server 2005
> >> > Enterprise? If so, how to access?
> >> >
> >> > While I am at it, is there a way to access Reporting Services for sql
> >> > Server
> >> > 2000 from VS2005 or am I limited to VS2003 for that?
> >> >
> >> > Thanks,
> >> > Rich
> >>
> >>
> >>
>
>|||Yep.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Rich" <Rich@.discussions.microsoft.com> wrote in message
news:736D9C89-D8D0-46DE-A67C-750002DF8251@.microsoft.com...
> Thank you for that tip. I am glad that I asked. So after I install RS on
> the server, then I guess I run setup on the workstation and select client
> tools or something?
> "Bruce L-C [MVP]" wrote:
>> You have to select to install RS on the server (just like you have to
>> select
>> the other services like integration services, analysis services,etc). The
>> designer is a client install.
>>
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>> "Rich" <Rich@.discussions.microsoft.com> wrote in message
>> news:5C71BA15-6565-467F-87E2-F839F731920C@.microsoft.com...
>> > Thanks for your reply. I think we have the delux MSDN subscription.
>> > Gives
>> > us everything. So yes, we have VS2005 installed. After a big ToDo
>> > (next
>> > month) we will install Sql Server 2005. So, I am understanding then,
>> > that
>> > RS
>> > 2005 will install as part of the sql Server 2005 (enterprise) install?
>> > Well,
>> > I guess I will find out. I hope RS2005 isn't quite as finicky as
>> > RS2003
>> > (sometimes I can't preview reports from within the designer with
>> > RS2003 -
>> > get
>> > weird error messages).
>> >
>> > Rich
>> >
>> > "Bruce L-C [MVP]" wrote:
>> >
>> >> RS 2000 is a framework 1.1 product (VS 2003 is also framework 1.1). RS
>> >> 2005
>> >> is a framework 2.0 app (as VS 2005 is). RS 2000 report designer cannot
>> >> be
>> >> hosted in VS 2005. The RS 2005 report designer is part of the SQL
>> >> Server
>> >> 2005 install media. If you have VS 2005 installed it will integrate
>> >> with
>> >> it.
>> >> If you do not have VS 2005 installed then it installs a version of VS
>> >> 2005
>> >> just for the report designer (so if you don't not have VS 2005 you do
>> >> not
>> >> have to buy it).
>> >>
>> >>
>> >> --
>> >> Bruce Loehle-Conger
>> >> MVP SQL Server Reporting Services
>> >>
>> >> "Rich" <Rich@.discussions.microsoft.com> wrote in message
>> >> news:C3541818-7B91-45D3-BCA8-A7AE292A7A6A@.microsoft.com...
>> >> > Hello,
>> >> >
>> >> > I have worked with Reporting services (only a few times - still a
>> >> > beginner)
>> >> > for sql server 2000, and I access it through Visual Studio 2003. My
>> >> > place
>> >> > upgraded VS to VS2005, and I don't see an icon for reporting
>> >> > services.
>> >> > Still using Sql Server 2000 though. But our MSDN subscriptoin
>> >> > finally
>> >> > gave
>> >> > us Sql Server 2005 Enterprise(not installed yet).
>> >> >
>> >> > So my question is if Reporting services comes with Sql Server 2005
>> >> > Enterprise? If so, how to access?
>> >> >
>> >> > While I am at it, is there a way to access Reporting Services for
>> >> > sql
>> >> > Server
>> >> > 2000 from VS2005 or am I limited to VS2003 for that?
>> >> >
>> >> > Thanks,
>> >> > Rich
>> >>
>> >>
>> >>
>>

Reporting Services Has a problem with my Dynamic SQL

I have a stored proc that I can execute from Visual Studio, Query Analyzer,
and from within the "Design the Query" window in the Report Wizard. It
returns data in all cases. However, when I continue on with the wizard and
get to the "Design the Table" page, there are no fields in the "Available
Fields" list box. If I continue on and Finish, there an ugly error message
about "MS Development Environment is unable to load this document.
Deserialization failed: The element 'http://schemas..../reportdefinition:
TableCells' has incomplete content... An error occurred at , (33, 16)."
What is unusual is that it seems to bomb anytime I use dynamic SQL, but if I
use a local variable (casting a date as a string) it will work. If I use the
same local variable, and parse the incoming date parameter to the identical
date string, it will not work.
Here's the code... any help is appreciated.
ALTER PROCEDURE ggpappl.INCIDENT_SUMMARY_RPT
(
@.Shop varchar(15),
@.DateBgn datetime,
@.DateEnd datetime,
@.IncTypes varchar(4096)
)
AS
SET NOCOUNT ON
DECLARE
@.lv_shop varchar(15),
@.lv_types varchar(4096),
@.lv_SQL varchar(8000)
BEGIN
If IsNumeric(@.Shop) = 1
SET @.lv_shop = @.Shop
Else
SET @.lv_shop = '%'
SET @.lv_types = @.IncTypes
SET @.lv_types = Replace(@.lv_types, ', ', ''',''')
SET @.lv_types = ('''' + @.lv_types + '''')
SET @.lv_SQL = 'select ggptrk08.prod_ln_i, ' +
'ggptrk07.incdnt_typ_d, ' +
'ggptrk08.incdnt_strt_t, ' +
'ggptrk08.incdnt_end_t, ' +
'ggptrk08.incdnt_n, ' +
'Round(DateDiff(mi, ggptrk08.incdnt_strt_t, ISNULL(ggptrk08.incdnt_end_t,
getdate())), 2) Duration, ' +
'ggptrk08.mold_n, ' +
'ggptrk08.mount_sect_i, ' +
'ggptrk08.mount_pstn_i, ' +
'ggptrk06.incdnt_rsn_d, ' +
'ggptrk08.incdnt_cmnt_e, ' +
'ggptrk27.incdnt_actn_t, ' +
'ggptrk27.incdnt_solution_c, ' +
'ggptrk27.actn_cmnt, actn_wrkd_x, ' +
'SUBSTRING(ggpemp02_incident.emp_m, 1, 3) emp_incident, ' +
'SUBSTRING(ggpemp02_action.emp_m, 1, 3) emp_action ' +
'FROM ggp.GGPEMP02_EMP GGPEMP02_incident ' +
'RIGHT OUTER JOIN ggp.GGPTRK08_PROD_LN_INCDNT GGPTRK08 ON
GGPEMP02_incident.JDE_ADDR_BOOK_N = GGPTRK08.EMPL_JDE_ADDR_BOOK_N ' +
'LEFT OUTER JOIN ggp.GGPTRK06_INCDNT_RSN GGPTRK06 ON GGPTRK08.INCDNT_RSN_C
= GGPTRK06.INCDNT_RSN_C ' +
'LEFT OUTER JOIN ggp.GGPTRK07_INCDNT_TYP GGPTRK07 ON GGPTRK08.INCDNT_TYP_C
= GGPTRK07.INCDNT_TYP_C ' +
'LEFT OUTER JOIN ggp.GGPTRK27_INCDNT_ACTN GGPTRK27 ' +
'LEFT OUTER JOIN ggp.GGPEMP02_EMP GGPEMP02_action ON
GGPTRK27.EMPL_JDE_ADDR_BOOK_N = GGPEMP02_action.JDE_ADDR_BOOK_N ON ' +
'GGPTRK08.INCDNT_N = GGPTRK27.INCDNT_N ' +
'WHERE ggptrk08.prod_ln_i LIKE ''' + @.Shop + ''' ' +
'AND ggptrk08.incdnt_strt_t >= ''' + Cast(@.DateBgn AS varchar(20)) + '''
' +
'AND ggptrk08.incdnt_strt_t < ''' + Cast(@.DateEnd AS varchar(20)) + '''
' +
'AND ggptrk07.incdnt_typ_c IN(' + @.lv_types + ') ' +
'ORDER BY ' +
'ggptrk08.prod_ln_i, ' +
'ggptrk07.incdnt_typ_d, ' +
'ggptrk08.incdnt_strt_t'
Exec (@.lv_SQL)
ENDIt seems to me that Report Wizard cannot get field list because it is a
dynamic query.
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"JKramer" <JKramer@.discussions.microsoft.com> wrote in message
news:E9FF54EA-478F-4CE4-BC17-219BAA942D4D@.microsoft.com...
>I have a stored proc that I can execute from Visual Studio, Query Analyzer,
> and from within the "Design the Query" window in the Report Wizard. It
> returns data in all cases. However, when I continue on with the wizard and
> get to the "Design the Table" page, there are no fields in the "Available
> Fields" list box. If I continue on and Finish, there an ugly error message
> about "MS Development Environment is unable to load this document.
> Deserialization failed: The element 'http://schemas..../reportdefinition:
> TableCells' has incomplete content... An error occurred at , (33, 16)."
> What is unusual is that it seems to bomb anytime I use dynamic SQL, but if
> I
> use a local variable (casting a date as a string) it will work. If I use
> the
> same local variable, and parse the incoming date parameter to the
> identical
> date string, it will not work.
> Here's the code... any help is appreciated.
> ALTER PROCEDURE ggpappl.INCIDENT_SUMMARY_RPT
> (
> @.Shop varchar(15),
> @.DateBgn datetime,
> @.DateEnd datetime,
> @.IncTypes varchar(4096)
> )
> AS
> SET NOCOUNT ON
> DECLARE
> @.lv_shop varchar(15),
> @.lv_types varchar(4096),
> @.lv_SQL varchar(8000)
> BEGIN
> If IsNumeric(@.Shop) = 1
> SET @.lv_shop = @.Shop
> Else
> SET @.lv_shop = '%'
> SET @.lv_types = @.IncTypes
> SET @.lv_types = Replace(@.lv_types, ', ', ''',''')
> SET @.lv_types = ('''' + @.lv_types + '''')
> SET @.lv_SQL = 'select ggptrk08.prod_ln_i, ' +
> 'ggptrk07.incdnt_typ_d, ' +
> 'ggptrk08.incdnt_strt_t, ' +
> 'ggptrk08.incdnt_end_t, ' +
> 'ggptrk08.incdnt_n, ' +
> 'Round(DateDiff(mi, ggptrk08.incdnt_strt_t, ISNULL(ggptrk08.incdnt_end_t,
> getdate())), 2) Duration, ' +
> 'ggptrk08.mold_n, ' +
> 'ggptrk08.mount_sect_i, ' +
> 'ggptrk08.mount_pstn_i, ' +
> 'ggptrk06.incdnt_rsn_d, ' +
> 'ggptrk08.incdnt_cmnt_e, ' +
> 'ggptrk27.incdnt_actn_t, ' +
> 'ggptrk27.incdnt_solution_c, ' +
> 'ggptrk27.actn_cmnt, actn_wrkd_x, ' +
> 'SUBSTRING(ggpemp02_incident.emp_m, 1, 3) emp_incident, ' +
> 'SUBSTRING(ggpemp02_action.emp_m, 1, 3) emp_action ' +
> 'FROM ggp.GGPEMP02_EMP GGPEMP02_incident ' +
> 'RIGHT OUTER JOIN ggp.GGPTRK08_PROD_LN_INCDNT GGPTRK08 ON
> GGPEMP02_incident.JDE_ADDR_BOOK_N = GGPTRK08.EMPL_JDE_ADDR_BOOK_N ' +
> 'LEFT OUTER JOIN ggp.GGPTRK06_INCDNT_RSN GGPTRK06 ON GGPTRK08.INCDNT_RSN_C
> = GGPTRK06.INCDNT_RSN_C ' +
> 'LEFT OUTER JOIN ggp.GGPTRK07_INCDNT_TYP GGPTRK07 ON GGPTRK08.INCDNT_TYP_C
> = GGPTRK07.INCDNT_TYP_C ' +
> 'LEFT OUTER JOIN ggp.GGPTRK27_INCDNT_ACTN GGPTRK27 ' +
> 'LEFT OUTER JOIN ggp.GGPEMP02_EMP GGPEMP02_action ON
> GGPTRK27.EMPL_JDE_ADDR_BOOK_N = GGPEMP02_action.JDE_ADDR_BOOK_N ON ' +
> 'GGPTRK08.INCDNT_N = GGPTRK27.INCDNT_N ' +
> 'WHERE ggptrk08.prod_ln_i LIKE ''' + @.Shop + ''' ' +
> 'AND ggptrk08.incdnt_strt_t >= ''' + Cast(@.DateBgn AS varchar(20)) + '''
> ' +
> 'AND ggptrk08.incdnt_strt_t < ''' + Cast(@.DateEnd AS varchar(20)) + '''
> ' +
> 'AND ggptrk07.incdnt_typ_c IN(' + @.lv_types + ') ' +
> 'ORDER BY ' +
> 'ggptrk08.prod_ln_i, ' +
> 'ggptrk07.incdnt_typ_d, ' +
> 'ggptrk08.incdnt_strt_t'
> Exec (@.lv_SQL)
> END|||Hi JKramer,
yes, when you link a stored procedure to a dataset in report services
it queries the report and builds the list of columns returned from the
query.....this is very, very handy as you can name your fields
consistently and then copy reports and just change the stored procedure
the report uses and it will 'auto-magically' put the data into the
right fields in the datasets linked to tables and charts.....very very
handy...if you use strings like this I gather than you can not do
this...
I don't see why you would want to generate strings like this.....we
tried this and found performance around 50% down on just using straight
sql with variables in it....also with strings you are limited to 8000
characters which you may over-run without knowing it....we have
queries over 8000 characters....
We are yet to find a situation where we cannot make do with using sql
and not strings like this......
Best Regards
Peter
www.peternolan.com|||Peter,
The reason I use dynamic SQL is because one of the where conditions is a
LIKE condition, which I'm taking in as one string parameter. So the input
might be "21,22,23" or it might be "31". It is also dynamic, so I'm never
exactly sure what might be coming in (though I'm sure I won't hit the 8000
character limit). I don't know how to build that using straight SQL. If it
can be done, I agree, that's the way to go.
Can you tell me how I'd accomplish what I'm trying to do with straight SQL?
"Peter Nolan" wrote:
> Hi JKramer,
> yes, when you link a stored procedure to a dataset in report services
> it queries the report and builds the list of columns returned from the
> query.....this is very, very handy as you can name your fields
> consistently and then copy reports and just change the stored procedure
> the report uses and it will 'auto-magically' put the data into the
> right fields in the datasets linked to tables and charts.....very very
> handy...if you use strings like this I gather than you can not do
> this...
> I don't see why you would want to generate strings like this.....we
> tried this and found performance around 50% down on just using straight
> sql with variables in it....also with strings you are limited to 8000
> characters which you may over-run without knowing it....we have
> queries over 8000 characters....
> We are yet to find a situation where we cannot make do with using sql
> and not strings like this......
> Best Regards
> Peter
> www.peternolan.com
>|||In case anyone is interested, I think the problem is actually with the wizard
and not in the handling of the dynamic SQL. After re-reading the error, I got
to thinking the problem was in the *.rdl. So as I attempted to "fix" it (and
I'm not familiar enough with it to do so), I didn't help the issue at all. So
I copied the text of a different *.rdl inot the one I couldn't get to work
and saved it. When I opened it up, it opened just fine (of course the data
source was wrong, since it was copied from another). So I went to the data
tab, pointed it to the correct Stored Proc (still using dynamic SQL) and it
worked fine from there. So the problem was not the data source, but the
wizard.
Hopefully that helps anyone else who runs into this one.
Where does one post a bug for reporting services?
"JKramer" wrote:
> I have a stored proc that I can execute from Visual Studio, Query Analyzer,
> and from within the "Design the Query" window in the Report Wizard. It
> returns data in all cases. However, when I continue on with the wizard and
> get to the "Design the Table" page, there are no fields in the "Available
> Fields" list box. If I continue on and Finish, there an ugly error message
> about "MS Development Environment is unable to load this document.
> Deserialization failed: The element 'http://schemas..../reportdefinition:
> TableCells' has incomplete content... An error occurred at , (33, 16)."
> What is unusual is that it seems to bomb anytime I use dynamic SQL, but if I
> use a local variable (casting a date as a string) it will work. If I use the
> same local variable, and parse the incoming date parameter to the identical
> date string, it will not work.
> Here's the code... any help is appreciated.
> ALTER PROCEDURE ggpappl.INCIDENT_SUMMARY_RPT
> (
> @.Shop varchar(15),
> @.DateBgn datetime,
> @.DateEnd datetime,
> @.IncTypes varchar(4096)
> )
> AS
> SET NOCOUNT ON
> DECLARE
> @.lv_shop varchar(15),
> @.lv_types varchar(4096),
> @.lv_SQL varchar(8000)
> BEGIN
> If IsNumeric(@.Shop) = 1
> SET @.lv_shop = @.Shop
> Else
> SET @.lv_shop = '%'
> SET @.lv_types = @.IncTypes
> SET @.lv_types = Replace(@.lv_types, ', ', ''',''')
> SET @.lv_types = ('''' + @.lv_types + '''')
> SET @.lv_SQL = 'select ggptrk08.prod_ln_i, ' +
> 'ggptrk07.incdnt_typ_d, ' +
> 'ggptrk08.incdnt_strt_t, ' +
> 'ggptrk08.incdnt_end_t, ' +
> 'ggptrk08.incdnt_n, ' +
> 'Round(DateDiff(mi, ggptrk08.incdnt_strt_t, ISNULL(ggptrk08.incdnt_end_t,
> getdate())), 2) Duration, ' +
> 'ggptrk08.mold_n, ' +
> 'ggptrk08.mount_sect_i, ' +
> 'ggptrk08.mount_pstn_i, ' +
> 'ggptrk06.incdnt_rsn_d, ' +
> 'ggptrk08.incdnt_cmnt_e, ' +
> 'ggptrk27.incdnt_actn_t, ' +
> 'ggptrk27.incdnt_solution_c, ' +
> 'ggptrk27.actn_cmnt, actn_wrkd_x, ' +
> 'SUBSTRING(ggpemp02_incident.emp_m, 1, 3) emp_incident, ' +
> 'SUBSTRING(ggpemp02_action.emp_m, 1, 3) emp_action ' +
> 'FROM ggp.GGPEMP02_EMP GGPEMP02_incident ' +
> 'RIGHT OUTER JOIN ggp.GGPTRK08_PROD_LN_INCDNT GGPTRK08 ON
> GGPEMP02_incident.JDE_ADDR_BOOK_N = GGPTRK08.EMPL_JDE_ADDR_BOOK_N ' +
> 'LEFT OUTER JOIN ggp.GGPTRK06_INCDNT_RSN GGPTRK06 ON GGPTRK08.INCDNT_RSN_C
> = GGPTRK06.INCDNT_RSN_C ' +
> 'LEFT OUTER JOIN ggp.GGPTRK07_INCDNT_TYP GGPTRK07 ON GGPTRK08.INCDNT_TYP_C
> = GGPTRK07.INCDNT_TYP_C ' +
> 'LEFT OUTER JOIN ggp.GGPTRK27_INCDNT_ACTN GGPTRK27 ' +
> 'LEFT OUTER JOIN ggp.GGPEMP02_EMP GGPEMP02_action ON
> GGPTRK27.EMPL_JDE_ADDR_BOOK_N = GGPEMP02_action.JDE_ADDR_BOOK_N ON ' +
> 'GGPTRK08.INCDNT_N = GGPTRK27.INCDNT_N ' +
> 'WHERE ggptrk08.prod_ln_i LIKE ''' + @.Shop + ''' ' +
> 'AND ggptrk08.incdnt_strt_t >= ''' + Cast(@.DateBgn AS varchar(20)) + '''
> ' +
> 'AND ggptrk08.incdnt_strt_t < ''' + Cast(@.DateEnd AS varchar(20)) + '''
> ' +
> 'AND ggptrk07.incdnt_typ_c IN(' + @.lv_types + ') ' +
> 'ORDER BY ' +
> 'ggptrk08.prod_ln_i, ' +
> 'ggptrk07.incdnt_typ_d, ' +
> 'ggptrk08.incdnt_strt_t'
> Exec (@.lv_SQL)
> END|||In general with Stored Procedures I very seldom use the Report Wizard. I
create a new report, go to the data tab and set it up, then to layout and
drag and drop the table. Right mouse click on a column to add additional
columns. Or, start off with a query that has the appropriate fields, use the
wizard and then change to a stored procedure.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"JKramer" <JKramer@.discussions.microsoft.com> wrote in message
news:75EEA5FA-0373-420B-B90E-0CF660220EF2@.microsoft.com...
> In case anyone is interested, I think the problem is actually with the
> wizard
> and not in the handling of the dynamic SQL. After re-reading the error, I
> got
> to thinking the problem was in the *.rdl. So as I attempted to "fix" it
> (and
> I'm not familiar enough with it to do so), I didn't help the issue at all.
> So
> I copied the text of a different *.rdl inot the one I couldn't get to work
> and saved it. When I opened it up, it opened just fine (of course the data
> source was wrong, since it was copied from another). So I went to the data
> tab, pointed it to the correct Stored Proc (still using dynamic SQL) and
> it
> worked fine from there. So the problem was not the data source, but the
> wizard.
> Hopefully that helps anyone else who runs into this one.
> Where does one post a bug for reporting services?
> "JKramer" wrote:
>> I have a stored proc that I can execute from Visual Studio, Query
>> Analyzer,
>> and from within the "Design the Query" window in the Report Wizard. It
>> returns data in all cases. However, when I continue on with the wizard
>> and
>> get to the "Design the Table" page, there are no fields in the "Available
>> Fields" list box. If I continue on and Finish, there an ugly error
>> message
>> about "MS Development Environment is unable to load this document.
>> Deserialization failed: The element
>> 'http://schemas..../reportdefinition:
>> TableCells' has incomplete content... An error occurred at , (33, 16)."
>> What is unusual is that it seems to bomb anytime I use dynamic SQL, but
>> if I
>> use a local variable (casting a date as a string) it will work. If I use
>> the
>> same local variable, and parse the incoming date parameter to the
>> identical
>> date string, it will not work.
>> Here's the code... any help is appreciated.
>> ALTER PROCEDURE ggpappl.INCIDENT_SUMMARY_RPT
>> (
>> @.Shop varchar(15),
>> @.DateBgn datetime,
>> @.DateEnd datetime,
>> @.IncTypes varchar(4096)
>> )
>> AS
>> SET NOCOUNT ON
>> DECLARE
>> @.lv_shop varchar(15),
>> @.lv_types varchar(4096),
>> @.lv_SQL varchar(8000)
>> BEGIN
>> If IsNumeric(@.Shop) = 1
>> SET @.lv_shop = @.Shop
>> Else
>> SET @.lv_shop = '%'
>> SET @.lv_types = @.IncTypes
>> SET @.lv_types = Replace(@.lv_types, ', ', ''',''')
>> SET @.lv_types = ('''' + @.lv_types + '''')
>> SET @.lv_SQL = 'select ggptrk08.prod_ln_i, ' +
>> 'ggptrk07.incdnt_typ_d, ' +
>> 'ggptrk08.incdnt_strt_t, ' +
>> 'ggptrk08.incdnt_end_t, ' +
>> 'ggptrk08.incdnt_n, ' +
>> 'Round(DateDiff(mi, ggptrk08.incdnt_strt_t, ISNULL(ggptrk08.incdnt_end_t,
>> getdate())), 2) Duration, ' +
>> 'ggptrk08.mold_n, ' +
>> 'ggptrk08.mount_sect_i, ' +
>> 'ggptrk08.mount_pstn_i, ' +
>> 'ggptrk06.incdnt_rsn_d, ' +
>> 'ggptrk08.incdnt_cmnt_e, ' +
>> 'ggptrk27.incdnt_actn_t, ' +
>> 'ggptrk27.incdnt_solution_c, ' +
>> 'ggptrk27.actn_cmnt, actn_wrkd_x, ' +
>> 'SUBSTRING(ggpemp02_incident.emp_m, 1, 3) emp_incident, ' +
>> 'SUBSTRING(ggpemp02_action.emp_m, 1, 3) emp_action ' +
>> 'FROM ggp.GGPEMP02_EMP GGPEMP02_incident ' +
>> 'RIGHT OUTER JOIN ggp.GGPTRK08_PROD_LN_INCDNT GGPTRK08 ON
>> GGPEMP02_incident.JDE_ADDR_BOOK_N = GGPTRK08.EMPL_JDE_ADDR_BOOK_N ' +
>> 'LEFT OUTER JOIN ggp.GGPTRK06_INCDNT_RSN GGPTRK06 ON
>> GGPTRK08.INCDNT_RSN_C
>> = GGPTRK06.INCDNT_RSN_C ' +
>> 'LEFT OUTER JOIN ggp.GGPTRK07_INCDNT_TYP GGPTRK07 ON
>> GGPTRK08.INCDNT_TYP_C
>> = GGPTRK07.INCDNT_TYP_C ' +
>> 'LEFT OUTER JOIN ggp.GGPTRK27_INCDNT_ACTN GGPTRK27 ' +
>> 'LEFT OUTER JOIN ggp.GGPEMP02_EMP GGPEMP02_action ON
>> GGPTRK27.EMPL_JDE_ADDR_BOOK_N = GGPEMP02_action.JDE_ADDR_BOOK_N ON ' +
>> 'GGPTRK08.INCDNT_N = GGPTRK27.INCDNT_N ' +
>> 'WHERE ggptrk08.prod_ln_i LIKE ''' + @.Shop + ''' ' +
>> 'AND ggptrk08.incdnt_strt_t >= ''' + Cast(@.DateBgn AS varchar(20)) + '''
>> ' +
>> 'AND ggptrk08.incdnt_strt_t < ''' + Cast(@.DateEnd AS varchar(20)) + '''
>> ' +
>> 'AND ggptrk07.incdnt_typ_c IN(' + @.lv_types + ') ' +
>> 'ORDER BY ' +
>> 'ggptrk08.prod_ln_i, ' +
>> 'ggptrk07.incdnt_typ_d, ' +
>> 'ggptrk08.incdnt_strt_t'
>> Exec (@.lv_SQL)
>> END|||Hi JKramer,
does it recognise the fieds being returned or do you have to type them
into the dataset? When you add a dataset to a report it automatically
adds the parameters and the fields returned from the SP...this is what
I was saying was useful...I gave up on wizards almost
immediately...they are just WAY too limited....we set up templates and
put the templates into a vs directory and they appear as templates when
we create a new report..although most of the time we just copy reports
anyway...
Peter|||It appears that a lot of folks have raised this issue also, but there was
never a concreate solution from the MFST experts?
Here is an example of a stored procedure that creates a dynamic query. I am
using a simple example to demonstrate the problem that can be recreated
easily, so please do not reply and said "why dont you use a straight select
statement instead?"
Create PROCEDURE dbo.QuarterlyReportingTest
@.CustomerPk int
AS
declare @.SQL varchar(2000)
select @.SQL = 'select * from [DataWarehouse].dbo.CustomerDim where
CustomerPk = ' + convert(varchar(10), @.CustomerPk)
exec (@.SQL)
This query will return the particular rows of information depending on the
report parameter @.CustomerPk
In RS, the dataset was setup as command type of 'Stored Procedure'. The
query string field has 'QuarterlyReportingTest'. When I clicked the '!', it
will prompt me for the CustomerPk. I would enter the CustomerPk, and it will
return the appropriate data.
The problem is, the DataSet fields remain blank. I can click the "Refresh
field" button, but the DataSet fields are still blank. Of course, without
the DataSet field, you cannot go and create the report, and report rendering
would also have error because there are no fields associated with the dataset.
Can anyone help in this so that the Dataset fields are populated / available
for these dynamic queries stored procedures?
Thanks.
LBJOHN99@.yahoo.com|||Hi JKramer,
can you use 'in' and just pass this set of values?
Also, I just got my copy of hitchhikers guide to SQL Server 2000 and
there is a specific example of this on pages 535 and 536. Since I'm a
believer in guys getting paid for their books I won't write the example
here...but they provide an example of picking multiple values from a
parameter in 2000 and then passing it through to a query making it safe
from SQL Injection along the way....the example is selecting a set of
employee ids from a list and printing the employee details...
Not sure if this would be applicable to your specific problem...but if
you know someone near you with a copy of the book you can look and see.
Best Regards
Peter Nolan
www.peternolan.com

Reporting Services Formatting Problem(s)

Hi. We seem to be having some recurring formatting issues with
Reporting Services (SQL 2005) and Visual Studio (2005).
We have a report that basically shows one record per page (it's used
to produce award-type certificates). We want the info centered on the
page, both horizontally and vertically. When we run the report, it
centers the info on the page one (the first record); however, all the
subsequent pages don't adjust to the centering, the text is just at
the top of the page. It seems like Visual Studio isn't re-formatting,
or re-running the report for pages 2 - the end. We tried deploying the
report, thinking that would force the report to reformat for the
remaining pages, but it didn't work. The formatting itself seems to
be ok because it adjusts the first page to anything we want - it's
just everything after the first page that doesn't change. Any ideas
would be appreciated - we're heading a roadblock!
Thanks!Have you tried putting your controls inside a rectangle?
--
Andy Potter
blog : http://sqlreportingservices.spaces.live.com
info@.(NOSPAM)lakeclaireenterprises.com
<alisonrhae@.hotmail.com> wrote in message
news:1176477583.112580.97300@.q75g2000hsh.googlegroups.com...
> Hi. We seem to be having some recurring formatting issues with
> Reporting Services (SQL 2005) and Visual Studio (2005).
> We have a report that basically shows one record per page (it's used
> to produce award-type certificates). We want the info centered on the
> page, both horizontally and vertically. When we run the report, it
> centers the info on the page one (the first record); however, all the
> subsequent pages don't adjust to the centering, the text is just at
> the top of the page. It seems like Visual Studio isn't re-formatting,
> or re-running the report for pages 2 - the end. We tried deploying the
> report, thinking that would force the report to reformat for the
> remaining pages, but it didn't work. The formatting itself seems to
> be ok because it adjusts the first page to anything we want - it's
> just everything after the first page that doesn't change. Any ideas
> would be appreciated - we're heading a roadblock!
> Thanks!
>|||On Apr 13, 12:47 pm, "Andy Potter" <i...@.lakeclaireenterprises.com>
wrote:
> Have you tried putting your controls inside a rectangle?
> --
> Andy Potter
> blog :http://sqlreportingservices.spaces.live.com
> info@.(NOSPAM)lakeclaireenterprises.com<alisonr...@.hotmail.com> wrote in message
> news:1176477583.112580.97300@.q75g2000hsh.googlegroups.com...
No, but I will. The only thing on the report page at this point is a
a single table with 1 column and 4 rows of information. Thanks for the
thought!
Alison Mumaugh

Reporting Services Designer Install/Product Key

We installed reporting services on our MS SBS Premium server. The
installation was fine, except that the machine doesn't have Visual Studio
tools. No worries-- since we plan to develop reports on client machines with
VS.
That's where the problem is: we can't install the RS designer on the client
machines with VS 2003. When we get to the product key page, we enter in the
same key that worked for the SBS-P machine, but no love. Message: "This is
an invalid Product Key value. Please check the number located on your Product
Key sticker." The number we enter is the same as both the sticker on the
server case and the reg key on the server.
What do I need to do to install the designer for VS?Anyone have a possible solution to the product key problem with Small
Business Server 2003 Premium?
"New to the game" wrote:
> We installed reporting services on our MS SBS Premium server. The
> installation was fine, except that the machine doesn't have Visual Studio
> tools. No worries-- since we plan to develop reports on client machines with
> VS.
> That's where the problem is: we can't install the RS designer on the client
> machines with VS 2003. When we get to the product key page, we enter in the
> same key that worked for the SBS-P machine, but no love. Message: "This is
> an invalid Product Key value. Please check the number located on your Product
> Key sticker." The number we enter is the same as both the sticker on the
> server case and the reg key on the server.
> What do I need to do to install the designer for VS?

Reporting Services Data Extension - Passing Report Parameters

I have created a custom data extension.

I am using this custom data extension from BI Studio.

Que1: I want to create report parameters from BI studio and capture them in my Data Extension.

Que2: Every report parameter has so many properties, like hidden, internal, default value etc, how do capture that information in my data extension, the parameters only give me name and value.

Que3: I know I can capture command Text. So My command can be Select * From tablename where fieldname= @.myFieldname. Once I get this commandText in my data extension, How do extract parameters of the command?

Que4: If I have any custom attributes in my RDL file, Can I capture them in my Data Extension ?

Any help is appreciated...

Anybody, Any suggestions, please.....

Reporting Services Currency (￡)

I am trying to produce a report showing Currency in ￡ using Visual Studio 2005 reporting services.

On trying to format the textbox the only option that it seems to give you is for it to be displayed in $.

Does anyone know how i can display a number in ￡ instead of $?

Try putting something like this in your format code:

￡ ###,###,###.##

Depending on how large your numbers could get, just add #'s. It doesn't add leading 0's.

Hope this helps.

Jarret

|||

Another way to do this is to set the language property of the report to 'English (United Kingdom)', then set your fields to display with the format code of 'C' (currency). It will automatically set the default currency symbol for that language on any fields set for currency.

Jarret

Reporting Services Currency (£)

I am trying to produce a report showing Currency in ￡ using Visual Studio 2005 reporting services.

On trying to format the textbox the only option that it seems to give you is for it to be displayed in $.

Does anyone know how i can display a number in ￡ instead of $?

Try putting something like this in your format code:

￡ ###,###,###.##

Depending on how large your numbers could get, just add #'s. It doesn't add leading 0's.

Hope this helps.

Jarret

|||

Another way to do this is to set the language property of the report to 'English (United Kingdom)', then set your fields to display with the format code of 'C' (currency). It will automatically set the default currency symbol for that language on any fields set for currency.

Jarret