Getting #Error details from deployed report

I have a report that displays #Error for some field values when deployed on the server. Is there any way to get details on the error?

Thanks.

Most likely the #Error comes from making a call into a custom assembly and insufficient security permissions for that custom assembly to be invoked.

You can partially simulate the server environment, if you run the report in the stand-alone preview of report designer. I.e. instead of clicking on the Preview tab, hit F5 which should open a new window for the stand-alone preview. For the #Error you should get warning messages with more details in the output window.

-- Robert

getdate SQL Convert to Long Format

,convert(varchar,getdate(),101) as [CONFIRMATION_DATE!1!REPORT_DATE]

The above displays as 8/26/2006, anyway you can convert that to a long format in the SP?

I.E. August 26, 2006

Thanks.

i think you are using c sharp code.
i dont know about c sharp. but in vb we do it like this

dim dt as string
dt = Format(Now, "MMMM DD,yyyy")

hope that it might help you.

|||Does thishttp://www.sql-server-helper.com/tips/date-formats.aspx help?|||

Why not simply using this:

select CONVERT(varchar,getdate())

For more information about converting DATETIME to various styles, please refer to the first table in this link:

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_ca-co_2f3o.asp

|||

thanks for the replies. The sql helper worked great.

Get Year

Posted - 01/08/2007 : 12:19:15

---

Hi,
In my report i have a parameter which displays the Year like this:2000,2001,..,2006.
When it is '1/1/2007' 2007 is automatically need to be add to Year parameter.This should automatically populate with each new year.
How to write the code for achieving this.

Thanks in advance

This 'should' provide the year for you.

SELECT year( getdate() )

|||

Hi,

I did this with this query:

Create Procedure rptCaseDetail_GetYear

as

Begin

Declare @.Year int

Set @.year=2000

Declare @.Current int

SET @.Current=Year(getdate())

declare @.jyear table

(

Year int

)

While (@.year<=@.Current)

Begin

insert into @.jyear Values( @.year)

SET @.Year=@.year+1

End

select * from @.Jyear order by year desc

End

|||I would create a function as it it easier to handle, joinable and more reusable:

ALTER FUNCTION dbo.NextYears

(

@.StartingYear SMALLINT,

@.AmountOfYears SMALLINT

)

RETURNS @.NextYears TABLE

(

TheYear SMALLINT

)

AS

BEGIN

WHILE @.AmountOfYears >= 0

BEGIN

INSERT INTO @.NextYears

SELECT @.StartingYear + @.AmountOfYears

SET @.AmountOfYears = @.AmountOfYears -1

END

RETURN

END

HTh, Jens K. Suessmeyer.

http://www.sqlserver2005.de

Get the Display value of a variable drop-down to display on report

I have a report where the drop-down list is presented to the User at runtime.
This drop-down list displays the User First and Last Name as the option of
the drop-down. But, the value of their selection is set to the EmployeeID.
How do I get the select Full Name to appear on the report for the selected
name from the variable drop-down list?
thanks,
SeanHi Sean.
You need to return the full name in your result set or pass it in as another
parameter.
--
Regards,
Tim Ellison, MCP
Ironworks Consulting, LLC
(m) 804.405.4874
"Sean" <Sean@.discussions.microsoft.com> wrote in message
news:00CC804C-31A7-4740-A670-C605BF162A05@.microsoft.com...
> I have a report where the drop-down list is presented to the User at
runtime.
> This drop-down list displays the User First and Last Name as the option of
> the drop-down. But, the value of their selection is set to the
EmployeeID.
> How do I get the select Full Name to appear on the report for the selected
> name from the variable drop-down list?
> thanks,
> Sean
>