nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Dynamic sql

sairag

I have two views, which has multiple versions. Each version is dynamically created, which is as part of design.
For the report design I need to union all the 2 views,all the versions that are available at the time of report execution.

Please find the attached report design. Here in this report I am able to exceute union all on one view.

How we can combine both the datasets(ASSET_ACQ,ASSET_ACQ1) in LatestRequirement.

Please suggest how to execute the same on multiple views.

Thanks
Amarnath

Find more posts tagged with

Comments

kclark

Have you tried creating separate dataSets and then joining them with a joint dataSet?

sairag

Yes, I tried the same.