Fields and Tables

[hgg21]

Hi,

I have some problems here.
I want to display some fields horizontal but I cant seem to do it.
For example:

Commission Convertibles GED

Another problem is that if there's no links between 2 tables, am I able to display their fields together in one report?
I cant seem to do it.

Please advice, Thanks.
Jerry

 

[LMCRYER]

well, if the data is totally unlinkable, and you need to report off of it - my first question is why is it not linkable? (what kind of back end are you working with here?)

secondly, you could pull in this data using a subreport and not link it to the main report - but before I really recommend doing this, can you give more details?

what version of crystal? what is your backend?
what exactly are you trying to accomplish? LMC cryerlisa@hotmail.com

select * from Management where proj_mgmt_skills <> NULL

0 records returned

 

[hgg21]

Hi Lmcryer,

thanks for replying.

I have managed to link two unrelated tables together by means of a third table. My version is 8.0 and Sybase database.

Now I have another problem. My report supposed to look like this:

Bucket Name Commission Convertibles New Issue
XXXXXXXX
YYYYYYYY
ZZZZZZZZZZ


BucketName is one field and those are its details. Commission and New Issue belongs to one field from another table.
Convertibles belongs to another field from another table.

How am i going to display them this way?? Also commission and new issue cant be displayed simultaneously. If i select the field to be commission, then new issue cant be displayed.

Please advise, Thanks
Jerry

 

[hgg21]

Hi,

now I know what I want:

Ok, I have this field Product.Product
In this field there are a lot of data: eg convertibles, GED, Agency Portfolio Trading, Block Trades, blah blah blah....

I also have this field ParentProduct.ParentProductName
In this field there are only three data, Commission, New Issue and GLEP.

I want to display only 5 fields in a horizontal line that is:
Commission Convertibles AgencyPortfolioTrading GED NewIssue

Do i have to write any formulas??

I cant seem to display the fields. When I put ParentProduct.ParentProductName = Commission then it cant show NewIssue.

How can i do it???
Thanks!
Jerry