Crystal Reports with *.csv Files

  • Thread starter Thread starter Sujith Manuel
  • Start date Start date
S

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.
 
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
 
Back
Top