all groups > sql server reporting services > june 2005 > threads for monday june 20
Filter by Day: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30
401: Access denied error after couple of hours of IIS restart
Posted by Milu at 6/20/2005 7:36:06 PM
I have a web application that accesses Reporting Services via Web Service
calls. Also, Forms authentication is configured to be used by RS. All works
fine on my local development machine. But after deploying it to production
server, I am facing Http status 401: access denied error. If I restar... more >>
now to make sub report NOT visible based on value in another field
Posted by moondaddy at 6/20/2005 5:23:09 PM
I have a report that has a number of sub reports. sometimes a report
doesn't need certain sub reports due to the nature of the data. In these
cased I wanted to set the sub report visible property to False and hope that
the space where it resides would collapse. 2 Ways I can think of doing t... more >>
Deploy Asks for Username and Password - Can't Deploy
Posted by Hunter Hillegas at 6/20/2005 4:51:03 PM
Today I installed SP2 on my client and rebooted.
Since then, when I try to deploy from Visual Studio, I get a box that pops
up that asks for a username and password. I tried entering everything under
the sun but I can't get past it.
The user I am logged in as is part of the Administrators ... more >>
Sorts
Posted by Danielle at 6/20/2005 4:25:30 PM
We want to be able to have a parameter for which column to sort the report
on and am having a hard time trying to figure out the parameter value for
sorting on a Total (calculated) field.
Does anyone have any ideas on how to do this?
Danielle
... more >>
Outlook Data as a Source
Posted by Jack Bender at 6/20/2005 3:44:03 PM
We have a few legacy Crystal Reports that we have written that group,
calculate, etc. Outlook Calendar and conctact information. We are looking to
replace these with SQL Reports, but when I looked at my connection info under
SQL Reporting, I did not see anything that can effectively query Out... more >>
windows logs parsing report ?
Posted by Simo Sentissi at 6/20/2005 3:28:05 PM
hello there
is there any guide or premaid reports that parses trough windows logs
exported to sql server ?
I want to know before I write anything ?
thanks
... more >>
Target New Window
Posted by Davie at 6/20/2005 3:20:07 PM
How can I set a link to a subreport to target a new window, i.e., open in a
new browser instance?
... more >>
Does RS use the MS FullText Search Engine?
Posted by RayG at 6/20/2005 2:33:01 PM
Not sure what this question means, but I am being asked this by our
Technology Department.
Somehow the SQL Server instance where the Report Server databases were got
dettached. They were able to re-enable it, but they cannot restart this
engine because of a corrupt configuration file.
T... more >>
Don't see what you're looking for? Search DevelopmentNow.com.
Textbox Properties
Posted by Don H at 6/20/2005 1:55:03 PM
Is there a way to access a textbox's properties with similar syntax below:
=ReportItems!textbox22.visibility.hidden = true
I noticed only value was available for the ReportIems Global Var, I was
wondering if something else was available.
I need to check the visibility of a textbox to set a ... more >>
DayOfWeek Function
Posted by Glass at 6/20/2005 1:55:02 PM
Would like to set a date parameter default in the report designer based on
the day of the week. So if it was Monday, then the default date would be set
to =today.adddays(-3) otherwise it would default to =today.adddays(-1). Is
there a dayOfWeek function that be used in an expression that retu... more >>
seriouse problem
Posted by Wei Ming at 6/20/2005 10:45:06 AM
I am using RS, sp3 + VS 2003, Here is what I suffered.
when I use union in my script and use parameter, sometime it will cause SQL
Server shut down without any warning!
It happened 3 times and I am sure VS has some problem. Not sure if any one
out there has the same problem????
There are 50... more >>
highlighting a table row
Posted by Glass at 6/20/2005 8:49:03 AM
Have generated a report that uses a table. In the table are 2 fields, the
first is a severity and the last is the timeOfResponse which is a numeric. I
would like to highlight a row if the combination of severity and
timeOfResponse exceeds a maximum. Is this possible for a table? If not, in... more >>
Changing PDF Output Orientation
Posted by Bob at 6/20/2005 8:26:10 AM
I have created report subscriptions for my end users which are emailed
PDF format reports. However, the default report orientation is PORTRAIT
but this format causes the reports to be generated in a very unreadable
way.
Is there a solution to changing the orientation to LANDSCAPE?
Thanks.
... more >>
Need a good start on matrix type report, please
Posted by Bob Hansen at 6/20/2005 7:57:10 AM
I've got the following data I need to report in this format:
Stage P Screen RE-Screen GrdTotal
user1 1 2
3
user2 2 1 ... more >>
Q: Standard or Enterprise
Posted by JIM.H. at 6/20/2005 7:05:04 AM
Hello,
Can I use my Standard SQL Server and Reporting services and run report
though our company’s internet site for everyone? Or does it have to be an
Enterprise version of SQL Server?
Thanks,
Jim.
... more >>
calculating percents in a group header
Posted by reportwriter at 6/20/2005 7:04:01 AM
I am attempting to calculate a percent value in a group header of a report.
My formula looks somethig like:
Iif(sum(Fields.empgolamt.Value,â€table1_Group2â€) <> 0,
sum(Fields!empamt.Value,â€table1_Group2â€) /
sum(Fields!empgolamt,â€table_Group2â€), 0)
but this results in a divide ... more >>
How do you put point labels outside the pie chart?
Posted by Meaghan Sullivan at 6/20/2005 6:30:01 AM
I have a pie chart that is showing the point labels inside the chart. How do
you force the chart to show the labels outstide with a line connecting them
to the slice?... more >>
|