1. Richard Albrecht
  2. Valentina Reports ADK
  3. Monday, August 02 2021, 08:12 PM
  4.  Subscribe via email
In Xojo the ADK is throwing an exception:
Datasource error: "Error( 1054 ) 42S22: "Unknown column 'Speaker' in 'field list'"".

However in Studio the same sql runs fine.

I'm don't have anything named speaker in the report???
Comment
There are no comments made yet.
Sergey Pashkov Accepted Answer
Is there any sorting/grouping set for this report on the Data tab?
Comment
There are no comments made yet.
  1. more than a month ago
  2. Valentina Reports ADK
  3. # 1
Richard Albrecht Accepted Answer
No Sorting
Comment
There are no comments made yet.
  1. more than a month ago
  2. Valentina Reports ADK
  3. # 2
Sergey Pashkov Accepted Answer
And this report runs fine with the same SQL query in VStudio, correct?
Comment
There are no comments made yet.
  1. more than a month ago
  2. Valentina Reports ADK
  3. # 3
Richard Albrecht Accepted Answer
Yes, exact same query
Comment
There are no comments made yet.
  1. more than a month ago
  2. Valentina Reports ADK
  3. # 4
Sergey Pashkov Accepted Answer
Could you please export this report and attach it here?
Comment
There are no comments made yet.
  1. more than a month ago
  2. Valentina Reports ADK
  3. # 5
Richard Albrecht Accepted Answer
I don't see an export option?

Also do you want an excel of sample data?
Comment
There are no comments made yet.
  1. more than a month ago
  2. Valentina Reports ADK
  3. # 6
Sergey Pashkov Accepted Answer
On the project tab, you can select report and export it using the context menu.

No, data is not necessary for now.
Comment
There are no comments made yet.
  1. more than a month ago
  2. Valentina Reports ADK
  3. # 7
Richard Albrecht Accepted Answer
I'm sorry but the only export I see is from a preview.
Comment
There are no comments made yet.
  1. more than a month ago
  2. Valentina Reports ADK
  3. # 8
Richard Albrecht Accepted Answer
Do you want to move this to Skype, I'm Hawkcode

We've used it before.
Comment
There are no comments made yet.
  1. more than a month ago
  2. Valentina Reports ADK
  3. # 9
Richard Albrecht Accepted Answer
I'm essentially stopped until this gets resolved.
Comment
There are no comments made yet.
  1. more than a month ago
  2. Valentina Reports ADK
  3. # 10
Sergey Pashkov Accepted Answer
So the problem was in the datasource string, after fixing it the error has gone.
Comment
There are no comments made yet.
  1. more than a month ago
  2. Valentina Reports ADK
  3. # 11
  • Page :
  • 1


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

Categories

Announcements & News
  1. 0 subcategories
Valentina Studio
  1. 2 subcategories
Valentina Server
  1. 4 subcategories
Valentina Database ADK
  1. 0 subcategories
Valentina Reports ADK
  1. 0 subcategories
Other Discussions
  1. 2 subcategories
BETA Testing
  1. 0 subcategories
Education & Research
  1. 0 subcategories