By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
429,053 Members | 1,595 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 429,053 IT Pros & Developers. It's quick & easy.

issue with crystal report created from a dataset

P: n/a
Hello

Here is my issue, I created a crystal report using a data set from my
xsd. Then I created a page with the crystal report viewer control and
bound the report to it.

When I try to view the report on the browser I get a logon page even
though my dataset has a connection string saved within it. When I
preview the data in the dataset I see it no problem. however the
report doesn't seem to know that the dataset is there or that the
dataset has the connection string saved. The connection string is my
config file with a user authentication method NOT windows
authentication.

What I am missing, I am not finding any answers online.

Thanks
Simone

May 16 '07 #1
Share this Question
Share on Google+
6 Replies


P: n/a

Here is the CR KB
http://support.businessobjects.com/c...etdatasets.pdf

Note they use a sloppy method to populate their dataset.
The best way is to populate the dataset seperate from anything else.

Here is the main crux of that KB (and their sloppy hugarian notation)

MyStrongDS ds = SomeClass.GetTheDataSet();
// The ds should be fully populated at this point............

oRpt = new CustomerSales ();
oRpt.SetDataSource (ds);
CrystalReportViewer1.ReportSource = oRpt;



"Simone" <oi****@hotmail.comwrote in message
news:11**********************@h2g2000hsg.googlegro ups.com...
Hello

Here is my issue, I created a crystal report using a data set from my
xsd. Then I created a page with the crystal report viewer control and
bound the report to it.

When I try to view the report on the browser I get a logon page even
though my dataset has a connection string saved within it. When I
preview the data in the dataset I see it no problem. however the
report doesn't seem to know that the dataset is there or that the
dataset has the connection string saved. The connection string is my
config file with a user authentication method NOT windows
authentication.

What I am missing, I am not finding any answers online.

Thanks
Simone

May 16 '07 #2

P: n/a
Thanks for your quick reply.

However I am having issues still. I am really new to this.. so sorry
for my poor knowlege on this.
I am all confused on the oRpt, what is that? The code declares public
customerSales oRpt = null >>not sure what this is???
BTW I am using visual basic and not c sharp.

Looks like I have to bind the data set to the report viewer on the
page load of the page where the report viewer lives.
so if my report viewer is called CrystalReportViewer1 and my report is
already attached to it (report name = test.rpt).

How do I do that?
The xsd file is called CRReporsTest and the table adapter is called
PtRoster.

Please help. Thanks
-S

On May 16, 11:52 am, "sloan" <s...@ipass.netwrote:
Here is the CR KBhttp://support.businessobjects.com/communityCS/TechnicalPapers/rtm_re...

Note they use a sloppy method to populate their dataset.

The best way is to populate the dataset seperate from anything else.

Here is the main crux of that KB (and their sloppy hugarian notation)

MyStrongDS ds = SomeClass.GetTheDataSet();

// The ds should be fully populated at this point............

oRpt = new CustomerSales ();
oRpt.SetDataSource (ds);
CrystalReportViewer1.ReportSource = oRpt;

"Simone" <oim...@hotmail.comwrote in message

news:11**********************@h2g2000hsg.googlegro ups.com...
Hello
Here is my issue, I created a crystal report using a data set from my
xsd. Then I created a page with the crystal report viewer control and
bound the report to it.
When I try to view the report on the browser I get a logon page even
though my dataset has a connection string saved within it. When I
preview the data in the dataset I see it no problem. however the
report doesn't seem to know that the dataset is there or that the
dataset has the connection string saved. The connection string is my
config file with a user authentication method NOT windows
authentication.
What I am missing, I am not finding any answers online.
Thanks
Simone- Hide quoted text -

- Show quoted text -

May 16 '07 #3

P: n/a
On May 16, 11:52 am, "sloan" <s...@ipass.netwrote:
Here is the CR KBhttp://support.businessobjects.com/communityCS/TechnicalPapers/rtm_re...

Note they use a sloppy method to populate their dataset.

The best way is to populate the dataset seperate from anything else.

Here is the main crux of that KB (and their sloppy hugarian notation)

MyStrongDS ds = SomeClass.GetTheDataSet();

// The ds should be fully populated at this point............

oRpt = new CustomerSales ();
oRpt.SetDataSource (ds);
CrystalReportViewer1.ReportSource = oRpt;

"Simone" <oim...@hotmail.comwrote in message

news:11**********************@h2g2000hsg.googlegro ups.com...
Hello
Here is my issue, I created a crystal report using a data set from my
xsd. Then I created a page with the crystal report viewer control and
bound the report to it.
When I try to view the report on the browser I get a logon page even
though my dataset has a connection string saved within it. When I
preview the data in the dataset I see it no problem. however the
report doesn't seem to know that the dataset is there or that the
dataset has the connection string saved. The connection string is my
config file with a user authentication method NOT windows
authentication.
What I am missing, I am not finding any answers online.
Thanks
Simone- Hide quoted text -

- Show quoted text -
Thanks for your quick reply.

However I am having issues still. I am really new to this.. so sorry
for my poor knowlege on this.
I am all confused on the oRpt, what is that? The code declares public
customerSales oRpt = null >>not sure what this is???
BTW I am using visual basic and not c sharp.

Looks like I have to bind the data set to the report viewer on the
page load of the page where the report viewer lives.
so if my report viewer is called CrystalReportViewer1 and my report is
already attached to it (report name = test.rpt).

How do I do that?
The xsd file is called CRReporsTest and the table adapter is called
PtRoster.

Plesae help. Thanks

May 16 '07 #4

P: n/a

oRpt is code found in the KB I sent you.

Aka, you have to read that KB to then understand what I am talking about.

................

oRpt is also an instance of the report in CR that you right. Aka, I think
its the ReportName.rpt, without the .rpt.
Aka, if you create a new CR called EmployeeSalaries.rpt, you'll want:

oRpt = new EmployeeSalaries();
(or in vb.net dim oRpt as EmployeeSalaries = new EmployeeSalaries() )

because EmployeeSalaries is EmployeeSalaries.rpt (without the .rpt)
..............
Repost if you still are having issues.


"Simone" <oi****@hotmail.comwrote in message
news:11**********************@o5g2000hsb.googlegro ups.com...
On May 16, 11:52 am, "sloan" <s...@ipass.netwrote:
Here is the CR
KBhttp://support.businessobjects.com/communityCS/TechnicalPapers/rtm_re...

Note they use a sloppy method to populate their dataset.

The best way is to populate the dataset seperate from anything else.

Here is the main crux of that KB (and their sloppy hugarian notation)

MyStrongDS ds = SomeClass.GetTheDataSet();

// The ds should be fully populated at this point............

oRpt = new CustomerSales ();
oRpt.SetDataSource (ds);
CrystalReportViewer1.ReportSource = oRpt;

"Simone" <oim...@hotmail.comwrote in message

news:11**********************@h2g2000hsg.googlegro ups.com...
Hello
Here is my issue, I created a crystal report using a data set from my
xsd. Then I created a page with the crystal report viewer control and
bound the report to it.
When I try to view the report on the browser I get a logon page even
though my dataset has a connection string saved within it. When I
preview the data in the dataset I see it no problem. however the
report doesn't seem to know that the dataset is there or that the
dataset has the connection string saved. The connection string is my
config file with a user authentication method NOT windows
authentication.
What I am missing, I am not finding any answers online.
Thanks
Simone- Hide quoted text -
- Show quoted text -

Thanks for your quick reply.

However I am having issues still. I am really new to this.. so sorry
for my poor knowlege on this.
I am all confused on the oRpt, what is that? The code declares public
customerSales oRpt = null >>not sure what this is???
BTW I am using visual basic and not c sharp.

Looks like I have to bind the data set to the report viewer on the
page load of the page where the report viewer lives.
so if my report viewer is called CrystalReportViewer1 and my report is
already attached to it (report name = test.rpt).

How do I do that?
The xsd file is called CRReporsTest and the table adapter is called
PtRoster.

Plesae help. Thanks

May 16 '07 #5

P: n/a
Thanks again.

The issue is that I don't see the name of the report when I do AS.
Like
dim oRpt as EmployeeSalaries = new EmployeeSalaries() I don't see the
"EmployeeSalaries". I am thinking I have to import something like
imports.... BUT I don't know what???. The name of my report is
PtRosterInCR.rpt.

Thanks soo much.
-S

On May 16, 2:31 pm, "sloan" <s...@ipass.netwrote:
oRpt is code found in the KB I sent you.

Aka, you have to read that KB to then understand what I am talking about.

...............

oRpt is also an instance of the report in CR that you right. Aka, I think
its the ReportName.rpt, without the .rpt.
Aka, if you create a new CR called EmployeeSalaries.rpt, you'll want:

oRpt = new EmployeeSalaries();
(or in vb.net dim oRpt as EmployeeSalaries = new EmployeeSalaries() )

because EmployeeSalaries is EmployeeSalaries.rpt (without the .rpt)
.............

Repost if you still are having issues.

"Simone" <oim...@hotmail.comwrote in message

news:11**********************@o5g2000hsb.googlegro ups.com...On May 16, 11:52 am, "sloan" <s...@ipass.netwrote:
Here is the CR

KBhttp://support.businessobjects.com/communityCS/TechnicalPapers/rtm_re...


Note they use a sloppy method to populate their dataset.
The best way is to populate the dataset seperate from anything else.
Here is the main crux of that KB (and their sloppy hugarian notation)
MyStrongDS ds = SomeClass.GetTheDataSet();
// The ds should be fully populated at this point............
oRpt = new CustomerSales ();
oRpt.SetDataSource (ds);
CrystalReportViewer1.ReportSource = oRpt;
"Simone" <oim...@hotmail.comwrote in message
>news:11**********************@h2g2000hsg.googlegr oups.com...
Hello
Here is my issue, I created a crystal report using a data set from my
xsd. Then I created a page with the crystal report viewer control and
bound the report to it.
When I try to view the report on the browser I get a logon page even
though my dataset has a connection string saved within it. When I
preview the data in the dataset I see it no problem. however the
report doesn't seem to know that the dataset is there or that the
dataset has the connection string saved. The connection string is my
config file with a user authentication method NOT windows
authentication.
What I am missing, I am not finding any answers online.
Thanks
Simone- Hide quoted text -
- Show quoted text -
Thanks for your quick reply.
However I am having issues still. I am really new to this.. so sorry
for my poor knowlege on this.
I am all confused on the oRpt, what is that? The code declares public
customerSales oRpt = null >>not sure what this is???
BTW I am using visual basic and not c sharp.
Looks like I have to bind the data set to the report viewer on the
page load of the page where the report viewer lives.
so if my report viewer is called CrystalReportViewer1 and my report is
already attached to it (report name = test.rpt).
How do I do that?
The xsd file is called CRReporsTest and the table adapter is called
PtRoster.
Plesae help. Thanks- Hide quoted text -

- Show quoted text -

May 17 '07 #6

P: n/a

"Namespace" is what you're looking for.

in C#, you'd see it like this.
namespace MyCompany.MyApplication.Data
{
public class EmployeeData{}
}
In vb.net, they (MS) kinda hide it from you.

Go to the project that has your PtRosterInCR class.
Right click it. Somewhere you'll find "Default Namespace"

Maybe something like
MyApplication.ReportDefinitions (whatever you find in the properties )

The fully qualified of your object is then:
MyApplication.ReportDefinitions.PtRosterInCR

So you can either do this

dim rpt as MyApplication.ReportDefinitions.PtRosterInCR = new
MyApplication.ReportDefinitions.PtRosterInCR()

OR

Imports MyApplication.ReportDefinitions
(top)

and then
dim rpt as PtRosterInCR = new PtRosterInCR
Something like that.

Make sure you "Add reference" to MyApplication.ReportDefinitions (assembly)
if you've got your rpt files in a seperate assembly.

................

This is probably my biggest nuisance complaint about VB.net.

It hides the namespace. And you always have to manually type in .
Namespace ReportFiles
End Namespace

It drives me nuts when I gotta go over to vb.net.



"Simone" <oi****@hotmail.comwrote in message
news:11*********************@p77g2000hsh.googlegro ups.com...
Thanks again.

The issue is that I don't see the name of the report when I do AS.
Like
dim oRpt as EmployeeSalaries = new EmployeeSalaries() I don't see the
"EmployeeSalaries". I am thinking I have to import something like
imports.... BUT I don't know what???. The name of my report is
PtRosterInCR.rpt.

Thanks soo much.
-S

On May 16, 2:31 pm, "sloan" <s...@ipass.netwrote:
oRpt is code found in the KB I sent you.

Aka, you have to read that KB to then understand what I am talking
about.

...............

oRpt is also an instance of the report in CR that you right. Aka, I
think
its the ReportName.rpt, without the .rpt.
Aka, if you create a new CR called EmployeeSalaries.rpt, you'll want:

oRpt = new EmployeeSalaries();
(or in vb.net dim oRpt as EmployeeSalaries = new EmployeeSalaries() )

because EmployeeSalaries is EmployeeSalaries.rpt (without the .rpt)
.............

Repost if you still are having issues.

"Simone" <oim...@hotmail.comwrote in message

news:11**********************@o5g2000hsb.googlegro ups.com...On May 16,
11:52 am, "sloan" <s...@ipass.netwrote:
Here is the CR
KBhttp://support.businessobjects.com/communityCS/TechnicalPapers/rtm_re...


Note they use a sloppy method to populate their dataset.
The best way is to populate the dataset seperate from anything else.
Here is the main crux of that KB (and their sloppy hugarian
notation)
MyStrongDS ds = SomeClass.GetTheDataSet();
// The ds should be fully populated at this point............
oRpt = new CustomerSales ();
oRpt.SetDataSource (ds);
CrystalReportViewer1.ReportSource = oRpt;
"Simone" <oim...@hotmail.comwrote in message
news:11**********************@h2g2000hsg.googlegro ups.com...
Hello
Here is my issue, I created a crystal report using a data set from
my
xsd. Then I created a page with the crystal report viewer control
and
bound the report to it.
When I try to view the report on the browser I get a logon page
even
though my dataset has a connection string saved within it. When I
preview the data in the dataset I see it no problem. however the
report doesn't seem to know that the dataset is there or that the
dataset has the connection string saved. The connection string is
my
config file with a user authentication method NOT windows
authentication.
What I am missing, I am not finding any answers online.
Thanks
Simone- Hide quoted text -
- Show quoted text -
Thanks for your quick reply.
However I am having issues still. I am really new to this.. so sorry
for my poor knowlege on this.
I am all confused on the oRpt, what is that? The code declares public
customerSales oRpt = null >>not sure what this is???
BTW I am using visual basic and not c sharp.
Looks like I have to bind the data set to the report viewer on the
page load of the page where the report viewer lives.
so if my report viewer is called CrystalReportViewer1 and my report is
already attached to it (report name = test.rpt).
How do I do that?
The xsd file is called CRReporsTest and the table adapter is called
PtRoster.
Plesae help. Thanks- Hide quoted text -
- Show quoted text -


May 17 '07 #7

This discussion thread is closed

Replies have been disabled for this discussion.