Click to See Complete Forum and Search --> : Using the tooltip text in my report


halsbloss
February 15th, 2007, 08:51 AM
Hi!
I'm looking to use the tooltip text in my report I get when hovering my mouse over a field.
The tooltip says the same as "Description" of a property I create and this is the string I want in my report rather than the "Value" of the property.
Ex.
Name: prop1
Value: 11
Description: "Speed selection"
Type: Integer

When just dragging the field into the report I get the value component, here 11.
Is there a way to get this text, it's clear that Crystal can access it since it diplays it in a tooltip.

halsbloss
February 19th, 2007, 07:15 AM
Noone knows about this? Please help me.

JaganEllis
February 19th, 2007, 11:30 PM
Surely this is just info from the database's data dictionary? So I guess you'll need to query the data dictionary tables to get the field attributes, just like Crystal did internally.

halsbloss
February 22nd, 2007, 02:22 AM
Ok could you please give me a pointer on how to do this or a link where some info can be found.
I tried to use a notation like "variable.description" - but it did not work.

Thanks for your support.

JaganEllis
February 22nd, 2007, 05:25 PM
Maybe I've misunderstood what you're asking - is prop1 a column in a table, and "Speed Selection" a description of that column? Or is it something to do with the Repository within Crystal? If the latter then I know pratically nothing about it - but I understand that it's still just a database so I assume you should be able to query it just like any other database.

halsbloss
March 8th, 2007, 03:10 AM
Hi sorry for the confusion, I will try to explain better.

The "Property" contains 4 columns, these are:
Name, Value, Description, Type.

The data in value in each of these columns are:
prop1, 11, Speed selection, Integer.

I can add the property to crystal and it shows as "prop1".
The tool tip in crystal shows the value of the Description column: "Speed selection", and when adding the property to crystal in the report it uses the Value column: "11".

I would rather add the data in the Description column here "Speed selection" to my report, is this possible?

Thanks for the help!