How to make peer table inside a table group render on report dynamically

[bmeyers]

I have a table group with several peer tables. Is it possible to stop one of the peer tables from rendering based off a dynamic variable passed into the report? I can successfully make the peer table invisible but that page the peer table appears on still loads.

[pturmel]

You need to make the nested table that drives the peer table return zero rows.

[bmeyers]

Currently I have a named query data source param_terms that grabs my data. I follow up with a script called script that checks if the peer is enabled or not (a report parameter tied to a session variable).

Here is script:

    terms_enabled = data['param_terms_enabled']
    if terms_enabled:
        pass
    else:
        data['param_terms'] = system.dataset.toDataSet([], [])

On the TableGroup I select the peer table called param_terms. It has a Key of param_terms.

This described setup right now shows either data from the named query or an empty dataset based off the session variable.

Can you explain where I need to go from here?

[pturmel]

I don't know how to expand your case. What I do know is that table groups will completely omit (no blank space) inner tables/objects that do not have a row in their (nested) control data. You may need to restructure your data to do this.

[bmeyers]

Can you expand on "(nested) control data"? What does that mean? How can I generate nested control data today?

[pturmel]

Report with Scripted Nested Data

The report datasource scripting examples explain how to access the nested data in another key for use constructing a custom dataset. What I don’t see is how to construct nested data that would be suitable for use with a child table in a table group. I have a parent dataset that I’m constructing via script due to annoying limitations of an ancient SQL Server 2000 instance. I need a subquery for each row that could be done with a normal query, but there’s no way to add a regular subquery to a s…

Table groups need nested data for full features. Your data isn't nested.

[bmeyers]

I followed along with your example and generated nested data but it doesn't seem to honor the Start on new page option. That is, if I have Start on new page selected I will always get the final page showing.

Is that behavior what you have seen before?

[pturmel]

I haven't used "start on a new page".