crystal reports

[sertev]

I have two questions about crystal reports in .net.

Firstly I would like to know how to set up my report exactly the way i want in design time and then pump the database path into the report at run time. At the moment I have to specify the database at design time. Any ideas?

Second I am having a problem when relating two tables. I have an ID_Number in one table that has a data type of number. In the second table I have ID_Number that is data type text. Now they are exactly the same fields exept one is a number and the other is text. Why you ask, I did this to simplify the code I had to write for a function. All I want to do is relate these two tables, but crystal reports wont allow it due to incompatable data types. Any Ideas?

Cheers,

[Lunatic3]

For first question:
See this guide from CR or this from MSDN.

and for second: maybe changing your code will be a better solution