Hi, I have a report that use data from a nested query. The nested query work fine because checking the XML file, I have all the right data. In my case just two of the instances of the nested query should bring data, usually 4 rows for both cases. but in reality Im just displaying one row on each instance meaning that I should have the wrong data but the xml file have the right data. I try putting a table inside the Details area and try to putting a static query as data source to check if the config of the table was wrong but with the static data everything worked fine.
This is commonly caused by dragging a fully-qualified data key from the key browser into a table row, where the table is expecting its row data keys to be just the final @columnName@ element.
1 Like
I try that and I got N/A. this is my structure.
I'm getting "number" from the first query, using that number to run the subquery with that parameter. Inside the table I'm using the following link @query.sub_query.name@
It needs to be just @name@.
I think I try all the combinations, @query.sub_query.name@ /@sub_query.name@ /@name@, just the first one work, the rest I get N/A
At the end I fix the issue adding another table inside the table, and linked the table to the sub_query, then I just use @name@, not sure why worked but it work.