florian.johannssen Posted January 2, 2017 Share Posted January 2, 2017 Hi Jasper fans,i want to sort my data by using a variable. So far so good. On the first view, the order seems to be correctly. The picture below shows what is going wrong. I define the variable as no calculation function. Increment type and reset type are setted to None. Dones anyone have an idea?Kind RegardsFlorian Link to comment Share on other sites More sharing options...
hozawa Posted January 3, 2017 Share Posted January 3, 2017 Sorry, but no idea what you are trying to do by looking at your images.If you want to change sorting, just use $P! parameter in your sql statement.http://community.jaspersoft.com/documentation/tibco-jaspersoft-studio-user-guide/v630/using-parameters-queries Link to comment Share on other sites More sharing options...
Sukanya Parisa Posted January 3, 2017 Share Posted January 3, 2017 I think it is considering as string like 15,16,17,18,19,2,21,22,23...it is considering numbers starting with 1 then again starting with 2, May be resolved by changing the variable type to integer if it is string type Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now