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 > august 2006 > threads for thursday august 3

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

SSRS 2005 - Logon Failure: Unknown user name or password
Posted by wardellcastles at 8/3/2006 7:35:19 PM
Whenever I run a report in SSRS 2005, I receive the message: Logon failed (rsLogonFailed) Logon failure: unknown user name or bad password. (Exception from HRESULT: 0x8007052E) Can someone give me a hint as to what the report was logging into when it failed? Was it the data source log...more >>

Possible todo some form of DISTINCT filtering?
Posted by Tarun Mistry at 8/3/2006 5:43:08 PM
Hi guys, I have a dataset that returns rows that look like the following field | value ----------- 1 | 7 1 | 7 2 | 4 8 | 90 Is it possible to remove the duplicate (1 | 7) row directly within a LIST control (or similar?)? I cannot use a DISTINCT directly in the SQL as e...more >>

how to total fields within footer
Posted by silverblatt NO[at]SPAM att.net at 8/3/2006 1:21:27 PM
I have a report footer which includes a number of totals fields. Each of those fields is computed based on various fields in the data set, using some rather long expressions. What I need now is to add a new "super total" field that displays the sum of three of the other total fields. The onl...more >>

next line
Posted by Ben Watts at 8/3/2006 12:45:39 PM
is there a way in an expression that I can tell it to carry over to the next line? ...more >>

chart visibility
Posted by Ben Watts at 8/3/2006 12:19:23 PM
Is there a way to may a chart show up if there is no data shwoing up. I have a pie chart and when there is nothing to sum it doesnt show, I would either like it to show up or display a message in lieu of that. Thanks ...more >>

Learning the Basics
Posted by CLM at 8/3/2006 11:32:01 AM
What's the best way to learn the basics of Reporting Services (for 2005 for starters)? Is there a site/article/book/link that has what I need to get going? I just want to get the installation going and set up a few basic reports....more >>

Convert DateTime Parameter to String
Posted by RAGHAVAN JAYARAMAN at 8/3/2006 11:16:11 AM
I have 2 reports and i have enabled Drilldown(Navigation) for the 1st Report. One of the Parameter is DateTime which is passed to the 2 reports which should treat this parameter as string since it's defined as string. How will i convert the DateTime to string Parameter for the Drilldown report....more >>

Report Builder Problem
Posted by Mike Read at 8/3/2006 11:03:21 AM
I am having trouble with the Report Builder toolbar button is not showing up on the reports pages of my reporting services. If I run http://servername/reportserver/reportbuilder/reportbuilder.application then it will open the report builder and I can built reports and save back to my rep...more >>



Error report: Interactive sorting loses the image reference
Posted by Steve MunLeeuw at 8/3/2006 9:47:00 AM
I have a table using the interactive sort feature and an image on each row. On the report server when I sort the column the images are lost and a broken link is displayed. In the Designer preview window the images are not lost. Anyone else share my experience, and does anyone know how to work...more >>

Very Strange Pagination Problem
Posted by randy1200 at 8/3/2006 9:02:01 AM
Working with SSRS2005. A while back, I created a report that makes a new report page for every record in the database. I found that making the background one big list1 box, then putting textboxes with values like field!recordid.value in them gave me exactly the one database record per page ...more >>

Insert a Page
Posted by sperotti at 8/3/2006 8:17:03 AM
Is there any way to insert a page into a report programatically or otherwise. I have a report where the users want to choose to insert a coverpage in a report. The scenario is that the user has a report options screen in the user interface. One of the options is to create a coverpage. If t...more >>

Custome code not working in Report manager
Posted by RajDeep at 8/3/2006 2:07:41 AM
Hi all, I have Written the Custom code to compare two different dates and show a message Box depending on their values .It was Working Fine in preview tab.But it is not working when i deploy to web.Only rhe message box part is not working in Web I do have the Custom code like this Publi...more >>

Change all FontFamily
Posted by ad at 8/3/2006 12:00:00 AM
How can I change all the font family of all controls in a report? ...more >>

Dynamic columns in report
Posted by Tanmaya Kulkarni at 8/3/2006 12:00:00 AM
hi, In RS2005, is it possible to add / remove report columns dynamically. I mean the user will have choice to see which columns he wants to see in the report. Depending on his selection, the report will be rendered. Is this possible? TIA, Tan ...more >>

Comments
Posted by Steve Dearman at 8/3/2006 12:00:00 AM
Does anyone know how to add a comment in a sql statement in reporting services, all the normal types e.g /*comment*/ and -- comment Dont work, it just removes then as soon as you move away from the sql window. could maybe be a menu choice but i cant find it! Help please Steve D ...more >>


DevelopmentNow Blog