How to display user input parameters in crystal report header

Posted on 2011-03-09
Last Modified: 2012-05-11
I need to display the user input parameters(nearly 4 parameters) in crystal report header by creating formulae in crystal reports. I am using crystal reports 2008 against BEx query as datasource.

I would really appreciate your quick reply.
Question by:bvreddy838
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
LVL 77

Assisted Solution

peter57r earned 83 total points
ID: 35080448
Just drag the parameter fields  into the header then.
LVL 23

Accepted Solution

Ido Millet earned 167 total points
ID: 35083085

Author Comment

ID: 35084442
I have 4different  parameters, which have values & description.(here SAP BW source)
1. year
2. month
3. name
4.another year
need to display user input parameter value description in crystal report header?

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

LVL 23

Assisted Solution

by:Ido Millet
Ido Millet earned 167 total points
ID: 35084519
You would have to create a formula to convert the value to a description or create a table in the database for this.  There is no way to retrieve the parameter value description directly.
LVL 100

Expert Comment

ID: 35084571
I you are referring to the description that is displayed with the parameter prompt then I agree.

Is the field with the description included in the report?

LVL 100

Expert Comment

ID: 35321869
This question has been classified as abandoned and is being closed as part of the Cleanup Program. See my comment at the end of the question for more details.

Featured Post

On Demand Webinar - Networking for the Cloud Era

This webinar discusses:
-Common barriers companies experience when moving to the cloud
-How SD-WAN changes the way we look at networks
-Best practices customers should employ moving forward with cloud migration
-What happens behind the scenes of SteelConnect’s one-click button

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

I hate sub reports and always consider them the last resort in any reporting solution.  The negative effect on performance and maintainability is just not worth the easy ride they give the report writer.  Nine times out of ten reporting requirements…
There have always been a lot of questions related to when Crystal Reports evaluates report components (such as formulas, summaries, cross-tabs, charts, to name a few examples). Crystal Reports uses a two-pass reporting process to provide greater …
This video shows how to use Hyena, from SystemTools Software, to update 100 user accounts from an external text file. View in 1080p for best video quality.
Suggested Courses

734 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question