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; } } }

Add Dynamically table to report

lrnrit

Hi,

I have very complex situation , I have one Table Which Contains No of queries (SQL SELECT STATEMENT AND WHERE CLAUSE) Stored in it.

What i have to do is call these queries in my report and run it and show there value in chart(IF it is count or avg) or Table(if it return more than one column).

Any Help Will Be Appreciated.

lrnit

Find more posts tagged with

Comments

lrnrit

Is It Even possible to do something like this.?

Please Help

lrnit

kosta

Hello Irnrit,

maybe you should describe closely what you have and want.
You have one SQL Table. If you have only one row then chart should be created, if more then table.
And you are using the report designer. Right?

Maybe you can solve than with the visible flag. (Report Perspective -> Report Properties View)
If one row make table unvisible otherwise chart unvisible.

Cheers.

lrnrit

hi, 
 
Let me explain this . I have one table "X" which contains 3 columns and n no rows Like 
 
1.ID| 2.SELECTSTMNT |3.WHERE 
1.|Select col1,col2|where rownum<10 
__|from Work____| 
 
2.|Select * from Ts|where assetnum <100 
 
3.|Count(*)from TS2| | 
 
 
Now i have to fetch these queries and combine them make complete sql statement and show there output in table if it returns values in no of columns and in chart if it returns value like count or avg etc. 
 
thanks, Please Help 
 
lrnit