BusinessObjects Board

Radio Button Orientation Issue

other Xcelsius - Crystal Dashboard Design
#1

Hi,

I have data set of near about 2500 records, I am trying to bind the radio button labels to excel cells (A4:A2500) & used filtered row option. I can see labels properly when orientation kept as vertical but when switching to horizontal orientation then display going beyond canvas & won’t able to see all labels, I tried to reduce the length but still getting the same issue.

Please help me out !!

Thanks in Advance…

patneel :india: (BOB member since 2006-11-02)

#2

Hi Bober ,

For such huge number of selction list I would suggest use Combo box or list box.

Regards
Sapan

swapnil_taz :india: (BOB member since 2006-04-06)

#3

My distinct labels are 4 regions for my radio button but i have to show charts by region so using the filter row option in radio button and binding radio button lables to A4:A2500.
I need to use radio button only, pls let me know how to acheive the same.

patneel :india: (BOB member since 2006-11-02)

#4

Hi Patneel,

Did you managed to sort this out as I am having the same problem
This might be a bug?

Anyone else managed to over come this issue?

Thanks

Rameshkumark (BOB member since 2002-08-29)

#5

I’ve seen this behaviour before with radio buttons. I found that it only works if you set the properties in a particular order.

If I used the normal order of, setting the labels, then changing the insertion type, then changing the orientation to horizontal id get the behaviour your experiencing.

But if I changed the insertion type first, then the orientation, then finally selected the labels if works perfectly.

See if this works, however my dataset was a lot smaller than 2,500 rows and to be honest if it was that size id look for a different solution.

Michael McBennett :uk: (BOB member since 2002-08-19)

#6

Hi Michael,

Thanks for your suggestion, it works on Dashboards 4, sp6.

I have another issue with Column Chart data not displayed properly, it have 2 series and my data is not spanned fully in the plot area and goes all the way to left side of the plot area.

Earlier I used inserted data from radio button and it completely used the plot area but when I added another (IF condition on the inserted data to plot the chart from excel), the chart is not using entire plot area and goes to left side of it.

I even used IF(ISBLANK(),“ALL”,"") condition in the x-axis labels…but not able to achieve it properly.

Please suggest.

Thanks

Mond (BOB member since 2006-07-31)

#7

It’s difficult to tell what’s going on from what you have stated above. Could you attach an example file so we can help more?

Thanks,

Roxanne P

Sr BI Consultant
InfoSol, Inc.

RoxanneP :us: (BOB member since 2006-08-07)