[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 407
  • Last Modified:

Customize crosstab report format

1.  I built a crosstab report using Crystal Report 8.5 wizards.. it came out smoothly like wat I needed.. but I thought of adding some label field 'n the record number in the report but it seems like dun allow to.. I can find any option tat I can insert a text field into the report...

2.  I hav a column of Month to be shown in the report using.."1, 2, 3..." how could i change them to "Jan, Feb, Mac.."?

pls help me with these 2 question.. thank you very very much!!
0
jellyfizme
Asked:
jellyfizme
  • 3
  • 2
1 Solution
 
SpykairCommented:
To answer your 2nd question:

Create a formula field:
@TextMonth
If {MyTable.MonthField} = 1
Then "January"
Else
   If {MyTable.MonthField} = 2
   Then "February"
   Else.
   .....
       If {MYTable.Month.Field} = 12
       Then "December"

Hth,
Spykair
0
 
OutinCommented:
As for the first question:
What do you mean?

Would you like to see a *row*number or do you really mean *record*number.
The latter is kinda impossible in a crosstab, since data in each cell is data based on a combination of record...

Greetz,

Outin
0
 
OutinCommented:
For 2nd question, another option...

Create a formula like this:

MonthName({MyTable.Monthfiield})


If you would like the abbreviated monthnames, use this:

MonthName({MyTable.Monthfiield}, TRUE)


hth

Outin
0
New feature and membership benefit!

New feature! Upgrade and increase expert visibility of your issues with Priority Questions.

 
SpykairCommented:
Jellyfizme, Outin's way is MUCH easier. Rather use his method.

Outin, thanx for pointing out that funciton...it'll come in handy

Spykair.
0
 
jellyfizmeAuthor Commented:
Hey Outin, thanks for your super duper formula.. it was cool..!   ^_^
For question no.1.. actually I was going to show the record number in the crosstab.. but it kinda difficult like u said... Still finding way to do tat..

Thanks everyone for your kindness 'n support.. I really appreciate tat ;)
0
 
OutinCommented:
Glad I could help...btw it's not my formula, it's all Seagates fault :-)

--
Outin

0

Featured Post

New feature and membership benefit!

New feature! Upgrade and increase expert visibility of your issues with Priority Questions.

  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now