Possible to query table in sub-report
Quote from CSSystems on August 30, 2019, 4:57 pmI have an application that has a primary person in Master Table with Related persons in Detail table.
My report (containing Sub-Report) queries (filters) those persons in the Master Table who will be attending an event.
The detail table contains persons who will be attending with them.
I have a field in the Detail table indicating whether the Related person is also attending.
Some Related people may not be coming so in my Report I want to filter only those coming with the Primary person.
Is it possible to query (filter) on the Sub-report table?
I have an application that has a primary person in Master Table with Related persons in Detail table.
My report (containing Sub-Report) queries (filters) those persons in the Master Table who will be attending an event.
The detail table contains persons who will be attending with them.
I have a field in the Detail table indicating whether the Related person is also attending.
Some Related people may not be coming so in my Report I want to filter only those coming with the Primary person.
Is it possible to query (filter) on the Sub-report table?
Quote from ebear on August 30, 2019, 10:19 pmHello,
Everything you want to show in your report you have to prepare before loading the report.
So this means that all the queries and filters have to be done in VisualNeo with DBPro.
After this you can display the query results in an report.I seems that you already have the report running with your Master table, the same you should do with the data you want to show in the Sub-report.
Hopefully this will give a start, otherwise let the community know.
Best regards,
Eric Beerhorst
Hello,
Everything you want to show in your report you have to prepare before loading the report.
So this means that all the queries and filters have to be done in VisualNeo with DBPro.
After this you can display the query results in an report.
I seems that you already have the report running with your Master table, the same you should do with the data you want to show in the Sub-report.
Hopefully this will give a start, otherwise let the community know.
Best regards,
Eric Beerhorst
Quote from CSSystems on August 31, 2019, 8:28 pmI queried the Master table which has worked from the beginning.
I queried the Details Table just before the report and the query didn't work on the Details Table.
I am expecting the answer to be to use SQL. Some day I will get good at SQL.
I queried the Master table which has worked from the beginning.
I queried the Details Table just before the report and the query didn't work on the Details Table.
I am expecting the answer to be to use SQL. Some day I will get good at SQL.
Quote from Gaev on August 31, 2019, 11:52 pm@cssystems
I queried the Details Table just before the report and the query didn't work on the Details Table.
I am expecting the answer to be to use SQL. Some day I will get good at SQL.
Perhaps you can start by posting details of ...
a) the Table Names and relevant Fields
b) all NeoDBPro commands you invoked
I queried the Details Table just before the report and the query didn't work on the Details Table.
I am expecting the answer to be to use SQL. Some day I will get good at SQL.
Perhaps you can start by posting details of ...
a) the Table Names and relevant Fields
b) all NeoDBPro commands you invoked