How to get a clickable bar Chart? 1

[jack91]

hi,

I have a 15 different kinds of software which i have shown on a bar chart where i show the count.

Then in the details section I have a separate page for each software with its own details.

How can i do the following:

Make the bar chart click able, for example if one of the bar in the chart is MS windows XP OS which say we have 20 of those in the company.
Then when the user clicks on that bar he **should be taken to the details section page for that particular software where user can see other relevant details such as what kind of computer the software is on etc.

(recall: I mentioned that each software has its own page in the details section)

How do i do this?

I have read that i need to do this by grouping -- I am trying this already.
Please advise

Thanks
Jk

 

[jack91]

I am using crystal version 10

thanks
Jk

 

[lbass]

This only works if you use the group chart layout, not the advanced.

-LB

 

[jack91]

I will try this, but the group chart layout is not even highlighted. I suspect i don't have enough criteria to even use the group chart layout.

May i ask what criteria / how many groups are required to be able to use the group chart layout?

Thanks
Jk

 

[lbass]

You have to have at least one group and you have to have inserted a summary on the field you want to summary, i.e., right click on the field in the detail section and insert a summary on it at the group level. Then the group chart will be activated.

-LB

 

[jack91]

I was able to do this. But when i click on the chart section it takes me to the details section.

Is there any way to have a pie chart # 1 clickable and then it takes you to chart #2 which is also clickable and then takes you to the details section?

Thanks
Jk

 

[lbass]

If you hide group #2, the group #2 chart will appear when you click on a group #1 pie slice. You would also hide the detail section to then click from group #2 pie slice to details.

-LB

 

[jack91]

When I click on one of the bars in the bar chart it takes me to the details. -- this is good!

BUT,
I am missing the page header which have the titles of the columns (containing the details).

Please advise,
Thanks
Jk

 

[lbass]

In file->report options, check "show all group headers upon drilldown" (or something like that).

-LB

 

[jack91]

Its working , its showing both RH as well as PH.

I can go with this unless you know of a way to see JUST the PH.

Thanks
Jk

 

[lbass]

You can format the report header to suppress conditionally using this formula:

drilldowngrouplevel > 0

-LB

 

[jack91]

THANKS !! it worked perfectly!

Regards,
Jk

 

[jack91]

LB,

I did not quite understand this part

"-- If you hide group #2, the group #2 chart will appear when you click on a group #1 pie slice. You would also hide the detail section to then click from group #2 pie slice to details."

What I am trying to achieve is

http://www.tek-tips.com/viewthread.cfm?qid=1560912&page=1

You can answer in any thread you wish.

THANKS THANKS THANKS
Jk

 

[lbass]

This is how drilldown works. This assumes you placed a chart in your group #2 section, so that when you drill down on your group #1 chart, the second chart would appear. The group #2 section must be formatted to "hide".

-LB

 

[jack91]

When the second chart appeared, I want that to be clickable so finally it should show me the details section.

Secondly,

When i click on computers under warranty, the drill down shows me the bar chart for * ALL the 3 categories under warranty/no warranty / out of warranty when I want to see only "under warranty".

Is there a way to specifically hide the other 2 categories?

Thanks
Jk

 

[jack91]

I have 3 -4 groups.

Their order is:

1)Critical
2)Warranty expired (formula)
3)Future warranty expiration info formula)
4)Old warranty expiration info (formula)

I made a summary for Future warranty expiration and so activated the *group chart expert.

What I want here is to:
Place chart: for each critical flag
on change of: future warranty expiration info
show: count of future warranty expiration info

I am unable to see this BUT what i do see in the options are

on change of: expired warranty and future warranty expiration info -- why is there a combo here?

does this have to do with the order of the groups?

Please advise
Thanks
Jk

 

[lbass]

You could suppress the unwanted charts using a section suppression formula that identifies the unwanted group instances and uses the drilldowngrouplevel function.

-LB

 

[jack91]

LB,
I am using your advise (your last comment).

Also,
If i have 4 groups:
1)Critical
2)Warranty expired (formula)
3)Future warranty expiration info formula)
4)Old warranty expiration info (formula)

AND
I created a summary for groups 2-4 so I can activate the "group layout" in the Chart Expert".
But why don't i see all the options in the drop down list in "On change of " in the Chart Expert.

ex. I want to create a group chart for "Future warranty expiration info":

Place chart: For each @criticality flag
On change of: @Future warranty expiration info
Show count of: count @Future warranty expiration info

but i dont see the option in "On change of". However when i move this group up to the #3 position from #4 position i am able to do this.

But this does not help as i need all 4 groups.

Please advise
Thanks
Jk

 

[lbass]

I don't know if I'm exactly following this, but groups are nested, so if criticality is your first group, your group #3 is nested within the instances of group #2, so the on change of value would occur twice, once within each instance of group #3, and I'm guessing that isn't allowed for charting.

-LB

 

[jack91]

Lb,

Your assessment is right. I guess I have to go with sub-reports then.

I am following your advise on the sub-report idea

"----You could suppress the unwanted charts using a section suppression formula that identifies the unwanted group instances and uses the drilldowngrouplevel function."

So I have the report now as:

group 1 --> criticality of the hardware
group 2--> @warranty expired formula using formula

(
if isnull({hardware.warranty_end})
then
"Hardware With NO Warranty INFO"
else if {hardware.warranty_end} <= CurrentDate then
"Hardware Out Of Warranty"
else
"Hardware Under Warranty"
)



RHa --> cross-tab
RHb --> Chart using:
once per report
Group: on change of @criticality and @Warranty Expired
Show: count of @warranty expired

This gives me 2 pie charts one for critical hardware and the other for non-critical hardware

Each of these pie charts has 3 sections:
1)Hardware Under Warranty
2)Hardware Out Of Warranty
3)Hardware With NO Warranty INFO

These individual pies are clickable. The purpose/idea being that when a user clicks on say:
1)Hardware under warranty --> user is taken to an other pie chart(breakdown of future warranty chart, those expiring in 30, 60 or 90 days)and showing all "Hardware under warranty") --> aka -subreport 1

2)user clicks on pie chart "Hardware *Out Of Warranty" --> user is taken to an other pie chart(breakdown of *OLD warranty chart, those expired in 30, 60 or 90 days showing all Hardware Out Of Warranty) --> aka -subreport 2

3)user clicks on pie chart "Hardware With NO Warranty INFO" --> user is taken to an other pie chart showing all Hardware With NO Warranty INFO) --> aka -subreport 2

The issue I am having is:

When i click on pie chart in main report it takes me to the *entire sub-report, now when i click on the this chart again it takes me to the same whole sub-report ** again.

Now when i click on say a particular bar it takes me to the relavent details.

Please advise on how to get rid of the redundant middle repetitious layer i just mentioned.

Thanks
jk