Search results for query: *

Wow. Brilliant. I'll try it and let you know. I already changed it to a subreport with several groups and a running total, but I'm going to experiment. Thanks.

Full discloseure - this stuff is not my strength! Anyway, I'm using Crystal 8.5 Cross tab Rows are: {coursename} Columns are: {markingcolumn} (There's only have 1 column showing, I've discarded the others under Specify Order) Summarized field is: {Max of CreditAwarded} Data is showing...

Maybe my question should be is it possible to do a union on 2 cross tabs if the row names are the same?

yes, from a db field. Actually, the logic would be suppress if 0, but I can't seem to add a suppression formula to a field in a cross tab.

I'm trying to combine 2 sets of data in a cross tab, but one set of data should only appear in the last column. eg: Col1 Col2 Col3 Col4 8 A 9 B 10 C 11 D but I only want the letter info to appear in the last column. Any ideas? Thx.

Wow! Yippee! After a day and a half I finally got it. I don't like not using the selection criteria, but hey I'll cope. Thanks a lot.

What about tables to the right of the table that was left-joined?

I have selection criteria, but not on the right-hand table.

Sorry, I should have mentioned that I did use left outer join. There are quite a few tables used and the visual linking expert looks like a spider's web (I didn't design the db). the only thing I can think of is to make a work around using dummy data and suppress the dummy data but this...

I'm new to Crystal, using 8.5 with odbc connection. Using Visual Linking and select expert to create sql statements. It seems that I can't pull a record if the last table in the visual linking sequence doesn't have data. ie should pull sales name even if nothing else related to him. Hope...