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 > october 2006 > threads for friday october 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 31

Dynamic SQL Stored Procedure problem
Posted by AB at 10/20/2006 6:20:39 PM
Hi, I have a project that all its reports are based on Dynamic SQL Stored Procedure. First, I had to handle the problem that in the Layout Tab there were no fields by adding them manually. However, when I try to show the report in the Preview tab I got the error: "Procedure x Expects a paramete...more >>


Reporting services caching data !!!
Posted by fitim skenderi at 10/20/2006 3:53:07 PM
Hi all, I have a smart client application that hosts an instance of IE. After user selects different seetings (parameters) create a URL and ask the IE to navigate to it. First time I get proper data. The problem starts when user clicks on the button to view the same report with same parameter...more >>

double-hop authentication for SSRS and ASP
Posted by susiedba NO[at]SPAM hotmail.com at 10/20/2006 3:25:03 PM
hey I work in a SSRS environment; I also do some web dev.. and we keep on having authentication problems getting a token to pass from one user to the webserver; and then to the database server. this is called 'double-hop' authentication.. right? I'm of the understanding that I need to che...more >>

No Report Server was found at http://<servername>/ReportServer
Posted by mmc at 10/20/2006 12:42:02 PM
I installed two instances of SQL Server in one machine (2000/2005). 1. On SQL 2000 (after the .rds and .rdl files are set up) - Whenever I press F5 on VS.NET 2003 the error is: "No Report Server was found at http://<servername>/ReportServer 2. On SQL 2005 (after the DS,DSV,RM are set up)...more >>

Parameter bar collapsed with JumpTo
Posted by Steve at 10/20/2006 12:01:02 PM
I have a report that I am jumping to from another report. It has several parameters that are passed in, which I don't want to show. That part works fine. It also has one that is defaulted that I want displayed so that the user can change the values. The problem is that when the report is jumpe...more >>

ReportViewer does not print on first attempt
Posted by Cathy at 10/20/2006 12:00:03 PM
Hi, Has anyone found a solution to the problem of the reportviewer not printing the first time you try to print? We found a solution on another newsgroup but it doesn't fully resolve the problem. Me.ReportViewer1.SetDisplayMode(Microsoft.Reporting.WinForms.DisplayMode.PrintLayout)Me.Report...more >>

Formating a numeric string, that is sometimes text
Posted by msflinx at 10/20/2006 11:30:02 AM
The old string didn't move up when I replied to it, so copied the information into this new question --------------------------------------------------------------------------------- OK -- this works to a point. I have real string data in my field that I want to display, if the field is not...more >>

complex report
Posted by Chop at 10/20/2006 10:43:01 AM
have the following data from a query age sex 39 M 48 F 14 M etc... need to be displayed as Age Group Number of Male Number of Female Total in Age Group 0 -2 2 3 5 3 - 9 ...more >>



displaying date ranges in the report header
Posted by jai at 10/20/2006 10:19:04 AM
I am using a table to structure my report. Body of the report Table header Group Header Details Group Footer Table Footer Earlier I had put the report name with the company logo in the report header section but now I moved it to the body of the report just above the table. I am trying...more >>

Custom assembly call in footer looses property values.
Posted by Steve MunLeeuw at 10/20/2006 9:22:21 AM
Custom assembly call in footer looses property values. I have a custom assembly that uses a method in the body to pass in a data field. When I fetch the data in the body I get my data back. When I do the same in the footer I don't get any data. I have an active call in with Microsoft so wi...more >>

Possible to grab Report Authors name to use in report?
Posted by JH at 10/20/2006 8:31:03 AM
Hi all, We would like to put the Report Authors name in the footer of our reports. I know there is a global "User!UserID" that picks up whoever runs the report, but is it possible to pick up the windows logon, or something to automatically fill in a field for report author? Thanks JH ...more >>

how to limit the characters in the string report parameter?
Posted by Vinod at 10/20/2006 8:26:03 AM
i have added one string parameter in the report. is it possible to limit the characters in the string parameter. so that use cannt enter the characters more than 30. any suggestions Thanks Vinod ...more >>

Problems using Split function
Posted by JH at 10/20/2006 7:39:02 AM
Hi, I'm trying to use the common text function "Split" to split the report name. An example report name would be "REF001-Title of Report". I'd like to be able to split this report name global into "REF001" and "Title of Report" However I can't get my head around the way Reporting Services...more >>

sql_variant is invalid error
Posted by randy1200 at 10/20/2006 6:41:02 AM
Using Visual Studio 2005 is create Reporting Service 2005 reports. In the Layout tab, I click Report -> Report Properties -> Code tab, and enter the function below. Then I go to the Data tab, click the elipse (...), and go to the Parameters tab. I create a parameter as follows: @UtcL...more >>

String Date Reformat
Posted by randy1200 at 10/20/2006 6:03:01 AM
I get a date value as a string from the following t-sql: select Convert(varchar(30), GetDate(), 11) as 'TheDate' which returns a yy/mm/dd format. Please don't ask me to changethe t-sql. In this instance, that's out of my control. In my Reporting Service 2005 report, I thought I could r...more >>

Report Services Bug? ----Sub Report and Page break!!!
Posted by CEO at 10/20/2006 4:55:02 AM
When the main report calls the meeting sub report, if the content of the sub report is longer than the pare space on the current page, it will jump to the next page without filling the rest space on the current page. Is it a bug of Report Services?...more >>

Users Cannot See Report Builder Button
Posted by Paul Paintin at 10/20/2006 12:00:00 AM
Hey. New server, SQL2005 including Reporting Services - as a domain admin I can log onto the Report Manager website, see & click the Report Build button all good. A 'normal' user browses the site and cannot see the Report Builder button; they can run the Report Builder app using the dire...more >>


DevelopmentNow Blog