SQL 2005 Reporting Services
-
Hi Guys I have a query that I am using to build a report in SRS 2005. The query sorts records by Customer ASC. When I view the query in SRS 2005 it is still sorted correctly. I have a group by Customer in the report. If I view the Report, my records comes back totally out of order. I also tried to force a sort by using the group properties and setting the sorting to customer, but still no luck. Can someone please tell me how I will be able to get this records sorted properly? I will really be greatfull for your help. Kind Regards, Elizma
-
Hi Guys I have a query that I am using to build a report in SRS 2005. The query sorts records by Customer ASC. When I view the query in SRS 2005 it is still sorted correctly. I have a group by Customer in the report. If I view the Report, my records comes back totally out of order. I also tried to force a sort by using the group properties and setting the sorting to customer, but still no luck. Can someone please tell me how I will be able to get this records sorted properly? I will really be greatfull for your help. Kind Regards, Elizma
-
Hi, Thanks for the willingness to help. I dont know what the problem was, but I deleted the report table, recreated it and then it worked fine. Elizma