Click here to Skip to main content
13,003,102 members (58,949 online)
Rate this:
Please Sign up or sign in to vote.
Hi all,

I want to create crystal report using below formula-

"Lightbox_Org_Course_User_Details.aspx?reqIndDivID=" + ToNumber ({dt_Org_Ind.ind_div_id}) + "&reqLevel=" + {?reqLevel} + "&reqDivision=" + {?reqDivision} + "&reqCourseName=" + {dt_Org_Ind.Course_Name} + "&reqType=Induction"

But it is showing error-

A string is required here. Error in File C:\DOCUME~1\OH3\LOCALS~1\Temp\CR_Org_Ind_Course {71F0A1D4-06B3-4353-AB6C-D59A371EFA6C}.rpt: Error in formula . '"Lightbox_Org_Course_User_Details.aspx?reqIndDivID=" + ToNumber ({dt_Org_Ind.ind_div_id}) + "&reqLevel=" + {?reqLevel} + "&reqDivision=" + {?reqDivision} + "&reqCourseName=" + {dt_Org_Ind.Course_Name} + "&reqType=Induction"'

Please help me to find out what is wrong
Posted 21-May-13 20:14pm
Updated 22-May-13 0:47am

1 solution

Rate this: bad
Please Sign up or sign in to vote.

Solution 1

error due to...
ToNumber ({dt_Org_Ind.ind_div_id}) 

it should be...
ToText ({dt_Org_Ind.ind_div_id}) 

Happy Coding!

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

  Print Answers RSS
Top Experts
Last 24hrsThis month

Advertise | Privacy | Mobile
Web01 | 2.8.170626.1 | Last Updated 22 May 2013
Copyright © CodeProject, 1999-2017
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100