Formulas with Grouping 5

[Ann28]

Hello Everyone,

I am creating my first Crystal Report. Please help!!!!
The data in the input file is by monthly.
The output should be grouped by quarters.

Here is the input:

employer: Period: Contract: Members:
====================================
1234567 200301 IR 1
1234567 200302 IR 1
1234567 200303 IR 1

1234567 200304 IR 1

3333333 200301 I 1
3333333 200302 I 1
3333333 200303 I 1


Output:
Employer: Q1 Q2 Q3 Q4
==============================
IR / I IR
=================================
1234567 3 1

3333333 3

REALLY APPRECIATE YOUR HELP!!!!!

 

[Madawc]

In Crystal 8.5, you could do this with three formulas, i.e.

@Year
left({Period}, 4)

@Quarter
if right({Period}, 2) in [01, 02, 03] then "Q1" 
else
etc.

@Group_It
@Year & " / "  & @Quarter

Create a group based on @Group_It

Madawc Williams
East Anglia, Great Britain

 

[Ann28]

My date is a string format 200301 , 200303 or so on
How do I convert it into Date?

Thank you

 

[MrBillSC]

You probably don't need to convert it to a date. Just put the values in quotes:
@Quarter
if right({Period}, 2) in ["01", "02", "03"] then "Q1" ...

MrBill

 

[Ann28]

hi MrBill,
Thank you very much for helping me with a report
I have another issues
the output looks like that:

CT
EMPLOYER 1234567 RECTOR SPORTS
2003 / Q1 1
2003 / Q2 2
2003 / Q3 3
2003 / Q4 4

EMPLOYER 333333 NEW BANK
2003/ Q1 0
2003/ Q2 5
2003/ Q3 6
2003/ Q4 7
Is it possibe to change it to:

employer Q1 Q2 Q3 Q4
====================================
1234567 RECTOR SPORTS 1 2 3 4
333333 NEW BANK 0 5 6 7

THANKS A LOT!!!
Ann

 

[synapsevampire]

Select Insert->Cross-tab

Place the {@period} in the columns, and the {table.employer} in th rows, and the {table.members} in the field to summarize.

Place the report in the Report Header or the Report Footer.

-k

 

[Ann28]

Hi,
I am sorry which columns?
Thanks a lot,
Ann.

 

[synapsevampire]

I don't know the names of your fields, the above are examples.

-k

 

[Ann28]

Hi - Really appreciate your help!

I created the crosstab report and it's working fine for one group.
I have an external Group break and it is not a part of a cross-tab set-up.
How do I incorporate an external break with the cross-tab report?

Now I am only displaying one group:
CL {@GROUP}
1234567 Q1 Q2 Q3 Q4 (Grouped by employer, summary by member.count)
134568 Q1 Q2 Q3 Q4

The report should look like:

CL
1234567 Q1 Q2 Q3 Q4 (Grouped by employer, summary by member.count)
134568 Q1 Q2 Q3 Q4
CT
1234567 Q1 Q2 Q3 Q4 (Grouped by employer, summary by member.count)
134568 Q1 Q2 Q3 Q4


THANKS A LOT!

 

[lbass]

Try placing the crosstab in your group header or group footer for {@group}.

-LB

 

[Ann28]

I really appreciate all your help with my first crystal report!
How do I put the group header on every page?
Thanks a lot,
Ann.

 

[johnstrang]

Ann,

If you go into the Change Group Options, the is a check box for "Repeat Group Header On Each Page"

John

 

[Ann28]

I have another problem with the report. Please help!
Really appreciate your help!

Here is the input:
empl cont count period
520029 I049 55 200303
520029 I049 200306
520029 I049 54 200309
520029 I049 200309

On the crosstab report I have {Goup_it} and {Contact} as Columns
and {Employer} as a row and summarized filed is count

On my output I am getting:

520029 2003 / Q1 2003 / Q2 2003/ Q3
I I I
165 0 54

THANKS A LOT!!!
Ann.

 

[lbass]

It is unclear what is wrong with the above display. Please provide another sample of how it is displaying and then also how you would like it to display. Or are you saying the summaries are wrong? Maybe a little more explanation would be helpful.

-LB