[2 days left] What’s wrong with your cloud strategy? Learn why multicloud solutions matter with Nimble Storage.Register Now

x
?
Solved

Crystal Reports 8.5

Posted on 2003-11-09
6
Medium Priority
?
292 Views
Last Modified: 2010-04-17
Hi experts ,
1,tablename is Invoice
 this have field InvoiceID,Name,Type,Date
2,tableName is InvoiceDetails
this have field InvoiceID,
ProductID,Name,UnitPrice

My report should display
Product Details :Name  Unit Price in the same line.
I used Multiple Column Format using Mailing Label expert. How can I do the same using Standard report expert

Say
TableInvoice Contains
IncoiceID   Name      Type    Date
1               Products  xxx      23/11/2003
2                 Articles   xxx     23/11/2003

InvoiceDetails
Invoice ID   ProdcutID   ProductName UnitPrice
1               1                Beverages      $569
1               2                Contiments    $5889
1               3                Fruits             $52


My Print Out should look like
InvoiceID  : 1 (Invoice.InvoiceID)

Product:    1 Beverages,2 Contiments,3 Fruits

All these are should be the same line
How can I do it in Standard Exper format




0
Comment
Question by:v_arshini
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
6 Comments
 

Author Comment

by:v_arshini
ID: 9709485
Using Crystal Reports 8.5 How can I get Multiple Column Format
in Standard Report Expert
0
 
LVL 101

Accepted Solution

by:
mlmcc earned 1000 total points
ID: 9710358
I don't think you can use Multiple Columns with the standad expert however you can setup the report then format the detail section with multiple columns.

An idea
1.  Group on the invoice id
     Put the details into the group footer.  Build a formula with each record by concatenating the informationinto a single line

The detail section is for use by a single record.  Therefore to do what you want you need to somehow group the records together

mlmcc
0
 
LVL 101

Expert Comment

by:mlmcc
ID: 10319388
Don't know if it helped.  

mlmcc
0

Featured Post

On Demand Webinar: Networking for the Cloud Era

Did you know SD-WANs can improve network connectivity? Check out this webinar to learn how an SD-WAN simplified, one-click tool can help you migrate and manage data in the cloud.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In this post we will learn how to make Android Gesture Tutorial and give different functionality whenever a user Touch or Scroll android screen.
We live in a world of interfaces like the one in the title picture. VBA also allows to use interfaces which offers a lot of possibilities. This article describes how to use interfaces in VBA and how to work around their bugs.
Viewers will learn how to properly install Eclipse with the necessary JDK, and will take a look at an introductory Java program. Download Eclipse installation zip file: Extract files from zip file: Download and install JDK 8: Open Eclipse and …
Progress

649 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question