.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

range inclusive ssrs report builder using SSAS as source unsolved

Posted By:      Posted Date: April 10, 2011    Points: 0   Category :


I am trying to use MDX query designer in SSRS report builder. I choose a date dimension and i need to include a range for it . So i selected range inclusive as the filter.

When i do that and give default dates it works fine. When i select parameters it and hit ok. it immediately throws a error.

"Query (1, 216) The restrictions imposed by the CONSTRAINED flag in the STRTOMEMBER function were violated."

So i went ahead changed it to scripting mode and removed the "constrainted" flag and ran it . but then a different error comes up


then i get this error.

"Query (1, 216) The STRTOMEMBER function expects a member expression for the 1 argument. A tuple set expression was used."

what do i need to do to make this compile correctly. Please suggest. I am working on this for 2 weeks. 

View Complete Post

More Related Resource Links

SSRS 2008 R2 and sharepoint 2007 report builder problems


I upgraded our enterprise sql server 2008 to sql server 2008 r2 last weekend.  Along with this i installed the report builder 3.0 on the servers as well and the updated ssrs add in for sharepoint.  The upgrade went fine, no errors that i could find.  The problem is now when i go to a library that has the report builder content type enabled and click report builder report under new it does not load report builder 3.0.

I updated the custom report builder url in central administration from /_vti_bin/ReportBuilder/ReportBuilder_2_0_0_0.application to /_vti_bin/ReportBuilder/ReportBuilder_3_0_0_0.application

however when i do click the new report builder report it kicks me over to http://company.com/ReportServer_MossEnt  which itemizes out each individual sharepoint site in the farm.

Is the integration of ssrs 2008 r2, sharepoint 2007 and report builder 3.0 work?  did i install the wrong version of the report builder add in?  The above is the only problem i am having now.

all servers are server 2008, 64 bit and moss 2007 enterprise with sp2 & april 2010 cu

[SSRS 2008 R2]Report Builder Access error-The remote server returned an error: (401) Unauthorized.

Hello,        I am able to login Web Service URL and report manager using computer name and report builder is also working fine.  http://RPTSRV/reportserver   (RPTSRV is report server name. web service url working fine. all accessible) http://RPTSRV/reports  (report manager working fine and all accessible ,report builder too) It means I am able to access everything locally right? http://rs.test.abc.com/reportserver  (web service url working fine. all accessible)  http://rs.test.abc.com/reports    (Report manager working fine and all accessible accept report builder)(I carefully checked the link and its taking rs.test.abc.com/reportserver.....)     when I click on reportbuilder button in report manager it shows me error dialog box with following error log!! I tried from local and remote computer too but gives the same error both side. I am not sure but I am just thinking is this double hop kerberos security issue? Please help me to solve this problem. I am finding solution from last 4 days. Reporting Service configuratin tool settings Web Serivice URL -  all set to default Report Manager URL - all set to default Environment - Distributed deployment Server1(report_srv) --Windows server 2003, Installed sql server 2008R2 reporting service,

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

SSRS Report Builder "Application cannot be started, contact application vendor"

Hi   In Report Manager, when i click on report builder its show me an error like "Application cannot be started, contact application vendor " I installed .net framework 2.0, I'm using windows 7,Sql server 2005 Can any one please help on this...   Thanks Sharon

SSRS Report based on SSAS Cubes doesn't show NULL values correctly

I have a SSRS report which is based on an SSAS Cube. In the Cube the formating of numeric fields that NULL values are properly shown as NULL values. In the Cube Browser and Excel this is shown correctly. However when I design the report already the query against SSAS shows these fields as "0" instead of NULL. Is there a way to fix this or is this a bug ?  

SSAS - calculation of ssrs report should be calculated before calculation in MDX script

Hi All I have: - A calculated member defined in an mdx query of an SSRS report (using the aggregate function). - A calculated member defined in the MDX Script of the cube The calculated member of the cube calculates a ratio. What we should achieve is the ratio of the aggregated members (defined in the report) and not the aggregation of the ratios. I thought that it would be automatically enforced by: http://msdn.microsoft.com/en-us/library/ms145539.aspx :"The exception to this precedence is the Aggregate function. Calculated members with the Aggregate function have a lower solve order than any intersecting calculated measure." I tried to play with the solve_order of the two calculated members (defining explicitly a lower solve_order for the aggregation defined in the report), but the calculation of the cubes is always executed first => I end up with the aggregation of the ratios. Are calculations defined in the MDX script always executed first? This doesn't seem logical to me.. Thanks a lot for your help. Regards Stefan    

Server 2008 R2 64 bit, SSRS 2008 64 bit with Report Builder 3.0 issues with Oracle OLE Driver

Folks, ran out of idea on this issues. Setup as shown at the Title. I can connect via VS 2010  but report builder cannot run properly when setup with connection string. I use a 32 bit Oracle Driver and VS 2010 works well with it, however, Report Builder on SSRS report a bad image issues while attempting to use the same driver. What have been tried: 1-Already attempted to try to download Oracle ODP drivers 64 bit, but current driver 11g and minor version above 11g does not install, installation failed. So far all chats indicated that Server 2008 R2 does not have a Oracle 64 bit driver provided y Oracle. Any help is appreciated ....    

Report Builder 3.0 Compatibility with SSRS and Sql Server 2008 (not R2)

I've built reports in Report Builder 3.0 (which I love!). I tried to deploy the reports to an instance of SSRS installed with SQL Server 2008 (not R2). I can't deploy the reports - it appears SSRS is not forward compatible with Report Builder 3.0 reports. Would SQL Server 2008 SP1 help? Is there anything I can do to use Report Builder 3.0 with SSRS 2008?

Unfortunately, I cannot install SQL Server 2008 R2 in the production environment (yet).

I'm getting exception while running Report builder 2.0 for SSRS Reports

I'm getting Exception like Failed to Preview Report "The request failed with HTTP status 401: Unauthorized." for SSRS Reports from Report Builder 2.0 application? May i know the reason?
Also please inform any other way to Preview Reports On SSRS through Report Builder.?

Note : I'm Using the Report Server as remote machine.


Default date selection in SSRS with SSAS cube as a source




I am fairly new to SSAS and I am hoping that someone can help me with an issue I am experiencing.  I am create a SSRS report that goes against a SSAS cube.  My cube has a Date dimension with a Fiscal Year - Fiscal Quarter - Fiscal Month hierarchy.  In my report I have created filters for a From Date and a To Date, which are populated with the hierarchy of the Date dimension.


I need to default the filters as follows:


To Date = current quarter (that is the last quarter with fact data)

From Date = the To Date quarter from the previous year (e.g. if To Date quarter = Q1 2008, then From Date quarter needs to be Q1 2007)


I found some SSAS code that allows me to get the index of the last quarter with data, but I am stuck at this point.  I am not sure how I can translate this into a default selection for the To Date SSRS report parameter.  I also realize that there may be a better approach.



SSAS Calculated Member not working as expected in a SSRS report


Dear forum guys, I have a simple cube to analyze my customer's sales. I have a Time Dimension, a Product Dimension (with a few hierarchys) and a couple measures (sales and purchase amounts).


I also have defined a few Calculated Members, in particular the average sales and purchase amount over the last 12 months from the selected month.


I need to show the results in a SSRS Report: the user must select a month and the report needs to show the sales and purchase amount of the selected month and the average of the previous 12 months (both for sales and purchases).


Everything works perfectly if I test the cube using the Cube Browser or Excel 2007 as a client.


When I define the SSRS Report I cannot get to work with the calculated members (the average): I get strange numbers which are much higher than the real numbers.


I've tried both Matrix and Table reports.


Can anyone suggest me what I'm doing wrong: I think this should be a very common mistake.


Best regards



SSRS - Report Builder - Wildcard usage in a Filter?


I am trying to use a wildcard in a Filter condition within a SSRS - Report Builder report. 


Are wildcards of anytime in fact allowed in this tool?  I get errors when I try to use SQL-like wildcards such as '%'.  I've also been unable to find any mention of "wildcards" in HELP.


Please help as soon as possible.  THANKS!

SSRS working fine in Report builder and manager but not in Report viewer


HI I have a report that worked fine until we upgraded the SQL server from 2008 to 2008 R2 and the report viewer to latest version as well.
This report has a pie display, NOW instead of showing one pie, it is showing 20 pies!

I am trrying to learn how to resolve and what is causing this. 

SSRS 2008 R2 report builder 3.0 map wizard bubble color not showing up


Some blog posts out there show an option for bubble color in the map wizard. Currently I only see an option for size.

Is this something that didn't make it out of beta?


Can I have 3 different tables in a report? And, can I pass 3 temp table to SSRS as source for these

I'm using BI 2008 and sql 2005 and 2008.  Is there an example to show me?  Thanks.

Report Builder:The type of the data source has not been specified.



I am getting the folloing error when I try to run the reeeport through report builder

The type of the data source has not been specified.

An error has occurred during report processing.

Please tell me what can i do to avoid this

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
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