I think your looking in the report catalog table, and there is a blank path and name record which is the root folder in report manager.

SET @NAMEID = '14359'

IF @ADR2 IS NULL AND @ADR3 IS NULL

SELECT ADR1,

...

You can build strings within text boxes, that use parameter values or use part of the current date

ie.

= "July, 1st " & YEAR(Parameter.value)-1 & " - " & ...

=MonthName(Parameters!ClaimMonth.Value)

SELECTCust_No,

Date,

(SELECT Financialyear FROM Financial_year_master_table WHERE Date BETWEEN Year_start_date AND Year_end_date) AS Financial_year

FROMDetail_table

You could do it this way, but you doing query for each row, so performance might not be...

ALTER PROCEDURE [dbo].[usp_SEL_InputCount]

@StartDate datetime,@EndDate datetime

AS

BEGIN

SET NOCOUNT ON;

SELECT TOP (100) PERCENT dbo.GetDay(ModuleTrx.Datestamp) AS Date, dbo.DayNight(ModuleTrx.Datestamp) AS DayNight, Modules.Type, COUNT(*) AS Count

FROM ...

TrackingNumDatestamp StationIDStatusCode

000235905 2008-12-02 18:36:42.0905-

000235905 2008-12-02 19:34:09.10731P

000235905 2008-12-02 19:34:10.09021P

001140044 2008-09-24 08:16:14.07710-

I want to group by shift so that i can compare, so from...

inline code? a little help please:P

my solution seem very slow, is there a quicker way to obtain the shift name?

So far i got this

CREATE TABLE [dbo].[ShiftList](

[StartDate] [datetime] NOT NULL,

[EndDate] [datetime] NOT NULL,

[Shift] [char](1) NOT NULL

) ON [PRIMARY]

ALTER FUNCTION [dbo].[TEST]

(@Date datetime)

RETURNS nchar(1)

AS

BEGIN

Declare @shift nchar(1)

SELECT @shift=...

nah, self develpoment, then I can apply to ssrs