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 > september 2006 > threads for thursday september 28

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

Can I build my own Table Style for the report wizard
Posted by Lasse Bjerre Knudsen at 9/28/2006 4:08:25 PM
Hi there, Today I can select different table style in the report wizard e.g. Forest or Slate. Is it possible to customize or create my own table style so it matches our company graphical standards??? Best regards Lasse Bjerre Knudsen ...more >>

Performance Question
Posted by Chris at 9/28/2006 12:52:23 PM
Just curious if anyone has experience with this. SSRS2005 I have a report that has a dataset and populates a table. I have 8 sub-reports that are placed on this report. Is this approach the best for performance, or should I add the other 8 datasets to this one report, and then include a tab...more >>

Reporting Services 2000 with SQL Server 2005 data source
Posted by Woo at 9/28/2006 9:49:01 AM
Hiya, Can anyone confirm if Reporting Services 2000 Reports are compatible with SQL Server 2005 data sources? Has anyone experienced any problems with this setup? Thanks Wendy...more >>

Same report - Different Databases
Posted by Rob at 9/28/2006 9:34:02 AM
I have been creating several reports that point to a test database. I can build and deploy my reports to the Report Server and everything is fine. We also have a DEV database and a PROD database that have the exact same tables/columns as the test db. I would like to point my reports at one ...more >>

Re: Borders on Cells Not Rendering Correctly
Posted by cphite NO[at]SPAM hotmail.com at 9/28/2006 8:56:33 AM
> I am creating a report where I need to create a border around a series > of cells. It looks great when viewing it in Report Manager; however > (there is always a however) when I print the report some borders are > thin and of a lighter weight than they should be. > My cells have a 0 padding,...more >>

Simple report parameter question
Posted by Hong Wang at 9/28/2006 8:16:03 AM
Hi, I am new in Report Service. I have recently set up a report using a stored procedure in SSRS 2005. The stored procedure has two input parameters, So I have set up two report parameters. The two parameters are @state, and @city. They both get their drop-down list from a query. My question i...more >>

List control visible
Posted by Mike OKC at 9/28/2006 8:12:01 AM
I want my list control only be visible if there is data. So, in my report I have several list controls, one of the list controls shows alias data for a customer. If the customer has no alias data then I don't want the alias list control to show. In the alias list control I have several textb...more >>

RS two seperate queries within a report
Posted by aggiechick717 at 9/28/2006 8:09:25 AM
Hi all. I was wondering if I have a report andI want to prompt the user to choose say current inventory or all inventory...Can i do that within a parameter? The problem I'm having is that if the user chooses current inventory it runs a query but if the user chooses all inventory it would hav...more >>



Multi column
Posted by Shan at 9/28/2006 7:41:02 AM
Hi, I dont know how to word this but I'll try. I have a report that shows two field in the output, i.e city and count. When the report is run it displays about 44 rows on one page, but since there are only two fields the rest of the page is left blank on the right hand side which can easil...more >>

Print Multi table report with a range of parameters.
Posted by msc at 9/28/2006 7:19:07 AM
We have a work order print that is called from a web page using a URL. The print consists of 4 tables. All of the recordsets use the same parameters but come from different data sets. I have a request to make it print multiple work orders at a time. When I use a select for multiple wor...more >>

Checkbox in reports
Posted by Gaurav at 9/28/2006 6:51:01 AM
I have a report on which i want to add a checkbox to the extreme left of every row and allow the user the ability to select it, hit a button named "Export" and move the contents of only that row to MS Excel. Does Reporting services 2000 support this? Any suggestions on how this can be done?...more >>

Get Toggle state at report runtime
Posted by FidelR at 9/28/2006 5:16:02 AM
Hi, I would like to find the toggle state of a textbox in the report to set an expression according to that state. I need to navigate to a second report with different parameters according to the toggle state of a particular row in my report. How do I write the expression (something like ii...more >>

Default start date 01/01/YEAR
Posted by !m NO[at]SPAM pe NO[at]SPAM ce at 9/28/2006 12:58:46 AM
hi... i need help from u all... i have a problem about SSRS 2005.. the problem is; i have to default start date to "01/01/year" any ideas how to get the current year?...my end date is key in by user... i have try this =cdate("01/01"+cstr(parameter!endDate.value )) but it not works.. :( tha...more >>


DevelopmentNow Blog