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

Top 5 Contributors of the Month
Gaurav Pal
Post New Web Links

SSRS 2005 Report Writer Limitation- 128 Max Length for Query Strings Constructed in Data Tab???!!!

Posted By:      Posted Date: October 21, 2010    Points: 0   Category :Sql Server

I'm trying to construct a SELECT query within the Report Writer 2005 Data Tab as follows- ="SELECT blah..." & SomeFunctionToConstructWhereClause() " ORDER BY 1"

When the length exceeds 128 characters, I get the following error (works otherwise)- Microsoft Report Designer Incorrect syntax near '='. <QUERY TEXT> The identifier that starts with is too long. Maximum length is 128.

Say it isn't so or that there is a reasonable workaround for this. 128 characters isn't that much when you're talking about complex query strings. Thanks in advance.

View Complete Post

More Related Resource Links

SSRS 2005 Error: Cannot add multi valued query parameter for data set because it is not supported b



getting the above error when running a report in SSRS 2005, using a stored procedure with many input parameters,

connected to a Sybase IQ database,

I want to have some of the prompts to be multi valued prompts.......

Please advise on how to fix......



Data source not found issue in subscribed report (subscribed in ssrs 2005) , with shared data source


Recently we have upgraded from SQL 2005 to SQL 2008. Following is the issue am facing in some reports in SSRS 2008. More details are below. Any solution/ cause for the issue would be of great help.

 1) Reports having issue are the ones which were deployed in SSRS 2005 through SUBSCRIPTION (Listed under My Subscriptions) and now tried to view in SSRS 2008.

2) The reports use a shared data source with name ‘Test Center’

3) After upgrading to 2008 and when we try to open the report data source not found error is thrown. “An error occurred during client rendering. An error has occurred during report processing. The data source ‘Test_Center’ cannot be found". Why does it have ‘_’ added in the data source name !!

4) When we go to the report Properties – Data sources and check the path of the shared data source, the path is correct and the data source do exists in the path.

5) If we go to report Properties – General – Report Definition – select Edit and save the RDL. Immediately select Update and browse the saved RDL and upload. The report works fine. However the data source reference still remains same.

6) Also if we deploy a report fresh referring the same data source, that too runs fine with no issues.

- Thanks & Regards, RaSuHe

SQL Server 2005: Jazz Up Your Data Using Custom Report Items In SQL Server Reporting Services


Custom report items in SQL Server 2005 Reporting Services address your needs for custom reports without the pain of doing it from scratch.

Teo Lachev

MSDN Magazine October 2006

Data Points: Report Controls in SQL Server 2005 Reporting Services


Reporting has always been one of the dark arts of development. The tools typically seem to do just enough to get you to a certain point, then leave you to find workarounds to solve more complex issues.

John Papa

MSDN Magazine July 2006

Web Q&A: Storing SQL Data, URL Query Length, and More


Find out the best way to store large amounts of XML data in SQL Server, along with the performance implications. What's the maximum length of an XML query to SQL Server in a URL?

Edited by Nancy Michell

MSDN Magazine May 2003

Report printing problem(ssrs 2005)

HI   i have a SSRS 2005 report with width as 32 inches i have a requirement to print the report in a3 landscape  but when i print the report it comes in 3 page width   is there any way to auto scale the report into a3 size without affecting the view in the report viewer   Thanks varun kumar

ssrs 2005 default value generates report

Hi, If all parameters have default value the report generates as soon as i load the report. Is it possible to only run the report when clicking on the view report button even if all parameters have default values? Thanks

SQL Reporting Service 2005 - share schedule report performace T-SQL query?

Hi, I have SQL 2005 reporting services Shared Schedules and each schedule has its own subscribed report. I would like to have T-SQL 2005 to find out performance loading on each schedule. i.e. MySchedule_1 has 10 reports in it and AVEGARE report eaxecutiontime is like 3mins 5sec      MySchedule_2 has 7 reports in it and AVEGARE report eaxecutiontime is like 4mins 9sec Pls can I have T-SQL 2005 on ReportServer database to find out load on each schedules (and more drill-down to each report level for execution time)?

SSRS 2008 R2 - Query builder freezes and needs to be shut down Report Builder 3 when attempting quie

Hi, In SSRS, using Report Builder 3.0 (SSRS R2), after choosing a Report Model as the report's embedded data source, launched "Query Deisinger…" from GUI to build data source in report.  First 1-2 attempts at querying underlying data source (Oracle back-end), are successful, but later attempts freeze application to the point where application freezes and overall Report Builder application needs to be forcibly shut-down. This system freeze has occurred when referencing tables containing a very small number of records as well as larger data sets.  Suspect that application freezing may be caused by timing-out of connection to back-end database. but I am not sure. Any suggestion to solve this issue? Thanks   Environment - Distributed deployment Server1(report_srv) --Windows server 2003R2 64bit, Installed sql server 2008R2 reporting service, configuration tools Server2 (report_db_srv) --windows server 2003r2 64bit, sql server 2005 for report server database

Multivalued parameter & Data driven subscription for SSRS 2005

I need to create data driven subscription for our reports. Most our reports have multi valued parameters (7-12 parameters with at least 4-5 with multiple values)and need to be send to a users between the range of 25-200. So standard subscription is really not a choice.I have gone through most of the threads before. Question 1:Does any one have a solution for the SSRS 2005 regarding passing mutiple values for a parameter for the Data subscription table. If yes, could you please share the information. Question 2:I found some solutions using the SOAP API. Can any one explain that in detail- how we can do it ?Reference:http://social.msdn.microsoft.com/forums/en-US/sqlreportingservices/thread/8ab615b4-1373-4258-bf49-c2843cfea8e9/http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=516735&SiteID=1 Question 3:Here is the other solution I found in one of the postsApparently passing in values like {A, B, C} only works when you configure the parameter values not to come from a dataset so that SSRS doesnt check for ValidValues.Reference: http://social.msdn.microsoft.com/forums/en-US/sqlreportingservices/thread/b2c50aea-2032-4025-a155-306c00fcb856/Any commends about this solution?Thanks

Cannot create a connection to data source !!!! SSRS 2005

I cannot get this error resolve either for myself or any users, and I'm actually part of the Admin group!  Furthermore, a user with whom I'm tring allow to view this report keeps getting prompted for their windows username and password.  I thought that since this datasource was set to Windows Authentification that it would just pass it through? I'm pulling my hair out at this point: Screen Shots: http://www.webfound.net/datasource_connection.jpg http://www.webfound.net/datasource_connection2.jpg http://www.webfound.net/datasource_connection3.jpg Also As far as I know, I've given sufficient permissions to the right logins and right users on my SQL Databases and related stored procs that the datasets (not datasource) run An error has occurred during report processing. Cannot create a connection to data source 'datasourcename'. For more information about this error navigate to the report server on the local server machine, or enable remote errors

SSRS 2005 Report with 7 subreports


I've SSRS 2005 Report with 7 subreports.
Toplevel report runs the query and returns recordset.

RegionID  CustID orderID  OBID     State      City       Name
69            1230    4565      75855    NY         NYC       Sam

Now i need to pass these values in subreports's query as parameter
something like
select * from Region where regionID = @RegionId (in my case it shud get 69 from upper record set.)
Likewise there are 6 more subreports where i need to pass above values as parameter.

Any suggestions would be very helpful.

Thank you,

SSRS 2005/2008 - Chart with bar graph not generating on subsequent executions of report even with mo


For a report executed from Report Manager that has a bar chart component, regenerating the report via refresh or view with same input parameters either gives a different result that is garbled or an empty chart (2008) or no chart at all (2005). I have the report set up to not do any caching, so that does not seem to be the issue. Is there some chart option I may need to set to get the proper chart display.

Report conversion from SSRS 2005 to SSRS 2008


I am converting reports developed in SSRS 2005 into SSRS 2008. In the report design interface I have several rows and columans of data that calculate count or rate. In addition to rows and columns, I have around ten hidden tablixes in which report expression calls hidden codes inside tablix to perform calculation with main report. My problem is when I set hidden tablix propert into hide, I am not getting correct calculation in my report.  when I change tablix property from hidden to show I will get correct calculation but I do not want to see those hidden tablixes in my report page. Is there any way  you can still call expressions inside hidden tablixes without turning on tablix property show in SSRS 2008? Is it a bug in SSRS 2008 reporting system? Please help me out!!

My operating system is windows vista.



YTD Variance on Matrix Report - SSRS 2005


I am trying to set up a report that pulls how many patients were referred to our physicians by other physicians in town.  I have a matrix report set up with parameters so that at the end of each month users can select the month and year and it will pull data year to date for the selected year and the year prior to the selected year.  The report ends up looking a little something like this

           CurrentYear     PrevYear

Phys1  3                      4

Phys2  5                      2

Phys2  6                      1


We need to have at least one column to calculate teh variance between the two years and possible a second for % variance.  I have been scouring the web and most answers seem to apply to 2008 but unfortunately this is a 2005 server.  Any help or pointers in the right direction are appreciated.

SSRS 2005 Report Printing Additional Blank Page



New to SSRS 2005 and having some problems printing. I have a report that has only 7 columns and while in layout mode, the body of the report only has a width of not even 7 inches. I have made my left margin 0.2 in, RM at 0 in, TM at 0 in and BM at 0 in as well and yet when I print, I get an additional blank page. All my records print in the first page just fine but I get the additional blank page. This also happens to me on a different report when I change the settings for landscape printing. I am able to fit all the columns in one page using landscape but get an additional blank page for every page that is printed. So instead of printing just two pages of records, I get 2 additional blank pages.

Any help will be greatly appreciated.



SSRS 2000 reports when upgraded to 2005 report with subreport really really slow


We recently upgraded a report server and corresponding reports from SQL Server 2000 (reports 2003) to SQL Server 2005. After upgrade one of our reports which use two subreport is very very slow.

The sp's used for these all these reports are fast. All the sp's together takes about 40 secs.

Both in the BIDS environment as well as the report site the report is very slow.

We are using a database in which data is inserted through replicatoin. In all our sp's we have given 'with nolock' along with the table names.

Can anyone please help me here?

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