Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: FRED QUAYE
  Where is FRED QUAYE?
 
 Ghana
 FRED QUAYE
 To: Paul Gibson
  Where is Paul Gibson?
 Glasgow
 United Kingdom
 Paul Gibson
 Tags
Subject: RE: problem print group rpt with header
Thread ID: 415590 Message ID: 416133 # Views: 30 # Ratings: 0
Version: Not Applicable Category: C#.NET
Date: Monday, December 22, 2014 2:29:12 PM         
   


> >
> >
> > report viewer .RDLC
> >
> >
> > VS 2010

> >
> >
> > ggggggggggg
>
>
> Thanks for answering the first question.
>
> Did you answer the second question? I can't see an answer to that one.
>
> Can you please clarify what you have tried already? Did you try the option in my screenshot?



Thanks a lot.


I have worked on it and its breaking all right but I am having one row on each page for a group.


How do I correct this ?

The stored procedure grouping is as follows

SELECT #MGFINAL.* ,#MGFINAL.IDNO+#MGFINAL.LOANUMBER AS IDNOLOANUMBER,
LOANS.CUSTOMER,
LOANS.ADVLOAN AS PRINCIPAL,
LOANS.AC_BALANCE AS ACCOUNT_BAL,
LOANS.TERM_START AS ORIGIN_TERM,
LOANS.TERM_NOW,
LOANS.TOTPAYMT AS TOT_AMT_PAID
FROM #MGFINAL
LEFT JOIN LOANS ON #MGFINAL.IDNO=LOANS.IDNO
GROUP BY #MGFINAL.IDNO+#MGFINAL.LOANUMBER
ORDER BY #MGFINAL.IDNO+#MGFINAL.LOANUMBER,#MGFINAL.TX_DATE


End

please review the stored procedure.















Thanks

ENTIRE THREAD

problm print grp rpt with header (sos) Posted by FRED QUAYE @ 12/8/2014 6:52:32 AM
RE: problem print group rpt with header Posted by Paul Gibson @ 12/8/2014 10:28:43 AM
RE: problem print group rpt with header Posted by FRED QUAYE @ 12/8/2014 11:40:07 AM
RE: problem print group rpt with header Posted by Paul Gibson @ 12/8/2014 12:17:32 PM
RE: problem print group rpt with header Posted by FRED QUAYE @ 12/22/2014 2:29:12 PM
RE: problem print group rpt with header Posted by Paul Gibson @ 12/22/2014 5:03:55 PM
RE: problem print group rpt with header Posted by FRED QUAYE @ 12/22/2014 5:50:38 PM
RE: problem print group rpt with header Posted by Paul Gibson @ 12/23/2014 10:19:05 AM
RE: problem print group rpt with header Posted by FRED QUAYE @ 12/24/2014 11:25:14 PM