VB Forum / Crystal Report / November 2007

I have some reports with a SQL Server Database source and it´s works fine.
But I need to change the data source at run time, becouse my applications
works with some enterprises with the same structure. I work with VBasic 6,
CR ver 8.5 and I use crViewer to show the reports. I´m ...

I have a problem when try to show a report (Crystal ver.8.5) with CrViewer.
Appears the message "Server has not yet been opened".
The data source that I use is OLEDB  (to Ms SQL Server 2000) .
Can you help me?

My VB6 application with Crystal Reports 11.5 works in 4 companies. The last
company started to use it recently and they report the problem with viewing
and printing reports. While all other companies do not have any problem on
any workstation (about 60 all together), the last ...

I'm trying to create a formula for converting inches to feet & inches,
such as converting 255 inches to 21'3".
The formula I use is
({Length} \ 12) & "'" & ({Length} mod 12) & '"'

Hopefully I can explain this well enough
I have a report based on a services database that includes 4 parameters:
Site
DateRange

I want to export  report in (pdf , xls,doc and rtf format)
report format is as below:
       Element Codes 1 16     14 11 19 10 2 3
     Employee nos. Employee Name Normal RDO WC Breveavement LWOP Sick

I am creating my first Crystal Report. Everything checks out - my
dataset can see the data, CRs Field Explorer can see the fields, etc.
Everything seems OK, but no data appears on the report when I go to
Report Preview.

I have a report which work great and on every line of the Details there is a
"Text25" field.
When I add comments manualy to one of the Text25 fields, all get updated
with the same data.

I have a number of reports that have parameters for date range when they
run. Is there a way to show what the report date range is in the report
header or page header? I have not been able to figure this out.
Thanks

After both the development machine and SQL Server machine changed,
I've found that a few of the reports are very slow to load (20-60
secs). The rest are fine.
This is not a data issue - the reports are small (15k) and fairly

iif(isnull({billing_tx_history_2004.date_of_service}),iif({view_episode_summary_current.preadmit_admission_date}<
today - 90,"Over 90 Days", "Less Than 90
Days"),iif({billing_tx_history_2004.date_of_service}< today - 90,"Over
90 Days", "Less Than 90 Days"))

What I'm trying to do is  :

be able
to click on one field and then open another report showing specific