help need in creating report as same as in excel sheet

[jensonchandy]

I need a report to be created as the same in the excel sheet

how to do this

 

[Ukraine82]

I suggest you make a crosstab query....

The only bad thing about making a report to look exactly like your excel is you have to many fields that will make you report print more than 1 page even if you use landscape.

hth,
Michael

 

[jensonchandy]

hai

i had done the crosstab query....
it's working thankz for that
now i need another help on that
i need the date as my labels in headings

eg:
empno total_hrs 1jan 2jan 3jan........31jan 1feb....
1001 8 2 2 4
it's going like this
but what i need is there should be some parameter value.A start date and an end date
when we enter the date suppose
01/01/2005 and 01/15/2005
then the report should be like this
empno total_hrs 1jan 2jan 3jan ....14jan 15jan
1001 6 2 2 2

could u help me in this
regards
jenson

 

[Ukraine82]

Take a look at the attachment file - it a little different from what you want, but you can play around with it.

hth,
Michael

 

[jensonchandy]

thankz for the reply

ur report is the same as i need
but the probs is that
there should be 2 parameter values
starting and ending date
when we enter the dates only the days between that should be displayd

regards
jenson

 

[Ukraine82]

When using a short date for crosstab query it will not allow you to enter dates parameter.

I sugguest you use months instead of short dates.

hth,
Michael