Andrew6464

Hello, I want to try and define multiple measures but have them in seperate columns My design in Jaspersoft currently looks like this Is there any way to drag the Cost Name and the Location Cost Measure so that they are in a new column

Hi, I'm trying to see if there is a way of adding the data for both the rows and columns in different queries The SQL query has three columns - location name, location type and size of location. The location name will be the row header and location type is a column I need to display all location names which may not have a location type. Currently this creates a null column and and I haven't found a way of hiding it. If I filter out nulls in my query, it then excludes location names with no type but as I have said, I need to show all location names Is there any way I can run one query which will output all location names with a type and then run another query to add the remaining location names