I have some parameters on which i am fetching the value but i want to show the description field on report as for which parameter the value is being shown.
e.g. I am passing Task_id as parameter in report but on report i want to show Task_desc.
Yeah m fetching Task_desc but its on some condition and its 10 table join.
Task_desc is getting displayed when there is data against that particular task in diffrent tables but in case of no data its also not displaying anything.
My purpose is that :-
When user sees a report then he can also see what parameter he passed to report. Its very easy to display parameter but parameter value is useless until there is no description.
Right click on variable option comes in toolbax and give name to that , after that the window open. Write code as below (as per your requirement)
StrigVar Task_Desc := "";
if {YourTableName.Task_Code} = "1" then Task_Desc := "abc" ; //for single condition check with custom description.
if {YourTableName.Task_Code} = "1" and YourTableName.DateColumn > "2008/11/30" then Task_Desc := {YourTableName.Task_Code} ; // if you want you desciprton will show
if {YourTableName.Task_Code} = "1" and YourTableName.DateColumn > "2008/11/30" then Task_Desc := "xyz" ; // for multiple condition check with custom description.
pradeepnt
Member
266 Points
154 Posts
parameter description field
Aug 16, 2012 07:40 PM|LINK
Hi..............
I am using ASP.Net C# 4.0 and crystal reports.
I want to display Parameter description field (rather than parameter value) on report.
How to do this please provide some help.
Pradeep Narayan
Ajay2707
Contributor
4487 Points
870 Posts
Re: parameter description field
Aug 17, 2012 04:42 AM|LINK
Hi Pradeepnt,
First of all, why you want this? and still if you want, are you save description in anywhere?
Generally for description part, you may use Tooltip option of the field. Right click on field and give it.
http://www.crystalkeen.com/articles/crystalreports/tooltiptext.htm
http://stackoverflow.com/questions/991271/is-there-a-way-to-display-balloon-tooltips-in-crystal-reports-or-ssrs
Second option is if you want at value position you may use variable and cusomize description message write and place it on report.
pradeepnt
Member
266 Points
154 Posts
Re: parameter description field
Aug 17, 2012 08:43 AM|LINK
hi.......
I have some parameters on which i am fetching the value but i want to show the description field on report as for which parameter the value is being shown.
e.g. I am passing Task_id as parameter in report but on report i want to show Task_desc.
Pradeep Narayan
Ajay2707
Contributor
4487 Points
870 Posts
Re: parameter description field
Aug 17, 2012 12:23 PM|LINK
Hi Pradeepnt,
As your requirement where are you stuck.
Are you fetching task_desc column or value from db via sp or else?if yes then it is very simple . drag and drop on req. place.
still you have problem, then plase explain clearly, show we will give proper suggestion.
pradeepnt
Member
266 Points
154 Posts
Re: parameter description field
Aug 18, 2012 06:31 AM|LINK
Thanks for ur response...
Yeah m fetching Task_desc but its on some condition and its 10 table join.
Task_desc is getting displayed when there is data against that particular task in diffrent tables but in case of no data its also not displaying anything.
My purpose is that :-
When user sees a report then he can also see what parameter he passed to report. Its very easy to display parameter but parameter value is useless until there is no description.
Pradeep Narayan
Ajay2707
Contributor
4487 Points
870 Posts
Re: parameter description field
Aug 21, 2012 05:22 AM|LINK
Hi Pradeep,
For this you can use variable feature.
Right click on variable option comes in toolbax and give name to that , after that the window open. Write code as below (as per your requirement)
StrigVar Task_Desc := ""; if {YourTableName.Task_Code} = "1" then Task_Desc := "abc" ; //for single condition check with custom description.if {YourTableName.Task_Code} = "1" and YourTableName.DateColumn > "2008/11/30" then Task_Desc := {YourTableName.Task_Code} ; // if you want you desciprton will showafter save it paste where you need.