I am working with a fairly large dataset, that includes 166 indicators of community health in the cities and counties of Virginia. In terms of functionality, I need to be able to search by certain cities and counties, and display all indicators listed vertically below for those selected cities and counties. This functionality is satisfied with a gallery report, because a gallery report gives me the indicators and data in a list below each city/county.
However, a table report is stylistically what I need - in that there is a single column with the indicator names, and the data is listed to the right. Yet, I need to be able to list the cities/counties as columns and the data as rows - which is satisfied in a gallery report. Essentially, a gallery report flips my data table so that I may search by city/county and return results vertically below. My problem with a gallery report is that it repeats the indicator names for each city/county returned in the results page, and is aesthetically not efficient in terms of space on my webpage.
Therefore, I would like to request the following customization:
Can someone tell me how to customize a gallery report that (1) lists only a single column of indicator names, and (2) adds borders within the data cells?
I am attaching a sample of my dataset. As you can see, the locality (city/county) must be listed in a column (in this case, Column D). This way, it is searchable and I may customize the number format of the remaining indicators - in the rest of the columns). Essentially, the gallery report is optimal because it allows me to search on Column D (my cities and counties) but then displays the remaining columns/indicators below. Rather than a table report, that fixes the indicators as column headings.
You can post now and register later.
If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.
Question
chsolutions
I am working with a fairly large dataset, that includes 166 indicators of community health in the cities and counties of Virginia. In terms of functionality, I need to be able to search by certain cities and counties, and display all indicators listed vertically below for those selected cities and counties. This functionality is satisfied with a gallery report, because a gallery report gives me the indicators and data in a list below each city/county.
However, a table report is stylistically what I need - in that there is a single column with the indicator names, and the data is listed to the right. Yet, I need to be able to list the cities/counties as columns and the data as rows - which is satisfied in a gallery report. Essentially, a gallery report flips my data table so that I may search by city/county and return results vertically below. My problem with a gallery report is that it repeats the indicator names for each city/county returned in the results page, and is aesthetically not efficient in terms of space on my webpage.
Therefore, I would like to request the following customization:
Can someone tell me how to customize a gallery report that (1) lists only a single column of indicator names, and (2) adds borders within the data cells?
I am attaching a sample of my dataset. As you can see, the locality (city/county) must be listed in a column (in this case, Column D). This way, it is searchable and I may customize the number format of the remaining indicators - in the rest of the columns). Essentially, the gallery report is optimal because it allows me to search on Column D (my cities and counties) but then displays the remaining columns/indicators below. Rather than a table report, that fixes the indicators as column headings.
Link to comment
Share on other sites
2 answers to this question
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.