jboomhower

I see that can make a Stacked Column Single Line report and a Single Column Multi Line report but I need to be able to combine the two and every time I add an extra measure to either it just adds it to the item that is considered multi for the report (stacks in the former or lines in the latter). I don't see any properties in the jrxml that I can alter to assign a measure to the line instead of the stack. Does anyone have any idea how this can be done?

jlongoria, I have a few questions regarding your solution. You mention right clicking and making input controls on a report but what I am concerned with is the filters on the dashboard. I know how to tie the filters there to filters on the individual reports/dashlets so that a selection in the dashboard will filter all the reports in the dashboard. I also have just done a hyperlink in Studio to a parameter/input control on a second report. I don't see how adding a parameter in a report will help drive the available values in all other dashboard filters. For example, a dashboard has a Master Customer and End Customer filter which ties to the same filters in the six dashlets/reports in the dashboard. What I want is that when the user selects a Master Customer from the Dashboard filter, the available values in the End Customer filter on the dashboard are reduced so you can create an impossible combination which would set all reports to blank. Is that possible?

I have since read through a demo on doing the same thing with a pie chart in an earlier version and though my JRXML looks the same as the demo, nothing is happening when I client the columns in the chart in server. <hc:series name="SiteCount"> <hc:contributor name="SeriesItemHyperlink"> <hc:contributorProperty name="hyperlinkTarget" valueType="Constant" value="Blank"/> <hc:contributorProperty name="hyperlinkType" valueType="Constant" value="ReportExecution"/> <hc:contributorProperty name="_report" valueType="Constant" value="/public/Reports/Applications/OMS/Predefined_Components/OrdersPlacedDetails"/> <hc:contributorProperty name="milestone_date" valueType="Bucket" value="MilestoneDate.month_link"/> </hc:contributor> </hc:series>

I was finally able to create a ReportExecution hyperlink in my HTML5 Chart in the 6.1 version of Studio but the link is made on a click of the background of the chart. I want it to link from the click of a column in the column chart and pass parameters from the selection. I see plenty of places on how to do this in earlier versions, where the hyperlink button is under the Advanced Properties of the Measure in the Chart Properties but in 6.1 there isn't such a button, only a Hyperlink Tab for the Entire Chart Properties window. Does anyone know how to associate a hyperlink to a measure/column instance from an HTML5 chart in this version? Thanks in advance. Example of current properties screen:

I have seen a ton of strategies and ideas for getting cascading filters/input controls applied to a report using JRXML code and Studio but I don't see any indication of how to do the same on a dashboard. Currently, we have a few dashboards, each with multiple reports that are tied to a list of input controls/filters. What I am looking for is a way to reduce the selection of values in other input controls on the dashboard when one or more of them has been used to select distinct values. I don't see any way to indicate cascade in the new filter manager dialog and Studio can't open a dashboard. Suggestions? Is this possible?