I have a parent report referencing GO Sales (query)
Bar Chart: Product Line and Revenue
Results: Camping Equipment/ Golf Accessories/ ... with revenue data on a chart.
Product Line Code is such - 991 equates to Camping Equipment. I am not using the Code/ Number on the chart. Only the description is displayed on the chart
I have a Target Report (GO Sales (query)).
List Report: product Line, Prod Type, Product, Revenue and Quantity.
Optional Parameter: product line code
Issue: I am trying to pass the product line code/ number value to the target report. When a user clicks on Camping Equipment, it should pass the "991" product line code/ number to the target report. The target report will then display the details for the description.
Is there a way, to pass the "code/ number" based on clicking the description.
Drill THrough definition is set up as:
Parameter added to Product Line Code in target report. Use Value: Product Line Code, Display Value: product Line
Parent Report: for parameter, p_productcode, Pass Data Item Value, Product Line Code
The same drill through when created with parent report now a LIST report, works. I am able to pass the product line code/ number to the target report.
This was achieved by adding the Product line code as a property of the list.
But, how can this be achieved via Chart? I was unable to view the properties for the Bar Graph in 11.0.7.
I have experienced the same problem. There appears to be no direct way of passing a data value that is not explicitly set in the chart object, or crosstab.
Have you tried putting the chart inside a singleton and setting the properties to include the data item you want to pass the value of?
Thanks for the suggestion. I will try it and let you know.
I've not seen a "Properties" property for Visualizations or Legacy Visualizations, but Charts and Crosstabs have this property available on the nodes rather than at the highest object level (Chart or Crosstab) properties. For a list you'd find it at the highest List level properties.
For example, create a chart (select Chart from the funnel icon in the upper right of the visualization gallery dialog) and drop something in categories click on that text item and then use the ancestor button to navigate up to the Chart Node Member. There you will see the "Properties" property. It works similarly for series or other chart elements but not for measures.
For crosstabs, click on a row or a column and find the Properties property there. You won't find it at that highest Crosstab level properties.
Lynn - thanks for your reply. I had to read your reply twice to understand what is needed.
I was able to create a chart in Report, from the available "Charts" gallery under Visualization. The charts retain the old Cognos 8/10 versions of charts that were available in Report Studio.
The properties menu also look similar to the earlier versions. It does display the Data menu and hence the properties.
Just to add, IBM should have extended the properties menu to the newer versions as well, at least speaking of Reporting tool. I have attached a screenshot for others who may ever need this.
Blue - I forgot to reply to your suggestion. I did try putting the chart into a singleton, and added the Product Line Code as a Property of the singleton. However, when I built the drill-through, it would pass only one value to the target report, irrespective of any product lines I clicked on the chart.