Passing Extra Parameters From Graphs
When working with graphs, drilldowns can be created that pass information to another report. For example, in a bar chart, the series and category information can be passed. However, at times it is necessary to pass more information to the drilldown report.
This tutorial shows how to create a report that prompts for a customer. A pie chart is drawn for the customer showing their sales by month. Then when the user selects a slice of pie, the selected month AND the selected customer are passed into the drilldown report.
Using SQL Blocks
In HTML reports, SQL Blocks can be used to easily query a database and display the results anywhere on a report. In this example, the reports prompts for a customer id. It then uses that customer id to lookup the customer name and display it in the Report Header.
-
Recent
- Blog has moved
- Passing Extra Parameters From Graphs
- Using SQL Blocks
- Tutorial – Using Subreports
- Tutorial – Form Builder (Add, Update, Delete)
- Tutorial – Adding Row Numbers to Reports
- Develop for the iPhone/iPod Touch
- Tutorial – Creating A Calendar Layout
- Tutorial – Working With Novell Audit in Report Builder
- Tutorial – Bar Chart in Report Builder
- Tutorial – Report Builder Prompts/Drill Down
- Tutorial – Prompts in Report Builder
-
Links
-
Archives
- July 2010 (1)
- March 2009 (2)
- February 2009 (10)
-
Categories
-
RSS
Entries RSS
Comments RSS
