Report Design
 Crystal Reports Forum : Crystal Reports 9 through 2020 : Report Design
Message Icon Topic: Reporting with Formula Post Reply Post New Topic
Author Message
Fuonge
Newbie
Newbie


Joined: 20 Oct 2014
Online Status: Offline
Posts: 1
Quote Fuonge Replybullet Topic: Reporting with Formula
    Posted: 10 Dec 2014 at 7:47am
Hi All,

I want to create a formula for a table that looks like this:

ID UDOfficer DATE
1   6          Jan
1   7          Jan
1   9          Jan
2   6          June
3   6          April
4   6          May
5   5          Dec
6   7          Nov
7   6          April
7   4          April


What I want to create is a formula to put in a crosstab to capture UDOfficer = 6 and all others, but if UDOfficer is in 6, 7 and 9, the all others can not count that ID that was already counted for UDOFFICER 6.

OUTPUTCrosstable

DATE   UDOFF6   UDOFFOTHER
JAN     1            0
APR     2            0           
MAY     1            0
JUN     1            0
NOV     0            1
DEC     0            1       

Edited by Fuonge - 10 Dec 2014 at 7:50am
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.031 seconds.