this is where I also am having some issues. Then, I tried applying what Terry wrote for the expressions. The user of this report would like to see it report exported in Excel with only one row for each Issue ID.Ģ. When the report is ran using Excel: the row cells on the three dataitems were "Merged" and the are in each single cell. => Ran the report and I got the results shown above. => Dragged the into the "Repeater" -> (did not put a "Text Item" for this example to keep it simple) => Clicked on the "Repeater", went to the Properties and Pointed the query to => Dragged the "Repeater" over to the List (positioned in the second to the last column of the List) => Grouped by all of the dataitems listed above. => I created a List report with one query called. Issue ID IssPrgDesc Issue Description Impacted Programs I followed the steps (Anthony's solution) and this is my result below: For some reason even tho I grouped, ,, it did not concatenate all the result into one row cell. ( created a very simple query since my main report had some Joins and Unions, and just want to see it working before I apply it to my main query):ġ. and I truly appreciate all your feedback and solutions.īelow are the stumbles I have encountered. ![]() This whole application is still new to me since last October 2011 and I apologize if I will sound dumb on the steps I am stumbling on. I thank you all for all the feedback and the solutions listed above. If the grouping is correct then you will end up with You need to set the aggregate to MAXIMUM for impacted program 1, 2 3 and 4 Impacted program 2 - if (count = 2) then (impacted program) else null ![]() Here impacted program 1 would have the expression if (count = 1 ) then (Impacted program) else null Query 2 issue date, issue desc, val date, impacted progam 1, impacted program 2, impacted program 3, impacted program 4 Since this query is then the source for query 2 Query 1 - issue is, issue desc, val date, count, impacted programs You need to know how many possible values to combine into one row, in your example you have 4 values, so you will need 4 data items in your query, you then need a way to identify which row you are looking at so you so you will need to use the original query as the source for a second query, you wil then end up with something like the following
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |