Group Customers With Invoices - Statements 2

[Dominican1979]

Hello everyone,

I'm creating a report for monthly customer statements. I have two views on the SQL Server, one that pulls all the customer info as far as address, etc. The other view pulls up the invoices. On my report the two views are joined by customer no. I created a group based on the custumer info view. So I have a group header section #1a (the default on custno) then i added Header section #1b where i added the customer number, name, address etc. I added Header #1c where i added the labels invoice No, date, due date, amount, etc and then right below that is the details section for the group. Now when I run and change from page to page, the customer info changes on every page, but I get the same set of invoices for every single customer, so I don't know what I'm missing. Your help is greatly appreciated. Thanks!

I'm running SQL Server 2005/Crystal XI.

 

[lbass]

On the surface it looks to me like you did everything correctly. I'm assuming your group is on custno, and that your join is an equal join.

You also might want to lay out fields from each table in the detail section of the report to see what is going on. If there is more than one record per custno in the customer info table, i.e., if there were multiple contacts listed, that could cause the data in the second table to repeat.

You also might want to try recreating the report--maybe it somehow became corrupted.

-LB

 

[IdoMillet]

Add a level 2 grouping on Invoice Number.

- Ido

view, email, export, burst, distribute, and schedule Crystal Reports.

http://www.MilletSoftware.com

 

[Dominican1979]

Hey guys thanks a lot, I think the report got somehow corrupted because I re-created the same exact thing and this time it worked. Thank you very much!