1. Dale
  2. Valentina Reports ADK
  3. Wednesday, June 10 2020, 03:26 PM
  4.  Subscribe via email
Hello!

I have the following MySQL Schemas:
- Branch01
- Branch02
- Branch03

They have the same tables and corresponding structures. I have a report that calls a stored procedure that pulls the data for the report. I designed my report using Branch01. At runtime, the user may select Branch01 or Branch02 or Branch03, depending upon the given situation. However, my report still calls the data of Branch01.

How to work around this? I am using MySQL and Xojo.
Comment
There are no comments made yet.
Dale Accepted Answer
Sergey, I got it now. Since my stored proc that is being called creates a temporary table, I included a "Select * from tempTable" at the end of the stored proc.

Sorry to bother. Cheers for your support!
Comment
There are no comments made yet.
  1. more than a month ago
  2. Valentina Reports ADK
  3. # 1
Dale Accepted Answer
Hi Sergey,

Please see attachment for my report's datasource at design time. I am calling the right schema from Xojo but my select statement is a call to the stored proc. If I use the first branch (in this case "bw01";), everything is okay but if I use another, it only shows a blank report.
Attachments (3)
Comment
There are no comments made yet.
  1. more than a month ago
  2. Valentina Reports ADK
  3. # 2
Sergey Pashkov Accepted Answer
Hi Dale,

How do you generate a report?

Usually we specify the schema name in the datasource string passed to MakeNewReport:
project.MakeNewReport(
"report1",
"host = '127.0.0.1', port = 3306, user = 'sa', password = 'sa', dbname = 'Branch01'",
"SELECT *.....
Comment
There are no comments made yet.
  1. more than a month ago
  2. Valentina Reports ADK
  3. # 3
  • Page :
  • 1


There are no replies made for this post yet.
However, you are not allowed to reply to this post.