despec
-
Posts
114 -
Joined
-
Last visited
Content Type
Forum
Downloads
Featured Visualizations
Knowledge Base
Documentation (PDF Downloads)
Blog
Documentation (Test Area)
Documentation
Dr. Jaspersoft Webinar Series
Security Advisories
Events
Profiles
Posts posted by despec
-
-
I was able to make an Mondrian OLAP connection in Ireport using the appropriate datasource and a "local" schema file. I'm able to write an MDX query and create the fields, but when I run the report, I'm getting no data.
Troubleshooting suggestions?
Thanks,
David
-
Hello to all,
I've searched the forum for this, but haven't been able to find an answer.
I'm attempting to make an OLAP connection through Ireport without success. My questions:
-- The JDBC connection should be a connection to my database or to the Jasper repository?
-- Initially, I put in the JDBC connection to my database, then tried to enter the repository path to the OLAP schema
I created in Jasper. No success there. What should I be entering here. I tried a local schema file and that worked out,
but an MDX query netted no data.If someone could let me know what I need to do to make this OLAP connection work, I would be extremely grateful!
Spinning my wheels in Ohio,
David
-
Bump (sorry, again)
-
Bump (sorry)...
-
...to set a default value in a dashboard input control...I have a default set for every report I have on this dashboard, but I cannot figure out a way to have the dashboard default to the same certain value as well. I would greatly appreciate any information about how I can get this to work.
David in Ohio
-
Hello to all,
I've done an extensive search here and via Google for more information about how I can setup date validation when running a report through a dashboard input control without much success. When I simply run the report unit, no problem, but when I add the report to a dashboard and use the dashboard input controls, I can enter anything into the date field and it accepts it without question.
What do I need to do to get this to work on a JS dashboard?
Any help would be greatly appreciated.
David in Ohio
-
Hello to all,
Is it possible somewhere within the report/job schedular to somehow delay the "kick-off" of a report until particular set of data (used for the report) has been completely updated? What's happening here is the reports are running before the data is updated, so we're not getting a current look when the report is generated.
Any advice would be appreciated.
David
-
Probably best to use the SQL "order by" clause within your SQL statement.
David
-
Creating a Hyperlink to Another Report
--------------------------------------
-- In a text field properties page, go to the "Hyperlink" tab.
-- Set the "Hyperlink Target" to "Blank" if you wish to open a new browser window for the report.
-- Set the "Hyperlink Type" to "ReportExecution".
-- Go to the "Link parameters" tab.
-- You must enter a parameter called "_report", which the Jasper server interprets as the URI to the report unit
location. In the value expression field, add this pathname in quotes. The path must point to a "report
unit" and not a jrxml file.
-- To pass parameters from the "calling" report to the subreport, create the same parameters in the "Input
Controls" folder for the report unit and also within the subreport itself. It's mandatory that you create
the parameters within the "Input Controls" folder or the parameters will be null.
-- When setting up link parameters, you may use any legal value expression as allowed by Ireport, like setting
to another parameter, field or simple string.
-
I'm attempting to use a main report as a link to 5 other reports by including them as subreports. I include a parameter for the user to select which report to run. I'm using Ireport 3.0. If I set the "print expression" to not print depending on the users choice, is the subreport going to run regardless and just not print, or does the "print expression" cause the subreport not to run?
Thanks for anyone's help in advance,
David
-
From what I'm slowly understanding, you have to use a special parameter construct using the $X variable, so your IN statement would look like so:
where $X{IN,<Fieldname>,<Parameter Name>}
Hope this helps.
David
-
Olap Connection Made--No Data
in Products
Posted
I'm using Ireport 3.0.0, so don't have that option available under "View"...
Yes, the query does return data, as I used Jasper's Schema Work Bench to test it.
Does it have anything to do using a "local" schema file, rather than one from the JasperServer?
David