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
Downloads
Everything posted by haskins.aaron
-
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
-
Parameter use, error: FUNCTION mpay.$P does not exist
haskins.aaron replied to haskins.aaron's topic in Products
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.
-
How to maintain columns in CSV file when the value is empty
haskins.aaron posted a topic in Products
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 -
How can I set a report name to the date when the report is run?
haskins.aaron replied to haskins.aaron's topic in Products
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
