Showing posts with label generated. Show all posts
Showing posts with label generated. Show all posts

Monday, March 26, 2012

Report Deployment Error on --http://localhost/reportserver

I am getting the following ERROR!! below when I try to DEPLOY my report. The output generated from - Debug --> Start
-- Deploy started: Project: Report Project1, Configuration: DebugLocal --
Deploying to http://localhost/reportserver/?%2fReport+Project1
Error rsReportServerDatabaseUnavailable : The report server cannot opena connection to the report server database. A connection to thedatabase is required for all requests and processing.
Deploy complete -- 1 errors, 0 warnings
=====================================================

When I try to go tohttp://<server>/reportserver a PROMT window pop up "Enter username and password for "" at http://localhost. Atthis point I'm pretty desperate to get it to work., I have been tryingfor couple of days. I reinstalled reporting services couple of timeswith no success. Any help would be greatly appreciated. Thanks!

-lalon

Hi it sounds to me the AspNet user or the user used in your dataset don't have access to your SRS database( "ReportServer" DB) . Check the permissions of the SQL Reporting Services database. Also you can't deploy to a server not running the SRS Server, unless you are on a SQL reporting server as localhost . I assume you clicked 'play' in VS.Net ? You need to deploy to a SRS Server.

Tuesday, March 20, 2012

Report Builder MDX on filter

Please interpret this MDX statement generated by Report Builder for me. I am not sure why it is returning all years in cube when I just want 2005:

SELECT

{ ( Extract( filter( { [Accounting Date].[MDY Date].Levels(1).Members * { [Accounting Date].[Date].[Calendar] } }, ( ( [Accounting Date].[MDY Date].CurrentMember.membervalue >= "09/01/2005" ) AND ( [Accounting Date].[MDY Date].CurrentMember.membervalue <= "09/30/2005" ) ) ), [Accounting Date].[MDY Date] ) , * ) } on 0

FROM

[Cube]

It is filtering the data on the month and day portion of the date range just fine, just not filtering on the year. Same report in Reporting Services generates different MDX and returns 2005 only, so this rules out cube problem.

Could you please add CDate() around the begin and end dates, so as comparisons are made using the proper time ordering?

For instance:

... >= CDate("09/01/2005") ...

Monday, March 12, 2012

Report Builder Connection Error

Okay, here is the scenario. I have an analysis services cube and a report
model generated from a OLAP datasource in reporting services. My first
problem is that when I try to create a report using the report builder from
my local pc I get data source connection errors, but if I remote desktop into
the dev server where reporting services is installed an complete the same
procedure everything works great. My second problem is that I cannot create
a report model from an OLAP datasource unless I am remoted into the report
server.
Thanks, Andrewwhen you create report model, you need to use default in your data source
properties, so that it takes the same and connects.
second problem is: have you deployed your report model, only then you can
see the entities and then you can create the reports.
Amarnath
"chabotwvu" wrote:
> Okay, here is the scenario. I have an analysis services cube and a report
> model generated from a OLAP datasource in reporting services. My first
> problem is that when I try to create a report using the report builder from
> my local pc I get data source connection errors, but if I remote desktop into
> the dev server where reporting services is installed an complete the same
> procedure everything works great. My second problem is that I cannot create
> a report model from an OLAP datasource unless I am remoted into the report
> server.
> Thanks, Andrew|||When I navigate to my OLAP datasource using SQL Server Management Studio and
generate the model my datasource security is set to windows integrated
security. The OLAP datasource impersonation information is set to use the
service account; when I do this from SSMS on my local laptop I get connection
errors, but if I remote desktop into the reporting services server and
connect to reporting services using the SSMS it will create the model and you
can create and run a report from the report builder no problem.
"Amarnath" wrote:
> when you create report model, you need to use default in your data source
> properties, so that it takes the same and connects.
> second problem is: have you deployed your report model, only then you can
> see the entities and then you can create the reports.
> Amarnath
>
> "chabotwvu" wrote:
> > Okay, here is the scenario. I have an analysis services cube and a report
> > model generated from a OLAP datasource in reporting services. My first
> > problem is that when I try to create a report using the report builder from
> > my local pc I get data source connection errors, but if I remote desktop into
> > the dev server where reporting services is installed an complete the same
> > procedure everything works great. My second problem is that I cannot create
> > a report model from an OLAP datasource unless I am remoted into the report
> > server.
> >
> > Thanks, Andrew|||Here is the error message from the Report Server Log Files:
e ERROR: Throwing
Microsoft.ReportingServices.ReportProcessing.ReportProcessingException:
Cannot create a connection to data source 'dataSource1'., ;
Info:
Microsoft.ReportingServices.ReportProcessing.ReportProcessingException:
Cannot create a connection to data source 'dataSource1'.
--> Microsoft.AnalysisServices.AdomdClient.AdomdConnectionException:
The connection either timed out or was lost. --> System.IO.IOException:
Unable to read data from the transport connection:
An existing connection was forcibly closed by the remote host. -->
System.Net.Sockets.SocketException: An existing connection was forcibly
closed by the remote host
"chabotwvu" wrote:
> When I navigate to my OLAP datasource using SQL Server Management Studio and
> generate the model my datasource security is set to windows integrated
> security. The OLAP datasource impersonation information is set to use the
> service account; when I do this from SSMS on my local laptop I get connection
> errors, but if I remote desktop into the reporting services server and
> connect to reporting services using the SSMS it will create the model and you
> can create and run a report from the report builder no problem.
> "Amarnath" wrote:
> > when you create report model, you need to use default in your data source
> > properties, so that it takes the same and connects.
> >
> > second problem is: have you deployed your report model, only then you can
> > see the entities and then you can create the reports.
> >
> > Amarnath
> >
> >
> > "chabotwvu" wrote:
> >
> > > Okay, here is the scenario. I have an analysis services cube and a report
> > > model generated from a OLAP datasource in reporting services. My first
> > > problem is that when I try to create a report using the report builder from
> > > my local pc I get data source connection errors, but if I remote desktop into
> > > the dev server where reporting services is installed an complete the same
> > > procedure everything works great. My second problem is that I cannot create
> > > a report model from an OLAP datasource unless I am remoted into the report
> > > server.
> > >
> > > Thanks, Andrew

Friday, March 9, 2012

Report Builder / Report Models

We would like to support Report Builder / Report Models in our application,
and we know that Report models are generated from SQL Server relational or
Analysis Services multidimensional databases. Based on our superficial
understandings of report models, it seems that we should be able to create an
entity based on more than one source table/view with or without security
filters and even give it a friendly name. Is this correct? If so, is it
possible to create a report model programmatically?
If not programmatically, we would want more help with how to create a report
model in details. The current tutorial in the SQL Server Books online is
actually not detailed enough (most of the time it guides us to accept the
defaults).Hi,
Welcome to use MSDN Managed Newsgroup!
From your descriptions, I understood you would like to whether it is
possible to create a report model programmatically. If I have misunderstood
your concern, please feel free to point it out.
I think BOL contains two useful articles for your reference
How to: Create a Model Using Report Manager
http://msdn2.microsoft.com/en-us/library/ms159118.aspx
How to: Create a Report Model Using the Model Designer Wizard
http://msdn2.microsoft.com/en-us/library/ms156284.aspx
Also, this article explains the major components of Microsoft Reporting
Services' ad-hoc architecture and semantic model, and walks you through an
end-to-end example that demonstrates how to author, manage, and deliver
ad-hoc reports.
Generate Ad-hoc Reports with Microsoft Reporting Services 2005
http://www.devx.com/dbzone/Article/28047
Thank you for your patience and cooperation. If you have any questions or
concerns, don't hesitate to let me know. We are always here to be of
assistance!
Sincerely yours,
Michael Cheng
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.

Wednesday, March 7, 2012

Report being generated never shows second report

I have a VS2005 Windows application that displays a reportviewer (SQL 2005) report in a tab control, then displays a second report in a second tab with reportviewer, and so on. The really strange thing is that I had this application working for about 3 months. I even had up to 30 reports in 30 tabs at one point. BUT, for some reason now all I get is the first report and the second, third, etc. tabs show a reportviewer with "Report being generated" that never displays the report. Even worse, another user is able to run this application and DOES get all the reports displayed. So what could have been updated on my PC that is causing this problem?

Thanks in advance.

The obvious question to ask is what's changed? Have you installed any service packs or updates recently? Maybe it was some new software?|||

I was hoping someone else could tell me what installations might cause this problem, because I can't be 100% sure what updates have been done to my PC. Our Network Services group pushes updates and with MS always forcing updates, it's difficult nowadays to know what's going on on your own PC. Anyway, in January, I installed Red Gate's SQL Prompt 3 and Net Services pushed McAfee OAS. I don't know the exact day Report Viewer stopped working, but I'm pretty sure it was working after these installs. The SQL Server/SSRS 2005 is running on SP1, my client SQL is on SP1. Here's the header info in the most recent SSRS log:

<Header>
<Product>Microsoft SQL Server Reporting Services Version 9.00.2047.00</Product>
<Locale>en-US</Locale>
<TimeZone>Eastern Standard Time</TimeZone>
<Path>C:\Program Files\Microsoft SQL Server\MSSQL.1\Reporting Services\LogFiles\ReportServer__02_22_2007_21_43_20.log</Path>
<SystemName>BNTRA</SystemName>
<OSName>Microsoft Windows NT 5.2.3790 Service Pack 1</OSName>
<OSVersion>5.2.3790.65536</OSVersion>
</Header>

Here are the last few lines in this log, that show me trying to run 2 reports. It looks like it does the same processing for both reports here, but it just can't display the report in the viewer.

w3wp!library!5!02/22/2007-22:08:11:: i INFO: Call to RenderFirst( '/JobReports/EOJreport' )
w3wp!library!1!02/22/2007-22:08:12:: i INFO: Call to RenderFirst( '/JobReports/EOJreport' )
w3wp!webserver!5!02/22/2007-22:08:12:: i INFO: Processed report. Report='/JobReports/EOJreport', Stream=''
w3wp!webserver!1!02/22/2007-22:08:13:: i INFO: Processed report. Report='/JobReports/EOJreport', Stream=''
w3wp!library!5!2/22/2007-22:13:21:: i INFO: Cleaned 0 batch records, 0 policies, 2 sessions, 0 cache entries, 2 snapshots, 12 chunks, 0 running jobs, 0 persisted streams
w3wp!library!a!2/22/2007-22:23:21:: i INFO: Cleaned 0 batch records, 0 policies, 2 sessions, 0 cache entries, 2 snapshots, 12 chunks, 0 running jobs, 0 persisted streams
w3wp!webserver!5!2/22/2007-22:29:04:: i INFO: Reporting Web Server stopped

Need more info? THANKS.

|||

After a lot of searching and matching dlls, it looks like that VS 2005 SP1 is my problem. I've started another thread here:

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1279959&SiteID=1

Report being generated never shows second report

I have a VS2005 Windows application that displays a reportviewer (SQL 2005) report in a tab control, then displays a second report in a second tab with reportviewer, and so on. The really strange thing is that I had this application working for about 3 months. I even had up to 30 reports in 30 tabs at one point. BUT, for some reason now all I get is the first report and the second, third, etc. tabs show a reportviewer with "Report being generated" that never displays the report. Even worse, another user is able to run this application and DOES get all the reports displayed. So what could have been updated on my PC that is causing this problem?

Thanks in advance.

The obvious question to ask is what's changed? Have you installed any service packs or updates recently? Maybe it was some new software?|||

I was hoping someone else could tell me what installations might cause this problem, because I can't be 100% sure what updates have been done to my PC. Our Network Services group pushes updates and with MS always forcing updates, it's difficult nowadays to know what's going on on your own PC. Anyway, in January, I installed Red Gate's SQL Prompt 3 and Net Services pushed McAfee OAS. I don't know the exact day Report Viewer stopped working, but I'm pretty sure it was working after these installs. The SQL Server/SSRS 2005 is running on SP1, my client SQL is on SP1. Here's the header info in the most recent SSRS log:

<Header>
<Product>Microsoft SQL Server Reporting Services Version 9.00.2047.00</Product>
<Locale>en-US</Locale>
<TimeZone>Eastern Standard Time</TimeZone>
<Path>C:\Program Files\Microsoft SQL Server\MSSQL.1\Reporting Services\LogFiles\ReportServer__02_22_2007_21_43_20.log</Path>
<SystemName>BNTRA</SystemName>
<OSName>Microsoft Windows NT 5.2.3790 Service Pack 1</OSName>
<OSVersion>5.2.3790.65536</OSVersion>
</Header>

Here are the last few lines in this log, that show me trying to run 2 reports. It looks like it does the same processing for both reports here, but it just can't display the report in the viewer.

w3wp!library!5!02/22/2007-22:08:11:: i INFO: Call to RenderFirst( '/JobReports/EOJreport' )
w3wp!library!1!02/22/2007-22:08:12:: i INFO: Call to RenderFirst( '/JobReports/EOJreport' )
w3wp!webserver!5!02/22/2007-22:08:12:: i INFO: Processed report. Report='/JobReports/EOJreport', Stream=''
w3wp!webserver!1!02/22/2007-22:08:13:: i INFO: Processed report. Report='/JobReports/EOJreport', Stream=''
w3wp!library!5!2/22/2007-22:13:21:: i INFO: Cleaned 0 batch records, 0 policies, 2 sessions, 0 cache entries, 2 snapshots, 12 chunks, 0 running jobs, 0 persisted streams
w3wp!library!a!2/22/2007-22:23:21:: i INFO: Cleaned 0 batch records, 0 policies, 2 sessions, 0 cache entries, 2 snapshots, 12 chunks, 0 running jobs, 0 persisted streams
w3wp!webserver!5!2/22/2007-22:29:04:: i INFO: Reporting Web Server stopped

Need more info? THANKS.

|||

After a lot of searching and matching dlls, it looks like that VS 2005 SP1 is my problem. I've started another thread here:

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1279959&SiteID=1

Saturday, February 25, 2012

Report

Hi is it possible to have a header and footer text on every page generated in an aspx report (rsdl)?
I tried to put it in a textbox, but then the table containing the report data is displayed on top of it so that doesn't work... Any ideas?

Cheers, mc

I think you can set it in the properties window "repeat in every page" = true/false.

Reponse to reporting service event

Hi,
Is there anyway to response when RS generated report? I need to do extra works such as encryption once report generated, before deliver to customer.

Thank you

Hi,

Can you give me a little more information on what you are trying to accomplish? Such as what are you trying to encrypt and at what event or time should the encryption happen?

Thanks!

|||Hi,
Thank you for reply.

Actually I am trying to protect report generated in PDF from editable. I did some research and found that RS doesn't support this.

Therefore, I am looking for any workaround. I know that is 3rd party tool which able do add "protection" to any existing PDF file. I was thinking to call this 3rd party tool to "protect" RS generated PDF before deliver to client.

Please advice.

Thank you