Last Week in the Forums: Using the Concatenate Aggregate, Hiding a Column When There is No Data

This blog series takes a look back at the past week in the forums, recalling how active they were and highlights some of the questions asked that seem to frequent the forums or other interesting topics. The forums have been very busy over the past several weeks heading towards the end of the year, but it looks like they’re starting to slow down as the holidays approach. This may be because of an issue with the response notification server going down and not notifying those who had a response to their thread last week. This is fixed now. As always, thanks to those members who are helping answer questions in the forums. It is a great help to the community!

The first topic that will be covered this week is about showing all values of field 2 that correspond to the same value in field 1. For example, in this thread, the poster had data like:

Model Year
Mod1 1990
Mod1 1991
Mod1 1992
Mod2 1991
Mod2 1992

and wanted it to look like:

Model Year
Mod1 1990-1992 –or–
Mod2 1991, 1992

The solution given for this was to use grouping on the “Model” field and then to create an aggregation in the group header with the “concatenate” aggregation function.

The second topic I’ll cover this week is about hiding a particular column in a report table if it returns no data. The solution to this is to initialize a variable to 0 in your initialize script, increment it or change the value in the onFetch script, finally, add a “dummy” text box at the top of your report and bind it to your dataSet. This will cause the dataSet to run so that your script is run so that you know if there are any values in the column. You can now use the visibility for the column and check the value of your variable to know whether to hide the column or not.

The last topic for this week is one that gets asked on a pretty regular basis. It is using multiple master pages. The poster wanted to have an option for the user to have the report in landscape or portrait. The way to do this is to set up two different master pages, one of each type. Then in your first element’s script, you can set your masterpage to the appropriate masterpage by grabbing the element’s style and setting the masterpage property.

Again, this is just a small sample of what went through the forums this past week. For more questions and answers that have been posted, check out the forums. As always, if you have a question, feel free to ask it, and if you see a question you know the answer to or have a similar experience to, feel free to post an answer or comment. 

Write a Reply or Comment

Your email address will not be published. Required fields are marked *