Geeting error while using calculated fields in columns of jasper adhoc reports

0

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 ?

raja.shekar's picture
Joined: Apr 21 2014 - 12:28am
Last seen: 4 years 8 months ago

Yes, that is absolutely possible. Not sure about why it is not wrong, could you please provide some more details.

nthapa - 4 years 9 months ago

@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.

 

 

 

raja.shekar - 4 years 9 months ago

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).

djohnson53 - 4 years 9 months ago
show 1 more...

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...

raja.shekar - 4 years 9 months ago

0 Answers:

No answers yet
Feedback