Can''t see function for code added in Report Properties

I put a function in the code section of Report Properties. I went to add an expression and can't find the function. I type =code. and did not see the function I created in the list.

Here's my code below:

Code Snippet

Public Function ConvertToStartDate(ByVal StartDate As String) As DateTime
Select Case StartDate
Case "Today"
Return DateTime.Today
Case "Yesterday"
Return DateTime.Today.AddDays(-1)
Case "30DaysOut"
Return DateTime.Today.AddDays(+30)
Case "2DaysPrior"
Return DateTime.Today.AddDays(-2)
' Additional cases
Case Else
Throw New ArgumentException("Unknown argument, " & StartDate, "StartDate")
End Select
End Function

I should be able to put in expression =code.ConvertToStartDate.StartDate("Today"), but that does not work. I get a red squiggly line under StartDate.

Thanks for your help,

Iris

from your code snippet up above, you would use:

=Code.ConvertToStartDate("Today")

I havent had the intellisense work on custom function code.

BobP

|||

Works like a charm....Thanks!

Iris

Can''t see function for code added in Report Properties

I put a function in the code section of Report Properties. I went to add an expression and can't find the function. I type =code. and did not see the function I created in the list.

Here's my code below:

Code Snippet

Public Function ConvertToStartDate(ByVal StartDate As String) As DateTime
Select Case StartDate
Case "Today"
Return DateTime.Today
Case "Yesterday"
Return DateTime.Today.AddDays(-1)
Case "30DaysOut"
Return DateTime.Today.AddDays(+30)
Case "2DaysPrior"
Return DateTime.Today.AddDays(-2)
' Additional cases
Case Else
Throw New ArgumentException("Unknown argument, " & StartDate, "StartDate")
End Select
End Function

I should be able to put in expression =code.ConvertToStartDate.StartDate("Today"), but that does not work. I get a red squiggly line under StartDate.

Thanks for your help,

Iris

from your code snippet up above, you would use:

=Code.ConvertToStartDate("Today")

I havent had the intellisense work on custom function code.

BobP

|||

Works like a charm....Thanks!

Iris

Can''t see function for code added in Report Properties

I put a function in the code section of Report Properties. I went to add an expression and can't find the function. I type =code. and did not see the function I created in the list.

Here's my code below:

Code Snippet

Public Function ConvertToStartDate(ByVal StartDate As String) As DateTime
Select Case StartDate
Case "Today"
Return DateTime.Today
Case "Yesterday"
Return DateTime.Today.AddDays(-1)
Case "30DaysOut"
Return DateTime.Today.AddDays(+30)
Case "2DaysPrior"
Return DateTime.Today.AddDays(-2)
' Additional cases
Case Else
Throw New ArgumentException("Unknown argument, " & StartDate, "StartDate")
End Select
End Function

I should be able to put in expression =code.ConvertToStartDate.StartDate("Today"), but that does not work. I get a red squiggly line under StartDate.

Thanks for your help,

Iris

from your code snippet up above, you would use:

=Code.ConvertToStartDate("Today")

I havent had the intellisense work on custom function code.

BobP

|||

Works like a charm....Thanks!

Iris

sql

Can't see content tab or properties tab.

An administrator installed reporting services. I went to the url to the
report manager, I cannot see anything on the home page, no tabs at all. How
do I set it up to show me these tabs?
Thanks,
Rick.Log into the machine locally as a member of the local administartor's group.
You'll be able to assign permissions either using the SiteSettings-->Manage
site wide security or through the properties tab
-Lukasz
This posting is provided "AS IS" with no warranties, and confers no rights.
"Rick" <noodle@.noodle.com> wrote in message
news:%23cSbAlPaEHA.644@.tk2msftngp13.phx.gbl...
> An administrator installed reporting services. I went to the url to the
> report manager, I cannot see anything on the home page, no tabs at all.
> How
> do I set it up to show me these tabs?
> Thanks,
> Rick.
>

Can't remove user from role

I have a user in a database role that I cannot remove from the role.
If I go into the user's properties and deselect the role, click OK,
then go back in, the role is still checked.
I've tried to remove them via sp_droprolemember without success.
I am able to add and drop the user from other roles, though, and I'm
able to add/drop other users to the same role.
How do I drop them from the role?
Using: SQL Server 2005 Enterprise
What error message did you get when you tried to remove it from the role?
Linchi
"cbtechlists@.gmail.com" wrote:

> I have a user in a database role that I cannot remove from the role.
> If I go into the user's properties and deselect the role, click OK,
> then go back in, the role is still checked.
> I've tried to remove them via sp_droprolemember without success.
> I am able to add and drop the user from other roles, though, and I'm
> able to add/drop other users to the same role.
> How do I drop them from the role?
> Using: SQL Server 2005 Enterprise
>
|||Hi Linchi:
I don't get an error. It appears to work successfully. But when I look
at the user's roles again, it's still there.
On Feb 12, 12:03Xpm, Linchi Shea
<LinchiS...@.discussions.microsoft.com> wrote:
> What error message did you get when you tried to remove it from the role?
> Linchi
>
> "cbtechli...@.gmail.com" wrote:
>
>
> - Show quoted text -
|||How did you verify whether it's still there in the role? If you are using a
GUI tool, could this be a case of the GUI interface not being refreshed? I
know this may be too obvious, but...
Linchi
"cbtechlists@.gmail.com" wrote:

> Hi Linchi:
> I don't get an error. It appears to work successfully. But when I look
> at the user's roles again, it's still there.
>
> On Feb 12, 12:03 pm, Linchi Shea
> <LinchiS...@.discussions.microsoft.com> wrote:
>
|||If I use sp_helpuser 'theuser' I don't see the role listed.
If I open the properties of the user, the role is listed. I've
refreshed with the same results.
Weird
On Feb 12, 2:26Xpm, Linchi Shea <LinchiS...@.discussions.microsoft.com>
wrote:
> How did you verify whether it's still there in the role? If you are using a
> GUI tool, could this be a case of the GUI interface not being refreshed? I
> know this may be too obvious, but...
> Linchi
>
> "cbtechli...@.gmail.com" wrote:
>
>
>
>
>
> - Show quoted text -

Can't remove user from role

I have a user in a database role that I cannot remove from the role.
If I go into the user's properties and deselect the role, click OK,
then go back in, the role is still checked.
I've tried to remove them via sp_droprolemember without success.
I am able to add and drop the user from other roles, though, and I'm
able to add/drop other users to the same role.
How do I drop them from the role?
Using: SQL Server 2005 EnterpriseWhat error message did you get when you tried to remove it from the role?
Linchi
"cbtechlists@.gmail.com" wrote:
> I have a user in a database role that I cannot remove from the role.
> If I go into the user's properties and deselect the role, click OK,
> then go back in, the role is still checked.
> I've tried to remove them via sp_droprolemember without success.
> I am able to add and drop the user from other roles, though, and I'm
> able to add/drop other users to the same role.
> How do I drop them from the role?
> Using: SQL Server 2005 Enterprise
>|||Hi Linchi:
I don't get an error. It appears to work successfully. But when I look
at the user's roles again, it's still there.
On Feb 12, 12:03=A0pm, Linchi Shea
<LinchiS...@.discussions.microsoft.com> wrote:
> What error message did you get when you tried to remove it from the role?
> Linchi
>
> "cbtechli...@.gmail.com" wrote:
> > I have a user in a database role that I cannot remove from the role.
> > If I go into the user's properties and deselect the role, click OK,
> > then go back in, the role is still checked.
> > I've tried to remove them via sp_droprolemember without success.
> > I am able to add and drop the user from other roles, though, and I'm
> > able to add/drop other users to the same role.
> > How do I drop them from the role?
> > Using: SQL Server 2005 Enterprise- Hide quoted text -
> - Show quoted text -|||How did you verify whether it's still there in the role? If you are using a
GUI tool, could this be a case of the GUI interface not being refreshed? I
know this may be too obvious, but...
Linchi
"cbtechlists@.gmail.com" wrote:
> Hi Linchi:
> I don't get an error. It appears to work successfully. But when I look
> at the user's roles again, it's still there.
>
> On Feb 12, 12:03 pm, Linchi Shea
> <LinchiS...@.discussions.microsoft.com> wrote:
> > What error message did you get when you tried to remove it from the role?
> >
> > Linchi
> >
> >
> >
> > "cbtechli...@.gmail.com" wrote:
> > > I have a user in a database role that I cannot remove from the role.
> > > If I go into the user's properties and deselect the role, click OK,
> > > then go back in, the role is still checked.
> >
> > > I've tried to remove them via sp_droprolemember without success.
> >
> > > I am able to add and drop the user from other roles, though, and I'm
> > > able to add/drop other users to the same role.
> >
> > > How do I drop them from the role?
> >
> > > Using: SQL Server 2005 Enterprise- Hide quoted text -
> >
> > - Show quoted text -
>|||If I use sp_helpuser 'theuser' I don't see the role listed.
If I open the properties of the user, the role is listed. I've
refreshed with the same results.
Weird
On Feb 12, 2:26=A0pm, Linchi Shea <LinchiS...@.discussions.microsoft.com>
wrote:
> How did you verify whether it's still there in the role? If you are using =a
> GUI tool, could this be a case of the GUI interface not being refreshed? I=
> know this may be too obvious, but...
> Linchi
>
> "cbtechli...@.gmail.com" wrote:
> > Hi Linchi:
> > I don't get an error. It appears to work successfully. But when I look
> > at the user's roles again, it's still there.
> > On Feb 12, 12:03 pm, Linchi Shea
> > <LinchiS...@.discussions.microsoft.com> wrote:
> > > What error message did you get when you tried to remove it from the ro=le?
> > > Linchi
> > > "cbtechli...@.gmail.com" wrote:
> > > > I have a user in a database role that I cannot remove from the role.=
> > > > If I go into the user's properties and deselect the role, click OK,
> > > > then go back in, the role is still checked.
> > > > I've tried to remove them via sp_droprolemember without success.
> > > > I am able to add and drop the user from other roles, though, and I'm=
> > > > able to add/drop other users to the same role.
> > > > How do I drop them from the role?
> > > > Using: SQL Server 2005 Enterprise- Hide quoted text -
> > > - Show quoted text -- Hide quoted text -
> - Show quoted text -