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 > may 2006 > threads for monday may 8

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

Prompting for userid and password
Posted by Ashok Segu at 5/8/2006 10:21:01 PM
Hi, I have a web application which is calling a reporting services URL to load couple of reports. The web server is on Machine A and the reporting services and the SQL Server are on Machine B. Both the Machines A and B are not on any domain... But when I log into my website and then try to...more >>


Reporting Services and Temp tables
Posted by jenniperez NO[at]SPAM gmail.com at 5/8/2006 2:47:16 PM
Here is the code I am using, you can disregard the drop statements, cause they have been taken out. If I choose text in the dataset, I get the table already exists error, if I choose Stored Procedure, I get an RPC error, any help would be appreciated. Thanks DROP TABLE #BPDET_05 SELECT CUST...more >>

jumping to a report
Posted by raj at 5/8/2006 1:03:01 PM
I have a wierd problem here. I am using jump to a report feature and passed 2 parameters to the report. It works fine in the review but when i see that in the webpage (i did using reportviewer) it does not show the report and gets to the first page of the report. Please help me out...more >>

Fatal Error on Uninstall of RS2000
Posted by Joshua A. Booker at 5/8/2006 12:40:54 PM
Hi there, I get a Fatal Error when I try to uninstall SSRS 2000. I can't find any directions to do a manual uninstall. Can someone help? TIA Josh ...more >>

Adding Linebreaks at specified positions in a string
Posted by Elliot Rodriguez at 5/8/2006 12:02:18 PM
I have a record with a row that can contain a long comma delimited string. In my ASP.NET version of my report, I have a small routine that checks if this string exceeds X number of characters. If so, then I add a breaking character after a comma where the comma appears either exactly at X or ...more >>

Create report items dynamically - how?
Posted by szabti at 5/8/2006 11:41:57 AM
Hi, All, I have a report with a parameter (a combo box with two names), that only show the CompanyName on the report. When I choose Name No1, I would like to show 4 textboxes, and choosing the name No2, I would like to show another one, and hide the pevious four. I'm going to make these tex...more >>

Counting Group fields
Posted by Jackson at 5/8/2006 10:38:52 AM
Is there a way I can count the number of grouped items in a textbox in a report? When I try to use =count(Fields!UserID.Value), the report gives me the amount of records in the query. I also tried using count distinct but that returned the same results. Is there anyway I can just count ...more >>

report designer
Posted by Lynn at 5/8/2006 9:32:02 AM
Hi there. Please understand, I am very new to reporting services. I upgraded from VS 2003 to VS 2005 last week, and now I am struggling to even get to the projects/reports I had already created. The layout, the start page -- everything is pretty different, old or new, I can't even open Repo...more >>



rotate a text box 270 deg
Posted by Rao Gadde at 5/8/2006 8:12:02 AM
I use Text WritingMode property is tb-rl, to display text in verticle direction (i.e 90 degrees). now I wanted to make 270 degrees is it possible to rotate text in 270 degrees. Please reply. Thanks, -- Rao...more >>

Visibility check amend font weight
Posted by IanP at 5/8/2006 8:02:02 AM
Can somebody confirm if the following code is correct or if my approach is incorrect. It accepts the code but when the + sign is pressed to expand the row the formatting does not change: =iif(("TableRow4") = "Collapsed","Bold","Normal") If this row in the report is visible font weight for...more >>

HttpContext
Posted by Maran at 5/8/2006 7:01:03 AM
Running a report with several DataSets (parameters not included) looses HttContext for the second DataSet. We are using a Data Extension Provider to manage permissions on data. To check permissions we need the HttpContext for user info (it's a must). "Unfortunatley" Reporting Services start...more >>

Problem Rendering report via URL
Posted by gdjoshua at 5/8/2006 6:44:02 AM
Here's the link: http://dvws02ms.firm.jonesday.dv:800/Reports/Pages/Report.aspx?ItemPath=%2fCLE+Reports%2ftest&rs:Command=Render&Type=O My report is called test and it has one report parameter, Type. Somehow if just keeps prompting me that the parameter is missing. Anybody had problems w...more >>


DevelopmentNow Blog