I was doing a report and used a query. However, the table I get is too long because it includes all the attributes even with blanks. How can edit the query for me to get a table just with the attributes that have values?
I used the filter option of the Cross Tab Editing properties, but every time I add a filter it understands it as && instead of ll. So I just get the table with the rows that have values for all the attributes and the ones that have some missing values are not considered.
@Jackie If I’m reading your messages correctly, you’ve done the following:
Created a query.
Added that query as a new dataset to a report
Added the query dataset to the report
Upon adding it, the table is too long/wide?
So-the issue is that you want the table in the report to have fewer A) columns and/or B) rows?
For A) columns, you can do several things:
Refine the query itself in the query builder (ie, more targeted query instead of general)
Modify the query to only have the columns of data that are required in them. Use the "query properties..." link on the tabular results page of a query. Uncheck "Only Show Columns With Data", then click "De-Select All" and check off whichever attributes you need.
Add the dataset to the report and only tick the attributes you want to use
For B) rows (e.g., I want to see all the wildlife species observed by rangers in a month, but I only want to see the species that were observed listed, not the full species list with many blanks) you can also do several things:
Refine the query itself in the query builder (eg, in the species example, you can use the filters option un the row header group bys to only select the species you're interested in)
Use a filter to only show attributes with data. In the species example, assume you have a table that is two columns: "Species Name" & "Number of Observations". If you only want to show species that were observed, create a filter for "Number of Observations" greater than 0.
What I need is the table to show all the data available for “Cantidad”, “Número de árboles” and “Volumen (m3)” for my specie “Cedro”, even when not all the variables have values.
So, I need to erase all the rows that are completely blank for all my variables. Something like this
@Jackie Without knowing context specific details, the simplest way I know of to get an output that looks like the table below is to create a computed column and then set the filter for that.
Your computed column in this case could be “Timber evidence” and then you would use the expression builder to define it as:
“Cantidad” + “Numero de arboles” + “Volumen”.
This would just sum the values in those three attributes, but then you would set the filter for the computed column value…
Timber evidence is >0
…meaning if any of those have any value they would make the computed columns value greater than 0 (hence visible).
You wouldn’t need to include the computed column in the table to do this, as you would set this in the data set, not the table itself.