Dynamic Titles, Texts, Fields -- Crystal 8, VB6

[rlb_wpg]

I need to create a report using Crystal 8 with VB6.
Based on values set by a user an SQL stmt is created.
The DataSource is set dynamically.

Different values may need to be shown in different
columns but the number of columns will always be the
same.
For instance,
the user may choose to order by Date therefore the
report would look like:
DateHired Name Phone City Age

The next time they may want it by name
Name DateHired Phone City Age

Or by City
City Name Date Hired Phone Age
etc.

With an average Age and a total # of records printed after
each new value in Column 1 (ie. new date, new last name,
new City) and a Grand total at the bottom of the
report.

I need to be able to change the report title, the field
title and, if possible, the field type (ie. string, Long,
double)

How do I do this in Crystal 8?

Also, the Crystal 8 examples all show an ICRDesigner.
How do I add an ICRDesigner? (without copying and altering
the examples)

Thanks!

[blindix]

The only way I found to display variables in title section in to repeat those variable in the Sql results:
"Select name, addrs, "John", "Give me the name and adrs of" from costumers where name like '%John%'

In you Sql result you have the 3rd and 4th column always set at 'John' and 'give ...'

Now you can use this variables in title section.

That an ignoble trick indeed, and if you find something better, tell us

Bye