If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

HELP- Eliminating Duplicate Records

Started by Modtamod, 24 Jan 2008 01:07:26 PM

Previous topic - Next topic

Modtamod

I am having issues on my report.  My Data structure looks like this

      Shipment              Received
         Date        Date                Price

Product 1          1/1/2007               2/1/2007          $1000
Product 2          1/5/2007               2/9/2007          $2000
Product 2           1/10/2007                                  $2500

The report that I want is just like a monthly calendar. Example


January                     February
1 -$1000-Shipped                           1- $1000- Received
2            2   
3            3
4            4
5- $2000-Shipped                   5
6            6
7            7
8            8
9            9- $2000-Received
10-$2000-shippned      10


I created a Union Query for this. However when I ran the report I got a duplicate records for the day number. It shows like

January                       February
1 -$1000-Shipped        1$1000- Received
1-                                1-
2            2   
3            3
4            4
5- $2000-Shipped                   5
5-          6   
6            7
7            8
8            9-$2000-Received
9            9-
10-$2000-shippned      10
10-      

How do I get rid of the duplicate item?