Click here to Skip to main content
Rate this: bad
good
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 21:14pm
Edited 22-May-13 1:47am
v5

1 solution

Rate this: bad
good
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!
Smile | :)
  Permalink  

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

  Print Answers RSS
0 OriginalGriff 6,569
1 Sergey Alexandrovich Kryukov 6,168
2 DamithSL 5,228
3 Manas Bhardwaj 4,717
4 Maciej Los 4,150


Advertise | Privacy | Mobile
Web04 | 2.8.1411022.1 | Last Updated 22 May 2013
Copyright © CodeProject, 1999-2014
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