Technical Questions
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Technical Questions
Message Icon Topic: suppress information Post Reply Post New Topic
Author Message
Wayne beasley
Newbie
Newbie


Joined: 02 Jun 2015
Online Status: Offline
Posts: 3
Quote Wayne beasley Replybullet Topic: suppress information
     Posted: 09 Jun 2015 at 2:41pm
Hi All.
My sales manager is after a report that highlights new customer invoices for last month. This wasn't a problem to do until she said she would like all of the invoices for the new customer for last month. I did have in the section expert customer=previous(customer) or invoice date <> lastfullmonth. The problem was it only showed the first invoice for the new customer. Does anyone know a way that would show all invoices for last month for the new customer? The report was sorted by customer.
IP IP Logged
niha
Newbie
Newbie
Avatar

Joined: 05 Jun 2015
Online Status: Offline
Posts: 28
Quote niha Replybullet Posted: 09 Jun 2015 at 9:04pm
so you want all the invoice per customer
IP IP Logged
Wayne beasley
Newbie
Newbie


Joined: 02 Jun 2015
Online Status: Offline
Posts: 3
Quote Wayne beasley Replybullet Posted: 10 Jun 2015 at 12:48pm
So I'm after all invoices for customers who haven't previously been invoiced in previous months.
Final result we be,
Here's the new customer's, what they purchased and $ amount.
Thanks
IP IP Logged
niha
Newbie
Newbie
Avatar

Joined: 05 Jun 2015
Online Status: Offline
Posts: 28
Quote niha Replybullet Posted: 16 Jun 2015 at 9:01pm
you can write in sql that that this customer id is not in startdate-enddate
so u can easily get that custome or u can use subreprot also.
IP IP Logged
Printable version Printable version

Forum Jump
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum