Crystal Reports with *.csv Files

[Sujith Manuel]

Hi All,

Iam facing a problem with crystal reports in dotnet. i am trying to
use crystal reports with csv files.i have successfully provided the
database details (csv filename and path)and all report fields in my
*.rpt file. But at runtime when i associate the report document
(Sample.rpt) with Crystal report Viewer, a DATABASE LOGIN screen is
coming up asking for username and password, but this specific csv file
doesn't have any security information as such.

Is there anyway to avoid this dialog, because this dialog prevents me
from displaying the report.

Thanks in advance,
Sujith Manuel.

 

[Sahil Malik]

Sujith - try this.

Create a strongly typed dataset that maps your dataset generated out of the
csv one to one.
Edit the rpt in vstudio (add it to your solution even).
Specify generate columns using XSD - this xsd is your strongly typed dataset
xsd.
At runtime databind the dataset to the report.

That should fix it.

- Sahil Malik
http://dotnetjunkies.com/weblog/sahilmalik