Print Page | Close Window

NEWBIE: One Stored procedure and parameter to fill

Printed From: Crystal Reports Book
Category: Crystal Reports for Visual Studio 2005 and Newer
Forum Name: Report Design
Forum Discription: The best way to design a report and problems you have encountered
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=14291
Printed Date: 20 Apr 2025 at 10:35am


Topic: NEWBIE: One Stored procedure and parameter to fill
Posted By: redspider
Subject: NEWBIE: One Stored procedure and parameter to fill
Date Posted: 07 Sep 2011 at 8:13am

Hi,

I am a Crystal Reports newbie with visual studio 2010

I have a report with multiple subreports.
•Subreport for header information
•Subreport for header logo
•Mainreport
•Subreport for footer information.

Now I want tot add the company info in the header en footer report.
I use a Stored Procedure to get the company info with an ID Parameter.

This works fine for the header, but for the footer I always get a popup asking to give the ID.
Is there someone who can tell me what I do wrong or if it's posible to use one SP and parameter for filling the footer and header.

thanks


Replies:
Posted By: hilfy
Date Posted: 08 Sep 2011 at 7:31am
Each subreport will run its own query - so data is not shared between the two.  I would check the links to the subreport in the footer to make sure that the ID parameter is being passed in correctly.
 
-Dell


-------------
Proviti, Data & Analytics Practice
http://www.protiviti.com/US-en/data-management-advanced-analytics - www.protiviti.com/US-en/data-management-advanced-analytics


Print Page | Close Window