Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Running totals 1

Status
Not open for further replies.

northw

MIS
Nov 12, 2010
140
US
Hi all,
I have a requirement, where I have to display the employee working days in a cross tab design but with out using cross tab, and it should be parameter driven.

My desired out put should be:

Emploree name Jan Feb Mar Apr

Abc 25 20 24 28
cde 21 12 23 29

Thank you.
 
You haven't explained why you don't want to use Crosstab. If you want to lump several values together, this can be done by a group field, you could do something like
Code:
If {your.code} in ["a", "b", "c"]
then "abc"
else {your.code}
I've a feeling this would not work in 8.5, which insisted on just database fields for crosstabs. It helps to give your Crystal version - 8, 8.5, 9, 10, 11 or whatever. Methods sometimes change between versions, and higher versions have extra options.

If crosstab won't do, create a 'Mock Crosstab', which is something that looks like a Crosstab, but in fact you define each column yourself, normally as a running total. This would need to go in the report footer, because running totals count as the reports 'run' and they will not be complete until then. Crystal should have included an example along with the Crosstabs.

You can save a little time by doing a paste to a dummy report, changing the name and then pasting back. In Crystal 11.5, you can also duplicate formula fields using the Field Explorer.

Each running total will count the record if it was within the criteria

[yinyang] Madawc Williams (East Anglia, UK). Using Crystal 11.5 with SQL and Windows XP [yinyang]
 
Insert a group on employee name and then create formulas like this:

//{@Jan}:
if {table.date} in date(year(currentdate),1,1) to date(year(currentdate),1,31) then
{table.amt}

Repeat for other months. Place the formulas in the detail section and insert summaries on them at the group level. Then suppress the detail and group header sections. Drag the groupname into the group footer.

But it looks like you could easily insert a crosstab instead. You can remove the grid, if that's the issue by going to the customize style tab->format grid lines->unncheck "show grid lines".

You need to explain what you mean by parameter-driven.

-LB
 
Sorry for the late reply.

Thank you Lbass, It worked perfect.

Thanks Madawc Williams.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top