Last post Jul 25, 2011 10:09 AM by MyronCope
Jul 22, 2011 03:51 PM|MyronCope|LINK
using rept builder 2.0
I have a tablix inside a report and I am ordering by a field ProductID (in my SQL query)
and i clicked on the tablix properties containing the report and then sorted by the ProductID (A to Z) but when I run the report the report is not ordering by the ProductID
the PRoductID is varchar but I am converting that to Int in my query so I am very puzzled as to whats happening
when I run my sql query all is well, it sorts perfectyl but not in the report, very puzzling
I even tried converting ProductID in the tablix sort expression but that did nothing
Jul 23, 2011 06:08 AM|princeG|LINK
Use Order by
Jul 24, 2011 10:22 PM|MyronCope|LINK
thanks for the feedback.
I am using ORDER BY in the sql query and when I run the query it returns in the correct order but when I run the report it changes the order which I cannot figure out.
Jul 25, 2011 10:09 AM|MyronCope|LINK
using Order by worked.
I'm modifying an existing report and found another Order by on it for a different field, removed that and my Order by in the sql worked