Select inside RPT to work with hierarchy

[MarceloOD]

Hello everyone.
I have a challenge and I would like some suggestions to go ahead.
I work with a RPT and I can send only the tables through the application (I cannot send Queries).
It is possible to create a query inside the RPT in order to create a new table to bring the data in a different way?
I want to work with hierarchy. All items are in the Table 1 and the structure are in the Table 2. In a query I could build a new column with the level of the item.
Unfortunately the application is limited and I can send only the entire tables to RPT.

Marcelo

[Lech Kulikowski]

Hello,

If you have sql connection, then yes, you can use any queries in the report.

Thank you.

[MarceloOD]

Hi Lech, No I don't have because it is an application which send the Data source ready, in other words the tables, I can not back and connect again at the Database, if I could it would limitation because the report is used for any different database, and I would need to change the SQL connection many times for each database.
For this reason I would like try a query or select using the tables and data I already have in the RPT.

[Lech Kulikowski]

Hello,

Unfortunately, it is not possible.
You can try to use the DataTransformation feature.

Thank you.