(UTC)
  Lantica User Forum › Archived Topics › Archived Topics › report problem
(Moderator: Forum Admin)
‹ Previous Topic | Next Topic ›
Page Index Toggle Pages: 1 Send Topic Send Topic Print Print
Normal Topic report problem (Read 4422 times)
pineberry
Full Member
***
Offline


No personal text

Posts: 115
Location: Strawberry, AZ  USA
Joined: Nov 30th, 2002
report problem
Jan 25th, 2005 at 10:03pm
Print Post Print Post  
Today must be my blind and dumb day. I have a result set with
Cust_no
Cust_name
Inv_no
Inv_amt
Inv_date
the Inv_amt is non zero and I have a report that lists

Cust_no   Cust_name   Total of all invoices for that customer

My problem is I can't seem to get the proper no. and name
on the same line as the sum.  The no. and name are the next one after the sum.

no 2 is on line with sum of no 1

What is the solution ?
  
Back to top
 
IP Logged
 
Ray the Reaper
Global Moderator
Members
Lantica Support
*****
Offline


The One & The Only

Posts: 2480
Joined: Aug 20th, 2003
Re: report problem
Reply #1 - Jan 25th, 2005 at 10:17pm
Print Post Print Post  
Hi Harley,

If you look in SesameSeasons there is a report that does this. It is named Sales Year To Date Total and can be found in the LineItems database. If you have any questions about it just let me know.

-Ray
  
Raymond Yoxall Consulting
ray.yoxall@gmail.com
ryoxall@lantica.com
Sesame Applications, Design and Support
Back to top
WWW WWW  
IP Logged
 
pineberry
Full Member
***
Offline


No personal text

Posts: 115
Location: Strawberry, AZ  USA
Joined: Nov 30th, 2002
Re: report problem
Reply #2 - Jan 25th, 2005 at 10:23pm
Print Post Print Post  
Thanks Ray.
I knew it was somewhere but just couldn't see it.

Harley
  
Back to top
 
IP Logged
 
Page Index Toggle Pages: 1
Send Topic Send Topic Print Print
‹ Previous Topic | Next Topic ›
 
  « Board Index ‹ Board Top  

Lantica User Forum » Powered by YaBB 2.6.11!
YaBB Forum Software © 2000-2024. All Rights Reserved.

Valid RSS Valid XHTML Valid CSS Powered by Perl Source Forge