Forms Authentication...Can it really be done?

I could really use help getting form authentication to work. I have a box with a web site and ReportingServices installed(which if I can get this working will be moved to the DMZ). The databases are on a different machine(which will on on our network).

I have been working with the sample provided with the install and this blog.

http://blogs.msdn.com/bimusings/archive/2005/12/05/500195.aspx

My problem is that I can logon and authenticate but when I call ListChildren() my System.Net.CredentialCache.DefaultCredentials is empty so I get nothing back from the call.

I know that I have a valid cookie because after I logon I can use the Reports and the ReportServer URL's and go directly to those pages.

Can someone tell me what I need to do to make ListChildren() work? Do I still call ListChildren()? Documentation is scarce and would appreciate any help provided.

Thanks

-JW

I was afraid I wouldn't get a response to this.

Can anyone help?

Formatting text within a text box

Trying to use this tool to create a form letter. I have a text box that has a paragraph of data within that paragraph I'd like to bold a word or underline a word. Is this just a gross misuse of this tool or is there a way to format text within the text box?Unfortunately, Reporting Services alone does not support richly formatted text, such as html or rtf. This is slated for a future release.

In the meantime, if you want to output to Word or Excel, you can use a 3rd party tool, OfficeWriter from SoftArtisans. OfficeWriter

lets you preserve all Excel and Word formatting.

http://officewriter.softartisans.com/officewriter-250.aspx

Ian|||I see other references to this being slated for a future release from last year. Do you know ballpark when that will be? Sometime 07 or later this year?|||

Hi Ran,

Can you tell us roughly when RTF feature would be available? In 6 months? One year? We're using Reporting Services extensively. The missing RTF feature is really painful.

Thanks!

Formatting text within a text box

Trying to use this tool to create a form letter. I have a text box that has a paragraph of data within that paragraph I'd like to bold a word or underline a word. Is this just a gross misuse of this tool or is there a way to format text within the text box?Unfortunately, Reporting Services alone does not support richly formatted text, such as html or rtf. This is slated for a future release.

In the meantime, if you want to output to Word or Excel, you can use a 3rd party tool, OfficeWriter from SoftArtisans. OfficeWriter

lets you preserve all Excel and Word formatting.

http://officewriter.softartisans.com/officewriter-250.aspx

Ian|||I see other references to this being slated for a future release from last year. Do you know ballpark when that will be? Sometime 07 or later this year?|||

Hi Ran,

Can you tell us roughly when RTF feature would be available? In 6 months? One year? We're using Reporting Services extensively. The missing RTF feature is really painful.

Thanks!

Formatting text in Textbox

Is it possible to format one word in a text box to the color blue and another word in the SAME textbox to the color red?

Hello,

Sorry, but formatting is applied to the whole textbox. You can't format text differently within the same textbox.

Jarret

Formatting text

Are there any plans for RS to support formatting of text within a text box. e.g. some of the text being bold, some of it italics and different fonts etc.

As many web apps now support text formating it would be good to be able to display the same formatting in a report. I think the formating is done using html so RS would need to be able to parse the html and format accordingly.

Anyone know if this is due to be supported?

Thanks

Refer to post http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=259291&SiteID=1

It will allow you to view rich text in a report. It doesn't support HTML markup but you could modify it to do so.

Also, the Microsoft rep I spoke with indicated they intend to include it in the next release. And by release, he didn't mean service pack, he meant SQL 2007.

Formatting text

I need to format a text in a text box to show a text field truncated.
In other terms, I must show only 40 characters of a very long string.
Do I use the statement "format"?
How can I solve this issue?
Many thanksI would do it in the SQL statement. As in left(fieldname, 40)
Richard
"Pasquale" <Pasquale@.discussions.microsoft.com> wrote in message
news:2550C968-0324-4FC8-A50D-67645F99C4BD@.microsoft.com...
>I need to format a text in a text box to show a text field truncated.
> In other terms, I must show only 40 characters of a very long string.
> Do I use the statement "format"?
> How can I solve this issue?
> Many thanks|||Or in the report itself:
Field => expression => LEFT(strVariable, 40)|||OK! Many thanks
"Vyv" wrote:
> Or in the report itself:
> Field => expression => LEFT(strVariable, 40)
>

Formatting part of a text box

hey all,

does anyone know of a way to format part of a text box in sql reporting services 2005? i am creating a form letter and need to concatenate static text with a column and need just the column value to be bold. like this:

"This letter is confirmation that Acme Agency has been chosen..."

my expression to build this is:

="This letter is confirmation that " + Fields!agency_name.Value + " has been chosen..."

Is there a way to apply formatting just to Fields!agency_name.Value ?

thanks!

jen

Sorry, this is currently not supported.

-- Robert

|||Unable to format individual words within a text is avoiding us to totally move from Business Objects and Crystal Reports to SSRS. Is there a workaround or is it expected in a future release?

Thanks,

Jeroen van der Wal
BI Consultant

|||

It is on the list for a future release. You might want to check out related threads on the SSRS 2008 forum: http://forums.microsoft.com/MSDN/ShowForum.aspx?ForumID=1624&SiteID=1

-- Robert

Formatting part of a text box

hey all,

does anyone know of a way to format part of a text box in sql reporting services 2005? i am creating a form letter and need to concatenate static text with a column and need just the column value to be bold. like this:

"This letter is confirmation that Acme Agency has been chosen..."

my expression to build this is:

="This letter is confirmation that " + Fields!agency_name.Value + " has been chosen..."

Is there a way to apply formatting just to Fields!agency_name.Value ?

thanks!

jen

Sorry, this is currently not supported.

-- Robert

|||Unable to format individual words within a text is avoiding us to totally move from Business Objects and Crystal Reports to SSRS. Is there a workaround or is it expected in a future release?

Thanks,

Jeroen van der Wal
BI Consultant

|||

It is on the list for a future release. You might want to check out related threads on the SSRS 2008 forum: http://forums.microsoft.com/MSDN/ShowForum.aspx?ForumID=1624&SiteID=1

-- Robert

Formatting part of a text box

hey all,

does anyone know of a way to format part of a text box in sql reporting services 2005? i am creating a form letter and need to concatenate static text with a column and need just the column value to be bold. like this:

"This letter is confirmation that Acme Agency has been chosen..."

my expression to build this is:

="This letter is confirmation that " + Fields!agency_name.Value + " has been chosen..."

Is there a way to apply formatting just to Fields!agency_name.Value ?

thanks!

jen

Sorry, this is currently not supported.

-- Robert

|||Unable to format individual words within a text is avoiding us to totally move from Business Objects and Crystal Reports to SSRS. Is there a workaround or is it expected in a future release?

Thanks,

Jeroen van der Wal
BI Consultant

|||

It is on the list for a future release. You might want to check out related threads on the SSRS 2008 forum: http://forums.microsoft.com/MSDN/ShowForum.aspx?ForumID=1624&SiteID=1

-- Robert

sql

Formatting Dates

I have a Text box containing the following info:
="Effective: " & Parameters!PMStartDate.Value & " to "
& Parameters!PMEndDate.Value
How do I control the format of the date? I want the Format to be dd/MMM/yyyy.You will need to use Format(). See
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/vblr7/html/vafctFormat.asp
for more information.
Below is a sample expression based on your parameter names:
="Effective: " & Format(Parameters!PMStartDate.Value, "Long Date") & "
to " & Format(Parameters!PMEndDate.Value, "Short Date")
--
Bruce Johnson [MSFT]
Microsoft SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"SAcanuck" <SAcanuck@.discussions.microsoft.com> wrote in message
news:9A6A54AE-1EE6-4A94-9A5C-244E77DD42A8@.microsoft.com...
> I have a Text box containing the following info:
> ="Effective: " & Parameters!PMStartDate.Value & " to "
> & Parameters!PMEndDate.Value
> How do I control the format of the date? I want the Format to be
dd/MMM/yyyy.|||Try this:
1. Pull up the report properties dialog, go to the code tab, and paste the
following into the code textbox:
public shared Function Convert(dt As datetime) As String
return dt.ToString("dd/MM/yyyy")
End Function
2. Paste the following into the textbox in question: ="Effective: " &
Code.Convert(Parameters!PMStartDate.Value) & " to " &
Code.Convert(Parameters!PMEndDate.Value)
The .NET datetime format strings are explained in detail in
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/cpguide/html/cpconcustomdatetimeformatstrings.asp?frame=true.
--
Ravi Mumulla (Microsoft)
SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"SAcanuck" <SAcanuck@.discussions.microsoft.com> wrote in message
news:9A6A54AE-1EE6-4A94-9A5C-244E77DD42A8@.microsoft.com...
> I have a Text box containing the following info:
> ="Effective: " & Parameters!PMStartDate.Value & " to "
> & Parameters!PMEndDate.Value
> How do I control the format of the date? I want the Format to be
dd/MMM/yyyy.|||My favorite way of formatting strings is
=String.Format("From {0:d} to {1:d}", Parameters!
From.Value, Parameters!To.Value)
>--Original Message--
>I have a Text box containing the following info:
>="Effective: " & Parameters!PMStartDate.Value & " to "
>& Parameters!PMEndDate.Value
>How do I control the format of the date? I want the
Format to be dd/MMM/yyyy.
>.
>

Formatting a Text box

I need to format a phone number parameter the user enters. Currently
when I print the parameter it displays like this ##########.
I want to format it to look like ###-###-####.
It can't be done with SQL, it must be done in the VB of that textbox.
Does anyone have any ideas' It would save me from pulling my last
hair out!!Down and Dirty, but:
=Mid(Fields!homephone.Value,1,3) & "-" & Mid(Fields!homephone.Value,4,3) &
"-" & Mid(Fields!homephone.Value,7,4)
You can substitute the Parameter value as Parameters!PHNumber.Value in place
of Fields!homephone.Value if they are entering the phone number in the
parameter box.
Rodney Landrum
"E" <ericfreiman@.mtgsi.com> wrote in message
news:1144097404.116802.178020@.v46g2000cwv.googlegroups.com...
>I need to format a phone number parameter the user enters. Currently
> when I print the parameter it displays like this ##########.
> I want to format it to look like ###-###-####.
> It can't be done with SQL, it must be done in the VB of that textbox.
> Does anyone have any ideas' It would save me from pulling my last
> hair out!!
>|||Hi,
Just select the cell you want to display with format right click and click
properties and select Format tab on the format field select "..." and click
custom and type "###-####"
Amarnath
"E" wrote:
> I need to format a phone number parameter the user enters. Currently
> when I print the parameter it displays like this ##########.
> I want to format it to look like ###-###-####.
> It can't be done with SQL, it must be done in the VB of that textbox.
> Does anyone have any ideas' It would save me from pulling my last
> hair out!!
>

Formatting a number field within a text box

I have a number of occassions to place a database field inside a bunch of
hardcoded text. But, it seems I can't do this if I want to format the number
(or field). Below is an example.
Your score this <DB Field1> is <DB Field2>%.
For DB Field1, the database stores a date/time format (6/1/2004 12:00:00AM).
I want to format it so it says June 2004. This is no problem, until I put
the field in an expression.
For DB Field2, the database stores the number as 69.15 (as an example). I
need 69.2. I can do this with no problem - as long as I don't try to put it
in an expression.
Is this normal behavior and is there any way around it?
Thanks
LeighEnter the following in the cell\textbox.
="Your score on " & Format(Fields!DBFiel1,"Y") & " was " &
Format(Fields!DBField2,"N1") & "%"
"Leigh" wrote:
> I have a number of occassions to place a database field inside a bunch of
> hardcoded text. But, it seems I can't do this if I want to format the number
> (or field). Below is an example.
> Your score this <DB Field1> is <DB Field2>%.
> For DB Field1, the database stores a date/time format (6/1/2004 12:00:00AM).
> I want to format it so it says June 2004. This is no problem, until I put
> the field in an expression.
> For DB Field2, the database stores the number as 69.15 (as an example). I
> need 69.2. I can do this with no problem - as long as I don't try to put it
> in an expression.
> Is this normal behavior and is there any way around it?
> Thanks
> Leigh

formatting a field

I'm trying to format a text box color using an expression
= (Field!Name.Value < 0, "Red", "Black") but system send this error
The color expression for the textbox 'Field name' contains an error
[BC30451] name 'Iff' is not declared.
Please let me know what can I douse =Iif(Field!Name.Value < 0, "Red", "Black")
"Yoya" wrote:
> I'm trying to format a text box color using an expression
> = (Field!Name.Value < 0, "Red", "Black") but system send this error
> The color expression for the textbox 'Field name' contains an error
> [BC30451] name 'Iff' is not declared.
> Please let me know what can I do

Formating a box??

Hi everyone, Im using SSRS 2000 and I was wondering is there a way to
create a click button? I have 2 reports linked with hyperlinks but I
wanted to make it look more presentable. So, instead of just clicking
on the words, if I had a box that looked like a click button would be
more presentable.
Thanks in advance,
AbnerOn Oct 15, 3:51 pm, abz <abz81s...@.gmail.com> wrote:
> Hi everyone, Im using SSRS 2000 and I was wondering is there a way to
> create a click button? I have 2 reports linked with hyperlinks but I
> wanted to make it look more presentable. So, instead of just clicking
> on the words, if I had a box that looked like a click button would be
> more presentable.
> Thanks in advance,
> Abner
No, I'm afraid not. The best way to create this functionality is to
create an ASP.NET application that interacts w/SSRS. Sorry that I
could not be of greater assistance.
Regards,
Enrique Martinez
Sr. Software Consultant|||On Oct 15, 5:40 pm, EMartinez <emartinez...@.gmail.com> wrote:
> On Oct 15, 3:51 pm, abz <abz81s...@.gmail.com> wrote:
> > Hi everyone, Im using SSRS 2000 and I was wondering is there a way to
> > create a click button? I have 2 reports linked with hyperlinks but I
> > wanted to make it look more presentable. So, instead of just clicking
> > on the words, if I had a box that looked like a click button would be
> > more presentable.
> > Thanks in advance,
> > Abner
> No, I'm afraid not. The best way to create this functionality is to
> create an ASP.NET application that interacts w/SSRS. Sorry that I
> could not be of greater assistance.
> Regards,
> Enrique Martinez
> Sr. Software Consultant
oh ok, thanks any way.

Format Text?

If I have a paragraph of text in a text box, but I only want to bold a couple words...how do I do that?Unfortunately this is not currently supported directly. You can cobble together multiple textboxes, or try an external solution like OfficeWriter.

Format text box with parentheses if negative

The users want to see negative values like this:

(-$1,000)

How do I format negative values that way without some major iif statement?

Hello,

I don't think you can unless you use an IIf statement.

=IIf(Fields!Amount.Value < 0, "(" & Fields!Amount.Value & ")", Fields!Amount.Value)

Hope this helps.

Jarret

|||

Haven't tested this formula I think it is similar to what Excel uses.

$#,##0_);(-$#,##0)

or

x,xx0.00_;(x,xx0.00(_)

cheers,

Andrew

|||

I have tested this one though...

#0.00;(#0.00)

cheers,

Andrew

|||

Try to use

FormatNumber(field!Num.Value, 0, 0, -1, 0)

This might work for you.

-Rohit

|||

Well, I've learned my something new for today. I'm guessing when you use a semicolon, the left side is the format for positive numbers and the right is for negative numbers? Thanks Andrew!

This one worked for me.

$#,##0.##;(-$#,##0.##)

Jarret

Format on text box not working as expected

I have a table in a report that is displaying some call duration data. I
have a field that averages the results and displays them. My issue is the
result is often a number with many decimal places (example 15.888883) and I
would like the field to display a whole number (example 15).
In report designer I right click on the cell in the table I wish to alter
and choose properties. In the Textbox Properties window under Format I
select Number and then 1234 (custom code D0) and click OK. I then preview
the report and the number still shows a bunch of decimal places.
When I go back to check the properties of the cell the Format is often reset
back to 'Default' as if it didn't save my select. I've tried using the
Standard and Custom radio buttons under Format but nothing I do seems to
change the display of the number to a nondecimal type. I'm sure I can run a
function that rounds the number but I'd much rather do it in the display as
it seems you should be able to do.
Any help would be appreciated!
Peace,
DanDan,
I'm not aware of this as a bug but if it is try setting it in the
properties window (not the same as right-click|properties) if you can't
see it, press F4. You will see a 'Format' property, set that to d0 or
alternatively try n0 (puts a comma in as a thousands seperator).
Chris
Dan Christjohn wrote:
> I have a table in a report that is displaying some call duration
> data. I have a field that averages the results and displays them. My
> issue is the result is often a number with many decimal places
> (example 15.888883) and I would like the field to display a whole
> number (example 15).
> In report designer I right click on the cell in the table I wish to
> alter and choose properties. In the Textbox Properties window under
> Format I select Number and then 1234 (custom code D0) and click OK. I
> then preview the report and the number still shows a bunch of decimal
> places.
> When I go back to check the properties of the cell the Format is
> often reset back to 'Default' as if it didn't save my select. I've
> tried using the Standard and Custom radio buttons under Format but
> nothing I do seems to change the display of the number to a
> nondecimal type. I'm sure I can run a function that rounds the number
> but I'd much rather do it in the display as it seems you should be
> able to do.
> Any help would be appreciated!
> Peace,
> Dan|||Chris,
Thank you for your reply. d0 did not work and that was a value for format
that I had already tried. n0 however worked great and change the display
from 8.333333336 to 8 exactly the way I want it. Weird how that's not one of
the choices when you rightclick/format and it shows the standard formatting.
Oh well it works, thanks much!
Peace,
Dan
"Chris McGuigan" <chris.mcguigan@.zycko.com> wrote in message
news:ez03hkRiFHA.1204@.TK2MSFTNGP12.phx.gbl...
> Dan,
> I'm not aware of this as a bug but if it is try setting it in the
> properties window (not the same as right-click|properties) if you can't
> see it, press F4. You will see a 'Format' property, set that to d0 or
> alternatively try n0 (puts a comma in as a thousands seperator).
> Chris
>
> Dan Christjohn wrote:
>> I have a table in a report that is displaying some call duration
>> data. I have a field that averages the results and displays them. My
>> issue is the result is often a number with many decimal places
>> (example 15.888883) and I would like the field to display a whole
>> number (example 15).
>> In report designer I right click on the cell in the table I wish to
>> alter and choose properties. In the Textbox Properties window under
>> Format I select Number and then 1234 (custom code D0) and click OK. I
>> then preview the report and the number still shows a bunch of decimal
>> places.
>> When I go back to check the properties of the cell the Format is
>> often reset back to 'Default' as if it didn't save my select. I've
>> tried using the Standard and Custom radio buttons under Format but
>> nothing I do seems to change the display of the number to a
>> nondecimal type. I'm sure I can run a function that rounds the number
>> but I'd much rather do it in the display as it seems you should be
>> able to do.
>> Any help would be appreciated!
>> Peace,
>> Dan
>|||Hi,
I just had the exact same problem. Choosing D0 does not work, but N0
does. This behaviour is weird and should be fixed because N0 puts a
comma in there.
e.g.
source = 2793.333333
D0 = 2793.333333
N0 = 2,793
When what I really want is 2793!! I think this is a bug. Internally,
the casting from float (with decimal) places is not being converted to
integeter properly.|||I think n with no zero will remove the comma but I'd have to test it to be
sure.
"Roy Assaly" <royassaly@.gmail.com> wrote in message
news:1121885650.591601.179260@.g43g2000cwa.googlegroups.com...
> Hi,
> I just had the exact same problem. Choosing D0 does not work, but N0
> does. This behaviour is weird and should be fixed because N0 puts a
> comma in there.
> e.g.
> source = 2793.333333
> D0 = 2793.333333
> N0 = 2,793
> When what I really want is 2793!! I think this is a bug. Internally,
> the casting from float (with decimal) places is not being converted to
> integeter properly.
>|||Hi Dan,
Just tested it:
source = 2793.333333
n = 2793.33
N = 2793.33
No difference. I still believe that D0 is the problem and that it's a
bug.|||'n' on it's own will always default to 2 decimal places.
I think the 'D' issue is because d or D is also a date format code it
may be getting confused!?!
You may want to consider custom format codes.
#0 or ## will give you 2793 with no commas. Using this you can specify
different formatting for positive, negative and zero numbers.
i.e. a format code of #,#;(#,#);"zero" would produce
2793 = 2,793
-2793 = (2,793)
0 = zero
Look up custom format codes in msdn vb help.
Chris
Roy Assaly wrote:
> Hi Dan,
> Just tested it:
> source = 2793.333333
> n = 2793.33
> N = 2793.33
> No difference. I still believe that D0 is the problem and that it's a
> bug.