Report Design
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Report Design
Message Icon Topic: Need help Post Reply Post New Topic
Author Message
hendrik
Newbie
Newbie


Joined: 19 Jan 2014
Location: Singapore
Online Status: Offline
Posts: 1
Quote hendrik Replybullet Topic: Need help
    Posted: 20 Jan 2014 at 2:30pm
guys can anyone help one i got data for example

Month  Item     PRice    Type

Jan        A          10      Gen
Jan        B          20       KR
Feb       A          10       CHN
Feb       B          40       KR    
Maret    A          20       CHN
APril      A          30       CHN

I want it to show at CR such as

Item     JAN        FEB       MAR      APRIL
A      10 GEN    10 CHN    20 CHN     30 CHN
B      20 KR        40 KR        ""          ""

i have done with the price by using group of month and item
now the question how to put Type beside of price at Crystal Report

if any one can help it thanks Cry
IP IP Logged
kostya1122
Senior Member
Senior Member
Avatar

Joined: 13 Jun 2011
Online Status: Offline
Posts: 475
Quote kostya1122 Replybullet Posted: 21 Jan 2014 at 6:33am
try to create crosstab
place item type in to Rows
month into columns
price as a sum and
type as a maximum into summarized fields
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.