Running totals 1

[northw]

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.

 

[Madawc]

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

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

Madawc Williams (East Anglia, UK). Using Crystal 11.5 with SQL and Windows XP

 

[lbass]

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

 

[northw]

Sorry for the late reply.

Thank you Lbass, It worked perfect.

Thanks Madawc Williams.