Child Queries not properly bringing back data
I've been a RB user for many years... 2001 or so. I just upgraded to RB
11.05 for Delphi 2009 from RB 7.04 for Delphi 7.
I am using SQL Server and ADO.
My users have always had intermittant issues with child queries missing data
when using group bands. When they reported an issue, we would typically try
to find a way to bring that child query into the main query or fire a query
using a custom function at runtime per group band.
I could never report the issue since I was so far behind in releases. I had
another customer yesterday see the issue, so I tested the same report in
Delphi 2009 RB 11.05 and the issue is still there.
Scenario: A main query with a multiple child queries. Using SQL Profiler
(SQL Server), I can see the main query fire and then the second query fire.
The second query (of course) is the magic SQL version of the main query and
child query mashed together.
The records exist properly in that query, but they report thinks the query
is empty when it gets to one of the records in the main query. The report
has one grouping band that shows all the controls on the footer of the
grouping band. It's at that point where the child query is empty for a
specific record even though it's in the SQL query.
Has anyone came across this before? If so, is there anything that I should
look for or a reason why this occurs?
This has happened at least 10-15 times in completely different reports and
different versions of SQL Server.
11.05 for Delphi 2009 from RB 7.04 for Delphi 7.
I am using SQL Server and ADO.
My users have always had intermittant issues with child queries missing data
when using group bands. When they reported an issue, we would typically try
to find a way to bring that child query into the main query or fire a query
using a custom function at runtime per group band.
I could never report the issue since I was so far behind in releases. I had
another customer yesterday see the issue, so I tested the same report in
Delphi 2009 RB 11.05 and the issue is still there.
Scenario: A main query with a multiple child queries. Using SQL Profiler
(SQL Server), I can see the main query fire and then the second query fire.
The second query (of course) is the magic SQL version of the main query and
child query mashed together.
The records exist properly in that query, but they report thinks the query
is empty when it gets to one of the records in the main query. The report
has one grouping band that shows all the controls on the footer of the
grouping band. It's at that point where the child query is empty for a
specific record even though it's in the SQL query.
Has anyone came across this before? If so, is there anything that I should
look for or a reason why this occurs?
This has happened at least 10-15 times in completely different reports and
different versions of SQL Server.
This discussion has been closed.
Comments
We have not seen this behavior before.
Are you certain there are in fact detail records for the current master
record in these reports? If not, and you have the pipeline set to
SkipWhenNoRecords, it will simply skip that master record. (in DADE this is
controled in the Link Dialog, double clicking the link).
Are you able to recreate this behavior with a simple example I could run on
my machine? If so, please send the example in .zip format to
support@digital-metaphors.com and I'll take a look at it for you.
--
Regards,
Nico Cizik
Digital Metaphors
http://www.digital-metaphors.com
Nico Cizik
Digital Metaphors
http://www.digital-metaphors.com
Having an example I can run on my machine would make tracking down the issue
much easier. Perhaps you can create a similar scenario with the DBDemos
database included with Delphi or create a simplified version of the
report(s) with the issue and send the data needed to run them.
--
Regards,
Nico Cizik
Digital Metaphors
http://www.digital-metaphors.com
Nico Cizik
Digital Metaphors
http://www.digital-metaphors.com