Sql Report protection: studio

Showing posts with label studio. Show all posts

Friday, March 30, 2012

Report, Data sources errors.

Hi,

I have created several reports with Reporting Services and Visual Studio 2005 for an ASP.NET 2 application.

Now, when I want to edit a report and I select Report -> Data Sources in the Visual Studio menu, I get the error "prefix " cannot be mapped to namespace name "xml" or "xmlns". Line 1 position 87." My website datasources are empty and I can't build new reports.

Any idea ?

Thanks for your help.

Nicolas.

I am having this same problem. Does anyone have a solution.

I was able to make 2 Reports, and as I was working on my third report today the same error occured.

When i open the pervious reports i made (which still work), and goto Report > Data Sources I also get the error message:

Prefix '' cannot be mapped to namespace name reserved for "xml" or "xmls". Line 1, position 87

Any help is appreciated - thanks.

sql

Wednesday, March 28, 2012

Report vs software

Hello,
I'm new in this issue of reporting.
Can some one tell me if is it necessary the installation of Visual Studio
.NET in the PC of a end user so he can exctract dinamic reports?
Besta Regars
ThanksA web navigator would be enough !
"Zurga" <Zurga@.discussions.microsoft.com> a écrit dans le message de news:
F36D4C94-FD59-4B25-B29A-9637B89DB1AA@.microsoft.com...
> Hello,
> I'm new in this issue of reporting.
> Can some one tell me if is it necessary the installation of Visual Studio
> .NET in the PC of a end user so he can exctract dinamic reports?
> Besta Regars
> Thanks
>|||You need to install Visual Studio to perform report design but an end user
would normally only need a web browser (internet explorer) to view, print
and export report data.
Good luck!
Dan
"Zurga" <Zurga@.discussions.microsoft.com> wrote in message
news:F36D4C94-FD59-4B25-B29A-9637B89DB1AA@.microsoft.com...
> Hello,
> I'm new in this issue of reporting.
> Can some one tell me if is it necessary the installation of Visual Studio
> .NET in the PC of a end user so he can exctract dinamic reports?
> Besta Regars
> Thanks
>

Report Viewer vs Report Server

Bonjour!
I deploy a report with Report viewer (Visual Studio 2005) on our web site
and it's working fine, I use the Integrated security. When I try to access
the same report but on the report server I have an authentication error but
with RV it's OK. This means it doesn't talk to the server the same way. Does
someone have hit that problem'
Regards, Joel:)On Nov 7, 9:38 am, Joel <J...@.discussions.microsoft.com> wrote:
> Bonjour!
> I deploy a report with Report viewer (Visual Studio 2005) on our web site
> and it's working fine, I use the Integrated security. When I try to access
> the same report but on the report server I have an authentication error but
> with RV it's OK. This means it doesn't talk to the server the same way. Does
> someone have hit that problem'
> Regards, Joel:)
Hello Joel, you may need to post more specifics on your authentication
setup.
I assume that by deploying "on our web site" you mean that you are
including a Reporting Services report as an object in a ASP.NET page
using the ReportViewer object. Authentication here is a local data
source connecting one-hop to a data source, pulling the data back to
the client and rendering on the client. When deploying to a Reporting
Server, the RS connects to the DS, pulls the data to the RS, renders
it to HTML, and sends the HTML to the client (you).
Check that you deployed to your Reporting Server using
"OverwriteDataSources" at least once, so the .ds files are actually
accessable. Then check the permissions on the Server, making sure
that the "user" that logs into the Reporting Services server has
permission to read from the data source.
Or you may have the "double hop" issue. You are at your desktop, NT
Authenticating to the Reporting Server, which should be sending your
authentication information to a SQL Server using NT Authentication.
This has failed at our company, and required a long process to get it
fixed. Here's the microsoft link: http://support.microsoft.com/kb/264921/
or just search on "double hop" to find solutions.
-- Scott|||Thanks Scott, that's exactly what I'm doing, I will try the "Overwrite"
Regards, Joel :)
"Orne" wrote:
> On Nov 7, 9:38 am, Joel <J...@.discussions.microsoft.com> wrote:
> > Bonjour!
> > I deploy a report with Report viewer (Visual Studio 2005) on our web site
> > and it's working fine, I use the Integrated security. When I try to access
> > the same report but on the report server I have an authentication error but
> > with RV it's OK. This means it doesn't talk to the server the same way. Does
> > someone have hit that problem'
> >
> > Regards, Joel:)
> Hello Joel, you may need to post more specifics on your authentication
> setup.
> I assume that by deploying "on our web site" you mean that you are
> including a Reporting Services report as an object in a ASP.NET page
> using the ReportViewer object. Authentication here is a local data
> source connecting one-hop to a data source, pulling the data back to
> the client and rendering on the client. When deploying to a Reporting
> Server, the RS connects to the DS, pulls the data to the RS, renders
> it to HTML, and sends the HTML to the client (you).
> Check that you deployed to your Reporting Server using
> "OverwriteDataSources" at least once, so the .ds files are actually
> accessable. Then check the permissions on the Server, making sure
> that the "user" that logs into the Reporting Services server has
> permission to read from the data source.
> Or you may have the "double hop" issue. You are at your desktop, NT
> Authenticating to the Reporting Server, which should be sending your
> authentication information to a SQL Server using NT Authentication.
> This has failed at our company, and required a long process to get it
> fixed. Here's the microsoft link: http://support.microsoft.com/kb/264921/
> or just search on "double hop" to find solutions.
> -- Scott
>

Monday, March 26, 2012

Report Viewer Issue in Visual Studio 2005 Beta 2. for Microsoft Reporting Services

I am trying to display Microsoft Reporting Service Reports from windows application.

I have application window with Report viewer control.

I have assigned valid path and URI from Server report properties in report viewer control. When I try to display the reports

Error is "

"The attempt to connect to the report server failed. Check your connection information and that the report server is compaitble version. The request failed with HTTP status 404: Not Found.

Please help me..Do I need to set any credential for my reportviewer control? then how?

this.reportViewer1.ServerReport.DisplayName = "SampleReport";

this.reportViewer1.ServerReport.ReportPath = "/SampleReportFolder/SampleReport";

this.reportViewer1.ServerReport.ReportServerUrl = new System.Uri("http://laptop/reportserver", System.UriKind.Absolute);

thanks in advance.

KamalKamal,

What version of Report Server are you connecting to? The ReportViewer control is not compatible with SQL Server 2000 Reporting Services. You need the April CTP of Report Server. Your code looks OK otherwise.

Rajeev|||

I do have the same problem. My installation is:

- VS.NET 2003
- Sql Server 2000 Dev
- Reporting Services for Sql Server 2000 + SP1
- VS.NET 2005 Beta 2
- Sql Server 2005 CTP April 2005

I would like to use VS.NET 2005 Beta 2 under "Go live license" but need the Sql Server 2000 Reporting Services as my customer will not upgrade a existing Sql Server 2000 installation.

Is it possible to use this combination?

Thanks,
Dirk

|||

Please make sure your setting in your webconfig

[Thanks to Akilal_MSFT]

- fix the ReportService.asmx error with replacing the <assemblies> section in the <system.web> section of the C:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting Services\ReportServer\web.config file:

Make sure the web.config files for reportserver and reportmanager have full access:
Change the following line in both web.config files:
<trust level="Full" originUrl="" />
Location: C:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting Services\ReportServer
and: C:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting Services\ReportManager

|||

Hai,
I create a window application and i wish to use the report viewer to view the reports that published to the server. Here is my code in VB.NEt

ReportViewer1.ServerReport.DisplayName = "SampleReport"

ReportViewer1.ServerReport.ReportPath = "/SampleReport/Report1"

ReportViewer1.ServerReport.ReportServerUrl = New System.Uri("http://localhost/reportserver")

Is there any problem to my code? why the report viewer didnt show anything and no error occured when i run the application?

the real path to show the report using report manager is as below:
http://localhost/ReportServer/Pages/ReportViewer.aspx?/SampleReport/Report1&rs:Command=Render
Am i need to change the reportpath same as above?

Another question is : Can i print the reports using my application? means i press a button print in my application and then the report can be print without using the report viewer.

Kindly wait for your reply.
Please email to me too if possible : elainelikim@.gmail.com

|||Did you find the solution to the above problem? I am having a similar issue. I add a reportviewer control in my webapp. I am using the ServerReprot and did specify report path etc. When I view the form, I can see the parameter page for the report fine but when I click on View report button, it basically does not do anything.
Thanks|||

Your issue is because it is SQL 2k RS you are hitting.

I have the same issue and have not found the resolution yet.

Except I have read things suggesting the VS05 ReportViewer does not work with SQL 2000 RS. I suppose it seems right to me; I have resorted to a Web Browser control in WinForms as a temp fix to the issue.

Report Viewer Issue in Visual Studio 2005 Beta 2. for Microsoft Reporting Services

I am trying to display Microsoft Reporting Service Reports from windows application.

I have application window with Report viewer control.

I have assigned valid path and URI from Server report properties in report viewer control. When I try to display the reports

Error is "

"The attempt to connect to the report server failed. Check your connection information and that the report server is compaitble version. The request failed with HTTP status 404: Not Found.

Please help me..Do I need to set any credential for my reportviewer control? then how?

this.reportViewer1.ServerReport.DisplayName = "SampleReport";

this.reportViewer1.ServerReport.ReportPath = "/SampleReportFolder/SampleReport";

this.reportViewer1.ServerReport.ReportServerUrl = new System.Uri("http://laptop/reportserver", System.UriKind.Absolute);

thanks in advance.

KamalKamal,

Rajeev
|||

I do have the same problem. My installation is:

- VS.NET 2003
- Sql Server 2000 Dev
- Reporting Services for Sql Server 2000 + SP1
- VS.NET 2005 Beta 2
- Sql Server 2005 CTP April 2005

I would like to use VS.NET 2005 Beta 2 under "Go live license" but need the Sql Server 2000 Reporting Services as my customer will not upgrade a existing Sql Server 2000 installation.

Is it possible to use this combination?

Thanks,
Dirk

|||

Please make sure your setting in your webconfig

[Thanks to Akilal_MSFT]

|||

Hai,
I create a window application and i wish to use the report viewer to view the reports that published to the server. Here is my code in VB.NEt

ReportViewer1.ServerReport.DisplayName = "SampleReport"

ReportViewer1.ServerReport.ReportPath = "/SampleReport/Report1"

ReportViewer1.ServerReport.ReportServerUrl = New System.Uri("http://localhost/reportserver")

Is there any problem to my code? why the report viewer didnt show anything and no error occured when i run the application?

Another question is : Can i print the reports using my application? means i press a button print in my application and then the report can be print without using the report viewer.

Kindly wait for your reply.
Please email to me too if possible : elainelikim@.gmail.com

Your issue is because it is SQL 2k RS you are hitting.

I have the same issue and have not found the resolution yet.

Friday, March 23, 2012

Report Viewer display problem

Hi,
I use reportviewer.dll in my aspx page, and everything works fine on my
development pc where sqlserver, reporting service and visual studio
installed. But when i try to access this page from another pc, iframe which
holds reportviewer gives me "The page cannot be displayed. The page you are
looking for is currently unavailable.....". Other stuff like ascx,
menus,gif are working well. Any suggestions?
Thanks.Ever find a solution to this?
"saglamtimur" wrote:
> Hi,
> I use reportviewer.dll in my aspx page, and everything works fine on my
> development pc where sqlserver, reporting service and visual studio
> installed. But when i try to access this page from another pc, iframe which
> holds reportviewer gives me "The page cannot be displayed. The page you are
> looking for is currently unavailable.....". Other stuff like ascx,
> menus,gif are working well. Any suggestions?
> Thanks.
>
>

report viewer conrtol problem

alslamo alikom...

Hi all...i have a problem with the report viewer control in visual studio 2005 ...i use the control to view a local report file (.rdlc)...and when i change the corresponding xml file (.rdlc) for example using the notepad...and then clicking refresh in the report viewer no thing happens and the new changes done to the report viewer doesn't appear....i have to close the whole application and run it again....so the new changes appear in the viewer....or i tried to remove the control from the form and construct a new one at run time viewing the same .rdlc file and add the new coonstructed viewer to the form and it viewed the new changes done to the .rdlc file...so the question is :

is there any way to refresh the report viewer...making it connect again to the .rdlc file and redraw it with the new changes...?

happy to communicate with u....wish u all a happy life...and thx for ur concern....

Clicking the refresh button will only reload the data for a report, not the report definition itself. To reload the definition, call ReportViewer.Reset(), and set the necessary properties on ReportViewer.LocalReport.|||

alslamo alikom....

thx alot brian...u were very helpfull....

Report viewer and Visual Studio 2005

Hi, I developed ASP.Net web site project with Report Viewer,and i published the project and put it another system in my LAN, after creating the virtual directory in IIS i tried to browse. I am getting the following error:

[WebException: The request failed with HTTP status 401: Access Denied.] Microsoft.SqlServer.ReportingServices2005.Execution.RSExecutionConnection.GetSecureMethods() +211

The report server of my machine can be accessed thru http://sys40/reportserver from that system. But the published website is showing the above mentioned error, so i created the a new project, same as the one created in my system, in the other system. While debugging the project i am able to access the report server and view the report but wen the website is published and then browsed the above mentioned error is displayed.

Even the identity impersonate = true condition was made in web config file..

How can this issue be solved...

Thanks in advance.. Somu

HI,radmoorthy ：

You can give it a try with these following steps:

1. Verify your NTFS permissions for the users on the folder C:\Program Files\Microsoft SQL Server\MSSQL\Reporting Services\ReportServer.

He should have ("Read & Execute", "List Folder Content" and "Read").

2.In IIS for Reports and ReportServer app set Authenication method to "Basic authentication" from "Integrated Windows authentication".

If i misunderstand you about your question, please feel free to correct me and i will try to help you with more information.

I hope the above information will be helpful. If you have any issues or concerns, please let me know. It's my pleasure to be of assistance

|||

HI,radmoorthy ：

We are marking this issue as "Answered". If you have any new findings or concerns, please feel free to unmark the issue.
Thank you for your understanding!

report viewer and reporting services security

i have a web application in studio 2005 using the report viewer control. i have my own security model implemented on my web pages for clients [1..n] each of the [1..n] clients should be able to view reports of their order history. i have the report viewer set up in url mode. the question is that when i have drill downs in my final reports, a user with some tech knowledge, would be able to obtain the url to my sql server running reporting services.

the sql server will not be given a port 80 acess. how do i go about displaying reports without any savvy user being able to locate the server locations/credentials?

i donot want to create windows account for each [1..n] clients as this is ever growing

If by "url mode" you mean hyperlinks pointing to the report URL address, you should rethink your approach. Instead, consider server-side report generation. In this case, SSRS does reasonable job to protect the parameters as you can see by inspecting the drilldown hyperlinks.|||

Teo, thats what i mean. How would i go about the approach that you are suggesting?

- would i have to create subscriptions to generate the reports and save them to disk?

|||If i am to use SOAP then the interactive features are not availabe as this read up provides that info:

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnhcvb04/html/vb04k8.asp|||You will host the VS.NET 2005 ReportViewer control on your ASP.NET page and bind it to the server report. If you are new to the Report Viewer control, you may find the following article useful.|||I did read the article but from read ups, the drill down interactive feature is lost when using SOA/web services to gerenate report in 'remote mode'. is that statetment true? if not then i guess this would work out well|||This is incorrect. SSRS 2005 enhances the web service APIs to support interactive features so interactive featues will work with the VS.NET ReportViewer.

Wednesday, March 21, 2012

Report Viewer

Hi
I'm using Visual Studio Beta 2
I have few questions about the ReportViewer WinForm Control.
When rendering a Server Report the Print button appears disabled is this by
design?
Also the Print Preview button is enabled but it does not do anything is this
also by design?
Any help is appreciated!!!
LuigiHi,
I am also facing the same problem. Without the print option the report is of
no use for our client. Please help on urgent basis.
"Luigi Di Santo" wrote:
> Hi
> I'm using Visual Studio Beta 2
> I have few questions about the ReportViewer WinForm Control.
> When rendering a Server Report the Print button appears disabled is this by
> design?
> Also the Print Preview button is enabled but it does not do anything is this
> also by design?
> Any help is appreciated!!!
> Luigi
>
>

Report Title above parameters (Urgent)

Hi All,

I have created a report in SQL Server Business Intelligence Development Studio 2005. I need to add a report title above the parameters area. Is that possible?. please help me

The output should be like

Report Title

Report Parameters Section View Report button

Report Body part.

Hi.

Under the current implementation of Reporting Services, any parameters for a report are generated as part of the report viewer controls (i.e. above the page number and export format controls). I do not know of any way of inserting your own title above those.

I can think of a couple of workarounds/solutions.

Firstly you could add another parameter to the report, call it something like Title and make it a string and ensure it is top of the parameter list. Then just give this a single non query value where the label is your report title (e.g. My Report) and set the value to 0; then set the default value to be non query as =0. When the report is generated you will then have a parameter above all the others, with a description of Title and a single (non changeable) value which is your report title.

Not perfect but it might suit your purpose.

The second way would be to create your own web page (e.g. in ASP.NET) which has whatever titles you want at the top then embed the report underneath, so you get your parameters after the title.

Hope this helps,

Gary.

Tuesday, March 20, 2012

Report Specific Data Source in sql Server reporting Services

Hi everyone.

I have problem in sql server reporting services.

I have created a sql server report in viisual studio 2003 using the report specific data source, not shared data source. I also set the credentials when i define the data source for the report.

When i test it in report manager, it runs nice and displays the required results. Now when i called this report in web application using the following URL:

It gives a report service error which is as follows:

"One or more datasource credentials required to run the report have not been specified. (rsCredentialsNotSpecified) "

This error shows that the credentials for the connection string is not set, but i set it when i define the data source for the report.

If any one can help, then please help as i am need of it urgently.

Thanks in advance.

Rizwan

Hi,

Try to create a shared connection and use that in your reports. while creating a connection, save credentials information too, otherwise it will ask on next new requests.

Report Source

Hi
We have different version of the same report. For example, Report 1,
Report 1a, Report 1b in the visual studio. We publish only one of them.
But, we go and change report name in browser to 1. After a while, we do not
remember which one did we publish. Is it possible to see which report is
published?
I know that you can get RDL code from browser and compare it against the
visual studio RDL. But, I have lot of such reports.typo in last post - should be "Description" property :-)
"manish" wrote:
> Hi
> We have different version of the same report. For example, Report 1,
> Report 1a, Report 1b in the visual studio. We publish only one of them.
> But, we go and change report name in browser to 1. After a while, we do not
> remember which one did we publish. Is it possible to see which report is
> published?
> I know that you can get RDL code from browser and compare it against the
> visual studio RDL. But, I have lot of such reports.
>|||Add the version number to the "Sedcription" property of the report before you
deploy it, then you will see that in the properties of the report in Report
Manager
"manish" wrote:
> Hi
> We have different version of the same report. For example, Report 1,
> Report 1a, Report 1b in the visual studio. We publish only one of them.
> But, we go and change report name in browser to 1. After a while, we do not
> remember which one did we publish. Is it possible to see which report is
> published?
> I know that you can get RDL code from browser and compare it against the
> visual studio RDL. But, I have lot of such reports.
>|||Hi Mary
Unfortunately, they are already deployed.
Thanks
Manish
"Mary Bray [SQL Server MVP]" wrote:
> typo in last post - should be "Description" property :-)
> "manish" wrote:
> > Hi
> >
> > We have different version of the same report. For example, Report 1,
> > Report 1a, Report 1b in the visual studio. We publish only one of them.
> > But, we go and change report name in browser to 1. After a while, we do not
> > remember which one did we publish. Is it possible to see which report is
> > published?
> > I know that you can get RDL code from browser and compare it against the
> > visual studio RDL. But, I have lot of such reports.
> >

Report solution does not open anymore after conversion to Visual Studio 2005

Hi,
we have a VS solution containing one SQL Server report project only, created with VS 2003 that was free of problems so far. We have uninstalled VS 2003 and installed VS 2005. VS 2005 converts/updates this solution without errors.
When opening the solution in VS 2005 an error message says:
"The application for project ....rptproj is not installed.
Make sure the application for the project (.rptproj) is installed."
What application is meant here? Where do we install it from?
Thanks for your help!

I assume that you are working with a RS 2000 report server. RS 2000 report projects can only be edited with VS 2003. You can install both VS 2003 and VS 2005 side-by-side on the same machine.

If you have upgraded to RS 2005, you need to install the Business Intelligence Development Studio witch comes with SQL 2005. It is an add on that works with VS 2005 and can edit RS 2005 report projects.

-Albert

Monday, March 12, 2012

Report services compatibility ??

Hi All ...
If I create a report with Microsoft SQL Server Reporting Services
Designers
Version 9.00.1399.00 ... ( Visual Studio 2005) ... Will I be able to
deploy it to SQL Server Report Services 2000 ?
*******
Error 8 An error occurred during the parsing of a resource required to
service this request. Please review the following specific parse
error details and modify your source file appropriately.
*******
I did verify my Report Server name in the "Microsoft CRM Deployment
Manager ... made some modification ...try to deploy again then I'm
getting another error message
******
A connection could not be made to the report server
http:// .........../ReportServer
ADDITIONAL INFORMATION:
The attempt to connect to the report server failed. Check your
connection information and that the report server is a compatible
version. (Microsoft.ReportingServices.Designer)
******
With this one it seems to be a version problem ... Just need an
approval from an expert
TanksNope.
You can deploy RS 2000 to RS 2005 but not RS 2005 to RS 2000.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Frank" <flefe2000@.gmail.com> wrote in message
news:1170879261.176664.43180@.j27g2000cwj.googlegroups.com...
> Hi All ...
> If I create a report with Microsoft SQL Server Reporting Services
> Designers
> Version 9.00.1399.00 ... ( Visual Studio 2005) ... Will I be able to
> deploy it to SQL Server Report Services 2000 ?
>
> *******
> Error 8 An error occurred during the parsing of a resource required to
> service this request. Please review the following specific parse
> error details and modify your source file appropriately.
> *******
>
> I did verify my Report Server name in the "Microsoft CRM Deployment
> Manager ... made some modification ...try to deploy again then I'm
> getting another error message
>
> ******
> A connection could not be made to the report server
> http:// .........../ReportServer
> ADDITIONAL INFORMATION:
> The attempt to connect to the report server failed. Check your
> connection information and that the report server is a compatible
> version. (Microsoft.ReportingServices.Designer)
> ******
> With this one it seems to be a version problem ... Just need an
> approval from an expert
> Tanks
>|||On 7 f=E9v, 15:21, "Bruce L-C [MVP]" <bruce_lcNOS...@.hotmail.com>
wrote:
> Nope.
> You can deploy RS 2000 to RS 2005 but not RS 2005 to RS 2000.
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "Frank" <flefe2...@.gmail.com> wrote in message
> news:1170879261.176664.43180@.j27g2000cwj.googlegroups.com...
>
> > Hi All ...
> > If I create a report with Microsoft SQL Server Reporting Services
> > Designers
> > Version 9.00.1399.00 ... ( Visual Studio 2005) ... Will I be able to
> > deploy it to SQL Server Report Services 2000 ?
> > *******
> > Error 8 An error occurred during the parsing of a resource required to
> > service this request. Please review the following specific parse
> > error details and modify your source file appropriately.
> > *******
> > I did verify my Report Server name in the "Microsoft CRM Deployment
> > Manager ... made some modification ...try to deploy again then I'm
> > getting another error message
> > ******
> > A connection could not be made to the report server
> > http:// .........../ReportServer
> > ADDITIONAL INFORMATION:
> > The attempt to connect to the report server failed. Check your
> > connection information and that the report server is a compatible
> > version. (Microsoft.ReportingServices.Designer)
> > ******
> > With this one it seems to be a version problem ... Just need an
> > approval from an expert
> > Tanks- Masquer le texte des messages pr=E9c=E9dents -
> - Afficher le texte des messages pr=E9c=E9dents -
Whaow ... Quick answer ... tanks
I'm using Microsoft CRM 3.0 with SQL Server Report Services 2000 ...
is it an easy task to upgrade Report Services 2000 to 2005 '
Tanks again
Frank|||I'm not familiar with CRM.
A regular RS 2000 environment is not hard to upgrade but there might be
specific things for your environment.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Frank" <flefe2000@.gmail.com> wrote in message
news:1170880734.453903.84940@.s48g2000cws.googlegroups.com...
On 7 fév, 15:21, "Bruce L-C [MVP]" <bruce_lcNOS...@.hotmail.com>
wrote:
> Nope.
> You can deploy RS 2000 to RS 2005 but not RS 2005 to RS 2000.
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "Frank" <flefe2...@.gmail.com> wrote in message
> news:1170879261.176664.43180@.j27g2000cwj.googlegroups.com...
>
> > Hi All ...
> > If I create a report with Microsoft SQL Server Reporting Services
> > Designers
> > Version 9.00.1399.00 ... ( Visual Studio 2005) ... Will I be able to
> > deploy it to SQL Server Report Services 2000 ?
> > *******
> > Error 8 An error occurred during the parsing of a resource required to
> > service this request. Please review the following specific parse
> > error details and modify your source file appropriately.
> > *******
> > I did verify my Report Server name in the "Microsoft CRM Deployment
> > Manager ... made some modification ...try to deploy again then I'm
> > getting another error message
> > ******
> > A connection could not be made to the report server
> > http:// .........../ReportServer
> > ADDITIONAL INFORMATION:
> > The attempt to connect to the report server failed. Check your
> > connection information and that the report server is a compatible
> > version. (Microsoft.ReportingServices.Designer)
> > ******
> > With this one it seems to be a version problem ... Just need an
> > approval from an expert
> > Tanks- Masquer le texte des messages précédents -
> - Afficher le texte des messages précédents -
Whaow ... Quick answer ... tanks
I'm using Microsoft CRM 3.0 with SQL Server Report Services 2000 ...
is it an easy task to upgrade Report Services 2000 to 2005 '
Tanks again
Frank|||On 7 f=E9v, 16:23, "Bruce L-C [MVP]" <bruce_lcNOS...@.hotmail.com>
wrote:
> I'm not familiar with CRM.
> A regular RS 2000 environment is not hard to upgrade but there might be
> specific things for your environment.
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "Frank" <flefe2...@.gmail.com> wrote in message
> news:1170880734.453903.84940@.s48g2000cws.googlegroups.com...
> On 7 f=E9v, 15:21, "Bruce L-C [MVP]" <bruce_lcNOS...@.hotmail.com>
> wrote:
>
>
> > Nope.
> > You can deploy RS 2000 to RS 2005 but not RS 2005 to RS 2000.
> > --
> > Bruce Loehle-Conger
> > MVP SQL Server Reporting Services
> > "Frank" <flefe2...@.gmail.com> wrote in message
> >news:1170879261.176664.43180@.j27g2000cwj.googlegroups.com...
> > > Hi All ...
> > > If I create a report with Microsoft SQL Server Reporting Services
> > > Designers
> > > Version 9.00.1399.00 ... ( Visual Studio 2005) ... Will I be able to
> > > deploy it to SQL Server Report Services 2000 ?
> > > *******
> > > Error 8 An error occurred during the parsing of a resource required to
> > > service this request. Please review the following specific parse
> > > error details and modify your source file appropriately.
> > > *******
> > > I did verify my Report Server name in the "Microsoft CRM Deployment
> > > Manager ... made some modification ...try to deploy again then I'm
> > > getting another error message
> > > ******
> > > A connection could not be made to the report server
> > > http:// .........../ReportServer
> > > ADDITIONAL INFORMATION:
> > > The attempt to connect to the report server failed. Check your
> > > connection information and that the report server is a compatible
> > > version. (Microsoft.ReportingServices.Designer)
> > > ******
> > > With this one it seems to be a version problem ... Just need an
> > > approval from an expert
> > > Tanks- Masquer le texte des messages pr=E9c=E9dents -
> > - Afficher le texte des messages pr=E9c=E9dents -
> Whaow ... Quick answer ... tanks
> I'm using Microsoft CRM 3.0 with SQL Server Report Services 2000 ...
> is it an easy task to upgrade Report Services 2000 to 2005 '
> Tanks again
> Frank- Masquer le texte des messages pr=E9c=E9dents -
> - Afficher le texte des messages pr=E9c=E9dents -
I will research on the CRM issue but beside that ... is it preferable
to upgrade or start from scratch '

report services

hi all I'm in the Microsoft Visual Studio creating a report and I noticed I cant bring a function over, am I doing something wrong. I wanted to make a report based on a function. its a table valued function

ALTER FUNCTION [dbo].[Beginning_EndingFinals](@.StartFINALSUITDONE datetime,
@.EndFINALSUITDONE datetime)
RETURNS TABLE
AS
RETURN ( SELECT TM#, LASTNAME, FIRSTNAME, CONDITIONAL, DATEOFCONDITIONAL, FINALSUITDONE
FROM dbo.EmployeeGamingLicense
WHERE (FINALSUITDONE BETWEEN @.StartFINALSUITDONE AND @.EndFINALSUITDONE) )why not make it a sproc?

I don't know if that matters or not|||Are you attempting to execute the ALTER FUNCTION code within text of the dataset?

Or are you making the call to the function within the text (ie, SELECT * from dbo.MyFunction(MyParameter)).

You might consider setting up a stored procedure instead (just set the command type in the Data Set to StoredProcedure).

Regards,

hmscott|||You might consider setting up a stored procedure instead (just set the command type in the Data Set to StoredProcedure).

Brilliant!|||this is the message I'm getting inside the Sql Server business intelligence studio|||this is the message I'm getting inside the Sql Server business intelligence studio

Ummmmm..what message|||Ummmmm..what message

My Bad, hope this helps

Monday, February 20, 2012

Report requesting 8.5 x 14 paper

Hello,
I have created a report in Reporting Services 2.0 using Visual Studio 2005
Report Designer. The report is defined as 8.5w x 11h.
For some reason when I preview the report using the Report Viewer and choose
to print the report, the printer is requesting 8.5w x 14h paper. I don't see
anything in the design that seems to call for that.
How can I debug this and get this to print properly? I would be more than
happy to provide the XML code that is generated by the designer.I would say that it is getting the 8.5 x 14 settings from your printer.
Check what the default paper is for your printer.
Craig
"WebPhenom" <WebPhenom@.discussions.microsoft.com> wrote in message
news:4CF88391-BB3E-45F9-ADF4-5D7B3F8AF35E@.microsoft.com...
> Hello,
> I have created a report in Reporting Services 2.0 using Visual Studio 2005
> Report Designer. The report is defined as 8.5w x 11h.
> For some reason when I preview the report using the Report Viewer and
> choose
> to print the report, the printer is requesting 8.5w x 14h paper. I don't
> see
> anything in the design that seems to call for that.
> How can I debug this and get this to print properly? I would be more than
> happy to provide the XML code that is generated by the designer.|||Actually, this occurs with every printer I print to so I don't think it is
from the default settings on the printer.
Is there something else that I could be checking?
I am going to try to recreate the report from scratch to see if that will
help. I hate to do that but I am at my wits end. In the mean time, if there
is something else I could be checking, please let me know.
"Craig" wrote:
> I would say that it is getting the 8.5 x 14 settings from your printer.
> Check what the default paper is for your printer.
> Craig
> "WebPhenom" <WebPhenom@.discussions.microsoft.com> wrote in message
> news:4CF88391-BB3E-45F9-ADF4-5D7B3F8AF35E@.microsoft.com...
> > Hello,
> >
> > I have created a report in Reporting Services 2.0 using Visual Studio 2005
> > Report Designer. The report is defined as 8.5w x 11h.
> >
> > For some reason when I preview the report using the Report Viewer and
> > choose
> > to print the report, the printer is requesting 8.5w x 14h paper. I don't
> > see
> > anything in the design that seems to call for that.
> >
> > How can I debug this and get this to print properly? I would be more than
> > happy to provide the XML code that is generated by the designer.
>
>|||Have you got the 8in x 14in setting on any printer?
"WebPhenom" <WebPhenom@.discussions.microsoft.com> wrote in message
news:FF84DD5D-523C-4B83-8F5B-2CA1106CE8D6@.microsoft.com...
> Actually, this occurs with every printer I print to so I don't think it is
> from the default settings on the printer.
> Is there something else that I could be checking?
> I am going to try to recreate the report from scratch to see if that will
> help. I hate to do that but I am at my wits end. In the mean time, if
> there
> is something else I could be checking, please let me know.
> "Craig" wrote:
>> I would say that it is getting the 8.5 x 14 settings from your printer.
>> Check what the default paper is for your printer.
>> Craig
>> "WebPhenom" <WebPhenom@.discussions.microsoft.com> wrote in message
>> news:4CF88391-BB3E-45F9-ADF4-5D7B3F8AF35E@.microsoft.com...
>> > Hello,
>> >
>> > I have created a report in Reporting Services 2.0 using Visual Studio
>> > 2005
>> > Report Designer. The report is defined as 8.5w x 11h.
>> >
>> > For some reason when I preview the report using the Report Viewer and
>> > choose
>> > to print the report, the printer is requesting 8.5w x 14h paper. I
>> > don't
>> > see
>> > anything in the design that seems to call for that.
>> >
>> > How can I debug this and get this to print properly? I would be more
>> > than
>> > happy to provide the XML code that is generated by the designer.
>>|||We have the same problem.
The report is set to use letter but it defaults to A4 for any printer
the user chooses. The default settings on the printers are also set to
letter. We tried this with different reports and we get the same
result. Running the same report from other clients the default page
size is letter.
>From this we can tell it is not the report and not the printer driver.
It seems like the Active-X control is the problem as it is getting it's
default setting from somewhere on this particular userss computer.|||Sadly, I had to recreate the report from scratch. Doing that solved the
problem but there must have been SOMETHING in the RDL to tell the printer it
needed/wanted Legal paper.
I wish I had an answer for you for your A4 problem.
"grandersg@.gmail.com" wrote:
> We have the same problem.
> The report is set to use letter but it defaults to A4 for any printer
> the user chooses. The default settings on the printers are also set to
> letter. We tried this with different reports and we get the same
> result. Running the same report from other clients the default page
> size is letter.
> >From this we can tell it is not the report and not the printer driver.
> It seems like the Active-X control is the problem as it is getting it's
> default setting from somewhere on this particular userss computer.
>|||I have the same problem and have checked every setting as well. I'd rather
not recreate my reports, so if anyone has another idea, I'd appreciate it!
"WebPhenom" wrote:
> Sadly, I had to recreate the report from scratch. Doing that solved the
> problem but there must have been SOMETHING in the RDL to tell the printer it
> needed/wanted Legal paper.
> I wish I had an answer for you for your A4 problem.
> "grandersg@.gmail.com" wrote:
> >
> > We have the same problem.
> >
> > The report is set to use letter but it defaults to A4 for any printer
> > the user chooses. The default settings on the printers are also set to
> > letter. We tried this with different reports and we get the same
> > result. Running the same report from other clients the default page
> > size is letter.
> >
> > >From this we can tell it is not the report and not the printer driver.
> > It seems like the Active-X control is the problem as it is getting it's
> > default setting from somewhere on this particular userss computer.
> >
> >

Report Render in VS2005 slower than stored proc

I have searched many forums and found some cases of people also reporting slower rendering in RS than in Management Studio / Query Analyzer. However, none of the other solution suggestions seem to make a difference for me.

I'm a VS/VB developer and have got multiple reports built -- all using stored procedures on the backend -- that all take many times longer to run than if executed via Management Studio (SSMS). My simplest proc takes a couple of parameters (no defaults included) and does a simple select against one table with a few joins. Nothing complicated. It runs in 8 secs for 6867 rows via SSMS. Through RS (running locally through Visual Studio 2005 at this point) it takes around 25-28 secs. Yet, when I'm in the report on the DATA tab (not the PREVIEW tab) the run takes the expected 8 secs ?!?!

All reports are behaving this way.

I am not using cursors.

I have no default values on parameters.

I have added the "WITH RECOMPILE" to the proc statement.

I have "SET NOCOUNT ON" as the first line of the proc.

I hate to say this, but I even connected the proc to Crystal Reports to see how it behaved. It ran in the expected 8 secs.

I've seen some mention by someone that perhaps this is a known issue of RS that it reads the proc twice. Any truth to this?

Also a couple posts have traced and demonstrated that the report is generating significantly more data "reads" via RS than through SSMS.

We're a shop that is considering a switch from Crystal to RS, but we do everything through stored procedures. I need to clear up this issue before I can go forward recommending a switch. I'm including a copy of a typical proc below for review... What am I missing? What's the deal here with RS?

IF OBJECT_ID('dbo.rpt_InactiveAccounts') IS NOT NULL

DROP PROCEDURE dbo.rpt_InactiveAccounts

CREATE PROCEDURE dbo.rpt_InactiveAccounts

(@.pRunDate datetime

,@.pSalesperson varchar(5000)

,@.pIncludeOpen char(1)

)

WITH RECOMPILE

SET NOCOUNT ON

SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED

-- CREATE/SETUP TEMP TABLE FOR USE IN PARSING MULTI-VALUED STRING INPUTS

DECLARE @.NumberPivot TABLE (NumberID INT PRIMARY KEY)

DECLARE @.intLoopCounter INT

SELECT @.intLoopCounter =0

WHILE @.intLoopCounter <=4999 BEGIN

INSERT INTO @.NumberPivot

VALUES (@.intLoopCounter)

SELECT @.intLoopCounter = @.intLoopCounter +1

END

-- CREATE TEMP TABLES TO HOLD PARSED VALUES FROM MULTI-VALUE STRING INPUT PARAMETERS

DECLARE @.SalespersonTable TABLE

(tmpSalesperson varchar(30))

-- PARSE OUT @.pSALESPERSON PARAMETER AND STORE VALUES IN TEMP TABLE

INSERT INTO @.SalespersonTable

SELECT SUBSTRING(',' + @.pSalesperson + ',', NumberID + 1,

CHARINDEX(',', ',' + @.pSalesperson + ',', NumberID + 1) - NumberID -1)

FROM @.NumberPivot

WHERE NumberID <= LEN(',' + @.pSalesperson + ',') - 1

AND SUBSTRING(',' + @.pSalesperson + ',', NumberID, 1) = ','

SELECT DISTINCT

CASE

WHEN s.Name IS NULL THEN '<< OPEN >>'

ELSE s.Name

END As SalespersonName

,c.ClassId

,c.CustId

,c.Name

,c.Addr1

,c.Addr2

,c.Addr3

,c.City

,State

,CASE

WHEN Len(c.Zip) = 9 And CharIndex(' ', c.Zip, 0) = 0 THEN Left(c.Zip, 5) + '-' + Right(c.Zip, 4)

ELSE c.Zip

END As Zip

,ac1.descr As Terms

,ac2.descr As Status

FROM

ACTCustomer c (NOLOCK)

LEFT OUTER JOIN CustSales cs ON c.CustId = cs.CustId

LEFT OUTER JOIN ACTSalesperson s ON cs.SlsId = s.SalesId

INNER JOIN @.SalespersonTable st ON s.Name = st.tmpSalesperson OR (s.Name IS NULL AND @.pIncludeOpen = 'Y')

INNER JOIN ACTCode ac1 ON ac1.Code = c.Terms And ac1.FieldId = 'CustTerms'

INNER JOIN ACTCode ac2 ON ac2.Code = c.Status And ac2.FieldId = 'Status'

WHERE

c.LastInvcDate <= @.pRunDate

And c.ClassId <> 'TR'

ORDER BY

SalespersonName, Name, CustId

Hi Dave,

I don't think that this will solve you performance issue but I have a recommendation for you, since you are passing some comma separated list to your reports as parameter, maybe you should create a user-defined function that will convert you list into a table. This would allow you to reuse this same function in all of you reports.

Sample Here:

Here is an example of a function that would convert comma separated list into a table:

http://blogs.vandamme.com/development/2007/06/parse_comma_sep.html

Then you could modify your SQL statement in the stored procedure tu use this function, something like this should do:

SELECT <Fields>

FROM <Table> a

JOIN <Function> (@.CommaSeparatedList) b ON b.uid = a.id

For the performance issue, did you try to profile and compare your SSMS execution and the Report execution?

HTH,

Friday, March 30, 2012

Report, Data sources errors.

Wednesday, March 28, 2012

Report vs software

Report Viewer vs Report Server

Monday, March 26, 2012

Report Viewer Issue in Visual Studio 2005 Beta 2. for Microsoft Reporting Services

Report Viewer Issue in Visual Studio 2005 Beta 2. for Microsoft Reporting Services

Friday, March 23, 2012

Report Viewer display problem

report viewer conrtol problem

Report viewer and Visual Studio 2005

report viewer and reporting services security

Wednesday, March 21, 2012

Report Viewer

Report Title above parameters (Urgent)

Tuesday, March 20, 2012

Report Specific Data Source in sql Server reporting Services

Report Source

Report solution does not open anymore after conversion to Visual Studio 2005

Monday, March 12, 2012

Report services compatibility ??

report services

Monday, February 20, 2012

Report requesting 8.5 x 14 paper

Report Render in VS2005 slower than stored proc

Sql Report protection

Blog Archive

About Me