Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

First row output repeating Expand / Collapse
Author
Message
Posted Friday, March 1, 2013 2:47 PM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Tuesday, May 20, 2014 12:49 PM
Points: 39, Visits: 278
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"
Post #1425760
Posted Friday, March 1, 2013 4:43 PM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Tuesday, May 20, 2014 12:49 PM
Points: 39, Visits: 278
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"
Post #1425786
Posted Wednesday, March 27, 2013 11:29 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Friday, October 25, 2013 1:07 AM
Points: 7, Visits: 64
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 .
Post #1436063
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse