haskins.aaron
-
Posts
6 -
Joined
-
Last visited
Content Type
Profiles
Forum
Events
Featured Visualizations
Knowledge Base
Documentation (PDF Downloads)
Blog
Documentation (Test Area)
Documentation
Dr. Jaspersoft Webinar Series
Security Advisories
Downloads
Posts posted by haskins.aaron
-
-
Ignore me. Using the wrong brackets, ARGH.
-
Hi, I am trying to use a parameter for a report but I am seeing this error return:
FUNCTION mpay.$P does not exist
mpay is the name of the database. We are using MariaDB if that helps.
The dataset is a really basic SQL query (trying to remove all complication):
select * from transactionmemo where da_holder = $P(da_holder)[/code]
I have created a parameter called da_holder. If I removed the parameter and hardcode this it works, but it doesn't seem to like the parameter use. I cannot understand where this error comes from, please help! I am using TIBCO Jaspersoft Studio.
-
Hi,
I am trying to write a report where sometimes the column values will be empty. However I still want the csv file to maintain the column even if there is no value.
Example
ID, FirstName, MiddleName, LastName
1,Tom,John,Smith
2,Fred,,Jones
In the second row, note there is nothing in the MiddleName.
Is this possible?
Thanks,
Aaron
-
Thanks Hozawa,
Is there a way that I can just use this timestamp as the name of the report?
Aaron
-
Hi,
New to using ireport (5.6.0) and so far I have just been using it to run basic csv reports with a static name.
Is it possible to set the report name to be dynamic? I'd like to name it YYYY-MM-DD_my_report e.g today's report would be named 2015-07-24_my_report
Thanks,
Aaron
Dataset and Query Dialog "No Metadata"
in Products
Posted
Hi,
I've recently changed OS (using Kubuntu 16.04) and I've not been able to get Jaspersoft Studio to work. I've tried 6.3.0 and now 6.2.2. So, I setup access to our Jaspersoft server but when I double-click on the jrxml file it gets stuck on 'Setting contents for '/MyReports/..' 'Refreshing /MyReports'. If I "Run in Background" then try and view the Dataset and Query Dialog, there is nothing there (the SQL disappears).
Any ideas? There is nothing in the error log following my intial "unauthorised" (typing wrong password).
Aaron