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 > december 2004 > threads for thursday december 9

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

Print report immediately without export
Posted by May Liu at 12/9/2004 6:19:07 PM
After report is generated, can I print the report immediately without exporting to PDF or EXCEL ???...more >>

how to get rid of document map in reports
Posted by ALI-R at 12/9/2004 5:13:14 PM
there is a tree on the left hand side of my report ,which I don't want it to be there ,how can I hide that document map??? is there a special paramter or somehting that I have to pass? thanks for yuor help. ALI ...more >>

Stored Procedure Parameters
Posted by Frank Ashley at 12/9/2004 3:47:21 PM
I have two parameters that are filled with the results from two sprocs. Either both or only one is to be passed into the report sproc. Is there any way to add say -1 as a datarow to one of the datasets so I can trap this in the report sproc and not process this parameter? Thanks Frank As...more >>

Reporting Services On Firefox 1.0
Posted by Marcial at 12/9/2004 12:59:09 PM
Hello Forum from a Newsgroup newbie, ...Was wondering: Has anyone had successes or failures when accessing Report Manager or Report View in a Frefox Browser. Trying to sell IE in a University environment has been difficult lately!! Any solutions also welcomed :-} -- Application Enginee...more >>

Run report locally
Posted by Mohamed Al Zayani at 12/9/2004 12:20:57 PM
Hi, How can I run the report locally without the server. I know that I can run the report from VS without the server, are there any way to just run the RDL file and integrate it in an application (no server) regrads ...more >>

Permissions and Administration
Posted by Andy998 at 12/9/2004 11:23:04 AM
Do you have to be a member of the local win2K administrators group in-order to perform administration functions and create folders in Reporting Services?...more >>

Custom Authentication
Posted by WizKid at 12/9/2004 11:19:58 AM
How do I change Authentication from Domain to custom. I tried the sample on teh website but somehow I dont have the solution required to do the modification.... Help greatly appreciated. -- Smit N Shah CIO OmegaSoft Inc. http://www.omegasoftinc.com...more >>

Joining a web farm
Posted by Victoria at 12/9/2004 11:19:07 AM
I have two servers in a web farm. Installation went fine on both servers and got the first one working. When activating the second server from the first with "rsconfig -m <RemoteMachineName> etc. I get the error message " Failure obtaining information from remote WMI provider: Unable to find R...more >>



User's Identity
Posted by WizKid at 12/9/2004 11:17:29 AM
I have a report where I need to pass a User's Authentication ID automatically on the backend... How do I do it ?? Please let me know -Smit. -- Smit N Shah CIO OmegaSoft Inc. http://www.omegasoftinc.com...more >>

Multi valued parameters
Posted by sathya at 12/9/2004 11:17:11 AM
Hi Say I need to add a parameter called CategoryID. Now the user can choose not to filter on that parameter and pick 'All' or one of the values displayed in the drop down to filter on them (there is a lookup dataset and I have built the custom query function to not include this WHERE claus...more >>

Bar codes ?
Posted by jean-marc.audrin NO[at]SPAM future.ca at 12/9/2004 11:11:03 AM
Hi guys I am new in SQL RS. I want to print bar codes on my report. Is it possible with RS ? Do I need external procedure ? Any suggestion will be welcome ! Thanks Jean-Marc ...more >>

MOM 2005 Reporting and Reporint Services SP1
Posted by Jeremy at 12/9/2004 9:17:03 AM
Does anyone know if MOM 2005 Reporting works on Reporting Services SP1....more >>

How can I put inside my Look and Feel?
Posted by Luis Esteban Valencia at 12/9/2004 9:16:26 AM
How can I put inside my Look and Feel? -- LUIS ESTEBAN VALENCIA MICROSOFT DCE 2. MIEMBRO ACTIVO DE ALIANZADEV ...more >>

Using ad-hoc SQL for report
Posted by michael.haskins NO[at]SPAM gmail.com at 12/9/2004 8:39:36 AM
Is there a way to create the SQL used in a Reporting Services report programmatically? I am trying to recreate a report done previously in ActiveReports that has some crazy parameter-driven SQL that includes several unions and subselects and cannot utilize the SQL builder to do what I need. ...more >>

Adding RDL to manager via .NET
Posted by hellfire_667 NO[at]SPAM hotmail.com at 12/9/2004 8:31:19 AM
Hi is it possible to add a RDL-Report via a Window-Application to the report manager? Thanks in advance! Regards Alex...more >>

Need Parameter Optionally Omitted
Posted by Mike Harbinger at 12/9/2004 8:26:11 AM
Is it possible to have a parameter ignored? I have a report that I am web-deploying with a large set of parameters, but a user may not wish to include some for a given execution of the report. For example, I have a Boolean checkbox that I cannot get the report to ignore. I have tried togglin...more >>

How can I change a datetime column format?
Posted by Luis Esteban Valencia at 12/9/2004 8:01:45 AM
How can I change a datetime column format? and How can I make a subtotal?? -- LUIS ESTEBAN VALENCIA MICROSOFT DCE 2. MIEMBRO ACTIVO DE ALIANZADEV ...more >>

Security/Configuration Question
Posted by msu94grad at 12/9/2004 7:49:04 AM
I have a configuration question. It may also relate to security. I had a SQL Server with Reporting services installed and it was located in my office (on the same LAN). I created, installed, and viewed a report fine from my machine. However when I went to another site and tried to view the...more >>

Excel Export - Missing pages
Posted by simon.place NO[at]SPAM uk.zurich.com at 12/9/2004 7:47:47 AM
I am using Excel as an export format but on some occasions only some of the report pages are represented in the Excel output (1 page per sheet). This doesn't happen for all exports but happens consistently for a given set of report input parameters. A PDF export of the same report seems fine. ...more >>

Multiple DataSets
Posted by Asim at 12/9/2004 7:45:04 AM
Can a single report (same layout) have multiple MATRIXES with all referring to either SAME or SEPARATE tables with different conditions mentioned for each matrix? Thanks ...more >>

SQL Parameter matching with 'LIKE'
Posted by Bassist695 at 12/9/2004 7:25:06 AM
Is there a way to prompt a user to enter a partial value, similar to "WHERE name LIKE '@partial_name' ? I'm dealing with policy numbers and this way, a user would be able to enter only a certain part of a number and bring back everything that matches. I've tried using LIKE in the SQL query ...more >>

Problem while converting pdf document to Word.
Posted by praveen79 at 12/9/2004 7:25:04 AM
Hi, I have a pdf document which is generated from MS SQL Reporting Services. I am unable to convert the pdf document(which was generated from MS SQL Reporting Services) To a WORD document USINg SOme tools which i downloaded from Internet. The PDF document i generated using Reporting ser...more >>

Using 'Between' operator in a parameter
Posted by greg_cochrane NO[at]SPAM hotmail.com at 12/9/2004 3:52:05 AM
Hi I have a report which requires a parameter to be entered by the user. The Parameter reads: WHERE craw1.Emp_Name IN (@Employee)) AND (d1.Date BETWEEN @Firstdate AND @seconddate) when i enter the values in the date parameters I get no rows returned where i should have plenty of rows. ...more >>


DevelopmentNow Blog