Hi All, I have created Ad-Hoc Report Model Project for End Users . I am using SQL server 2008 R2 with Report Builder 3.0. Dataset 1 as Select Region, District, TotalSales, TotalOrder from Sales When User will run report then they have to enter Input parameter Customername, which is drop down box. But the problem is that, Using Report Builder 3.0 I have created Cname dataset (dataset2) and all the customernames should populated in ASC order but it is not in order.. I mean I need all customer name in ASC order. More on this, I am unable to write SQL query here. Any Idea... Please Help.... Thanks in Advance... fredy

I mean I need all customer name in ASC order. More on this, I am unable to write SQL query here. Hello Fredy, Then add a ORDER BY clause to your query, like SELECT * FROM yourTable ORDER BY CustomerName ASC; Optional you can define the sort option for the tablix in Report Builder. Olaf Helper * cogito ergo sum * errare humanum est * quote erat demonstrandum * Wenn ich denke, ist das ein Fehler und das beweise ich tglich Blog Xing

I mean I need all customer name in ASC order. More on this, I am unable to write SQL query here. Hello Fredy, Then add a ORDER BY clause to your query, like SELECT * FROM yourTable ORDER BY CustomerName ASC; Optional you can define the sort option for the tablix in Report Builder. Olaf Helper * cogito ergo sum * errare humanum est * quote erat demonstrandum * Wenn ich denke, ist das ein Fehler und das beweise ich tglich Blog Xing

Hi, I think, you can not do this unless you add ORDER BY on customer name in DSV file. This would be difficult as after doing this you need to redeploy model. There is also one more workaround you can take, as suggested below. http://blogs.msdn.com/b/bobmeyers/archive/2007/10/11/sorting-the-values-in-parameter-dropdowns-in-report-builder.aspx - Chintak (My Blog)

Hi Olaf Helper , Thanks for quick reply but it is not possible. because when I click on Query Designer then there is Semantic Query so I am unable to write any query over there. It seems that it is a xml code or something. I am not sure on that..

Hi Olaf Helper , Thanks for quick reply but it is not possible. because when I click on Query Designer then there is Semantic Query so I am unable to write any query over there. It seems that it is a xml code or something. I am not sure on that..

Hi There Thanks for your posting. I think this is currently a limitation for more details http://social.msdn.microsoft.com/Forums/en-US/sqlreportingservices/thread/06a22ad8-829b-4b79-9407-f6c0dff58c40 The work around provided by Chintak work some time, you can try finger cross Many thanks Syed

Hi There Thanks for your posting. I think this is currently a limitation for more details http://social.msdn.microsoft.com/Forums/en-US/sqlreportingservices/thread/06a22ad8-829b-4b79-9407-f6c0dff58c40 The work around provided by Chintak work some time, you can try finger cross Many thanks Syed

Thanks Chintak, For your quick reply.. For the people whom this might help. Just work around in my case is that there were around more than 1000 distinct customername in the Sales table but End Users is using only 10 from that list so, I made a new dataset (cname) in which I select those 10 customername. My input parameter directed to take values from new dataset name(cname). Earlier I was trying to select distinct but since end users is using only 10 out of 1000 that save in my case. Hope it will help to someone. Thanks to Everyone for your comments. Fredy

Thanks Chintak, For your quick reply.. For the people whom this might help. Just work around in my case is that there were around more than 1000 distinct customername in the Sales table but End Users is using only 10 from that list so, I made a new dataset (cname) in which I select those 10 customername. My input parameter directed to take values from new dataset name(cname). Earlier I was trying to select distinct but since end users is using only 10 out of 1000 that save in my case. Hope it will help to someone. Thanks to Everyone for your comments. Fredy

Hey Fredyy.. for this, this solution might help you .. when you select entity fields from Query Designer.. at that time.. for the specific field, you want to sorting.. just drag that field ahead and you will get sorted field. just look below image.. suppose you want to sort on full name .. drag it to out of entity groups.. you will get sorted output of full name in this dataset.. try it out .. it will work 100 % .. :) same way.. if you want to sort birthdate. drag it out to entity grouping.. 20CF

Hey Fredyy.. for this, this solution might help you .. when you select entity fields from Query Designer.. at that time.. for the specific field, you want to sorting.. just drag that field ahead and you will get sorted field. just look below image.. suppose you want to sort on full name .. drag it to out of entity groups.. you will get sorted output of full name in this dataset.. try it out .. it will work 100 % .. :) same way.. if you want to sort birthdate. drag it out to entity grouping.. 20CF