subreport not printing data
I am having a perplexing problem with a nested subreport:
I show some data in the parent subreport and then try to show additional
data from a different table in a subreport below it. There two elements
to the report (two different primary subreports).
The first one works fine. The second one doesn't. Each of them have a
nested sub report handling a second table.
The second one (which is failing)is a columnar report (left to right)
The second one uses different tables as well. The index arrangements
appear to be correct and the data is correct when I view outside of
report builder.
So far, the only time I came close to sucess with the second one is
after monkeying with various properties it prints one line of data after
blowing away the columnar report (meaning it prints only one column per
page) and then only prints one line of data on a separate page.
Is what I'm doing possible? Is there an issue with columnar reports?
Any suggestions will be greatly appreciated as I'm running out of time.
thanks
michael peirce
I show some data in the parent subreport and then try to show additional
data from a different table in a subreport below it. There two elements
to the report (two different primary subreports).
The first one works fine. The second one doesn't. Each of them have a
nested sub report handling a second table.
The second one (which is failing)is a columnar report (left to right)
The second one uses different tables as well. The index arrangements
appear to be correct and the data is correct when I view outside of
report builder.
So far, the only time I came close to sucess with the second one is
after monkeying with various properties it prints one line of data after
blowing away the columnar report (meaning it prints only one column per
page) and then only prints one line of data on a separate page.
Is what I'm doing possible? Is there an issue with columnar reports?
Any suggestions will be greatly appreciated as I'm running out of time.
thanks
michael peirce
This discussion has been closed.
Comments
The LeftToRight column traversal feature does not work at all in versions
prior to RB 7.x. (TopToBottom traversal for subreports will print columns if
the subreport is pbFixed. For pbChild, the childreport will not print
columns - this limitation exists in RB 7.x as well).
Using RB 7.03 and DBDemos, I was able to create a customer/orders report in
which the orders were printed in LeftToRight columns. If you are not using
RB 7, try downloading a trial version and perform the same test.
--
Nard Moseley
Digital Metaphors
http://www.digital-metaphors.com
Best regards,
Nard Moseley
Digital Metaphors
www.digital-metaphors.com