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 > january 2006 > threads for tuesday january 31

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

Moving Reporting Services
Posted by Jason Wood at 1/31/2006 8:51:55 PM
I have two servers, one being the SQL server with RS db, one being the webserver with reporting services on it. I want to replace this webserver slowly by installing reporting services on a new server but at the same time being able to access the reports on the old server until we take it off...more >>


DateTime Picker does not work all the times
Posted by Minal at 1/31/2006 5:22:26 PM
Hi, I am using DateTime parameters for SQL 2005 Reports that are converted from SQL 2000. The report works fine for me but my client complains that the Datetime pop-up does not come up always on clicking the date button. It comes up but at times after 3-4 clicks. Any idea as to why ...more >>

Possible to Create Report model - mySQL
Posted by carolus.holman at 1/31/2006 1:40:30 PM
Is it possible to create a Report Model based on a mySQL server? i am getting errors: ERROR [42000] [MySQL][ODBC 3.51 when connecting. Ihave been able to write standard reports but am running into this issue. Also I was looking into using the DotNet Data connector but cannot figure out how to ...more >>

ReportViewer control doesn't accept Parameters
Posted by Raghu at 1/31/2006 1:14:15 PM
Hello, I have developed a web application that uses ReportViewer Web control supplied with VS 2005 RTM version. The ReportViewer control uses Network credentials to connect to a remote SQL 2005 server to get the reports. It works fine for reports that doesn't use any parameters. But, for the ...more >>

Help with embedded code for SSRS Report
Posted by dba123 at 1/31/2006 1:06:27 PM
How can I create a VB.NET function to run my query below that my SSRS report can run to retreive TotalPostingDays so I can show that in a textbox in my report? I need help creating the function in the Report properties of my SSRS report and not sure how to call this stored procedure to return T...more >>

custom sercurity extention and ssl
Posted by Marvin at 1/31/2006 12:48:34 PM
can the custome security extension for forms authentication use ssl?...more >>

Report Builder problem with no All level on Scenario?
Posted by FurmanGG at 1/31/2006 12:15:29 PM
At first glance, this appears to be a bug in Reporting Services... I have a 2005 cube with a Scenario dimension. On the Scenario attribute I set IsAggregatable to False (since it doesn't make sense to add Actuals and Budgets). This effectively removes the All level, as I understand it. I've ...more >>

Annoying feature - report service rewrite query automatically.
Posted by qye2020 at 1/31/2006 12:06:46 PM
This feature is very annoying, report service 2k rewrites my query, even the format of query is changed too. How to disable this feature? Thanks really a lot. ...more >>



User Roles / add remove users
Posted by SC at 1/31/2006 11:11:27 AM
Hello Does anyone know why the Home page of the reporting services displays ALL the reports to ALL the domain users? I would like to set the site so that I can restrict or not the users to see the reports. Thank you so much in advance...more >>

Upper case format
Posted by Kyriakos at 1/31/2006 9:13:27 AM
Hello all, does anybody know the format code for upper case field formating? I.E. in MS Access it's the greater sign ">" and turn all the fields text to upper case. Thanks....more >>

Login problem publishing to my machine from VS2005
Posted by dgk at 1/31/2006 9:10:32 AM
So I'm trying my first Report project from Visual Studio 2005 and I get a good connection string and run the project. When I run it it tries to deploy to http://localhost/reportserver, and asks for a login and password. But nothing works. I don't even think I have a password set up for reporting...more >>

VS.NET Crashes EVERYTIME
Posted by carolus.holman at 1/31/2006 7:11:27 AM
Everytime I use VS.NET 2005 to Author Reports the IDE Crashes. It crashes when I click Exit, it crashes when I uses the Query designer, I fully expect it to crash everytime! Anyone else see this happening? Any one know why it crashes all the time? ...more >>

Dynamic grouping problem
Posted by msdnuser at 1/31/2006 6:56:30 AM
Hi all, I need a certain functionality in my Reporting service report. I need a report with 4 levels of grouping above the detail level. The initial visibility of all the lower levels should be hidden expect the top most level. For all the levels toggle item is set in the group properties...more >>

Tabel in table -> Header missing
Posted by Maran at 1/31/2006 6:51:30 AM
I have a table(No.1) with several groups. I have inserted another table(No.2) in one of the groups footer. Both tables have the same DataSet as source and groups with same Column. Everything works fine except that the Header and Footer, for table2, will not be rendered. I have hardcoded val...more >>

Trying to email out reports
Posted by JaffaB at 1/31/2006 4:29:07 AM
Hello, I have a SBS2003 running with SQL Reporter, and I want to try and get it to email to the excahnge server (on the same box) the copy of the report. Can anybody point me to what the settings should be in the RSReportServer.config file? At the moment, I am emailing it out to my yahoo ...more >>

IIF Function in Dataset
Posted by Sme at 1/31/2006 1:55:27 AM
I am trying to build my dataset WHERE clause with the IIF function. I have 4 parameters that include a "ALL" option and that is what I am trying to cater for. Have done is successfully when there is only one parameter involved, IIF (Parameters!Rep.Value = "0", " WHERE A.Region = '" & Parame...more >>

Best Practice, Stored Procedures & Datasets
Posted by Jay Sanderson at 1/31/2006 12:00:00 AM
Hi, Would be interested to hear your thoughts on whether is best to minimise or maximise the use of stored procedures in SQL Reporting. Is it best to have as much as possible coming from Stored Procedures or is it better to have as little as possible. At this stage I am more concerned abou...more >>

Creating Subscriptions
Posted by Jay Sanderson at 1/31/2006 12:00:00 AM
Does anyone have any good examples of programmatically creating subscriptions using the SQLRS web service ? rgds, Jay ...more >>


DevelopmentNow Blog