Report Design
 Crystal Reports Forum : Crystal Reports for Visual Studio 2005 and Newer : Report Design
Message Icon Topic: Combining multible table fields to one report Post Reply Post New Topic
Author Message
Lux4Coding
Newbie
Newbie


Joined: 11 Aug 2007
Online Status: Offline
Posts: 1
Quote Lux4Coding Replybullet Topic: Combining multible table fields to one report
    Posted: 12 Aug 2007 at 2:17am
I have VB form named Booking where i can book Six items at once for a particular customer . Now these booking details gets stored in BookingMaster database table according to the following fields:

Order Number
Customer ID
Booking date
Delivery date
Quantity
Item
Sub Item
Rate

For every item booked a new record is created according to the aforementioned fields. For example OrderNo: 2 has three items booked (Pant, Shirt & Coat). The booking in the database will be like this:

Order Number : 2
Customer ID : 5
Booking date : 10-8-07
Delivery date : 14-8-07
Quantity : 1
Item : Pant
Sub Item : Formal
Rate : 200.00


Order Number : 2
Customer ID : 5
Booking date : 10-8-07
Delivery date : 14-8-07
Quantity : 3
Item : Shirt
Sub Item : Readymade
Rate : 150.00


Order Number : 2
Customer ID : 5
Booking date : 10-8-07
Delivery date : 14-8-07
Quantity : 2
Item : Coat
Sub Item : Single Breast
Rate : 2200.00

  Now while printing Booking Form i want to select Quantity,Item,Sub Item & Rate from all the records where Order Number = 2 and print it in the same report in Details section as follows:

Order No: 2   Book Dt: 10-8-07   Delivery Dt: 14-8-07          Cust ID: 5

Quantity           Item        Sub - Item                  Rate               Amount
 
      1                   Pant       Formal                        200.00              200.00
      3                   Shirt       Readymade                 150.00              450.00
      2                   Coat       Single Breast             2200.00            4400.00

                                                     Total        5050.00


How can i do this ???
Please help !

IP IP Logged
Post Reply Post New Topic
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



This page was generated in 0.016 seconds.