Kiran's personal website
Blog    Forums   Sitemap   Social    Phone

Knowledge base home, and site home.
List of all Knowledge base categories.
An alphabetical list of technical terms.
Contact Me
Contact me for knowledge base questions
My Blog
My articles, white papers, ideas and thoughts.


How to pass formula values to a stored procedure in Crystal Report?

Date Added January 1, 1970 | Print | Bookmark
How to pass formula values to a stored procedure in Crystal Report?
In Crystal reports once you connect to a database stored-procedure it automatically creates the parameter fields and does not allow you to pass formula based values.

Here the workaround to pass formula values to the database stored procedure through Crystal reports:

Create new blank crystal reports without connecting to the database (I call it as main-report).

Insert a sub-report in to the main report‘s detailed section. In the sub-report you call the stored procedure (as usual).

Create formulas on main report and link the main report formulas to the sub-report parameters. (Right click sub-report and link)

Was this article helpful?

Yes No

Category: Crystal Reports - General

Last updated on January 1, 1970 with 10416 views


Home | About Me | Products | Support | Contact | Knowledgebase | Forums | Blog | Site map | Site Search | Subscribe | Links | Social | News

Travel | Guest Book | All Pages | History | Site Calendar | Recipes | Ex-Rates | UK Stuff | Downloads | Telugu Stuff | Tell a Friend | Feedback

Bookmark and Share
Terms of Use
Site contents Copyright © 2008-2009 Kiran Reddy. All rights reserved.