bp21 wrote:WHAT's your apex VERSION?
I am using standard report. I have a situation wherein I need to display more than one table in the report from a single query. Tables are seperated based on the value in one of the column's data.
For example, I have employees table. In the report, I want three tables like: 1) employees having personal vehicle 2) employees not having personal vehicle 3) employees who belong to facilities division
Is this doable? If so, how can I achieve this?
bp21 wrote:But how do you determine which categories employees belong to?
Yes, but I dont see the columns listed in Break Columns for which I want to break on. I see only First, First and Second and First,Second and Third only whereas there are more than 3 columns in my report.
1) employees having personal vehicle 2) employees not having personal vehicle 3) employees who belong to facilities divisionAre these categories based on data in the report? Which column(s)?
bp21 wrote:Then it sounds like you can create a report based on a query like:
For the first two tables that I want in report, I have a column 'vehicle' in employee table. If that has some value then the employee has vehicle else if the column has null value then the employee does not have vehicle.
For third table, I have a column 'division' with different values in it and I want to select one division employees.
Then set the Break Formatting options:
select case division when 'facilities' then '3) employees who belong to facilities division' else nvl2(vehicle, '1) employees having personal vehicle', '2) employees not having personal vehicle') end category , ... from employees ... order by category ...
bp21 wrote:Doing so in a single standard report—if it's even possible—would be decidedly non-trivial. I don't have time to get into it just now (might be a interesting puzzle for the weekend...)
I am unable to use
as I have sortable columns. Is there any other way to do this?
order by category