Archived Months
June 2004
July 2004
August 2004
September 2004
October 2004
November 2004
December 2004
January 2005
February 2005
March 2005
April 2005
May 2005
June 2005
July 2005
August 2005
September 2005
October 2005
November 2005
December 2005
January 2006
February 2006
March 2006
April 2006
May 2006
June 2006
July 2006
August 2006
September 2006
October 2006
November 2006
December 2006
January 2007
February 2007
March 2007
April 2007
May 2007
June 2007
July 2007
August 2007
September 2007
October 2007
November 2007


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 >>



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 >>


DevelopmentNow Blog