logo
Welcome Guest! To enable all features please Login or Register.

Notification

Icon
Error

Options
Go to last post Go to first unread
priyadarshanr  
#1 Posted : Tuesday, January 3, 2023 2:56:42 PM(UTC)
priyadarshanr

Rank: Newbie

Groups: Registered
Joined: 1/3/2023(UTC)
Posts: 2
India
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?
epf  
#2 Posted : Tuesday, January 3, 2023 4:32:24 PM(UTC)
epf

Rank: Administration

Groups: Administrators
Joined: 12/20/2013(UTC)
Posts: 1,163
Switzerland

Thanks: 14 times
Was thanked: 191 time(s) in 184 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.
priyadarshanr  
#3 Posted : Wednesday, January 4, 2023 5:21:29 AM(UTC)
priyadarshanr

Rank: Newbie

Groups: Registered
Joined: 1/3/2023(UTC)
Posts: 2
India
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

Users browsing this topic
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.