Cant find correct value for row

[dwessell]

Hi,

I have two DB fields that I"m working with. Entrydate and totalprice..

I'd like to do a report, something like:

2006 2007
Jan
Feb
March
etc...

So the sum of totalprice for Jan 06 and 07,
Then for Feb, and so on.

I've got a crosstab report going, but I'm having an issue with the dates.

As the column, I have entrydate and groupoptions set for the column to be printed for each year.

In the summarized fields, I have the sum of totalprice..

But I can't get the row correct.. Should I have entrydate here as well? Each time I try and group by month, the row goes:

Jan 06
Feb 06
and on down
Jan 07
Feb 07..


In stead of just

Jan
Feb
Marc

Can someone point me in the right direction?

Thanks
David

 

[dgillz]

Do you want more than 1 years' worth of data in this crosstab?

Software Sales, Training, Implementation and Support for Macola, eSynergy, and Crystal Reports

http://www.gainfocus.biz

"If you have a big enough dictionary, just about everything is a word"
--Dave Barry

 

[lbass]

You need to use a formula for the row field:

month({table.date})

Use this formula as your row field and while in the crosstab expert with this field highlighted->group options->options->customize group name->use a formula->x+2 and enter:

monthname(month({table.date}),true)

-LB

 

[dwessell]

LB!!! Your my hero!!

Thanks a ton!!

Thanks
David

 

[dwessell]

In the same scenario...

I've added a grouping by entry date, that changes each month.. This gives me in the left hand pane, an entry for each month.

I'd like for that to lead to showing the salesperson (Another field in the DB) and the sum(totalprice)..

I can t put in the grouping for the salesperson into the Details section, but not the sum(totalprice).. Is there a way to put a summation in the Details?

Thanks
David

 

[lbass]

I can't follow what you are trying to do. Is this in the main report, NOT in a crosstab? Please also show a sample of your data as you would like it to appear.

-LB

 

[dwessell]

Hey LB..

The main report is a crosstab, and looks like this:

2006 2007
Jan
Feb
March
etc...

In my left hand pane that gives me a grouping for each month..
Is it possible, so that if you click on one of those months it gives me a grouping of the salesperson field, and the sum(totalprice)?

I've posted a picture at

http://straightrazorplace.com/tempimage.jpg

Thanks
David

 

[lbass]

Why not just add a second row field on salesperson?

-LB

 

[dwessell]

LB,

I'd like the (Assuming I understand you correctly) salesperson information to be on a seperate page, and the first page to be nothing but the monthly breakdown.. Is that explaining it a bit better?

Thanks
David

 

[lbass]

You can't drill down on a crosstab, but you could drilldown on a group within your main report, if you have a hidden group on salesperson with summaries per salesperson. This would give you one salesperson at a time.

Or you could place a crosstab with salesperson as the row in the group footer for month in your main report. If you place your monthly crosstab in the report header, the salesperson crosstab would follow. You could suppress the group header and detail section.

-LB