komal145 (6/13/2012)

---

My function for split parameter:

ALTER FUNCTION [dbo].[SplitParameterValues]

(@input nvarchar(4000), @row_delimiter char(1))

RETURNS @OutputTable TABLE ( [value] nvarchar(100))

AS

BEGIN

declare ...

battery_acid_h (5/30/2012)

---

Problem 1 : I need to develop a report that allows the data to return the top ten performing [indent][/indent]projects by actual GP per region. The problem is that...

riya_dave (5/31/2012)

---

hi

i have created 1 group in my report.now i want sorting on differen field.

example,

account date month

u1 12/31/2010 ...

Anthony Kowaliw (5/30/2012)

---

Hi dilipd006,

I have debugged your code and the problem lies with the declaration of your parameters.

You must explicitly convert them to date e.g.

DECLARE @fromdate DATETIME = CONVERT(DATE,'2012-05-24');

DECLARE @todate...

Think this is the required query. Could be tidier and perform between other ways but this passes all your suggested outcomes.

-- Sample data

declare @ProductRate table (

[ProductID] [int] NOT NULL,

[FromDate]...

Try this. Works with your two rules. It returns the new episode starts, ie sequence=1 or 14days after last closure. (NHS data not included).

-- Create a table...

anthony.green (5/30/2012)

---

The MS Training...

In summary you need to use the series that needs to be alone on the secondary X axis to separate from the other stacked bars. Demo below from SSRS 2008...

*.sqlplans attached. (SQL below used to create the sample data - know this isn't optimal but didn't want to spend too much brain power on it, got bored waiting at...

Sorry I would love to help, but cannot understand what you want. You seem to have a report produced and want to know how to produce it.

Is...

Agreed, I reproduced the test and noticed that the second query (that used a index scan) had a weird estimate for the output. Image attached.

Actual number of rows = 70000...

The drop field technique / terminology was SSRS 2005. You have SSRS 2008 ( or R2). Use the box as shown with values and categories.

Fitz

In SSRS 2008 it is possible...

wendy elizabeth (5/24/2012)

---

I have the following questions for running an subscription for an SSRS 2008 r2 standard edition report

1: When the subscription is setup, how will it know what...

riya_dave (5/24/2012)

---

hi

i have 1 pie chart,now i need to make table of whatever secton of pie chart made.

for example, if i run report my pie chart legend shows...