Crystal report Viewer

colin

unread,

Apr 9, 2002, 6:22:35 PM4/9/02

to

Hope this is the correct forum.

I set up report to use ado.net dataset as report source and managed to point
a winform containing a report viewer at the report as a report source but
when you run the viewer the report brings up a login dialog prompting for
server password etc.

Is this a known bug reporting from datasets or do you have to do something
in code to disable the dialog.

Any pointers to a walkthrough that demonstrates crystal reports?

Colin

Philip Martin

unread,

Apr 10, 2002, 10:59:57 AM4/10/02

to

This is exactly what I'm doing, and I don't get any
requests for a database password. Perhaps your connection
to the database has not been authenticated.
Have you filled your dataset before telling the viewer to
show the report?

>.
>

colin

unread,

Apr 10, 2002, 11:33:44 AM4/10/02

to

> Have you filled your dataset before telling the viewer to
> show the report?

you could be correct my viewer is on a seperate form accessed from a button
on the form with a dataset i will pass the datset into a property of the
viewer form and try that

Thanks

Colin

"Philip Martin" <garg...@nospam.com> wrote in message
news:0dfd01c1e0a0$61651c10$3bef2ecf@TKMSFTNGXA10...

colin

unread,

Apr 10, 2002, 4:22:18 PM4/10/02

to

Philip,

Thanks for the pointer, it works when i pass a dataset to the viewer form
with a property

Cheers

Colin

"Philip Martin" <garg...@nospam.com> wrote in message
news:0dfd01c1e0a0$61651c10$3bef2ecf@TKMSFTNGXA10...

colin

unread,

Apr 10, 2002, 5:48:52 PM4/10/02

to

Any idea how to send the dataset filtered to the report (ie current record
only)

Colin

"Philip Martin" <garg...@nospam.com> wrote in message
news:0dfd01c1e0a0$61651c10$3bef2ecf@TKMSFTNGXA10...

Krishna

unread,

Apr 11, 2002, 11:22:17 AM4/11/02

to

Hi Colin,
I'm also getting the same problem(Login Dialogue)
while executing the application(winforms).
I'll explain in datail,
1.Adding a OleDBConnction to the windows form.
2.Crating a OleDBDataAdapter and using Data Adapter
configuration wizard entered the query using the
option "Use SQL Statement".
3.Here the SQL query is made based on a view(SQL
Server).
4.Before executing the application, from your
conversation , filled the DataSet after
InitilizeComponent.

But it is asking the login dialogue again...

Please give me a detail explanation, If possible give me a
example code senario.

Thanks in advance...

Regards,
Krishna

>.
>

colin

unread,

Apr 11, 2002, 1:19:29 PM4/11/02

to

I got my report to work by passing it a filled dataset as a property and
used the setvalue method to refresh the report:

1. build a report bound to a datset and save in solution (ie myreport)
2. built a new form placed a crystal viewer on the form (frmViewer)
3. Created a property on the Viewier form to accept a dataset (property
rptDataSet)
4 on the on load of the viewer form used CrystalViewer1.setvalue =
rptDataset

Code on main form button:
dim frm as new frmViewer
frm.rptDataset=dscustomer (my dataset on source form)
frm.show

Hope this helps

Colin

"Krishna" <kri...@anion.com> wrote in message
news:0ffd01c1e16c$aa90f9f0$a4e62ecf@tkmsftngxa06...