Unfortunately I'm still getting the same error message.

Msg 195, Level 15, State 10, Procedure Waterfall_version2, Line 40

'varchar' is not a recognized built-in function name.

Create PROCEDURE [dbo].[Waterfall_version2]

-- Declaring the variables...

I keep getting errors with this section of the code:

'Msg 195, Level 15, State 10, Procedure Waterfall_version2, Line 40

'varchar' is not a recognized built-in function name' ...

@ Jason

When i try running the script i get the following error which i cant seem to fix

Msg 102, Level 15, State 1, Procedure Waterfall_version2, Line 22

Incorrect syntax near...

The sp can run within ssms on my system would you like a copy of the DB?

Do you mean the dataset within SSRS??

.

This this the SP i'm using at the present moment

USE [DSReports]

GO

/****** Object: StoredProcedure [dbo].[Waterfall_New] Script Date: 10/06/2011 15:42:53 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

ALTER...

Hi Ninja

I've done exactly as what you said and this is the error that i am getting

An error occurred during local report processing.

An error has occurred during report...

@ Jason and Ninja thanks for your replies

@ Jason I've read through the article and i must admit i am struggling a little to understand how to relate function...

Thanks for your reply Jason-299789 I'm going through this article now and will get back to you in a few hours with my results

Ok I'm trying that now

Another questions I've entered the code below in SSRS query windows

select distinct Item

from dbo.January

where Item IN ('A101','A102','A105','A202','A205','B901-12'

...

Hi John

Thanks for your reply I've managed to get it working now. The error i got before were invalid object and syntax near ')' in my older version i...

It works in SSMS in the sp but when i try to refer to it in BI visual studio (SSRS) i usually get an error message that it doesnt exist....

Ninja's_RGR'us (9/12/2011)

---

#1 Is half correct. The query will work but the refresh columns will fail. What you need to do to go around that is to run the...

Hi Ninja's_RGR'us

I received the following error message when trying to run your calender script.

Msg 1921, Level 16, State 1, Line 1

Invalid filegroup 'Data Filegroup 1' specified.

Msg 1750, Level 16,...

Ninja's_RGR'us (9/9/2011)

---

#1 Under the covers, SSRS uses sp_executesql @Items = 'A101,A102'

If you use a query (not a sp). The code WHERE tbl.Item IN (@Items) will be...