.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Register
 
Win Surprise Gifts!!!
Congratulations!!!


Top 5 Contributors of the Month
david stephan
Fauzul Azmi
Asad Ali
Post New Web Links

Reporting Service of SQL 2008, BC30494, Line is too long

Posted By:      Posted Date: September 27, 2010    Points: 0   Category :Sql Server
 

I have a report which is working fine on SQL server 2005 reporting service. Recently I moved it to SQL Server 2008 Reporting service but it returns [BC30494] error, saying "Native Compiler returns error: Line is too long". I am using Visual Studio 2008 BI, just bring rdl of 2005 into a new project. 

Does anybody know about this? Does 2008 implement some limitations on rdl size?

I searched about this issue and changed by short textbox name and no helps. There are some expressions inside the report but I couldn't locate which expression caused this error.

wondering why 2005 version works.

Thanks in advanced.

 




View Complete Post


More Related Resource Links

Windows service can't use Reporting Services on SQL Service 2008 R2

  
Hello. I have a Windows service that run as Local System account. The service uses the Reporting Services ReportService2005.asmx web service. When I have SQL Server 2008 installed, I have no problems and my service is able to browse and create report. After I have installed SQL Server 2008 R2 I get the error "The request failed with HTTP status 401: Unauthorized." when the service tries to use the web service. If I change my service to log on as a user with administrator rights, it is able to use Reposting Services again. What has changes in SQL Server 2008 R2, that doesn't allow the Local System account to use Repoting Services? And is it possible to configure Reporting Services to allow it?   - Per

Parallel Groupings are not showing the data in Reporting Service 2008.

  
Hi All, My main goal is to show rows under two adjecent groups (say A another one is B) which have one parent group lat call it as AB (all are row sections) and i have one column group for "months".The details inside the group A under the "months" group is not showing any values or expressions it returing me blank. Adjacent groups in SSRS 2008 still shows blank lines for invisible rows (why?). Any ideas.Please let me know. Veeren.

How to use SharePoint 2007 list data in Reporting Service (Visual Studio) 2008?

  
Jeez - I have been googling left and right, and tried all the suggestions. No luck in getting it to work. I am using Reporting Service 2008 tools in my VS2008, trying to create a simple report using SharePoint 2007 data (from a simple list). Here is what I've been doing: Created a simple SharePoint list in a test site - only one column (Title) with one record of data. Started Visual Studio 2008 and created a new Report Server Project Wizard project. I named the data source "dsTest". Type: "XML". As connection string I used: http://site/subsite/subsite/_vti_bin/lists.asmx. Credentials: "Use Windows Authentication (Integrated Security)". Clicked Next and arrived at the "Design the Query" form. I entered this in the Query string box: <Query> <Method Namespace="http://schemas.microsoft.com/sharepoint/soap/" Name="GetListItems" /> <SoapAction>http://schemas.microsoft.com/sharepoint/soap/GetListItems</SoapAction> </Query> Clicking Next I get this error: An error occurred while the query design method was being saved. Failed to execute web request for the specified URL. Soap Fault: Exception of type 'Microsoft.SharePoint.SoapServer.SoapServerException' was thrown. Now if I view the Details when trying it inside the Query Builder I get this: <errorstring xmlns="http://schemas.mi

Does SQL Server 2008 R2 Express Reporting Service support Shared Datasets?

  
I have spent a few hours trying to get this to work. I am using Report Builder 3.0 (locally), with SQL Server 2008 R2 Express Edition on a remote web server. I am running Report Builder as an Admin under Win7 64bit. All is OK until I attempt a Save of a newly created shared dataset. The error message is: Failed to save dataset "mydataset.rsd" The feature "Shared dataset" is not supported in this edition of Reporting Services. Details: The feature: "Shared dataset" is not supported in this edition of Reporting Services. ---> Microsoft.ReportingServices.Diagnostics.Utilities.OperationNotSupportedException: The feature: "Shared dataset" is not supported in this edition of Reporting Services. I have researched the web, and the list of features for Express Edition does not list this feature as not being supported, although it does list "Shared component library" as being missing. Could anyone please confirm the situation please. If it is  a bug, is there any fix or workaround?  John Walton  

SQL 2008 Express with Reporting Service

  
My internal url for reporting service works on my SBS 2003 server, but I cannot access this url via the internet. Could anyone help?

SQL Server Reporting Service 2008 R2 - The request failed with HTTP status 401: Unauthorized.

  
I got the error "The request failed with HTTP status 401: Unauthorized." when I call the Reporting Service Web Service.

The code is very simple:

// Initialise the reporting service Web Service

this.RSWebService = new ReportingService2010();

// Pass windos authentication credentials to Web Service

this.RSWebService.Credentials = System.Net.CredentialCache.DefaultCredentials;

// List children

List<CatalogItem> reports = this.RSWebService.ListChildren(folder, false).ToList();

The SQL Server is installed on a different machine (say server A) from the Web server (say server B). We are using Windows Server 2003.

The code work fine for all the scenario below:

i) Run locally (XP) to call the web service on the sql server

ii) Provide the Network Credentials with the username, password, and domain when calling the web service

iii) If the web server and sql server is using same server (i.e. not distributed)

I'm using windows authentication and impersonation. Any idea?


Issue when migrating Reporting service reports from SQL Server 2005 to SQL Server 2008

  

Hi Friends,

We are migrating reporting service reports from SQL server 2005 to SQL Server 2008 and facing below login issue.

We got a virtual machine with 2003 server and got SQL Server 2008 installed with reporting service.

I was able to publish my 2005 reports using VS 2005 easily.


1) But when I try to run the reports I am getting below errors at my website home page.

The permissions granted to user 'DomainName\MachineName' are insufficient for performing this operation. (rsAccessDenied)

I could not get why there is no user name in above error and how it says machine name does not have permissioin?

There should be at least some user id mentioned as per me.

What could be the reason of above error?

2) Also when I try to run reports using Reports website (i.e. http://server/Reports URL), I get below errro in executing the reports.

"An error has occurred during report processing. (rsProcessingAborted)
Cannot create a connection to data source 'ReportSource'. (rsErrorOpeningConnection)
Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'."

Here the question is how it is picking up Anonymous logon. I thought it might be using Network Sevice acct to access reports.

What should I be doing to resolve above errors?

3) Also one more point about the s

Issue when migrating Reporting service reports from SQL Server 2005 to SQL Server 2008

  

Hi Friends,

We are migrating reporting service reports from SQL server 2005 to SQL Server 2008 and facing below login issue.

We got a virtual machine with 2003 server and got SQL Server 2008 installed with reporting service.

I was able to publish my 2005 reports using VS 2005 easily.


1) But when I try to run the reports I am getting below errors at my website home page.

The permissions granted to user 'DomainName\MachineName' are insufficient for performing this operation. (rsAccessDenied)

I could not get why there is no user name in above error and how it says machine name does not have permissioin?

There should be at least some user id mentioned as per me.

What could be the reason of above error?

2) Also when I try to run reports using Reports website (i.e. http://server/Reports URL), I get below errro in executing the reports.

"An error has occurred during report processing. (rsProcessingAborted)
Cannot create a connection to data source 'ReportSource'. (rsErrorOpeningConnection)
Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'."

Here the question is how it is picking up Anonymous logon. I thought it might be using Network Sevice acct to access reports.

What should I be doing to resolve above errors?

Static column after aggreate column in matrix reporting service 2008

  

Dear sir/madam,

I would like to creating cross tab with static column after aggregate column. My report showed as below:

No

Name of employee

Performance Rating

Total Rating (Average of Performance rating)

Previous Salary

Increment

1

2

Salary

Bonus

A. Managerial Employee

 

 

 

 

 

 

 

B. Non-Managerial Employee

 

 

 

 

 

 

 

Performance Rating is cross tab column

Total Rating is Aggregate column

Previous Average,Previous,Increment is static column

I look forward to hearing from you.

Thanks in advance,





SQL Server 2008 R2 Reporting Service Error

  

Hi everybody,

 

I have an error when i try to access http://localhost/ReportServer

The report server has encountered a configuration error. See the report server log files for more information. (rsServerConfigurationError)

 

I have found lots of posts according this error but any of it describes my error.

Do you have any ideas about problem reason?

 

I am using Forms authentification

 

Here is my LOG file:

<Header>
  <Product>Microsoft SQL Server Reporting Services Version 2009.0100.1600.01 ((KJ_RTM).100402-1539 )</Product>
  <Locale>English (United States)</Locale>
  <TimeZone>GTB Daylight Time</TimeZone>
  <Path>D:\SQLDATA\MSRS10_50.MSSQLSERVER\Reporting Services\Logfiles\ReportServerService__05_26_2010_09_29_36.log</Path>
  <SystemName>RAPORTALAPP1</SystemName>
  <OSName>Microsoft Windows NT 6.1.7600</OSName>
  <OSVersion&g

Design two column in reporting service 2008

  

Dear sir/madam,

I'm using Visual Studio 2008 and SQL Server 2008 SP1. I want to design data to show two columns in list as below:

Annual Appraisal       Probation Appraisal

Sepcial Appraisal       Comment

I look forward to hearing from you.

Thanks,

Seyha




Design two column in reporting service 2008

  

Dear sir/madam,

I'm using Visual Studio 2008 and SQL Server 2008 SP1. I want to design data to show two columns in list as below:

Annual Appraisal       Probation Appraisal

Sepcial Appraisal       Comment

I look forward to hearing from you.

Thanks,

Seyha

 


seyha

Reporting service 2008 with sql server 2005

  

Is SSRS2008 Report builder 2.0 sufficient for generating reports using sql server server 2005?


how to use visual studio to debug sql server reporting service 2008 by attaching process

  

I did custom security extension and want to debug it. I used to debug it using visual studio by attaching its iexplore.exe process using visual studio 2005 and sql server reporting services 2005. After then, I can debug UILogon.aspx.cs and AuthenticationExtension.cs in Microsoft.Samples.ReportingServices.CustomSecurity.dll. When I set break point, it can reach.

Now I used 2008 version for all application. After I attaching process, it can't reach break point I set. I realize sql server reporting services didn't use IIS and it use another component to hold web app. I may affect it and unable to debug it ? Do I need to do any configuration or any thing before I can use visual studio 2008 to do debug by attaching process ?

thanks

Gary

 


SSRS 2008 reporting service proxy issues

  

Hi friends,

We are facing the following issues after upgrading web reference to ReportService2010.asmx reporting service.

 

  1. The type or namespace name 'ReportParameter' could not be found (are you missing a using directive or an assembly reference?)   
  2. The type or namespace name 'ItemTypeEnum' could not be found (are you missing a using directive or an assembly reference?)    

Have any of you faced the same issues while upgrading the service reference?  Are there any alternative classes for the same. 

One alternative to the error no. 2 has been given in the following link.

http://www.deeptraining.com/litwin/devcnxfall10/Litwin_SQL_SBI305_ProgrammingReportingServices.pdf

But I am not able to find solution for error 1.  Please provide your views.

Thanks.

Murtaza

SQLServer 2008 R2 Reporting Service websevice url does not display with custom authentication

  

Hi:

I have installed SQLServer2008R2(CUD3) (64bits on Windows7) Reporting Service with custom authentication.  I can log in to the report server and report manager and everything appears fine, but the webservice url: http://myhost/ReportServer/ReportService2005.asmx no longer works (The webservice url did display before I put int custom authentication).  I got a html back with error message.

This webservice url used to be not protected.  I wonder if this is something changed in 2008R2 and it is a bug, or something I did not do it right.

 

Thanks for any help!

<html>
    <head>
       // some info here

</head>

    <body bgcolor="white">

            <span><H1>Server Error in '/ReportServer' Application.<hr width=100% size=1 color=silver></H1>

            <h2> <i>Access is denied.</i> </h2></span>

            <font face="Arial, Helvetica, Geneva, SunSans-Regular, sans-serif "

Trying to make a SQL Server Reporting Service 2008 report public for basic users

  

Hey.  I'm somewhat new to SSRS 2008 and I've built two datasources connecting to "HumanResources" and "HumanResourcesDev5" databases on a single server.  Both of those datasources have been changed from a Windows NT login clone to a preset login for a temp account that we have for testing called "Test2".  I have opened my created datasets and verified that when they open they ask for the password for the new credentials that I have set for the datasources.  After verifying this and the connection I re-opened the reports that I made within Report Builder (not Report Designer a VS extension) and verified all of the dataset and datasource information.  These reports and report parts get saved to the http://localhost/Reports folder within the server.  I have published the report parts to the /Report Parts folder within the localhost. 

This is where I begin to have issues...

When someone uses the reports that I have generated through report builder and link to them on our sharepoint site when a person without an actual account on the SQL server tries to view them they cannot because they do not have sufficient permissions.  And what I noticed is that it still tries to use their Windows NT credentials rather than the temp account (Test2) that we have created which is why they

Categories: 
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend