Seal Report Forum
»
Report Edition
»
Data Source Creation
»
MS SQL multiple views created to get the final view or the table, how to just import the columns
Rank: Newbie
Groups: Registered
Joined: 1/3/2023(UTC) Posts: 2  Location: Coimbatore
|
I have got a MS SQL result table created by multiple views and joins, can it be imported as just columns to map the values in chartjs as bar chart, no aggreate functions are to be modified in seal report designer, the imported table is the final, just need to map the values of the columns to bar chart, Even the SQL check is failed, Is it possible to import table with views and joins?
|
|
|
|
|
|
Rank: Administration
Groups: Administrators
Joined: 12/20/2013(UTC) Posts: 1,209  Thanks: 14 times
Was thanked: 206 time(s) in 199 post(s)
|
did you try to create a SQL Model, enter your SQL,
then set the model property 'Use raw SQL' to True to avoid the "select * from (<your SQL>) a"
in this case the SQL should work but you cannot apply dynamic restrictions.
|
|
|
|
|
|
Rank: Newbie
Groups: Registered
Joined: 1/3/2023(UTC) Posts: 2 Location: Coimbatore
|
Hi, epf I have set [the model property 'Use raw SQL' to True ] but I can not generate the table or the chart. I shall try to modify the query to generate models in the seal report designer. Thanks for your reply. Edited by user Wednesday, January 4, 2023 5:22:23 AM(UTC)
| Reason: Not specified
|
|
|
|
|
|
Seal Report Forum
»
Report Edition
»
Data Source Creation
»
MS SQL multiple views created to get the final view or the table, how to just import the columns
Forum Jump
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.
