March 1, 2013 at 2:47 pm
I'm having difficult with output in a report. This report was originally created with two subreports and it works fine that way. The end user does not want the main report to have subreports. I copied the queries from the subreports and created separate datasets for each subreport to use in the main report. The output of the report that I am working on is such that the correct number of rows is displayed, but the output from the first record is repeated on all rows.
Bad output:
A End is: BELG-B
Circuit ReferenceStatusLive DateSignatory
BELG-B012TNZE-B020 Live 4-Dec-2012Van Wilder
BELG-B012TNZE-B020 Live 4-Dec-2012Van Wilder
BELG-B012TNZE-B020 Live 4-Dec-2012Van Wilder
B End is: BELG-B
Circuit ReferenceStatusLive DateSignatory
TNZE-B016BELG-B007 Live 4-Dec-2012David Hasselhoff
TNZE-B016BELG-B007 Live 4-Dec-2012David Hasselhoff
TNZE-B016BELG-B007 Live 4-Dec-2012David Hasselhoff
TNZE-B016BELG-B007 Live 4-Dec-2012David Hasselhoff
TNZE-B016BELG-B007 Live 4-Dec-2012David Hasselhoff
TNZE-B016BELG-B007 Live 4-Dec-2012David Hasselhoff
Good output:
A End is: BELG-B
Circuit ReferenceStatusLive DateSignatory
BELG-B012 TNZE-B020 Live 4-Dec-2012Van Wilder
BELG-B013 TNZE-B021 Live 4-Dec-2012Van Wilder
BELG-B014 TNZE-B022 Live 4-Dec-2012Van Wilder
B End is: BELG-B
Circuit ReferenceStatusLive DateSignatory
TNZE-B016BELG-B007 Live 4-Dec-2012David Hasselhoff
TNZE-B017BELG-B008 Live 4-Dec-2012David Hasselhoff
TNZE-B018BELG-B009 Live 4-Dec-2012David Hasselhoff
GOLD-A015BELG-B031 Live 28-Jan-2005Kibbles Andbits
GOLD-A016BELG-B032 Live 11-Feb-2004Alexandra Teepee
GOLD-A017BELG-B033 Live 11-Feb-2004Alexandra Teepee
"Nicholas"
March 1, 2013 at 4:43 pm
I managed to get it working. I can't say what I did because I'm not sure. It was a pain to fix, but it worked out in the end.
"Nicholas"
March 27, 2013 at 11:29 am
I know why its happen because if we put fields in row group in table then its show exactly you had problem , So remove group in report design and enter field in normal row .
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply