dglasberg

I am getting the following error on essentially a brand new install of Jaspersoft when loading the create Ad Hoc page. Any ideas?

The title says it all. We are passing in an attribute for an already created user and it is not updating the attribute with the value passed in. Is it possible to update/change this attribute value in Jaspersoft if we pass something different in the token?

Is it possible to pass the organization Id and the organization name in using token authentication?

Hi, I am trying to convert a varchar column in a MSSQL database to a BigDecimal field via a Domain calculated field. When i bring this calculated field into an Ad Hoc view I get the following error: 2017-03-15 10:33:49,773 ERROR AdhocAjaxController,http-apr-8080-exec-6:954 - ad hoc controller exception: An error occurred while performing the previous request.org.codehaus.groovy.runtime.typehandling.GroovyCastException: Cannot cast object '5500.0000' with class 'java.lang.String' to class 'java.math.BigDecimal'. 5500.00 is the correct amount returned by the database.The forumla I have in the calculated field is: str2money(CA_SE_Log.New_Data) I have a custom str2money function that converts the varchar to money via SQL: <entry key="str2money"> <value>"CASE WHEN ISNUMERIC(" + sqlArgs[0] + ") = 1 THEN CAST(CONVERT(money, " + sqlArgs[0] + ") AS DECIMAL(34,4)) ELSE (0.00) END"</value></entry> Thanks,Dennis

Hi, Is there any way to convert a varchar to a float in a Domain's calculated field. I am pulling data from a MSSQL database. Thanks, Dennis

Hi, Is it possible to create a domain utilizing joins but not enforce joins if fields from the joined table aren't requested in the report. Example, if i want to create a report showing only customer data, can the domain pull from the customers table, and not use any of the joins to other tables? If not, is the way around this using all Outer Joins? Thanks, Dennis