Sub reports losing the first element of output

rbuser

Hello,

I am developing on D7 with RB10.04. I have a report that uses several
subreports, the user selects which ones to display at runtime. These
reports have recently started skipping the first item in the result set.
When I view the report in preview mode, I can see the whole set appear, then
the first line of data disappers. This happens on all the subreports of
this report but no other reports. One of the subreports counts the lines
with a dbCalc component. It is still seen on the first line but reads 0.

I know these reports are supposed to have more data because I see the line
appear, I have run the SQL through the db manager for comparison, and the
subreports are repeated on other reports. On the others, they consistently
have one more item of data.

Frank

rbuser

I'm sorry. I meant to add "Has anyone seen this before, and how was it
corrected?"

nicocizik

Hi Frank,

I would first suggest upgrading your version of ReportBuilder to 10.06 and
see if that changes the behavior. Contact info@digital-metaphors.com for
upgrade instructions. If this does not help, try commenting out all your
event code and see if that causes the problem. If so, then periodically
begin adding the code back to isolate the issue. Also you may try
simplifying your report by perhaps creating a smaller version with less
data/subreports/event code to see if you can isolate the issue.

--
Regards,

Nico Cizik
Digital Metaphors
http://www.digital-metaphors.com

rbuser

Tracked down the cause. Don't yet know how to fix it and get everything
needed.

The problem is that the reports skip the first element when the report is
set to psTwoPass. If I change it to one pass, all the elements appear, but
the "Page X of Y" at the bottom is wrong.

Frank

nicocizik

Hi Frank,

Have you tried commenting out your event code? There may be some code
firing for each pass that you only want firing once. In this case, you will
need to check that Report.SecondPass is true before executing the code. Try
tracing your event code, especially any dealing with data access and see if
you can isolate the problem.

--
Regards,

Nico Cizik
Digital Metaphors
http://www.digital-metaphors.com