Dataset for crystal report

[Hemang Shah]

I have form1 which has the dsDataset which is instance of
dsDataSetClass.xsd

I have a button called "report", which opens up another form, which has the
Crystal Report Viewer.

The datasource of the report is "current connection" dsDataSetClass

But whenever I run the report, it shows up the "Database Login" screen.

Even if I enter the details it doesn't work.

Firstly 1) Why isn't it working?
secondly 2) How can I save that setting ? so that it works smoothly for the
clients.

There isn't much I could find on the net on it.

Thanks

HS

 

[Kamal Vaghjiani]

Hemang

Is the database connection established in Crystal Reports ?
Are you trying to do this via code ?

Example 1 c#
ReportTest rep = new ReportTest ();
rep.SetDatabaseLogon("USERNAME","PASSWORD");

I hope this helps...

Regards

KV

 

[Sahil Malik]

How have you generated the various available fields for the report? If you
generated it as a result of a query or stored proc, then you'll probably see
that logon. Use the XSD instead.

- Sahil Malik
http://codebetter.com/blogs/sahil.malik/

 

[Hemang Shah]

Thanks Kamal

I think I have to set the rep.setdatasource(datasetname)

But my dataset is current in the parent form, how do I reference that?

Thanks.

 

[Hemang Shah]

Hello Sahil

I used the xsd..

but then I need to fill in the .setdatasource property right ?

The report expert doesn't do that for you.

but my dataset is in the parent form, how do I access that ?

Thanks

 

[Sahil Malik]

Hemang, you need to set the datafields per the xsd at "DESIGN TIME" not run
time.
Is that what you did?

- Sahil Malik
http://codebetter.com/blogs/sahil.malik/

 

[news.microsoft.com]

Yes Sahil, I set it at design time.

But during runtime, the report needs to see the dataset right ? the dataset
is not running on the form that has the crystal report viewer, the datset is
on the form that is calling another form which has the crystal report viewer
in it.

I can create another dataset and all, in the form that has the crv, but all
data is ther on the parent form, i just want to refer that.

Thanks

HS

 

[Sahil Malik]

Hemang,

It doesn't matter where the dataset instance exists, as long as you can get
a reference to it.
Once you do that, just set the report datasource = datasource and databind.
That should be enough.

- Sahil Malik
http://codebetter.com/blogs/sahil.malik/

 

[Hemang Shah]

That is my problem, how can I reference a dataset which is on the parent
form, from the child form ?

It seems I have to define my dataset initially as static ?... That seems to
mess things up..

 

[Sahil Malik]

Not necessarily, the two forms exist as instances of the forms. You can
easily create a public property of the parent form. (It's just a class
right?)
Or it could be passed in as a constructor parameter to the child form.

- Sahil Malik
http://codebetter.com/blogs/sahil.malik/

 

[news.microsoft.com]

Would it be too much to ask for examples ? :$

Not necessarily, the two forms exist as instances of the forms. You can
easily create a public property of the parent form. (It's just a class
right?)
Or it could be passed in as a constructor parameter to the child form.

- Sahil Malik
http://codebetter.com/blogs/sahil.malik/

 

[Sahil Malik]

No it wouldn't be, but do know that last night I slept at 5, and this
morning I woke up at 8 - been that busy really !! But send me an email
instead because I can't post such big attachments to the newsgroup.

- Sahil Malik
http://codebetter.com/blogs/sahil.malik/

 

[Sahil Malik]

And maybe you could invite me for a chai party after I do send the example?
Maybe maybe?

 

[Hemang Shah]

would love to

And maybe you could invite me for a chai party after I do send the
example? Maybe maybe?