chart problem

Hello everybody,
I have problem to make a simple line report:
My Query's dataset:
select VALUE_IND, DATE_IND
from uc.TB_INDI as TI, uc.TB_DEF_IND as TDI
where TDI.LIB_DEF_IND = @.param1 and
TDI.NO_DEF_IND = TI.NO_DEF_IND and
TI.NO_PRJ = @.param2
The result of this query is (from my test base):
VALUE_IND Date_IND
5.0 2005-01-02 00:00:00.000
15.0 2005-02-02 00:00:00.000
10.0 2005-03-02 00:00:00.000
25.0 2005-04-02 00:00:00.000
9.0 2005-05-02 00:00:00.000
33.0 2005-06-02 00:00:00.000
25.0 2005-07-02 00:00:00.000
10.0 2005-08-02 00:00:00.000
28.0 2005-09-02 00:00:00.000
55.0 2005-10-02 00:00:00.000
5.0 2005-11-02 00:00:00.000
10.0 2005-12-02 00:00:00.000
I want to make a chart 'Simple Line' with date in X axis and value in Y
axis. So, in 'Drop data fields here', i put VALUE_IND (which contains
Fields!VALUE_IND.Value like value) and in 'Drop category fields here', i
put DATE_IND (which contains =Fields!DATE_IND.Value like expression)
But when i make a preview, i have only one date record: January in X
axis (x5)and all the value are grouped at the right of the chart!
I don't understand what's happening, i need help please.
Thanks in advance,
aVravrama wrote:
> Hello everybody,
> I have problem to make a simple line report:
> My Query's dataset:
> select VALUE_IND, DATE_IND
> from uc.TB_INDI as TI, uc.TB_DEF_IND as TDI
> where TDI.LIB_DEF_IND = @.param1 and
> TDI.NO_DEF_IND = TI.NO_DEF_IND and
> TI.NO_PRJ = @.param2
> The result of this query is (from my test base):
> VALUE_IND Date_IND
> 5.0 2005-01-02 00:00:00.000
> 15.0 2005-02-02 00:00:00.000
> 10.0 2005-03-02 00:00:00.000
> 25.0 2005-04-02 00:00:00.000
> 9.0 2005-05-02 00:00:00.000
> 33.0 2005-06-02 00:00:00.000
> 25.0 2005-07-02 00:00:00.000
> 10.0 2005-08-02 00:00:00.000
> 28.0 2005-09-02 00:00:00.000
> 55.0 2005-10-02 00:00:00.000
> 5.0 2005-11-02 00:00:00.000
> 10.0 2005-12-02 00:00:00.000
>
> I want to make a chart 'Simple Line' with date in X axis and value in Y
> axis. So, in 'Drop data fields here', i put VALUE_IND (which contains
> Fields!VALUE_IND.Value like value) and in 'Drop category fields here', i
> put DATE_IND (which contains =Fields!DATE_IND.Value like expression)
> But when i make a preview, i have only one date record: January in X
> axis (x5)and all the value are grouped at the right of the chart!
> I don't understand what's happening, i need help please.
> Thanks in advance,
> aVr
I try again with no success... In fact, i dont't understand the
philosophie of RS.
aVr|||avrama wrote:
> avrama wrote:
>> Hello everybody,
>> I have problem to make a simple line report:
>> My Query's dataset:
>> select VALUE_IND, DATE_IND
>> from uc.TB_INDI as TI, uc.TB_DEF_IND as TDI
>> where TDI.LIB_DEF_IND = @.param1 and
>> TDI.NO_DEF_IND = TI.NO_DEF_IND and
>> TI.NO_PRJ = @.param2
>> The result of this query is (from my test base):
>> VALUE_IND Date_IND
>> 5.0 2005-01-02 00:00:00.000 15.0 2005-02-02
>> 00:00:00.000 10.0 2005-03-02 00:00:00.000 25.0
>> 2005-04-02 00:00:00.000 9.0 2005-05-02 00:00:00.000
>> 33.0 2005-06-02 00:00:00.000 25.0 2005-07-02
>> 00:00:00.000 10.0 2005-08-02 00:00:00.000 28.0
>> 2005-09-02 00:00:00.000 55.0 2005-10-02 00:00:00.000
>> 5.0 2005-11-02 00:00:00.000 10.0 2005-12-02
>> 00:00:00.000
>> I want to make a chart 'Simple Line' with date in X axis and value in Y
>> axis. So, in 'Drop data fields here', i put VALUE_IND (which contains
>> Fields!VALUE_IND.Value like value) and in 'Drop category fields here', i
>> put DATE_IND (which contains =Fields!DATE_IND.Value like expression)
>> But when i make a preview, i have only one date record: January in X
>> axis (x5)and all the value are grouped at the right of the chart!
>> I don't understand what's happening, i need help please.
>> Thanks in advance,
>> aVr
>
> I try again with no success... In fact, i dont't understand the
> philosophie of RS.
> aVr
Ok, it's good, it's working...
It was an X axis problem.
Thanks for you help
aVr