Share
Report
908Hi All,
I have a set of requirement which are as follows:
Have to generate 2 .xls file (different format) with a month long report of the hours entered on each date for the range of start and end date .
I am able to generate the report for Format A where the dates of the month are row wise.
Now the other report I have to create where the rows become column that is like this:
| DA Job Pos. | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29 | 30 | 31 | Total |
| 1.0 | 1.0 | 2.0 | 1.0 | 5.0 |
where the first row is the date and the corresponding hours are there in the second row. How could this be achieved?
I want to insert an image and also chnage colors of certain cells how to achieve that through BC as using a template is not possible.
Regards,
Indira
All responses (
Answers (
