I have a form which uses the crystal OCX control bound to a data control to
create ad-hoc reports as per the example in the Seagate knowledge base. The
problem is that the reports cannot be formatted and if there are too many
fields in the query, they do not appear on the report. I cannot pre-format
the report since the query is completely different every time (using a
natural language query builder). Exporting the results to different file
types varies the amount of fields saved!

Can anyone suggest how to display all fields - ReportSource property is set
to 3

Thanks in advance

Lez

------------------------------------------------------------------
Lez Lytollis - Internet & Database Developer
Computer Clothing Research centre
http://www.*-*-*.com/
Tel: +44 (0) 115 948 6836

bound to a data control to
Seagate knowledge base. The
and if there are too many
report. I cannot pre-format
different every time (using a
results to different file
ReportSource property is set

Try with:
        Format Menu > Auto-arrange report
It work with Crystal Report 5.0

By the way, i have other problem with Date/Time
fields in Access: only can print Date.
I know how to solve it with a normal report:
        File Menu > Report Options > Convert
Date-time to Date Disabled
        (Now, Date/Time fields are strings)
        {Table.Field}[11 to 22]  (for to get only
Time)
Can anybody help me how to get this with a bound
report? Thanks on advance.

Pablo

Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't.