LITTLEBLACKDOG.COM Forum Index LITTLEBLACKDOG.COM

 
LWD LWD   FAQ FAQ   Memberlist Memberlist   Usergroups Usergroups   Active Topics Active Topics   Register Register  
  Profile Profile   Log in to check your private messages Log in to check your private messages   Log in Log in  
  Who is Online Who is Online   Image Gallery Image Gallery   Chat Chat   Search Search  
  LWDGear       LBDGear  

Visual Studio 2005 with built in crystal reports
 View next topic
View previous topic
Post new topic     Reply to topic   LITTLEBLACKDOG.COM Forum Index » Code Warriors
Author Message
AnalogKid
Butt Sniffer
Butt Sniffer


Joined: 26 Aug 2004
Posts: 1618
Post Posted: Fri Sep 21, 2007 12:46 pm   Post subject: Visual Studio 2005 with built in crystal reports Reply with quote Back to top  
Does anyone here have experience using these?

_________________
"It's just like the story of the grasshopper and the octopus: all year long the grasshopper kept burrying acorns for winter, while the octopus mooched off his girlfriend and watched TV, but then the winter came, and the grasshopper died, and the octopus ate all his acorns - and also he got a race car! Is any of this getting through to you?" -FRY

View user's profile Send private message
EdisonRex
Lead Dog
Lead Dog


Joined: 06 May 2002
Posts: 10052
Location: Not Moscow
Post Posted: Fri Sep 21, 2007 2:00 pm   Post subject: Reply with quote Back to top  
yes.

_________________
Garret: It's so retro.
EGM: What does retro mean to you?
Parker: Like, old and outdated.
View user's profile Send private message AIM Address Yahoo Messenger
ThunderDawg
Alpha Dog
Alpha Dog


Joined: 14 Apr 2002
Posts: 16588
Location: In The Garden of Eden, Hawnay.
Post Posted: Fri Sep 21, 2007 4:26 pm   Post subject: Reply with quote Back to top  
I would imagine that's good to know Approve Smile
View user's profile Send private message
AnalogKid
Butt Sniffer
Butt Sniffer


Joined: 26 Aug 2004
Posts: 1618
Post Posted: Fri Sep 21, 2007 5:37 pm   Post subject: Reply with quote Back to top  
Ok, well I'll have a question for you on Monday. My policy is not to put one ounce of effort into work over the weekends Very Happy

_________________
"It's just like the story of the grasshopper and the octopus: all year long the grasshopper kept burrying acorns for winter, while the octopus mooched off his girlfriend and watched TV, but then the winter came, and the grasshopper died, and the octopus ate all his acorns - and also he got a race car! Is any of this getting through to you?" -FRY

View user's profile Send private message
Skookum
Butt Sniffer
Butt Sniffer


Joined: 26 Oct 2001
Posts: 1535
Location: I dunno, I lost my Mommy
Post Posted: Sat Sep 22, 2007 7:48 pm   Post subject: Reply with quote Back to top  
Sadly enough I have experience too.
craxdrt.dll is your friend.

_________________
"Paranoia is no longer a mental illness it is a way of life" - Me
View user's profile Send private message Send e-mail Yahoo Messenger MSN Messenger
Webster
Guide Dog
Guide Dog


Joined: 16 Feb 2002
Age: 28
Posts: 8695
Location: Vacationland
Post Posted: Mon Sep 24, 2007 5:42 am   Post subject: Reply with quote Back to top  
I've had to maintain some of them, and am starting to develop it. However, first i need to figure out our new licensing requirements...we finally upgraded from CR 8.5 to XI.

_________________
www .Run To Win.com
The Marathon Thread
I finally published my book: Comprehensive Guide to Marathon Preparation & Recovery
View user's profile Send private message Send e-mail Visit poster's website AIM Address
Alphi
Big Dog
Big Dog


Joined: 05 Apr 2002
Age: 37
Posts: 3038
Location: Grand Rapids, MI USA
Post Posted: Mon Sep 24, 2007 6:07 am   Post subject: Reply with quote Back to top  
Skookum wrote:
Sadly enough I have experience too.
craxdrt.dll is your friend.



Friend... Enemy... Same difference, I guess...


(Yup, some Crystal Reports & .NET experience here too)

_________________
They that can give up essential liberty to obtain a little temporary safety deserve neither liberty nor safety.
- Benjamin Franklin


Prosper.com - P2P lending
View user's profile Send private message Send e-mail ICQ Number
AnalogKid
Butt Sniffer
Butt Sniffer


Joined: 26 Aug 2004
Posts: 1618
Post Posted: Mon Sep 24, 2007 6:43 am   Post subject: Reply with quote Back to top  
Forgive me if I don't explain this well.
I am working on a .net 2.0 web app using VS 2005.
We designed this using a data access layer (just a directory with many files... all of the methods for connecting to the DB)
In my project, I added a CR file. Next I went to the "database expert". Under .NET Objects shows all of my cs files in the data layer that I want. So I find the one I want and add it to the right side of the wizard and click ok.

Well now I guess I'm supposed to get a choice of fields I want to add to the report...I assume. I'm not exactly sure where this "list" would come from since it's not reading what is returned from my stored procedure.

In the particular file (method) I added has only one call to the DB

Code: Select all
public DataSet GetData(string identity, int myID
    {
        WindowsIdentity wi = this.GetIdentity(identity);

        SqlConnection cxn = new SqlConnection(this.ConnectionString);
        SqlCommand cmd = new SqlCommand("pGET_GetData", cxn);
        cmd.CommandType = CommandType.StoredProcedure;
        cmd.Parameters.AddWithValue("@myID", myID);

        DataSet set = new DataSet("GetData");
        SqlDataAdapter da = new SqlDataAdapter(cmd);

        .
        .
        .
        .
        etc
    }


I've never used CR before so I'm just going off what I know.
How the hell do I simply add a field to this report that would be populated by my stored proc?

_________________
"It's just like the story of the grasshopper and the octopus: all year long the grasshopper kept burrying acorns for winter, while the octopus mooched off his girlfriend and watched TV, but then the winter came, and the grasshopper died, and the octopus ate all his acorns - and also he got a race car! Is any of this getting through to you?" -FRY

View user's profile Send private message
Display posts from previous:   
Post new topic     Reply to topic   LITTLEBLACKDOG.COM Forum Index » Code Warriors
 
Jump to:  

View next topic
View previous topic
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2002 phpBB Group
phpBB SEO
All times are GMT - 8 Hours

Help us keep advertisements off this site. Donate today!