d.b
-
Posts
8 -
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
Everything posted by d.b
-
How do I change the line width on a timeseries chart? The colors that the chart chooses can be difficult to see while being so thin.
-
Used multi axis charts
-
I have data that looks like this: datestorepurchasesreturns2014-12-29Store A60008002015-01-05Store A2600040002014-12-29Store B13006002015-01-05Store B49002000 How do I create a timeseries chart which would create 4 lines? The X axis would be date, Y axis count, Line 1 = Store A Purchases, Line 2 = Store B Purchases, Line 3 = Store A Returns, Line 4 = Store B Returns. Right now, all I am able to successfully get is 2 lines with Store A Purchases and Store B Purchases. Thanks
-
I was searching for an answer to do it all in Jaspersoft Studio, but I don't know if its possible. This is what I did: Sent report with parameter to jasperreports serverAdded a Query resource that got the distinct list of states from this tableEdited the report's input control to read from the Query created, setting as type Mulit-Select QueryWould there have been a way to do this all in studio? It would be REALLY great to know, because it seems like everytime I update the report in studio and push it to the server, I have to reconfigure the input control. Very annoying!
-
Building a report in jaspersoft studio 6.0.1 and pushing to jasperreports server 5.5.0. The portion of query I am trying to get to work is "select state_name, count(1) from sales.by_state where ($P{chosen_states}='ALL' or state_name in ( $P{chosen_states} group by state_name))" I would like to have an input parameter with a list of existing state_names that exist on the by_state table. Also, I would like to add to the checkbox list an "ALL" option which should return everything. Is this possible? ----edit----- I've changed my where clause to where $X{IN,state_name,chosen_states} and se the chosen_states parameter to java.util.List, which seems to help me get a little bit of the way there. Is there a way to dynamically populate the chosen_states with all that show in the query if running everything?
-
Answered my own question: start date was given default value: new java.sql.Date(System.currentTimeMillis()-(((long)1000)*60*60*24*30)) end date was given default value: new java.sql.Date(System.currentTimeMillis())
-
Note that I'm trying to get java.sql.Date
-
I have a report that takes a start date and an end date as required parameters. The report was created in JasperSoft Studio 6.0.1 and pushed to JasperReports server 5.5.0 How do I prepopulate start date with the first of the month and the end date as Todays date? I would want the dates to be in the field, but allow the user to change them before running if they want. I do not want the report to run with the default parameters on its own.
