I am trying to do some date manipulation in the data set based on a report
parameter .  The parameter is called RDate and is a datetime type.
DATEADD(DateInterval.month, DATEDIFF(DateInterval.month, RenewalDate,
@RDate), Month)

In an attempt to avoid hardcoding of server / database names in Reporting
Services Reports, I'm attempting to use a UDL for all of the Datasets.
I already have a datasource established, using the Data Link properties box,
which I then employ for each dataset, but I'm uncertain how ...

I created a test procedure as below. However, when I execute the proc, I
get the message stating: Procedure test_sp expects parameter @fldofc which
was not supplied. In the Parameters tab I have made the assignment properly.
Also, I added them to the Report Parameters in the ...

I am attempting to update a reporting services report  but the developer
that initially developed it is no longer with the company, and all of any
related Visual Studio development files are missing.
Is there any way I can open up this report in designer mode the way I would

I need to install SQL2000 Reporting Services on w2k3SE R2 x64 (for MS
MOM2k5SP1) but it requires Visual Studio .NET 2003 that requires FrontPage
Server Extensions 2002. But there is no such component in x64 version of
Windows Server 2003. Is it possible to install SQL2000 ...

Is there a "lite" version of Visual Studio 2005 or 2003 that works with
Reporting Services for SQL Server 2000?
Thank you in advance.
Rich

I am trying to display data on a new page when one field contains
specific data.
Once this data is read I wish for any following information to be
displayed on the next page. Any help would be much appreciated.

M a newbie in RS 2005 ..
I need to integrate my RS 2005 Reports into the web applications ....
say ASP.NET or made using C# ...
without using the web-services ...

If I want to upgrade my SQL server 2000 RS box to 2005, is there anything I
should be aware of, is there a document laying out instructions?  I am also
upgrading from VS2003 to VS2005, is there anything in my report solution
files that I should be aware of?  Just looking for info ...

Can someone please tell me how I can return  the Nth item in a dataset
I can get the first element out like so:
=First(Fields!ID_Month___Year_Jul_.Value, "ds_Set")
But how to get the Nth element

Hi all, I have a report that has a number of sections.  I have put each
section into a list so that a section does not get cut in half between pages.
All is fine except for the fact that when I print the report I get a blank
page (header only) between each page.  I have not set ...

Report Builder doesn't play to well with Custom authentication does  it?
If i'm wrong let me know, otherwise, time to start getting creative again.

Hi Experts,
Can anyone tell me how to specify an expression to be mentioned in the "Jump
to Report" in the Navigation tab. I basically dont want the hyperlink for
some values.

I have a Table in my report and I chose "AttributeNormal"  for
DataElementStyle property of the all text boxes within the table's detail
row.
The problem is that SQL RS doesn't output text boxes with null values.

Hi,all
I have a datetime parameter,
I use calendar to select value,but I want to format it as "yyyy-MM"
Any suggest?Can I use expression,how to ?