Scott on Writing

Feedback

# re: Crystal Reports Tip for the Day: Specifying the Database Name Dynamically 3/10/2005 9:09 PM Jeff Atwood

Someone needs to take Crystal Reports out behind the woodshed and put it out of its ever-lovin' misery. Man. I remember using that POS in VB3 and hating life. I've specifically avoided it ever since then.

# re: Crystal Reports Tip for the Day: Specifying the Database Name Dynamically 3/10/2005 11:43 PM Armando Andrade

Hello Scott, i have worked a lot with Crystal Reports.NET in a ASP.NET Intranet, i even made a class for working with this reports, would you like me to send you the class so you can review it?

# Crystal Reports Tip for the Day: Specifying the Database Name Dynamically 3/11/2005 7:06 AM CodeBetter.Com Link Blog

# re: Crystal Reports Tip for the Day: Specifying the Database Name Dynamically 3/11/2005 12:42 PM Scott Mitchell

Armando, why don't you post your library up on a public, stable URL and then share the link here?

Thanks

# re: Crystal Reports Tip for the Day: Specifying the Database Name Dynamically 3/15/2005 11:46 AM Sonu Kapoor

I would like to see the class too Armando. If possible can you please email it to me via sonukapoorREMOVETHIS@gmail.comREMOVETHIS

Thanks

# re: Crystal Reports Tip for the Day: Specifying the Database Name Dynamically 3/15/2005 2:27 PM Ryan Farley

Hi Scott,

You can also just remove the prefixed database and owner names from the table. I usually just go into Database|Set Location and remove the prefix info from each table name. This works in most cases since the database you use to build the report will likely be identical to the one you run it against in production. Removing those qualifying prefixes will assume the database and owner info from your connection in the report.

-Ryan

# re: Crystal Reports Tip for the Day: Specifying the Database Name Dynamically 3/17/2005 11:45 AM johnway

hello,I hvae spent a lot of to deal with it.Any easy read materail can be suggested to me?

# re: Crystal Reports Tip for the Day: Specifying the Database Name Dynamically 3/17/2005 11:51 AM Scott Mitchell

Johnway, you might want to consider picking up a copy of Brian Bischof's book, Crystal Reports .NET Programming - http://www.amazon.com/exec/obidos/ASIN/0974953652/4guysfromrollaco

I use that book quite a bit when working with CR. (And writing a review of Brian's book is on my never-shrinking TODO list!)

# re: Crystal Reports Tip for the Day: Specifying the Database Name Dynamically 3/21/2005 3:27 PM Ben Strackany

What about just using an alias in the connection string ("SERVER=MYSERVER"), and using cliconfg.exe on the server hosting the report to point the MYSERVER alias to the appropriate database server?

# re: Crystal Reports Tip for the Day: Specifying the Database Name Dynamically 3/21/2005 3:29 PM Ben Strackany

Although I guess my example string should have been "Data Source=MYSERVER", heh.

# re: Crystal Reports Tip for the Day: Specifying the Database Name Dynamically 3/27/2005 4:25 AM Lis

Hello Scott,

I have created my reports in Crystal(not in-built). I have 8 reports and a user can view them separately cos they are in separate asp pages. But this is taking so much time. I would like to know how I can call these various reports from a single page. (ASP.NET, VB.NET)

Thanks and Regards,

lis

# re: Crystal Reports Tip for the Day: Specifying the Database Name Dynamically 3/27/2005 9:08 AM Scott Mitchell

Lis, it is possible to load and display a CR dynamically, such as passing the report name or id through the querystring. I'm no expert on this, but there are plenty of CR smarties available at the Crystal Reports forum over at:
http://forums.asp.net/76/ShowForum.aspx

hth

# re: Crystal Reports Tip for the Day: Specifying the Database Name Dynamically 4/1/2005 3:06 AM Brian Storrar

What a guy! That's probably saved me the best part of a serious stress related cardio-vascular excursion!

Thanks for sharing this.

# re: Crystal Reports Tip for the Day: Specifying the Database Name Dynamically 4/3/2005 10:27 PM Tirupathirao

public void LogonToReport(string server, string database,string ID, string password)
{
TableLogOnInfo logonInfo = new TableLogOnInfo();
int i=0;
foreach(CrystalDecisions.CrystalReports.Engine.Table table in rd.Database.Tables)
{
logonInfo = table.LogOnInfo;
logonInfo.ConnectionInfo.AllowCustomConnection = true;
logonInfo.ConnectionInfo.ServerName = server;
logonInfo.ConnectionInfo.DatabaseName = database;
logonInfo.ConnectionInfo.UserID = ID;
logonInfo.ConnectionInfo.Password = password;
table.ApplyLogOnInfo(logonInfo);
rd.Database.Tables[i].Location=table.Name;
rd.DataSourceConnections[server,database].SetConnection(server,database,ID,password);
i++;
}
}

# re: Crystal Reports Tip for the Day: Specifying the Database Name Dynamically 5/7/2005 9:20 AM Peter

Thank you very much for this info. This will help so many users who got annoyed with this problem.

# re: Crystal Reports Tip for the Day: Specifying the Database Name Dynamically 7/6/2005 2:47 AM Lampan

What if report is using a Stored Proc as DataSource ...?

# re: Crystal Reports Tip for the Day: Specifying the Database Name Dynamically 10/27/2006 1:47 AM gvenu

Hi,

I am working on VB.Net i have problem with setlocation i want to know what is rd in above code

Title:
Name:
Url:
Enter the code you see:
Comments
Remember Me?