Home page access

We are running the June CTP.
When some users go to htttp://theserver/Reports, all they see is the
word 'Home' and a line across the page.
This happens even though I have added these users as both
Administrators and Users.
I imagine that this has something to do with the domain, but I don't
see what arrangement would allow them to get to a partially completed
page.
Any ideas?
JimMake sure the RS services are running under a domain log in and that the
login has permissions on the Tempfiles directory under ths MSSQL.3
directory.
--
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
<jhcorey@.yahoo.com> wrote in message
news:1125062702.187423.141040@.g14g2000cwa.googlegroups.com...
> We are running the June CTP.
> When some users go to htttp://theserver/Reports, all they see is the
> word 'Home' and a line across the page.
> This happens even though I have added these users as both
> Administrators and Users.
> I imagine that this has something to do with the domain, but I don't
> see what arrangement would allow them to get to a partially completed
> page.
> Any ideas?
> Jim
>|||The services are running under a login that is an admin in the domain,
as well as an admin on the machine.
We notice that there is a user group on the machine called.
SQLServer2005ReportServerUser$MSSQLServer. Users that we've added to
this can use RS normally. But as I noted, users that we've added from
the web site cannot. These are all users in the same domain.|||My guess here is that they have not been setup in a role. The windows groups
are for validation of who they are, not what they can do. You need to assign
users or groups to a role (in report manager). Read up in books online about
roles. What I do is have a local group to that local group I add domain
groups and invidual users. I then assign the local group to the browser
role.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
<jhcorey@.yahoo.com> wrote in message
news:1125330865.896229.33860@.f14g2000cwb.googlegroups.com...
> The services are running under a login that is an admin in the domain,
> as well as an admin on the machine.
> We notice that there is a user group on the machine called.
> SQLServer2005ReportServerUser$MSSQLServer. Users that we've added to
> this can use RS normally. But as I noted, users that we've added from
> the web site cannot. These are all users in the same domain.
>|||Ah yes, it was simple of course once one knew where to look -- in the
properties for the home page.
I was thinking that System security would take care of everything.

Holy hordes of transactional data Batman

I did the DBCC Shrinkfile and I get an error saying that
some part of the file is in use and cannot continue.
Is this DB suppost to be off line ?

>--Original Message--
>I have a LOG file of 113Gig with only 29 Gig of free
space
>available on the drive, I have no media that will hold
>this as a backup.
>I ran the "Backup Log" "with_truncate" and "no_truncate"
>but nothing seems to be making this thing disappear.
>What is my next step to dissolving this beast?
>.
>
No, but if you have active transactions, you'll have to wait.
http://www.aspfaq.com/
(Reverse address to reply.)
"Vidro" <Vid_ro@.myalias.postalias.com> wrote in message
news:a49d01c4d71c$5a1db910$a401280a@.phx.gbl...[vbcol=seagreen]
> I did the DBCC Shrinkfile and I get an error saying that
> some part of the file is in use and cannot continue.
> Is this DB suppost to be off line ?
> space

Holy hordes of transactional data Batman

I did the DBCC Shrinkfile and I get an error saying that
some part of the file is in use and cannot continue.
Is this DB suppost to be off line ?

>--Original Message--
>I have a LOG file of 113Gig with only 29 Gig of free
space
>available on the drive, I have no media that will hold
>this as a backup.
>I ran the "Backup Log" "with_truncate" and "no_truncate"
>but nothing seems to be making this thing disappear.
>What is my next step to dissolving this beast?
>.
>No, but if you have active transactions, you'll have to wait.
http://www.aspfaq.com/
(Reverse address to reply.)
"Vidro" <Vid_ro@.myalias.postalias.com> wrote in message
news:a49d01c4d71c$5a1db910$a401280a@.phx.gbl...[vbcol=seagreen]
> I did the DBCC Shrinkfile and I get an error saying that
> some part of the file is in use and cannot continue.
> Is this DB suppost to be off line ?
>
> space

History Limit

I use SQL Server Management Studio and when I View History for a Job there
seem to be a 100 line limit. Some of my jobs have more than 100 steps so
some don't show. Is there a place you can increase that limit a bit?
Thanks
John
Yes -
Check properties of SQL Server Agent and then go to History.
There you can play with your settings.
Enjoy
Immy
"John Holt" <johnh@.regionv.k12.mn.us> wrote in message
news:uAdCacj4GHA.512@.TK2MSFTNGP06.phx.gbl...
>I use SQL Server Management Studio and when I View History for a Job there
>seem to be a 100 line limit. Some of my jobs have more than 100 steps so
>some don't show. Is there a place you can increase that limit a bit?
> Thanks
> John
>
|||John Holt wrote:
> I use SQL Server Management Studio and when I View History for a Job there
> seem to be a 100 line limit. Some of my jobs have more than 100 steps so
> some don't show. Is there a place you can increase that limit a bit?
> Thanks
> John
>
Right-click on SQL Server Agent, choose Properties, go to the History tab...
Tracy McKibben
MCDBA
http://www.realsqlguy.com

History Limit

I use SQL Server Management Studio and when I View History for a Job there
seem to be a 100 line limit. Some of my jobs have more than 100 steps so
some don't show. Is there a place you can increase that limit a bit?
Thanks
JohnYes -
Check properties of SQL Server Agent and then go to History.
There you can play with your settings.
Enjoy
Immy
"John Holt" <johnh@.regionv.k12.mn.us> wrote in message
news:uAdCacj4GHA.512@.TK2MSFTNGP06.phx.gbl...
>I use SQL Server Management Studio and when I View History for a Job there
>seem to be a 100 line limit. Some of my jobs have more than 100 steps so
>some don't show. Is there a place you can increase that limit a bit?
> Thanks
> John
>|||John Holt wrote:
> I use SQL Server Management Studio and when I View History for a Job there
> seem to be a 100 line limit. Some of my jobs have more than 100 steps so
> some don't show. Is there a place you can increase that limit a bit?
> Thanks
> John
>
Right-click on SQL Server Agent, choose Properties, go to the History tab...
Tracy McKibben
MCDBA
http://www.realsqlguy.com

History Limit

I use SQL Server Management Studio and when I View History for a Job there
seem to be a 100 line limit. Some of my jobs have more than 100 steps so
some don't show. Is there a place you can increase that limit a bit?
Thanks
JohnYes -
Check properties of SQL Server Agent and then go to History.
There you can play with your settings.
Enjoy
Immy
"John Holt" <johnh@.regionv.k12.mn.us> wrote in message
news:uAdCacj4GHA.512@.TK2MSFTNGP06.phx.gbl...
>I use SQL Server Management Studio and when I View History for a Job there
>seem to be a 100 line limit. Some of my jobs have more than 100 steps so
>some don't show. Is there a place you can increase that limit a bit?
> Thanks
> John
>|||John Holt wrote:
> I use SQL Server Management Studio and when I View History for a Job there
> seem to be a 100 line limit. Some of my jobs have more than 100 steps so
> some don't show. Is there a place you can increase that limit a bit?
> Thanks
> John
>
Right-click on SQL Server Agent, choose Properties, go to the History tab...
Tracy McKibben
MCDBA
http://www.realsqlguy.com

Highlighting in tables.

I would like to highlight every other line in a table to enhance readability. Is there an easy way to do this? If so, how?

TIAHi Tia,

I just started writing custom code today - so naturally I think it can solve all problems!

I'm thinking you may be able to write custom code to set the table row's background
property based on if it is an "even" or "odd" row. I looked around and there doesn't
seem to be an easy way like we have on ASP.Net grid controls. Has anyone
done something like this using custom code?

Jane|||actually I thgt abt it for a while and its not very complicated. in your properties tab for that textbox or for the row, click on the color property and click on "Expressions" and you can write an expression over there like a regular one

 IIF(Fields!yourval.value <10, " Red", "Blue")

hth|||Dinakar,

Thanks! the expression I finally chose was:

=iif(RowNumber(Nothing) Mod 2, "WhiteSmoke", "White")

set on the row level properties tab in BackgroundColor. This highlights every other row of my table, making it easier to read.

Regards,

Daniel|||

chanbe backgound property of the table as =iif(((rownumber("table1") mod 2)=0),"White","#FFEBBD")

here "table1" is ur table name

sql

Hiding Missing Information

I'm designing a report, where an address will be displayed. There's also line for a P.O. Box, but most of the addresses don't have one, so this line is empty most of the time.

Like:

Name
Street
POBox
City
Phone

If there's no POBox it looks like:

Name
Street

City
Phone

Is there any tqchnique, so that I can get rid of this blank line? And it would look like:

Name
Street
City
Phone

As far as I know, there are no report items, that can hande such a problem. Probably dynamically generating the XML would work, but that's a effort, I want to avoid.

I was just enquiring if you managed to resolve this issue?

Hiding a subreport - How to suppress the blank line ?

Hi, I have a main report with several subreports in a list. If I hide a subreport that contains no data by using the "visibility" attribute, there s always a blank line left in the list. Is there any way to suppress that blank line?

Minimize the size(width and height) of the sub report to the maximum extent.

sincerely,

Amde

|||

Hi,

I have the same problem. I am using a sub report with a table. Even, if I reduce the height to maximum extent, it still adds up and creates blank space. Is there any other way?

Can I suppress a single cell of the table if it is blank?

Thanks in advance !!!

|||Thanks, I tried that before, but that doesn′t solve my problem.
Even when I minimize the height of the line in the main report or the sub report itself, there′s still a noticable blank line. In my case, I′ve got like 6 or more sub reports in that table and even minimized there′s too much blank space if more than one sub reports are hidden.
Isn′t there any way to completley hide the line, where the sub report would have been?
|||Common guys, any "Pro" out there has got to know how to do that?!
Or is it just impossible?
I postet on several forums and a lot of people have this problem, too, but noone seems to have a solution for this.
|||

hi nic

Create an Empty Row in yout table.

Embed the sub-report in this table row.

Hide the table row when theres no data in your subreport.

And it will hide the extra space

|||

Hi,

Right click on the field and go to expression.

In expression type the below

=IIF(Field!FieldName="",true,false)

Regards,

Prashant

|||

What is the actual expression to "Hide the table row when theres no data in your subreport" ?

Thanks,

Pete