Stimulsoft Reports.JS discussion
harryhan
Posts: 5 Joined: Sun Apr 18, 2021 10:56 am
Post
by harryhan » Sun Apr 18, 2021 6:02 pm
How do I get the sqlcommand of a report.
Code: Select all
report.dictionary.dataSources.list[0].sqlCommand
return undefined
Lech Kulikowski
Posts: 7292 Joined: Tue Mar 20, 2018 5:34 am
Post
by Lech Kulikowski » Mon Apr 19, 2021 11:17 pm
Hello,
Your code should work.
Thank you.
Attachments
Screenshot 2021-04-20 011644.png (245.33 KiB) Viewed 3682 times
harryhan
Posts: 5 Joined: Sun Apr 18, 2021 10:56 am
Post
by harryhan » Tue Apr 20, 2021 7:26 am
Thanks.
We define the query in the report with the designer. How can we get this query per script.
Attachments
Screenshot 2021-04-20 092329.png (29.27 KiB) Viewed 3677 times
Lech Kulikowski
Posts: 7292 Joined: Tue Mar 20, 2018 5:34 am
Post
by Lech Kulikowski » Tue Apr 20, 2021 9:44 pm
Hello,
With the following code:
report.dictionary.dataSources.list[0].sqlCommand
Sorry, maybe we did not exactly understand your question. Could you explain your issue in more detail?
Thank you.
harryhan
Posts: 5 Joined: Sun Apr 18, 2021 10:56 am
Post
by harryhan » Wed Apr 21, 2021 2:30 pm
hello
the sql command from the report is required.
i can't find my error.
thank you
harry
Screenshot 2021-04-21 162556.png (111.56 KiB) Viewed 3662 times
Lech Kulikowski
Posts: 7292 Joined: Tue Mar 20, 2018 5:34 am
Post
by Lech Kulikowski » Thu Apr 22, 2021 12:42 pm
Hello,
Please send us a sample project that reproduces the issue for analysis.
Thank you.
Lech Kulikowski
Posts: 7292 Joined: Tue Mar 20, 2018 5:34 am
Post
by Lech Kulikowski » Mon Apr 26, 2021 8:15 pm
Hello,
Please send us a sample project that reproduces the issue for analysis.
Thank you.
harryhan
Posts: 5 Joined: Sun Apr 18, 2021 10:56 am
Post
by harryhan » Mon Apr 26, 2021 8:57 pm
Sorry
the projet file is gone, here again. mea culpa
Thanks
Attachment: TestSqlCommand.zip
Attachments
TestSQLCommand.zip
(150.39 KiB) Downloaded 215 times
Lech Kulikowski
Posts: 7292 Joined: Tue Mar 20, 2018 5:34 am
Post
by Lech Kulikowski » Thu Apr 29, 2021 10:08 am
Hello,
We need some additional time to investigate the issue, we will let you know about the result.
Thank you.