[issues pulling in data from xls/csv datasource - error re escaping $]

I connected successfully to a csv and then a xls datasource and also successfully can see my fields.  I added on field (a username, an ID, any of them this occurs).  No variables, no parameters, just the field to verify I can see the data and everytime I get the following error.

I looked at the XML and do not even have a line 145.  I only have 70 or so lines, like I said, I only added one field so not much code.  The only $ signs are for the field I added ($F{Username} for example) so I cannot for the life of me figure out what to do.  

calculator_report3_1430330503346_585573: 145: illegal string body character after dollar sign;
   solution: either escape a literal dollar sign "$5" or bracket the value expression "${5}" @ line 145, column 46.
1 error

 

THanks for any help.

Jo

[How do I escape double quotes to use the following if/else statement]

I am trying to use the following if/else statement but I think the double quotes in the JSON are causing issues and I'm not sure the proper syntax to get this work correctly. I'm a jasper/groovy newb.

 

$F{PAYMENT_METHOD_DATA}  == '{"deposit_name":"PayNearMe","is_important":true,"logo":"https://nj-cdn-casino.ballyinteractive.com/cms/V3/Deposit-Methods/icon-Paynearme.png"}' ? "PayNearMe" :

$F{PAYMENT_METHOD_DATA} ==  '{"deposit_name":"ACH (Optimal)","withdrawal_name":"ACH (Optimal)","display_order":"101","is_important":true}' ? "ACH" :

$F{PAYMENT_METHOD_DATA} ==  '{"deposit_name":"wire transfer","withdrawal_name":"wire transfer","display_order":"42","is_important":true}' ? "Wire Transfer" :

$F{PAYMENT_METHOD_DATA} ==  '{"deposit_name":"Personal check","withdrawal_name":"Personal check","display_order":"6","is_important":true}' ? "Personal Check" :

$F{PAYMENT_METHOD_DATA} ==  '{"deposit_name":"Cashier''s check","withdrawal_name":"Cashier''s check","display_order":"7","is_important":true}' ? "Cashiers Check"

: "Cash"

 

Thanks,

Jo

[subtotals are the same in each group footer]

Hi there. I'm a jasper newbie.  I followed the following video (

) to create subtotals are thought it worked great and then noticed that in each of my groups the subtotals were the same.  My variables are all setup right from what I can see as I followed the above guys video exactly and it is totalling but only one group is correct, it is using that group for all of them. 

 

Thanks for the help.

JB