How do I change the user and password?

[bigfoot]

I am using Crystal Decisions and VS.NET.

Once I create my report thru the wizard, and I create a new connection. I enter the login name and password. Next I finish with the wizard, and run the report.

It keeps asking me for the name and password again. Is there any way to change this? I wanted to go into the connection properties, but Crystal does not seem to have a way to get back to it.

I want to get it from an ini file or something.

Where do I go?

 

[pgtek]

hi

you have your report jsut go in the database set location and there you will see the datasource and there you can repoint it to a new source.

pgtek

 

[bigfoot]

I don't want to repoint it a new source. I want to specify the name and password in code so I can pull it from an ini file. This way it's not hard coded.

Any way to do this? I did do a push where I created a dataset and worked with it that way.

 

[pgtek]

hi
if your using vb just decalre parameter in your report to have user enter user id ans password and have it pass to the report.
Just do a search here for download sample

http://support.crystaldecisions.com/search/

cheers

pgtek

 

[pgtek]

hi
heres the link of all the samples

http://support.crystaldecisions.com/fix/samplescr.asp?ref=default.asp_selectlist

cheers

pgtek

 

[bigfoot]

Oooooooo. Thank you. (Like a kid in a candy store).

Good stuff there. I'm downloading all of them. It's time to take a day and play, er... I mean learn.

 

[bigfoot]

None of them work. I can't get them to load. They tell me that it's a web app and to contact it using a url. So I copied it to my inetpub folder and it still won't load. What's the deal.

I think I'm buying a web reporting tool. Crystall's too hard. No documentation and no one to call. At least with Component One or Data Dynamics, I have tech support. I can't seem to make it do anything. This is getting frustrating.

 

[pgtek]

hi
you can try a third party tool
you can search in this forum i saw something about that in there
pgtek

 

[pgtek]

hi
you used the wizard to create your report
are you using an ODBC connection?
If so did you create this ODBC as a system DSN?

cheers

 

[bigfoot]

It did not give me the option to create the ODBC as a system DSN, only it's own connection, and that's why I am stuck. I wanted to create the connection in VB then point the report at it.

I guess I am used to Active Reports where the program drives the report, not the other way around.

 

[pgtek]

hi

I never use this wisard before sorry.
I always create my owned and assign the connection myself.
then i pass the info to vb thru parameter and in the vd i call set logoninfo and pass it to crystaland there the parameter set the login and password to the report

i know recrystalize does that

cheers

pgtek

 

[bigfoot]

I'd love it if you could send me some code on how to do that. That's whet I was looking to do.

Please let me know, and I'll send you my e-mail. Any getting started info would be great.

Thanks a bunch.

 

[bigfoot]

I added a report. I added a CrystalReportViewer1. I added a button, and in it's event I put.

Dim Rpt As CrystalReport2
Rpt = New CrystalReport2
Rpt.Database.Tables.Item("CATITEMLST&quot.LogOnInfo.ConnectionInfo.UserID = "myuser"
Rpt.Database.Tables.Item("CATITEMLST&quot.LogOnInfo.ConnectionInfo.Password = "mypassword"

CrystalReportViewer1.ReportSource = Rpt

But what if I wanted to pass it a query? Ir use a join on more then one table.

 

[bigfoot]

The project you are opening is a web report. You need to open it by specifying it's url.

What does this mean? Where do I have to copy the files to make this work? I tried putting the project in inetpub/

http://www_root

and it could not open it.

 

[bigfoot]

I think I understand how to get this working, but all of the examples I found are using a MS Access database, and I wast to use a SQL Server database which makes me have a log on. I want the log on to BE THE SAME ALL THE TIME. We don't use user security here, and a simple username and password coming from the web.config file will do the trick. Would someone please take the time to post me some code. I have ALL of the tutorials from the crystal website and they are no help at all.

Thanks everyone ahead of time.

 

[pgtek]

hi
read this threat it might help you

thread149-568181

pgtek

 

[NorthBank]

Morning.

I've come to this late so you may have resolved this already.

It sounds like your going through a similar evaluation excercise as I am with some reporting tools.

I encountered a similar problem with Crystal and seem to recall using the SetDatabaseLogon method on the ReportDocument instance. Using the overload for just 'the uid and pswd seemed to work well. I did manage to get the TableLogonInfo method used widely in the examples but I found but you have to remember to use the ApplyLogOnInfo for each table in the collection.