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 Reference Status Live Date Signatory
BELG-B012 TNZE-B020 Live 4-Dec-2012 Van Wilder
BELG-B012 TNZE-B020 Live 4-Dec-2012 Van Wilder
BELG-B012 TNZE-B020 Live 4-Dec-2012 Van Wilder
B End is: BELG-B
Circuit Reference Status Live Date Signatory
TNZE-B016 BELG-B007 Live 4-Dec-2012 David Hasselhoff
TNZE-B016 BELG-B007 Live 4-Dec-2012 David Hasselhoff
TNZE-B016 BELG-B007 Live 4-Dec-2012 David Hasselhoff
TNZE-B016 BELG-B007 Live 4-Dec-2012 David Hasselhoff
TNZE-B016 BELG-B007 Live 4-Dec-2012 David Hasselhoff
TNZE-B016 BELG-B007 Live 4-Dec-2012 David Hasselhoff
Good output:
A End is: BELG-B
Circuit Reference Status Live Date Signatory
BELG-B012 TNZE-B020 Live 4-Dec-2012 Van Wilder
BELG-B013 TNZE-B021 Live 4-Dec-2012 Van Wilder
BELG-B014 TNZE-B022 Live 4-Dec-2012 Van Wilder
B End is: BELG-B
Circuit Reference Status Live Date Signatory
TNZE-B016 BELG-B007 Live 4-Dec-2012 David Hasselhoff
TNZE-B017 BELG-B008 Live 4-Dec-2012 David Hasselhoff
TNZE-B018 BELG-B009 Live 4-Dec-2012 David Hasselhoff
GOLD-A015 BELG-B031 Live 28-Jan-2005 Kibbles Andbits
GOLD-A016 BELG-B032 Live 11-Feb-2004 Alexandra Teepee
GOLD-A017 BELG-B033 Live 11-Feb-2004 Alexandra 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