Cross tab repeat row name

[dev1212]

Hi,

I have a cross tab in report footer section, below are the fields used on the cross tab.

Row Fields:
1 - Company
2 - Account

Summary:
1 - Account (Count)
2 - Account_amount (Sum)

Now the problem is the first row is not getting repeated for every Account.

The report is getting generated like,

Company Account CNT_ACCT Sum_amount
Auto A13 12 15244.12
A14 13 17728.33
Banking B12 10 15000.33
B13 13 17099.71

I need the report to be like below,

Company Account CNT_ACCT Sum_amount
Auto A13 12 15244.12
Auto A14 13 17728.33
Banking B12 10 15000.33
Banking B13 13 17099.71

Please let me know how to do it

Thanks

 

[lbass]

If you add the account first and then the company the company name will repeat.

-LB

 

[dev1212]

Okay,

i added it in the following way,
1-Account
2-Company
3-Account

It is working fine, but i dont want to show first row
(1-Account), how to avoid it

 

[lbass]

Suppress it.

I actually meant for you to remove the second instance of Account, but I guess you need it in that order for some reason.

-LB

 

[swiss2007]

Create a formula
(Company + Account) and use this formula in the cross tab instead of Company.

Now right click on the cross tab,
select (Company + Account) formula ----> Group options -------> options ----->check Customize Group Name Field and select your company field from the database, click OK, OK.

 

[dev1212]

Yes, i need it in that order.
I was able to suppress the first row.
But i got a new problem,
When exporting to excel the cell size of summary field (count of account) is getting expanded to almost its double size.
Any idea how to lock the field width..?

Thanks

 

[dev1212]

Never mind, i resolved it... just had to move gridlines a bit.

Thanks lbass for your help..

 

[lbass]

I like swiss2007's solution actually. Maybe you should try that.

-LB