Why do records not apear on cross-tab 1

[7007]

1)Account names are selected in the rows where the names are available on that table these names are selected in spesific order on the group option.

2)Activity for the month to date is selected on the summarised field in a different table.

These two tables are linked by account number and company and branch,on the first table only the name field is selected on table two the company ,branch, activity for the month, year and month fields are selected.Different links were tried left and right outer and = .
eg.

jan feb marc
salaries 50000 60000 50000
car allow 700 900 700
uif 30 30 30
Total salaries 50730 60930 50730

On this Cross-tab workmans compansation were also selected in the spesific group order but because there were no activity up to date it do not appear,thou i need it in the report to show that it is null.

 

[kenhamady]

What field do you look at to know if the record should be salary or not? How do you determine which records should go into which groups? Ken Hamady

http://www.kenhamady.com/

Crystal Reports Training/Consulting and a
Quick Reference Guide to VB/Crystal (including ADO)

 

[dcm]

7007: You CAN use FULL NAME twice in the grouping process. Select it the first time and choose your specified order. Then create a formula field (@cheat_the_order} with FULL NAME as the formula - this acts as an alias for FULL NAME and you can then select @cheat_the_order for the next level of grouping. David C. Monks
david.monks@chase-international.com

http://www.chase-international.com

Accredited Crystal Decisions Enterprise Partner