Results 1 to 6 of 6

Thread: Using Stored Procedure with CR 11

  1. May 21st, 2008, 04:07 PM #1
    blakemckenna
    blakemckenna is offline

    Thread Starter
    PowerPoster
    Join Date
    Jan 2004
    Location
    Southern California
    Posts
    5,034

    Using Stored Procedure with CR 11

    I'm using Crystal Reports 11 and was wondering if it's possible use Stored Procedures with it? I have a report in which I have no idea how to show the data just by creating Formulas. I need to "Count" data but the data is derived from several SQL Server Tables. I'm clueless as to how to accomplish this.

    Any ideas or other solutions are helpful!

    Thanks,
    Blake
    Reply With Quote Reply With Quote
  2. May 22nd, 2008, 10:32 AM #2
    riteshjain1982
    riteshjain1982 is offline
    Frenzied Member
    Join Date
    Jan 2006
    Posts
    1,875

    Re: Using Stored Procedure with CR 11

    May be you can user Crystal report's fomula field to count data !
    Reply With Quote Reply With Quote
  3. May 22nd, 2008, 10:47 AM #3
    blakemckenna
    blakemckenna is offline

    Thread Starter
    PowerPoster
    Join Date
    Jan 2004
    Location
    Southern California
    Posts
    5,034

    Re: Using Stored Procedure with CR 11

    I'm not good with complex formulas...
    Blake
    Reply With Quote Reply With Quote
  4. May 22nd, 2008, 10:48 AM #4
    riteshjain1982
    riteshjain1982 is offline
    Frenzied Member
    Join Date
    Jan 2006
    Posts
    1,875

    Re: Using Stored Procedure with CR 11

    can you give some example like what will be your i/p and what's expected o/p ?
    Reply With Quote Reply With Quote
  6. May 22nd, 2008, 11:18 AM #5
    blakemckenna
    blakemckenna is offline

    Thread Starter
    PowerPoster
    Join Date
    Jan 2004
    Location
    Southern California
    Posts
    5,034

    Re: Using Stored Procedure with CR 11

    can't do that due to company security policies...
    Blake
    Reply With Quote Reply With Quote
  7. May 22nd, 2008, 01:32 PM #6
    jggtz
    jggtz is offline
    Frenzied Member
    Join Date
    May 2006
    Location
    some place in the cloud
    Posts
    1,886

    Re: Using Stored Procedure with CR 11

    Yes, It's possible to create a report from Stored Procedures in a SQL Server

    When You select the DataSource for the report You will see in the DataExplorer, the tables, views and StoredProcedures that are in the SQL Server, and You can select and relate them
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules


Click Here to Expand Forum to Full Width