Wednesday, March 7, 2012

multiple columns in details section

I have three fields in my report that make up each record. I would like to display these in detail section.

so instead of

1. alam Dept1 10000
2. khaiser dept2 20000
3. mujeeb dept2 20000

I would have

alam khaiser mujeeb ...
dept1 dept2 dept2 ...
10000 20000 20000 ..Use Crosstab Report|||1. Right-click on the dtails section, to open the Section Expert dialog box.

2. On the 'Sections' list, click the details section.

3. On the 'Common' tab, select 'Format with multiple columns' check box. A new tab called 'Layout' appears.

4. On the 'Layout' tab, specify the formatting for the columns:

Enter the width of the column in the 'Width' box. (you can set the height by dragging the section borders in the Design view of the report)

Enter the space between labels going across the page in the 'Horizontal gap' checkbox.

Enter the space between labels going down the page in the 'Vertical gap' box.

Select the printing direction, 'Across then Down' or 'Down then Across'.

Good Luck|||after using the Scetion expert i got mutliple columns but the sum of salary should be in right side but it is not coming ......

No comments:

Post a Comment