I have created the calculated field with concatenated by two strings using jasper domian designer. when i try to use the calculated field in adho view column i am getting the following error "An erorr occured while performing the previous request". Is it possible to add calculated fields as a column in jasper adhoc view reports ?
0 Answers:
No answers yet
Yes, that is absolutely possible. Not sure about why it is not wrong, could you please provide some more details.
@nthapa thks for the reply.
I have the below two fields
1. officer_custody_to_evidence.LNAME
2. officer_custody_to_evidence.FNAME
So i have concatenated two fields using domain designer calculated fields as given below.
calculated field name is "name"
CONCAT(CONCAT(officer_custody_to_evidence.LNAME,' '),officer_custody_to_evidence.FNAME)
When i tried to use "name" calculated field in groups of jasper adhoc view it's working. however when i tried to use in column of jasper view reports the following error i am getting " An erorr occured while performing the previous request". please help me on this.
nthapa,
Is this Spring Security trying to protect against SQL injection?
I usually set the concatenations in the Ad Hoc report itself rather than in the Domain. Also, Concat() can carry any number of Arguments, so there wouldn't a need to embed one in the other. So, instead of CONCAT(CONCAT(a,' '),a), it becomes CONCAT(a,' ',b).
Hi djohnson,
I should need to use concatenation in domain designer rather than using in Adhoc report . Also tried using the above funciton
for concatenation that is CONCAT(a,b) in domain designer. when i dragged to derived table field in Adhoc view Groups the field is getting value.
However when i tried to drag that derived field in columns of adhoc view i am getting the following error "An erorr occured while performing the previous request ". Please help me on this...