•
•
•
•
What is DaniWeb IT Discussion Community?
You're currently browsing the MS SQL section within the Web Development category of DaniWeb, a massive community of 426,185 software developers, web developers, Internet marketers, and tech gurus who are all enthusiastic about making contacts, networking, and learning from each other. In fact, there are 1,777 IT professionals currently interacting right now! Registration is free, only takes a minute and lets you enjoy all of the interactive features of the site.
Please support our MS SQL advertiser: Programming Forums
Views: 666 | Replies: 0
 |
•
•
Join Date: Mar 2007
Posts: 1
Reputation: 
Rep Power: 0
Solved Threads: 0
Newbie Poster
Crystal Report problem I have three tables that are linked as follows:
SOShipheader.shipperid, SOShipheader.invctot
SOShipline.shipperid, SOShipline.invtid, SOSHipline.qty, SOShipline.price
SOShipmisc.shipperid, SOShipmisc.miscid, SOShipmisc.charge
Here is what I want the report to look like:
S80709 150.00
abcpart 3 40.00
defpart 1 10.00
misca 20.00
S80710 30.00
defpart 1 20.00
miscb 10.00
I have group1 as soshipheader.shipperid
I have tried putting the soshipline information in details a and the soshipmisc information in details b. It lists all the soshipmisc information for each of the soshipline entries. The same thing happens if I put soshipheader information in group1, soshipline information in group2, and soshipmisc information in group3.
Does anyone have any suggestions?
SOShipheader.shipperid, SOShipheader.invctot
SOShipline.shipperid, SOShipline.invtid, SOSHipline.qty, SOShipline.price
SOShipmisc.shipperid, SOShipmisc.miscid, SOShipmisc.charge
Here is what I want the report to look like:
S80709 150.00
abcpart 3 40.00
defpart 1 10.00
misca 20.00
S80710 30.00
defpart 1 20.00
miscb 10.00
I have group1 as soshipheader.shipperid
I have tried putting the soshipline information in details a and the soshipmisc information in details b. It lists all the soshipmisc information for each of the soshipline entries. The same thing happens if I put soshipheader information in group1, soshipline information in group2, and soshipmisc information in group3.
Does anyone have any suggestions?
|
•
•
•
•
•
•
•
•
DaniWeb MS SQL Marketplace
•
•
•
•
Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
Linear Mode
- Crystal Report problem (VB.NET)
- How add Crystal Report Version 11 in VB6 (Visual Basic 4 / 5 / 6)
- problem connection vb6 & crystal report 11 (Visual Basic 4 / 5 / 6)
- Dynamic crystal report with VB4/5/6 (Visual Basic 4 / 5 / 6)
- Crystal Report Problem (ASP.NET)
- Crystal report problems (ASP.NET)
- problem in exporting crystal report (ASP.NET)
- Problem with Crystal Report in ASP.NET (ASP.NET)
- Help me with Crystal Report (ASP.NET)
Other Threads in the MS SQL Forum
- Previous Thread: help pleaseeeeeeeeeee
- Next Thread: Mom, I'm feeling fear. Does computer explode?
