CODEWITHSUNDEEP
crystal-reports
Rohan
Rohan

Reputation: 177

Display one Column as Multiple Columns

I have Table Structure Like enter image description here

I am Using Visual Studio 2013 and Crystal Report 13.0.12

Upvotes: 0

Views: 150

Answers (1)

4444
4444

Reputation: 3680

You could use a Cross Tab for this, but you'll get more freedom by not using one:

In your report, group by Customer Name, then by TestName. Suppress all 5 of these sections except for the Group Footer of Customer Name. Here, place Customer Name, Result, and a new formula named Sugar. And inside sugar put this code:

PREVIOUS({Result})

Assuming there's no other TestNames besides Protein and Sugar, and assuming every Customer has one value for each, you should get the desired results in the footer. Let me know if that's the case and I can update the answer to accommodate.

Upvotes: 1

Related Questions