despec

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

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

Hello, Does the $X{} syntax only support the "IN" clause. I have a situation where I would like to use the "LIKE" clause of a SQL query. Anyway possible writing this in a ireport query? Thanks, David