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

 

[dgillz]

In regards to your second question, generally tou must link the tables together. You can create formula fields and link on those formula fields in a subreport, however.

In terms of vertical/horizontal, I assume you have placed your database fields horizontally in the details section of your report? Then the labels that come with it are horizontal and each line of data is horizontal. What is it you want to do that this does not work for? Software Support for Macola, Crystal Reports and Goldmine
dgilsdorf@mchsi.com

 

[hgg21]

Hi dgillz,

thanks for replying.

I have managed to do what u said: link two unrelated tables together by means of a table.

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 and is in another table.
Convertibles belong to another field in 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

 

[dgillz]

you said, "I have managed to do what u said: link two unrelated tables together by means of a table." I have no idea what this means. I always link tables by a field not a table, or like I suggested via a formula field in a subreport.

If you have linked the 2 tables together you should be able to place all the objects on the report and let it go. If you cannot do this you need to revisit your links. Are they equal joins, left outer joins, what are they? Also some more explanation of how you got these tables linked would be nice.

Software Support for Macola, Crystal Reports and Goldmine
dgilsdorf@mchsi.com

 

[dgillz]

you said, "I have managed to do what u said: link two unrelated tables together by means of a table." I have no idea what this means. I always link tables by a field not a table, or like I suggested via a formula field in a subreport.

If you have linked the 2 tables together you should be able to place all the objects on the report and executeit. If you cannot do this you need to revisit your links. Are they equal joins, left outer joins, what are they? Also some more explanation of how you got these tables linked would be nice.

Software Support for Macola, Crystal Reports and Goldmine
dgilsdorf@mchsi.com

 

[hgg21]

hi,

Okie table A and table C are not related. But i need to display their fields on the report. however table B has something in common to table A and table C. So i used table B to connect A and C together. But i did not display any fields from table B.

This is really what i want to do:

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

 

[dgillz]

I need to know more about your tables.

I am also confused by your use of the word "field". You talk about field Product.Product containing data for "convertibles, GED, Agency Portfolio Trading, Block Trades, blah blah blah....". A field typically only contains one type of data, a table can contain several. Is Product.Product a field or a table?



Software Support for Macola, Crystal Reports and Goldmine
dgilsdorf@mchsi.com

 

[hgg21]

Product is the table. Product.Product is a field in this table. In this field there are many data such as convertibles, GED, Block Trades etc. Is this clear??

Basically there are fields from 3 tables which i need to display on the table.
The 3 tables are Product, ParentProduct and Bucket.
Product and ParentProduct are directly connected. These 2 tables are in turn connected to Bucket through other tables but without display the fields in these tables.