Forms Authentication

I've successfully set up RS to use Forms Authentication. However, here's
something strange. The first time I access Report Manager (say after a
reboot) and enter the admin credentials, RS churns and churns, then I end up
back at the login screen. If I enter the same credentials again, I get
logged in successfully.
Any one else experience this issue?
ThxAre you using the same server name to access the report server in your
browser as is set in the config files? If not, the cookie won't be getting
through due to cross-(web)domain security.
--
Cheers,
'(' Jeff A. Stucker
\
Business Intelligence
www.criadvantage.com
---
"FNDS" <absolutelynospam@.nodomain_.com> wrote in message
news:ezRzXl%239EHA.1396@.tk2msftngp13.phx.gbl...
> I've successfully set up RS to use Forms Authentication. However, here's
> something strange. The first time I access Report Manager (say after a
> reboot) and enter the admin credentials, RS churns and churns, then I end
> up back at the login screen. If I enter the same credentials again, I get
> logged in successfully.
> Any one else experience this issue?
> Thx
>|||"Jeff A. Stucker" <jeff@.mobilize.net> wrote in
news:ugC03WC#EHA.3708@.TK2MSFTNGP14.phx.gbl:
> Are you using the same server name to access the report server in your
> browser as is set in the config files? If not, the cookie won't be
> getting through due to cross-(web)domain security.
>
So, how do you address this issue in a hardware load balanced, web farm?
We have a single URL (domain) (ex. http://reporting.xxxxxxx.com/Reports)
but each machine naturally maintains a unique IP that I'm assuming is being
used by each machine when setting the cookie. The web.config files have
matching <machinekey> values to allow for Forms Auth in a web farm but I
don't know how to control the domain of the cookie.

Formatting, pdf, and SP2

I have a strange issue that I need help resolving. Basically, the formatting
on a report that I am exporting to pdf changed when I updated my VS to the
SP2 of the Reporting Services. Here's what I am trying to do and what SP2 did:
I have a report that I created that makes address labels. I made it to where
it has three columns, and it fit 10 rows on one page. It worked great, until
I installed SP2. Now, it will only print three across the top of the page,
then move on to the next page.
So, my questions are: 1) should I reinstall pre-SP2 RS so that I can do this
report the way that I had it, or 2) does anyone know of an example that will
help me to do what I had done in the pre-SP2 installation?
Any help would be greatly appreciated!!!It sounds weird, and at least I don't know if this is either caused by the
SP2. But what you can do is redefine your report's margins

Formatting

Hello all, I have a strange problem that i need some advice on. I have the following field called FILENO. It is a SQL 2000 field with the Data Type set to Char (7). The following sql statement works perfectly: SELECT TOP 1 RTRIM(FILENO) AS TEST, RIGHT(DATEPART(Yy, FILENOYEAR), 2) AS YEAR FROM tblRecords WHERE RIGHT(DATEPART(Yy, FILENOYEAR), 2) = '05' ORDER BY FILENO DESC It returns the correct data, 0050. Now, what i'm trying to do is add 1 to the value so i can get the next available number which is 0051. But, when i run the following sql statement, i get 51 instead of 0051. SELECT TOP 1 RTRIM(FILENO+1) AS TEST, RIGHT(DATEPART(Yy, FILENOYEAR), 2) AS YEAR FROM tblRecords WHERE RIGHT(DATEPART(Yy, FILENOYEAR), 2) = '05' ORDER BY FILENO DESC Does anyone have an idea how to solve this? Thanks. Richard M.

do you convert it to Char(7) after you add 1 ... so that will reformat it to the char rather than integer

Format(Now(), "yyyymm") shows minutes instead of months?

Just ran into a strange error.
I want to see what year and month it is today, like 200411 for November,
2004. I've added a textbox to show this, and set the value to
="Month: " & Format(Now(), "yyyymmmm")
For some reason, this shows 200430, because the time is 09.30 on my
computer. I've tried with m, mm, mmm and mmmm, and it just shows the
minutes. Why?
I tried using VBA!Now() but then I get an error saying "VBA is not
declared". Where do I need to declare it?
Running VS.NET 2003 with the Report Designer installed. The Report Server is
Ent. edition, and it shows the same error when I upload the report.
Any help appreciated!
Kaisa M. LindahlTry "yyyyMMMM".
A really good page for all .NET format code is:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/cpguide/html/cpconformattingtypes.asp
"Kaisa M. Lindahl" <kaisaml@.hotmail.com> wrote in message
news:ePUM8bjxEHA.1392@.tk2msftngp13.phx.gbl...
> Just ran into a strange error.
> I want to see what year and month it is today, like 200411 for November,
> 2004. I've added a textbox to show this, and set the value to
> ="Month: " & Format(Now(), "yyyymmmm")
> For some reason, this shows 200430, because the time is 09.30 on my
> computer. I've tried with m, mm, mmm and mmmm, and it just shows the
> minutes. Why?
> I tried using VBA!Now() but then I get an error saying "VBA is not
> declared". Where do I need to declare it?
> Running VS.NET 2003 with the Report Designer installed. The Report Server
is
> Ent. edition, and it shows the same error when I upload the report.
> Any help appreciated!
>
> Kaisa M. Lindahl
>|||USE Format(Now(), "yyyyMM")
"Kaisa M. Lindahl" wrote:
> Just ran into a strange error.
> I want to see what year and month it is today, like 200411 for November,
> 2004. I've added a textbox to show this, and set the value to
> ="Month: " & Format(Now(), "yyyymmmm")
> For some reason, this shows 200430, because the time is 09.30 on my
> computer. I've tried with m, mm, mmm and mmmm, and it just shows the
> minutes. Why?
> I tried using VBA!Now() but then I get an error saying "VBA is not
> declared". Where do I need to declare it?
> Running VS.NET 2003 with the Report Designer installed. The Report Server is
> Ent. edition, and it shows the same error when I upload the report.
> Any help appreciated!
>
> Kaisa M. Lindahl
>
>|||Using MM instead of mm|||Tried this, and it works.
Thanks to all who answered. And for the url too.
Kaisa
"David Hughes" <spamfree@.freespam.com> wrote in message
news:uFg6$NkxEHA.1400@.TK2MSFTNGP11.phx.gbl...
> Try "yyyyMMMM".
> A really good page for all .NET format code is:
>
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/cpguide/html/cpconformattingtypes.asp
>
> "Kaisa M. Lindahl" <kaisaml@.hotmail.com> wrote in message
> news:ePUM8bjxEHA.1392@.tk2msftngp13.phx.gbl...
> > Just ran into a strange error.
> > I want to see what year and month it is today, like 200411 for November,
> > 2004. I've added a textbox to show this, and set the value to
> > ="Month: " & Format(Now(), "yyyymmmm")
> >
> > For some reason, this shows 200430, because the time is 09.30 on my
> > computer. I've tried with m, mm, mmm and mmmm, and it just shows the
> > minutes. Why?
> >
> > I tried using VBA!Now() but then I get an error saying "VBA is not
> > declared". Where do I need to declare it?
> >
> > Running VS.NET 2003 with the Report Designer installed. The Report
Server
> is
> > Ent. edition, and it shows the same error when I upload the report.
> >
> > Any help appreciated!
> >
> >
> >
> > Kaisa M. Lindahl
> >
> >
>