prompt for chart

[Former Member]

Hi,

Can we create a prompt for a chart or single block of data? I have a report with table and chart. I want to change the chart data by prompting. Is it possible? If so please help me on this.

Thanks.

[Former Member]

Hi Swathi,

If you are working with Web Intelligence XI 3.1 SP2 or above, you may be interested by Input controls for this requirement.

This feature enables to define a widget control (e.g. drop down list, free text entry, check boxes, etc.) where a report filter is embedded, so report consumers have a nice and user-friendly way to interact with report content. Furthermore, input control design and edition allows very detailed scope definition onto your report, with that feature you could typically define a new control to filter only the chart (and leave table unchanged).

For instance, you can define a chart displaying revenue for a list of countries, and use an radio-button input control to only display revenue for any single country on the chart... from the description of your requirement, this should fit your expectations.

Moreover, since input controls are only related to simple report filters, you will not have any performance concern with input controls (while Web Intelligence prompts are always connected to document refresh, which can take some time, depending on query & database setting).

PS. if input controls are a good fit for your expectations, you might also be interested to know that you can also set WebI report elements (tables & charts) to use them as input controls for other customized areas in the same report.

Hope that helps,

David.

[Former Member]

Both Table and Chart based on same DataProvider/Query?? And contains same objects??

YES, then You have to create one more query for Chart based report and Prompt on top of it.

If you create Variables also, it won't work because again you are defining them based on your datasource objects only.

Thank You!!

[former_member142702]

You can use variables and you do not need a new query. You can add a self canceling filter condition with a single prompt text in the existing query and then use the UserResponse function in your variable to select the data you want to display in your chart.

eg. you can add following filters in your query

Object A equal Prompt('Please enter value')
OR
Object A not equal Prompt('Please enter value')

for the variable you can use the following formula:

= If (UserResponse('Please enter value')='B' then [ObjectB] else [ObjectC]

Harald is right though. You can change the data displayed through the usage of local variables and prompts but NOT the type of the chart. If this is your use case then you may want to consider using Crystal Reports.

Regards,

Stratos

[Former Member]

You cannot change a block type based on a prompt. However, you can change which chart appears based on prompts, I have done this on many occasions. For example, I have a blog post on Chart Alerters that shows you how to create two different charts, one red and one green, and display only the one appropriate for the chart trend. I have also shown the same technique used to switch from a pie chart to a column chart based on the number of values selected.

In a nutshell: create two charts, one of each type you want to see, and then adjust the logic so that only one chart is visible at a time.

http://www.dagira.com/2007/07/31/alerters-on-charts-part-ii/

[Former Member]

As we see the original post, the Report contains both Table and Chart, it has Prompt also but Prompt should applicable on Chart only.

Thank You!!

[Former Member]

Hi All,

Thanks for your response.

There are table and chart in my report. prompt should not effect the table data, only chart should have changes. By adding a new report it was done. But is there any way to make it possible in the same report?

I have tried with a variable formula. But it was effecting the whole report. Could you please let me know that how to create a formula which should only effect the chart?

Thanks for all again.

Swati.

[Former Member]

As I told you in my earlier post and which you did is correct. (creating one more query/report for Chart).

I tried it and posted, same time tried with Variables also but it's applying on whole report (as you told).

So suggested other query/report for Chart.

Let's wait if any workaround anyone find or ourself...,,

Thank You!!

[former_member142702]

Did you add a filter condition in your query exactly as described? You cannot just take any prompt.

It is not a straightforward solution but it works.

You can even apply a local webi filter based on the defined variable just on your chart.

Regards,

Stratos

[former_member189544]

Hi,

using Crystal Reports this is possible, but I think you are talking about WebIntelligence, aren't you. There I think it is not possible to show/hide certain blocks/elements or changing the type from chart to table using prompts...

Regards,

Harald

[former_member142702]

You can add a variable that queries the prompt and display the variable in your chart instead of the fields that are retrieved directly from the database.

Regards,

Stratos