Report Design
 Crystal Reports Forum : Crystal Reports for Visual Studio 2005 and Newer : Report Design
Message Icon Topic: CR use in VS2008 Post Reply Post New Topic
Author Message
mcaster2000
Newbie
Newbie


Joined: 21 Oct 2010
Online Status: Offline
Posts: 3
Quote mcaster2000 Replybullet Topic: CR use in VS2008
    Posted: 26 Oct 2010 at 7:13am

We started with CR reports in VS2003 and CR 9.  Everything was great.  Then we upgraded to CR 11.  Everything still good.  Then we upgraded to VS2008.  Went down the tube.  We can't get parameter inputs to work correctly, visually or programatically.  We can't get the programatic logon to the SQLServer DB to work at all.

Any suggestions, places to look, things to read would be greatly appreciated!!
IP IP Logged
BrianBischof
Admin Group
Admin Group
Avatar

Joined: 09 Nov 2006
Online Status: Offline
Posts: 2458
Quote BrianBischof Replybullet Posted: 26 Oct 2010 at 7:25am
I have code sample in my CR.NET 2008 book on Amazon, but here are some code snippets that might help:

Use the .SetParameter() method to change the current value of parameters.

myReport.SetParameterValue("Country", "USA")

To set the login credentials, use SetDatabaseLogin()

myReport.SetDatabaseLogin("user1", "1234")

If you're using ASP.NET, don't put your code in the page Load() method. It screws up the viewer control in VS2008. Use the On_Init() method instead. This keeps memory clean.

Here is the link for my book: Crystal Reports.NET 2008 book



Edited by BrianBischof - 26 Oct 2010 at 7:30am
Please support the forum! Tell others by linking to it on your blog or website:<a href="http://www.crystalreportsbook.com/forum/">Crystal Reports Forum</a>
IP IP Logged
mcaster2000
Newbie
Newbie


Joined: 21 Oct 2010
Online Status: Offline
Posts: 3
Quote mcaster2000 Replybullet Posted: 26 Oct 2010 at 8:01am
Many thanks.  Your version 9 book CR .NET Programming got us to our first success and I have just ordered the latest/greatest with the assumption it will see us along.  Meanwhile, I will try your suggestions.
 
M.
IP IP Logged
Post Reply Post New Topic
Printable version Printable version

Forum Jump
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum



This page was generated in 0.031 seconds.