Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion Groups
DB Engine
SQL ServerMSDESQL Server CE
Services
Analysis (Data Mining)Analysis (OLAP)DTSIntegration ServicesNotification ServicesReporting Services
Programming
CLRConnectivitySQLXML
Other Technologies
ClusteringEnglish QueryFull-Text SearchReplicationService Broker
General
Data WarehousingPerformanceSecuritySetupSQL Server ToolsOther SQL Server Topics
DirectoryUser Groups
Related Topics
MS AccessOther DB ProductsMS Server Products.NET DevelopmentVB DevelopmentJava DevelopmentMore Topics ...

SQL Server Forum / Services / Reporting Services / June 2005

Tip: Looking for answers? Try searching our database.

chart problem

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
avrama - 27 Jun 2005 22:44 GMT
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
avrama - 29 Jun 2005 06:36 GMT
> Hello everybody,
> I have problem to make a simple line report:
[quoted text clipped - 31 lines]
> Thanks in advance,
> aVr

I try again with no success... In fact, i dont't understand the
philosophie of RS.
aVr
avrama - 30 Jun 2005 22:08 GMT
>> Hello everybody,
>> I have problem to make a simple line report:
[quoted text clipped - 31 lines]
> philosophie of RS.
> aVr
Ok, it's good, it's working...
It was an X axis problem.
Thanks for you help
aVr
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2009 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.