mikij Posted October 26, 2008 Share Posted October 26, 2008 Hi,I'm just not sure if this forum works at all, because I cannot get almost any answers to my questions :-(. I hope that this will be better, because I'm stuck with some things I asked on this forum, even though I read the book and tutorials :-(. I have simple table Orders, and I need to define report like this, e.g. for month october and complete year: Year: 1.1.2008 - 30.10.2008 Month: 1.10.-30.10.2008Order price | Value | Percent | | Value | Percent | --------------------------------------------------------------------- ---------------------------------------------------0-1000 | someValue$ | % (of all values) | | someValue$ | % (of all values) | --------------------------------------------------------------------- ---------------------------------------------------1000-2000 | someValue$ | % (of all values) | | someValue$ | % (of all values) | --------------------------------------------------------------------- ---------------------------------------------------etc., to 9000-10000. The same Price scope is for year (left table) and month (right table). Do you have ANY HINT how can I define report like this, because I don't have :-( ? --Thx in advance!! Link to comment Share on other sites More sharing options...
mdahlman Posted October 27, 2008 Share Posted October 27, 2008 mikij,This will be easiest to do as 2 subreports. Create a Year to Date report. Create a Month to Date report. Use these as subreport1 and subreport2 in a main report. Regards,Matt Link to comment Share on other sites More sharing options...
mikij Posted October 27, 2008 Author Share Posted October 27, 2008 O.K. Thank you. I'm just not sure for one more thing, how should I define this Order price scope (0-1000, 1000-1400, 1400-2000, etc. to 10000) ? --Thx in advance, Miki Link to comment Share on other sites More sharing options...
yskripch Posted October 28, 2008 Share Posted October 28, 2008 Are you grouping the values in your sql statement? Link to comment Share on other sites More sharing options...
mikij Posted October 28, 2008 Author Share Posted October 28, 2008 Yes, I need to group columns and to get sum for value column. Link to comment Share on other sites More sharing options...
mikij Posted October 30, 2008 Author Share Posted October 30, 2008 For this Order price scopes, I think that I can define then as "CASE WHEN" in SQL query ? But then I want to show all defined scopes, and where there is no values, I want to show 0. How can I define such a query ? Thx!! 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