Chart whitout value

[philelmousse]

Hello, I have a big problem with a report.

In this report I have a chart with data from my framework manager model. But in this chart I cant see any data and if I create a simple list to see my data they appears correctly in the list. So I'm a bit lost...

[jive]

Hi Phile,

Just to be sure did you check if the sql source for your chart is the same as the one used in the list. If it's the same you will be able to see data in the chart. there other solution it's to have master-detail relation between the chart and the query used in the list.

Regards Jacques,

[philelmousse]

my source is a query subject wich returns that kind of data

name toto toto

Category general general

Month 1 1

Amount 1000 2500

So I took the column Month for the "x-axis", the column Category for the legends and the column Amount for the measures. But nothing in my graph...

[philelmousse]

and if I create a list with that columns my chart appears with the values. So it should be a problem in my framework manager model ?

[philelmousse]

no one have an idea ? :/

[PRIT AMRIT]

easy fix would be, create a LIST with that column and just hide the LIST;)

[philelmousse]

yes why not but thats not really optimized  ;D

[PRIT AMRIT]

I don't think if you use the same QUERY for the list report, then it would make a big difference in terms of performance.

[philelmousse]

so i tried to hide the list but we still see the big space of the hiden list. Is it possible to completly remove that space ?

[PRIT AMRIT]

how you have hided? In properties there r two options 'Visible' & 'Box Type'

Select the List, in properties Box Type= 'none'

Can you just select the LIST and 'Cut' it and see if it helps?

[philelmousse]

yes it works with box type ='none'. Thanks for you help :) I will ask if its an acceptable solution

[PRIT AMRIT]

So far working fine and no performance issues then it's all right. End user is interested in Result rather how you have done it   :D

[philelmousse]

the problem appears again even with the list :/ i'm gonna crazy arg

[philelmousse]

Hi, I finaly found the solution so if it could help...

I had a category with null amount so I just created a filter in the chart "amount is not null".