Crystal report

[pmollik]

when i run the crystal report , there is message
"The report you requested requires further information."
For dataset , it requires username and password

I cannot login the report page.....

please help....

I want to view report without username and password

[gep13]

Hey,



I think you are going to need to provide us some more information before we are going to be able to help you.

Can you show some of the code that you are using? How did you go about creating the Report in the first place?

Gary

[pmollik]

1.add dataset
2.add table from databse to dataset
3.then build crystal report from the report wizard in dotnet 2008
4. include crystal report into crystal report viewer in aspx page
then i run the report
but cannot view the report as page contains the

The report you requested requires further information.



--------------------------------------------------------------------------------
DataSet1
Server name:
Database name:
User name:
Password:
Use Integrated Security


as a result , i cannot view the report

[gep13]

Hey,

Have you configured the connection to SQL Server

http://msdn.microsoft.com/en-us/library/ms226340.aspx

Gary

[mendhak]

I want to view report without username and password

You can't do that. Why would you want to make your data insecure?

[Claude2005]

I have the same case when I started using Crystal Reports. I think the username and password is used for authenticating a user if he/she is valid to actually use the Crystal Report or not. IMO, it has nothing to do in making your data insecure, since I can view the same DataSet in a DataGridView.

[mendhak]

Not sure I understand - are you saying this is a CrystalReports username and password?

(Also, being able to 'view' the data in a dataset/or dgv still requires a connection string so that counts as the secure bit)

[Claude2005]

I really don't know what exactly to say but, when you use crystal reports to view a System.Data.DataSet, that "login part" always appear.

So here is what I did. To remedy this, we have to create a DataSet within your "App_Code" folder, let's say you named it "DataSetSample".

If you create an instance for System.Data.DataSet, you type...

Dim ds As New System.Data.DataSet

To call the DataSet that is within your "App_Code" folder, you type

Dim ds As New DataSetSample

From here, go to the DataSetSample Tab, and create a DataTable from the Server Explorer. Let's say you want data from the "Personnel_Information" Table from your database. Click and drag the Personnel_Information to the workspace of the DataSetSample Tab. By default, the DataTable will also be named as Personnel_Information.

And when you populate your DataSetSample, you type... (sample code in SQL)

Dim da As New System.Data.SqlClient.SqlDataAdapter("SQL Command here", "SQL Connection String here")
Dim ds As New DataSetSample
da.Fill(ds, "Personnel_Information")

Please take note the line "da.Fill(ds, "Personnel_Information")". It is important to name your ds with the same name as your DataTable in your DataSetSample.

PS. Please go easy on me, I just started computer programming just months ago. I really don't know what you call this process.

[mendhak]

You can refer to it as "regular ADO.NET". You've created a dataset and filled it with a dataadapter. The DataSetSample must be a class that derives from DataSet in some way. DataSetSample must be available to you in some project you're using, but in other projects you do, you'll use DataSet.

[Claude2005]

I see that's what you call it. I'm only using ADO.NET if I'm using Crystal Reports.

@Topic Starter

I hope this thread helps