HiForthe SSRS report, the client parameter value is passed in the URL, the value is in the dimension member unique name format, if the value is passed in with mixed case e.g. [Client].[Client Hierarchy].&[American Bank], the report runs fine, thestring is identified as valid member. But when the value is passed as all uppercase like [Client].[Client Hierarchy].&[AMERICAN BANK] the string is identified as invalid member. The report works fine when the client name is in complete lowercase.The MDX that is running behind the scene runs fine for any of the above strings and returns valid member. When I browse the diemsnion, all member names are in uppercase. And we have a similar setup of SSRS server SSRS_UAT, whichuses the same OLAP cubeas source. When I run the report throughURL against this UAT server, the report runs fine with any client name string passed, it does not care about case. The following are the set up configs:1. The ReportServer database (on sql server) for both report servers have collation as Latin1_General_CI_AS_KS_WS which is case insensitive2. The dimensionisbuilt with collation as "Latin1_General, Accent sensitive"Not sure why the two SSRSreport servers behave differently?? I also looked in ReportServer config filebut could not findany setting / parameter related to case sensitivity. I wonder if there is any other report server level config parameter. Anyone can help me out to resolve this?For now I have updated the report to conver the parameter value into all lowercase so the report works fine.Thanks Shailesh

Hi Sharilesh, There is an option to set the data case sensitivity in Business Intelligence Development Studio 2005. Go there by opening the dataset window and switching to Data Options tab. You can set it to false to disable the data case sensitive. Hope this help. Thanks, Jerry

Hi Jerry,Thanks for the reply. I cannotsee the data options tab. I can open data set window by using View --> Datasets or Ctrl+Alt+DWould you please let me know how can I go to data options tab?Thanks again,Shailesh

Hi Shailesh, When building a report, you will use Data tab, Layout tab and Preview tab. Please switch Data tab and select the dataset you want in the dataset dropdown list, then click the Edit selected Dataset button, which is the ellipsis button() next to the dataset drop down list, to view the dataset dialog box. In the box, you can see the data options tab. Thanks, Jerry

Happy New Year Jerry and everyone else. I see where this can be changed for a particular report and this is nice however is there a way to change this for the SSRS server as a whole or on the main DS itself? The project I’m working, I don’t control all of the SSRS reports and therefore I can’t (easily) set this option on every report. http://www.enhansoft.com/