Selecting Numeric Or Time-scale Values On Chart Yields Duplicate Months

Numeric Or Time-scale Values Apparently Produce 2 Datasets?
 

Hi All,
I have developed few charts - line graphs - and have checked the Numeric or time-scale values on the X-Axis. Now, when the graphs come out, they appear to have two datasets. For example, if the X axis has values from 1st march to 14th March, then there will be a line from 1st March to 14th March, but additionally there will be another one, pointing to different datapoint, and again starts from 1st March and ends at 14th March. Whereas I think it is because of the Numeric or time-scale values selection, but I am not sure. Also, is there a particular way to interpret such graphs??
 
Thanks a lot, I would have loved to give a picture, but I think I cannot give it.. I did not find an option..
 
Let me know if the question is not clear enough..
 
Manoj Deshpande.

View Replies !   View Related

---

Numeric Or Time-scale Value
Hi,
 
The x-axis of my chart is of type datetime my data has values for various times i would like the datetime scale on the x-axis to be evenly spaced and i belive you do this by setting the type of data under the x-axis tab of the chart properties to 'Number or time-scales' and then set a minimum and maximum for the scale.
 
My question is what is the syntax to sent the minimum scale to say six hours and the maximum scale to 24 hours or one day?
 
Could you please post an example of the syntax.
 
Cheers,

View Replies !   View Related

---

Chaging The Min And Max Scale Of A Chart At Run Time
I have a stored procedure which will bring me back the Min, Max and Mean of different result sets. What I want to do with the Y-Axis is set the Min scale value of the chart to be Min -%5 and the Max scale value to be Max + 5%.

Is there a way to change the Y-Axis values at report run time without spitting my own RDL?

View Replies !   View Related

---

Creating Line Chart Expession Based Y-Axis Scale Values
 

Hello,
I need to know what means are available to change the Minimum and Maximum Y-Axis scale values rather than leave them simply as they are in the properties.
Right now whatever min/max values I enter into the scale for the Y-Axis are unchangeable.
I need to be able to change the min/max scale values based on the value of the data at run time.
 
Any help is appreciated.
 
Thanks.  

View Replies !   View Related

---

Selecting Data Within 1 Month, 6 Months, 12 Months
 

I have the following table

 

FeedBack         Type       Date

test2                  positive     03/15/08

tes3                    negative   03/01/08

..                             ....

 

in my page i need to select the number of  negative/positive comments within the last

 

1 month, 6 months, 12 months

 

How can I accomplish that?
thanks

 

View Replies !   View Related

---

Bar Chart Scale
 

Can you have different scales on a bar chart.  I want to chart sales and quantity.  Oracle lets you label the top of the bar chart as money and the bottom as quantity.
 
I am dividing my sales by one million and quantity by one thousand to make them similar in size on the same chart.  I am using the sum of the sales/1000000 as a point label.  Is there any way to limit the number of decimal places displayed.  Currently it is displaying something like 1.94889312043; 1.95M would be better.
 
Thank you.

View Replies !   View Related

---

IS It Possible To Scale Chart In SQL Server 2000
Hi

 

I need to scale barchar or any other chart in sql server 2000

i need to know the possiblity of this in SQl 2000

 

Regards

 

View Replies !   View Related

---

Add Additional Right Scale On Chart Report
Hi there,

I have a case. I have 3 numeric fields and 1 category field to be displayed on bar chart reports. the problem is 2 of the 3 numeric fields have significant different scale value.  so I need to add additonal scale at the right side of bar chart to represent 1 numeric fields + the 2 other numeric fields at the left side scale (Y). Please advice. Thanks.

R'gards

Toni

View Replies !   View Related

---

Grouping My Months In A Chart
Hi

I'm trying to create a chart with monthly comparisons, but when i throw my months into the chart it groups them under one another instead of next to one another. Please Help!!

Kind regards

Carel Greaves

View Replies !   View Related

---

Colouring The Chart Plot Area Based On X-axis Scale
 

Hi,

 

I have a report based on a line chart.

The values on X-axis are scaled from -100 to +100. I want to colour the band from -100 to 0 with red colour and that from 0 to +100 in green colour, and i want to provide legend for these bands/sections. How can i do this?

A prompt response would be really appreciated

 

Thanks a lot!!

 

Simranjeev

View Replies !   View Related

---

Selecting Only Numeric Data From A String
Hello,I need to be able to select only the numeric data from a string that isin the form of iFuturePriceID=N'4194582'I have the following code working to remove all the non-numeric textfrom before the numbers, but it is still leaving the single quote afterthe numbers, i.e. 4194582'Any ideas or suggestions how to accomplish that? Thanks in advance.Declare @TestData varchar(29)Set @TestData = "iFuturePriceID=N'4194582'"Select Substring(@TestData, patindex('%[0-9]%', @TestData),Len(@TestData))TGru*** Sent via Developersdex http://www.developersdex.com ***

View Replies !   View Related

---

Listing All Months Regardless Of Values
I have written the following query which returns the number of orders received grouped by the year and month:
SELECT DATEPART(yyyy, order_placeddate) AS year, DATEPART(mm, order_placeddate) AS month, count(order_id) AS orders
FROM orders
GROUP BY DATEPART(yyyy, order_placeddate), DATEPART(mm, order_placeddate)
ORDER BY year, month
year month orders
---- ----- ------
2004 6 17
2004 7 37
2004 8 30
2004 9 42
2004 10 34
2004 11 46
2005 1 25
2005 2 7
2005 4 1
The obvious problem with the above is that it misses out the months that have no orders, i.e. December, March, May, etc.

Is there a way I can amend my query so that it shows all months regardless of whether any orders were placed?

I have thought about trying to LEFT OUTER JOIN the above to a table that has rows with values of 1 – 12, but I’m not convinced this is the answer... and I don’t really know how to do it!

Do let me know if any of the above is unclear – what I’m after is the following:
year month orders
---- ----- ------
2004 6 17
2004 7 37
2004 8 30
2004 9 42
2004 10 34
2004 11 46
2004 12 0
2005 1 25
2005 2 7
2005 3 0
2005 4 1
2005 5 0
Many thanks

View Replies !   View Related

---

Getting Density Of Values Across Years And Months
Hi All,
 
I have the following table "Project"

-------------------------------------------------------------------------------------------
ID                Name                Start Date         End Date
--------------------------------------------------------------------------------------------
001           Project 1               2-2-2003          2-3-2007
002           Project 2               1-24-2003        2-6-2007
003           Project 3               4-10-2005        2-10-2008
004           Project 4               5-20-2006        6-6-2008
...
015           Project 15             2-20-2006        3-3-2009
----------------------------------------------------------------------------------------------
What I want is the the following output.
 
Output 1:
 
------------------------------------------------------------------------------------------------------------------------------------------------
Year                             Projects                  No. Of Projects                       Starting Months
------------------------------------------------------------------------------------------------------------------------------------------------
2003                     Project 1 , Project 2                 2                                February, January
2005                     Project 3                                 1                                April
2006                     Project 4, Project 15                 2                               May , Feb
------------------------------------------------------------------------------------------------------------------------------------------------
 
(the order displayed in the months shoudl be in accordance with the order of the projecs in the projects column...)
and also the following
 
Output 2: (this is optional view...)
-----------------------------------------------------------------------------------------
Year            Start Date                     Project Name              
-----------------------------------------------------------------------------------------
2003                


February 2                          Project 1                     
January 24                          Project 2                        
2005              
                    April 4                                Project 3
2006        
                   May 5                                  Project 4
                   February 20                          Project 15
-------------------------------------------------------------------------------------------
 
I am very much in need of Output 1. Could someone help me,
 
 
 
 
 

View Replies !   View Related

---

Chart Background Image Duplicate
I am using Visual Studio 2005 SP1, SQL Reporting Services 2005 SP2 (9.00.3054.00)
 

I have set the BackgroundImage property for a chart to an External URL source where I am dynamically creating an image to the correct height for the chart based on the min and max values for the Y scale. The image is set correctly when I view it in Visual Studio. When I deploy to Reporting Services and run it, the background image appears twice once where it is supposed to be and then again flushed against the upper left corner of the chart area. If I export to PDF or Excel the background image is fine. Not sure if this is a known bug and if there is a fix.
 
Here is the report definition:
 

<?xml version="1.0" encoding="utf-8"?>

<Report xmlns="http://schemas.microsoft.com/sqlserver/reporting/2005/01/reportdefinition" xmlns:rd="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner">

<DataSources>

<DataSource Name="BMIReports">

<DataSourceReference>BMIReports</DataSourceReference>

<rdataSourceID>02517fb1-1481-43ce-b53b-3468b2a2e016</rdataSourceID>

</DataSource>

</DataSources>

<BottomMargin>0.5in</BottomMargin>

<RightMargin>0.5in</RightMargin>

<PageWidth>11in</PageWidth>

<ReportParameters>

<ReportParameter Name="ReportID">

<DataType>Integer</DataType>

<Prompt>ReportID</Prompt>

</ReportParameter>

<ReportParameter Name="MetricDefinitionId">

<DataType>Integer</DataType>

<Prompt>MetricDefinitionId</Prompt>

</ReportParameter>

<ReportParameter Name="MaxScale">

<DataType>Integer</DataType>

<DefaultValue>

<DataSetReference>

<DataSetName>dsParams</DataSetName>

<ValueField>MaxScale</ValueField>

</DataSetReference>

</DefaultValue>

<AllowBlank>true</AllowBlank>

</ReportParameter>

<ReportParameter Name="MinScale">

<DataType>Integer</DataType>

<DefaultValue>

<DataSetReference>

<DataSetName>dsParams</DataSetName>

<ValueField>MinScale</ValueField>

</DataSetReference>

</DefaultValue>

<AllowBlank>true</AllowBlank>

</ReportParameter>

<ReportParameter Name="RedValue">

<DataType>Integer</DataType>

<DefaultValue>

<DataSetReference>

<DataSetName>dsParams</DataSetName>

<ValueField>RedValue</ValueField>

</DataSetReference>

</DefaultValue>

<AllowBlank>true</AllowBlank>

</ReportParameter>

<ReportParameter Name="IsGreaterThanOperator">

<DataType>Boolean</DataType>

<DefaultValue>

<DataSetReference>

<DataSetName>dsParams</DataSetName>

<ValueField>IsGreaterThanOperator</ValueField>

</DataSetReference>

</DefaultValue>

<AllowBlank>true</AllowBlank>

</ReportParameter>

</ReportParameters>

<rdrawGrid>true</rdrawGrid>

<InteractiveWidth>11in</InteractiveWidth>

<rdnapToGrid>true</rdnapToGrid>

<Body>

<ReportItems>

<Chart Name="chart1">

<Legend>

<Visible>true</Visible>

<Style>

<BorderStyle>

<Default>Solid</Default>

</BorderStyle>

<FontSize>7pt</FontSize>

</Style>

<Position>RightCenter</Position>

</Legend>

<Subtype>Plain</Subtype>

<Title>

<Caption>=First(Fields!MetricName.Value)</Caption>

<Style>

<FontWeight>700</FontWeight>

<FontSize>14pt</FontSize>

</Style>

</Title>

<Height>5.75in</Height>

<CategoryAxis>

<Axis>

<Title>

<Caption>Quarters</Caption>

</Title>

<Style />

<MajorGridLines>

<Style>

<BorderStyle>

<Default>Solid</Default>

</BorderStyle>

</Style>

</MajorGridLines>

<MinorGridLines>

<Style>

<BorderStyle>

<Default>Solid</Default>

</BorderStyle>

</Style>

</MinorGridLines>

<MajorTickMarks>Outside</MajorTickMarks>

<Visible>true</Visible>

</Axis>

</CategoryAxis>

<PointWidth>0</PointWidth>

<Left>0.25in</Left>

<ThreeDProperties>

<Rotation>30</Rotation>

<Inclination>30</Inclination>

<Shading>Simple</Shading>

<WallThickness>50</WallThickness>

</ThreeDProperties>

<DataSetName>MetricTrend</DataSetName>

<SeriesGroupings>

<SeriesGrouping>

<DynamicSeries>

<Grouping Name="chart1_SeriesGroup1">

<GroupExpressions>

<GroupExpression>=Fields!Company.Value</GroupExpression>

</GroupExpressions>

</Grouping>

<Label>=Fields!Company.Value</Label>

</DynamicSeries>

</SeriesGrouping>

</SeriesGroupings>

<PlotArea>

<Style>

<BorderStyle>

<Default>Solid</Default>

</BorderStyle>

<BackgroundColor>Gainsboro</BackgroundColor>

<BackgroundGradientEndColor>Gainsboro</BackgroundGradientEndColor>

</Style>

</PlotArea>

<ValueAxis>

<Axis>

<Title />

<Style />

<MajorGridLines>

<ShowGridLines>true</ShowGridLines>

<Style>

<BorderStyle>

<Default>Solid</Default>

</BorderStyle>

</Style>

</MajorGridLines>

<MinorGridLines>

<Style>

<BorderStyle>

<Default>Solid</Default>

</BorderStyle>

</Style>

</MinorGridLines>

<MajorTickMarks>Outside</MajorTickMarks>

<Min>=Parameters!MinScale.Value</Min>

<Max>=Parameters!MaxScale.Value</Max>

<Margin>true</Margin>

<Visible>true</Visible>

<Scalar>true</Scalar>

</Axis>

</ValueAxis>

<Type>Line</Type>

<Width>9.5in</Width>

<CategoryGroupings>

<CategoryGrouping>

<DynamicCategories>

<Grouping Name="chart1_CategoryGroup2">

<GroupExpressions>

<GroupExpression>=Fields!Quarter.Value</GroupExpression>

</GroupExpressions>

</Grouping>

<Sorting>

<SortBy>

<SortExpression>=Fields!Quarter.Value</SortExpression>

<Direction>Ascending</Direction>

</SortBy>

</Sorting>

<Label>=Fields!Quarter.Value</Label>

</DynamicCategories>

</CategoryGrouping>

</CategoryGroupings>

<Palette>Default</Palette>

<ChartData>

<ChartSeries>

<DataPoints>

<DataPoint>

<DataValues>

<DataValue>

<Value>=Fields!MetricValue.Value</Value>

</DataValue>

</DataValues>

<DataLabel>

<Style>

<Format>P0</Format>

</Style>

</DataLabel>

<Style>

<BorderWidth>

<Default>0.75pt</Default>

</BorderWidth>

</Style>

<Marker>

<Type>Auto</Type>

<Size>5pt</Size>

</Marker>

</DataPoint>

</DataPoints>

</ChartSeries>

</ChartData>

<Style>

<BorderStyle>

<Default>Solid</Default>

</BorderStyle>

<BackgroundImage>

<Value>=Code.SetBackground(Parameters!MaxScale.Value, Parameters!MinScale.Value, Parameters!RedValue.Value, Parameters!IsGreaterThanOperator.Value)</Value>

<Source>External</Source>

<BackgroundRepeat>NoRepeat</BackgroundRepeat>

</BackgroundImage>

</Style>

</Chart>

</ReportItems>

<Height>5.875in</Height>

</Body>

<PageHeader>

<ReportItems>

<Textbox Name="textbox7">

<Left>7.125in</Left>

<Top>0.125in</Top>

<rdefaultName>textbox7</rdefaultName>

<ZIndex>1</ZIndex>

<Width>2.75in</Width>

<Style>

<TextAlign>Right</TextAlign>

<PaddingLeft>2pt</PaddingLeft>

<PaddingBottom>2pt</PaddingBottom>

<FontFamily>Tahoma</FontFamily>

<FontWeight>700</FontWeight>

<FontSize>12pt</FontSize>

<PaddingRight>2pt</PaddingRight>

<PaddingTop>2pt</PaddingTop>

</Style>

<CanGrow>true</CanGrow>

<Height>0.25in</Height>

<Value>Performance Analysis Reports</Value>

</Textbox>

<Image Name="image1">

<Sizing>Fit</Sizing>

<MIMEType />

<Width>3.25in</Width>

<Source>External</Source>

<Style />

<Height>0.875in</Height>

<Value>bm_logo.gif</Value>

</Image>

</ReportItems>

<Height>1.125in</Height>

<PrintOnLastPage>true</PrintOnLastPage>

<PrintOnFirstPage>true</PrintOnFirstPage>

</PageHeader>

<rd:ReportID>4206e98a-fe32-4d1f-8698-e99ac2163900</rd:ReportID>

<LeftMargin>0.5in</LeftMargin>

<DataSets>

<DataSet Name="MetricTrend">

<Query>

<CommandType>StoredProcedure</CommandType>

<CommandText>sp_Get_Metric_Trend</CommandText>

<QueryParameters>

<QueryParameter Name="@ReportID">

<Value>=Parameters!ReportID.Value</Value>

</QueryParameter>

<QueryParameter Name="@MetricDefinitionId">

<Value>=Parameters!MetricDefinitionId.Value</Value>

</QueryParameter>

</QueryParameters>

<DataSourceName>BMIReports</DataSourceName>

</Query>

<Fields>

<Field Name="Quarter">

<rd:TypeName>System.Int64</rd:TypeName>

<DataField>Quarter</DataField>

</Field>

<Field Name="Company">

<rd:TypeName>System.String</rd:TypeName>

<DataField>Company</DataField>

</Field>

<Field Name="MetricName">

<rd:TypeName>System.String</rd:TypeName>

<DataField>MetricName</DataField>

</Field>

<Field Name="MetricValue">

<rd:TypeName>System.Int32</rd:TypeName>

<DataField>MetricValue</DataField>

</Field>

<Field Name="FiscalYear">

<rd:TypeName>System.Int32</rd:TypeName>

<DataField>FiscalYear</DataField>

</Field>

<Field Name="FiscalQuarter">

<rd:TypeName>System.Int32</rd:TypeName>

<DataField>FiscalQuarter</DataField>

</Field>

</Fields>

</DataSet>

<DataSet Name="dsParams">

<Query>

<rd:UseGenericDesigner>true</rd:UseGenericDesigner>

<CommandText>SELECT MaxScale, MinScale, RedValue, IsGreaterThanOperator FROM MetricDefinition WHERE MetricDefinitionId = @MetricDefinitionId</CommandText>

<QueryParameters>

<QueryParameter Name="@MetricDefinitionId">

<Value>=Parameters!MetricDefinitionId.Value</Value>

</QueryParameter>

</QueryParameters>

<DataSourceName>BMIReports</DataSourceName>

</Query>

<Fields>

<Field Name="MaxScale">

<rd:TypeName>System.Int32</rd:TypeName>

<DataField>MaxScale</DataField>

</Field>

<Field Name="MinScale">

<rd:TypeName>System.Int32</rd:TypeName>

<DataField>MinScale</DataField>

</Field>

<Field Name="RedValue">

<rd:TypeName>System.Int32</rd:TypeName>

<DataField>RedValue</DataField>

</Field>

<Field Name="IsGreaterThanOperator">

<rd:TypeName>System.Boolean</rd:TypeName>

<DataField>IsGreaterThanOperator</DataField>

</Field>

</Fields>

</DataSet>

</DataSets>

<Code>public function SetBackground(sMax As String, sMin As String, sRed As String, sType As String) As String

SetBackground = "http://localhost/BMI/Background.aspx?max=" + sMax + "&amp;min=" + sMin + "&amp;red=" + sRed + "&amp;type=" + sType

end function</Code>

<Width>10in</Width>

<InteractiveHeight>8.5in</InteractiveHeight>

<Language>en-US</Language>

<TopMargin>0.5in</TopMargin>

<PageHeight>8.5in</PageHeight>

</Report>

View Replies !   View Related

---

Selecting Duplicate Records
Is there a way to see a list of duplicate records??
EG There is a field named "Invoice" in a table named "Orders" and I want to see only records where the same invoice shows more than once.

Sample output:

Invoice--Partno
123------a66
123------9pp
123------k33
5988-----j22
5988-----bx1
66-------pq1
66-------333

etc......

Thanks
Mike

View Replies !   View Related

---

Help Selecting Duplicate Record Details
I have the following query I am using to identify duplicate records in one of my database tables:


Code:


SELECT memberID,
COUNT(memberID) AS NumOccurrences
FROM ChapterMembers
GROUP BY memberID
HAVING ( COUNT(memberID) > 1 )



Executing the above proc returns 4079 records...

Now, I would also like to know the ChapterID for each member with a duplicate record. ChapterID is also stored in the ChapterMembers Table...

I tried running the following procedure:


Code:

SELECT memberID,
COUNT(memberID) AS NumOccurrences, chapterID
FROM ChapterMembers
GROUP BY memberID, chapterID
HAVING ( COUNT(memberID) > 1 )



But zero results are returned ...

The ultimate goal here is to identify duplicate records where one of their chapterID's = '81017' and to delete that record from the database.

Anyone have any ideas what I am doing wrong? Also, any suggestions for removing the records would be appreciated.

Thanks,

Jandrews

View Replies !   View Related

---

Pull Only Numeric Values
I have a varchar field that contains both numeric and text data.  I need to pull only numeric, non-null values.

View Replies !   View Related

---

Search For Numeric Values
Hi,

Is there a way to search for numeric values in the field.

For eample my table is

create table test (sector varchar(20))

insertinto test
values ('Hybrid 3/1')
values ('ARM')
values ('20yr')

is it possible to display
3/1
NULL
20
for the above?

Thanks.

View Replies !   View Related

---

How To Insert Values Without Duplicate Values?
Hi,
 
I want to insert data into table without duplicate values ..
 
how to do?

View Replies !   View Related

---

SSRS In Scale-out-Deployment (Joining A Remote Report Server Named Instance To A Scale-out Deployment)
 

Hello
 
We configured SSRS in 2 Instances (web server's). MNA01 and MNA02, Which have IIS 6.0. We have SQL Server Database (Report server DB, Report Server Temp DB)
 
The table Keys in the Database is having 2 values, one for MAN01 and one for MNA02. Shall we have 2 values or 1 value in the table "Keys"?
 
I have seen the article says we have to Join the Keys using the rskeymgmt utility. (Joining a Remote Report Server Named Instance to a Scale-out Deployment)
 
Note: A report server scale-out deployment refers to a deployment model where multiple report server instances share the same report server database. A report server database can be used by any report server instance that stores its symmetric keys in the database. For example, if a report server database contains key information for three report server instances, all three instances are considered to members of the same scale-out deployment.
 
Please advice for the correct configuration of SSRS in scale-out-deployment.
 
Thanks in advance. Jay

 
 

View Replies !   View Related

---

Strange Problem With Time Series Data On Time Series Chart
Hi, all experts here,

 

Thank you very much for your kind attention.

 

I encountered a very strange problem again. Why the time series displayed on the chart are so strange? The Key time column I chose for my time series algorithm is cal_month(e.g 199001...), but why the date displayed on the time series chart is like :05/06/2448? (it should be like 199001..?) What is that data? And where exactly did it come from? What is the exact cause of this?

 

Hope it is clear for your help.

I am really confused on this and thanks a lot for your kind advices and help and I am looking forward to hearing from you shortly.

 

With best regards,

 

Yours sincerely,

 

View Replies !   View Related

---

How To Add Default Values To My Chart
Hi out there
need some help with this.
 
I am developing some reports that are using a time scaled X Axis.
 
The value displayed are a summation of how many times an event have occurred within a certain time frame.
The dataset returned could be like the one pasted below.
 
The "Time" column is shown as X Axis
The "ID" column is used as Series
The "Value" is shown as Y Axis
 
The problem is that if there is only one point (Single Point) the chart will not draw a line - that is obvious.
 
My problem would be solved by inserting the value 0 (zero) in the time frame before and after the Single Point - now there would be enough points for the chart to draw a line (actual two lines)
 
Is there any way that I can make the chart plot a default value (like 0) when it have no actual value?
 
Time                                 ID   Value
2007-05-17 08:48:00.000   29      5
2007-05-23 23:36:00.000   29      6
2007-05-30 14:24:00.000   29      5
2007-06-06 05:12:00.000   29      4
2007-06-12 20:00:00.000   29      4
2007-06-19 10:48:00.000   29      5
2007-06-26 01:36:00.000   29      1
2007-07-02 16:24:00.000   29      8
2007-07-09 07:12:00.000   29      8
2007-07-15 22:00:00.000   29     25
2007-07-22 12:48:00.000   29     46
2007-07-22 12:48:00.000   1       17 (This is my Single Point)
2007-07-29 03:36:00.000   29      1
2007-08-04 18:24:00.000   29      1
2007-08-11 09:12:00.000   29      1
2007-08-18 00:00:00.000   29      1

View Replies !   View Related

---

Chart - Negative Values
Hi,

I´m working with chart type bar (Simple Bar) and i received four values from stored procedure, all values are negative numbers. The Reporting Service shows the values in the chart, but, doesn't show the "bars".... If one of four values will be positive, the report shows the values and the "bars" but if all values will be negative, the report shows just de values.

What do I do for the bars appear with four negative values ?

Thanks.

View Replies !   View Related

---

Zero Values On A Line Chart
am using a line chart to display series of results over time - data is got from and AnalysisServices cube.

problem is that sometimes there is no value for the result - and the chart doesnt display that as zero

e.g. with the following data

week 1 10 items

week 2 12 items

week 3 14 items

week 4 8 items

week 6 12 items

the chart will join the week 4 result of 8 items directly to the week 6 result of 12 items

is there anyway of changing this so the line goes from 8 items on week 4 to ZERO items on week 5 and then 12 items on week 6 ???

 

View Replies !   View Related

---

Data With 0 Values In Pie Chart
I have created one report with expolded pie chart showing data along with labels. The problem is though one of the values in pie chart is 0, it still shows the colour in pie chart. For eg - The chart has two values - 'Yes' or 'No'. Though the value for 'No' is 0, it still displays the colour of 'No' on pie chart. Is it a bug in SSRS? Is there any solution??

Please let me know!!

Thanks in advance!!

View Replies !   View Related

---

Displaying Values On A Chart
I have a chart with columns on it, and my boss wants me to display the height of each column on the chart.

Is there a way to do this? I've googled it some, and searched around in the chart properties, but I couldn't find anything.

View Replies !   View Related

---

Using PatIndex To Find All Numeric Values
Hello,
I forget. How can PATINDEX be used to find column values where the data is all numeric? I've tried, the following:
 

select distinct acct from tbl_CYProcessedSales

where PatIndex('%[0-9]%',Acct) > 0

order by acct

 
Acct is varchar(8). What am I doing wrong?
 
Thank you for your help!
 
CSDunn

View Replies !   View Related

---

Ignoring Numeric & Alphanumeric Values
Hi,
I am using SQL Server 2000. In database i am having one column named Address which contains full address of the customer. While searching i want to ignore starting numeric or alphanumeric values. Kinly guide how I can ignore numeric or alphanumeric values while searching the data.

View Replies !   View Related

---

Adding Numeric Values In The Database
hi folks...now m in serious trouble...i hve a very complicated problem now...

let me explain

i have a table in SQL...I have to select values from this table depending on 2 where conditions.....and add these values......and insert them in another table......

now can somebody tell me how can i add the values from the database and store them in a session and update them to another table...

if i am not clear then ask me i will explain u in more detail


Navi

View Replies !   View Related

---

Converting Varchar To Numeric Values
Not sure how I can convert varchar to numeric values in SQL Server? Trying to do so in Design and get error:
Unable to modify table.
ODBC error: [Microsoft][ODBC Server Driver][SQL Server] Error converting data type varchar to numeric.
Any suggestions?

View Replies !   View Related

---

Two Values On Y Axis Of Line Chart?
Dear Friends,
I have been trying to put name and description grouped by name and description on y-axis of line chart but no sucess till now.
I have been able to generate the one line per name and also showing labes on points for description but the thing is not getting done if i want the same thing grouped by name so that
there will be list of names on y and then all the description (6 or 7) grouped by name and description and on x axis date.
Please see the current chart:
 
http://picasaweb.google.com/jwalant.soneji/Softwares/photo#5109636829663433682
 
and please reply me asap.
thanks,
 
 
Can anyone please answer me!
Also asking to you all MVPs.
Thanks,

View Replies !   View Related

---

Filtering NULL Values From A Chart
 

I am facing some problems in displaying data in a chart on a report. Let me give you a background on the report


The report has 8 parameters, Industry,CType,PType, S#, ECode, Start Date, End Date and Trend.

The layout of the report has a table and a chart.

Both the table and the chart need to display Normalized Value ( count of ECode / count of PType that are closed in the date range selected) and the Trend ( where the trend can be Weekly, Monthly, Yearly or Quarterly).

Both the chart and the table should display the data for the entire date range i.e if the Trend is Month and the Date Range is Jan 2007 Jan 2008, then the table and the chart should display months from Jan 2007, Feb 2007 .... Jan 2008 irrespective of whether or not there are error codes present for that month.

In order to satisfy the point 4 mentioned above, we have created the main dataset in such a way that it would have one row for each day between Jan 2007 to Jan 2008. Any fields that do not have data corresponding to a date will come up as NULL in the dataset.

 

Now, we need to display a chart in the report which would be a Trend v/s the Normalized Value chart for each ECode. So, we have put in the Normalized value in the 'Value' field of the chart, Trend group in the 'Category' field of the chart and ECode in the 'Series' group of the chart. The chart displays fine except for one extra series for the NULL values in the Error Code ( the one in green below). Is there any way in which we can do away with this NULL series without changing the dataset? I tried using filters for the 'Series' but it doesn't work ( used filters like <>NULL, <> "" , <>Nothing, cstr(ECode) <> NULL/"" etc ).

View Replies !   View Related

---

Horizontal Bar Chart Date Values
 

I've read several posts that seem to dance around this subject.  Some may actually answer my question, but I'm not finding a solution.  Here's my situation.
 
Horizontal bar chart that has PRODUCT in the category field.  (Left side X-axis)  I am trying to illustrate the product life cycles along the the horizontal stacked bars.
 
If I use the CONCEPTION date as a baseline, I can calculate the datediff between the CONCEPTION and various milestones i.e. DESIGN, MANUFACTURING, INTRODUCTION, TERMINATION etc.  This provides a fairly good representation.  The problem is the Y-axis labels are numbers and not dates.
 
I have tried using the actual date values instead of the calculated datediff and the results are totally unacceptable.  Is there a means to either use the actual date values, or set the labels as dates?  I can do this with an Excel graph, so I assume there's a simple solution, but it's eluding me.

View Replies !   View Related

---

Report Chart Values Overlayed
Hi to everyone.I have this problem in my chart control in report.I am retrieving datas from my database.My x-axis is consist of dates of the year,y-axis is the hit counts.My problem here is when i only have hits in only one month(ex december) and almost over 20 hits are retrieved,the bars of my graph become so overcrowded and overlayed which make the value unclear to see.And also another thing is my legend repeats the color when there are too much data.is there anyway to fix this or this is just a ReportingService bug??Hope not..hehe.. Thanx

View Replies !   View Related

---

Determine If Values In A Field Are Alpha Or Numeric
HI,
Thanks in advance for taking your time to read this post.
I am trying to write a SQL query using MS SQL 2005 that will read the value of a field and tell if it is alpha or numeric.  I have tried the following but it does not work:
select field1 from table1 where left(field1,2)='[0-9]'
select field1 from table1 where isnumber(left(field1,2) tried with a =1 at the end and without and =1 at the end
the goal is to read through a field and format it so if a field looks like this 12xxx111xx I can change it to look like 12-xxx-111-xx.
Any help is greatly apprecaited

View Replies !   View Related

---

Skip Alphanumeric Values (or Check If Value Is Numeric)
Is it possible to write a sql statement to skip aplpha numeric values? I got a field containing these values; 20, 70, 150, 140, 100, KORT, 90, 180, 160. And I'm trying to check if any value is bigger than 175 (@Limit), but I want to skip the value 'KORT'. So is it possible to check if a value is numeric or not? ISNULL( CONVERT(int, ProductVariant.Size), 0) > @Limit  Regards, Sigurd 

View Replies !   View Related

---

How To Check Numeric Values In A Varchar Field
Hi all,

I have a field defined as varchar(8) but this field should not contain any letters, needs to be only numbers. How can I validate the data if it contains only numbers? Any ideas?

Thanks,
Jannat.

View Replies !   View Related

---

Incrementing Numeric Values Of An Entire Column
Hello everyone,

I have an Access database of prices with the following fields:
ID, finish, region1, region2, region3, region4, region5and 600 records like the following:
1, Stone, 95800, 99800, 100300, 66780, 45000How do I write an SQL query to increment all 600 values in region4 by 6000?

Thanks for any help!

Scott

View Replies !   View Related

---

Replacing Numeric Values On Y-axis With Labels
Is there a way of mapping numeric values on the y-axis to strings such as when y=1 the label 'Low', when y=2 the label 'Medium' etc appear on the y-axis instead of the numbers?

View Replies !   View Related

---

Problem-Adding Numeric Values In The Database
i have a table in the below shown format

Values Items.......................................................TABLE1

Customer1 20 Fuses

Customer2 30 Screws

Customer3 40 Fuses

Customer1 45 Fuses

Customer3 78 Batteries

Customer1 40 Screws

now i want to add the values of screw of customer1 and insert in a table in one field as shown below

Screws Fuses Screws .................................TABLE2

Customer1 65 (total of above) 115 40

Custoerm2 ------------------------------------

NOW ADD VALUES IN THE ABOVE WAY AND INSERT IN THE TABLE 2


Thanks


Navi

View Replies !   View Related

---

How To View Time Series Chart In C#
Hi!

When I using SQL Server 2005 to buide a Time Series mining model, in the Charts tab, it show the chart about somthing to predict in the future.

How to view that Time Series Chart in C# . ( Or using a third component)

View Replies !   View Related

---

How To Present Time Series Chart On The Web
Help me!!

1. Can you tell me the way to present Time Series Chart on The Web by ASP.Net 2.0
2. I have a Time Series Mining Model. Its structure is:

(Month datetime key time, Sales continous predict)

When the query runs:


select Flattened  Predict(sales,5)

from Model_Name
The result is Month and sales in the future. But i wan also retrieve Month and Sales in the past . Tell me the way?????

Thank alots!!!!!!!

View Replies !   View Related

---

Change Chart Title At Run-time
 Is it possible to change the title of a chart at run-time?

View Replies !   View Related

---

Selecting Values In CSV
I have to write a master detail query, in which the detail record shouldbe stored in a variable as Comma Seperated Values. Can anyone helpme......Sun*** Sent via Developersdex http://www.developersdex.com ***Don't just participate in USENET...get rewarded for it!

View Replies !   View Related

---

Generate Values Between A Starting And Stopping Point (time Values).
[RS 2005]

Given the starting and stopping points (time values), how do I generate values between these points.

For example, if I have 08 (representing Hour) as a starting point and 12 as a stopping point.

From this I would like to generate a data sequence like 08, 09, 10, 11, and 12.

So how do I accomplish this? In SQL or in the RS?

The only thing I can think of is using a WHILE loop and a temporary table in SQL (not to keen on doing this).

 

//HÃ¥kan

View Replies !   View Related

---

Display Null Values As 0 On Line Chart
I have a report I'm writing and have got a problem that has stumped me.

 

The data the report is based in is in this format:

 

Date                 Type

1/1/08               A

1/3/08               B

3/1/08               C         

3/5/08               B

3/10/08             A

3/12/08             C

3/20/08             A

 

 

Management wants a report showing a line chart that summarizes the data by Month and by Type. So, there are 2 series depending on the Type and data values are based on the count of each Type. So, in the example above the x-axis group would be month, the values would be count(Type) and there would be 2 series €“ Series 1. A, B and Series 2. C

 

I€™ve defined the x-axis to be Month(Fields!DateOccured.Value). However, they want the x-axis to show every month for the entire year not just what is in the database. So, I defined the x-axis to have a scale of 1 to 12 and the major interval is set to 1. This displays 1 through 12 on the x-axis.

 

The problem is when there is no data (null) for a particular month. Instead of showing 0, the line chart does not plot anything and the line is drawn to the next displayed point. So, for example on the data above the line chart would plot:

January  

Series 1 €“ Qty. 2           Series 2 €“ Qty. 0

February

Null

March

Series 1 €“ Qty. 3           Series 2 €“ Qty. 2

 

The line chart would draw a line from January to March skipping February. I need to display the null values as 0 and not null indicating no occurrences for the month rather than no data present.

 

Thanks!
 

 

View Replies !   View Related

---