Stimulsoft Reports.JS discussion
-
harryhan
- Posts: 5
- Joined: Sun Apr 18, 2021 10:56 am
Post
by harryhan »
How do I get the sqlcommand of a report.
Code: Select all
report.dictionary.dataSources.list[0].sqlCommand
return undefined
-
Lech Kulikowski
- Posts: 6266
- Joined: Tue Mar 20, 2018 5:34 am
Post
by Lech Kulikowski »
Hello,
Your code should work.
Thank you.
-
Attachments
-
- Screenshot 2021-04-20 011644.png (245.33 KiB) Viewed 3234 times
-
harryhan
- Posts: 5
- Joined: Sun Apr 18, 2021 10:56 am
Post
by harryhan »
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 3229 times
-
Lech Kulikowski
- Posts: 6266
- Joined: Tue Mar 20, 2018 5:34 am
Post
by Lech Kulikowski »
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 »
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 3214 times
-
Lech Kulikowski
- Posts: 6266
- Joined: Tue Mar 20, 2018 5:34 am
Post
by Lech Kulikowski »
Hello,
Please send us a sample project that reproduces the issue for analysis.
Thank you.
-
Lech Kulikowski
- Posts: 6266
- Joined: Tue Mar 20, 2018 5:34 am
Post
by Lech Kulikowski »
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 »
Sorry
the projet file is gone, here again. mea culpa
Thanks
Attachment: TestSqlCommand.zip
-
Attachments
-
- TestSQLCommand.zip
- (150.39 KiB) Downloaded 141 times
-
Lech Kulikowski
- Posts: 6266
- Joined: Tue Mar 20, 2018 5:34 am
Post
by Lech Kulikowski »
Hello,
We need some additional time to investigate the issue, we will let you know about the result.
Thank you.