Groups | Blog | Home


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 > february 2006 > threads for friday february 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

passing parameters through url
Posted by wtk at 2/3/2006 11:37:19 AM
I use slq2005 reportserver, how can I let users pass parameters or query through report srv url to execute the query... thanks al -- ...more >>


Parameter reset problem in Report Manager
Posted by Nayan at 2/3/2006 11:09:02 AM
Hi, I have a report with 4 parameters (Company, Department, StartDate and EndDate) Company and Department have dropdown selection; Startdate and Enddate are textbox controls All parameters have some default value assigned to it i.e. Company= <All>, Department=<All>, StartDate={Current ...more >>

only 1 data row shows up in preview - should have 10
Posted by Rich at 2/3/2006 10:56:17 AM
I am relatively new to Reporting services. I have a real basic dataset select * from tbl1 tbl1 contains 10 rows and 6 fields. I have 6 textboxes in the layout view. I linked each textbox to a field in the dataset. When I go to preview, I only see one row of the 10 rows and only 1 page....more >>

Please help! Report Builder model from UDM?
Posted by ystueker at 2/3/2006 10:37:42 AM
This is my second posting. Please help! Hello, I have created a cube in Analysis Services and made many business logic changes in the Data Source View and dimensions. Can I use this to build a model for the Report builder? I believe they call this UDM? People will create ad-hoc reports in...more >>

detecting whether all items are selected in a multi-value paramete
Posted by FurmanGG at 2/3/2006 9:55:15 AM
Is there an easy way to detect whether the user has selected all possible items in a multi-value parameter? If they've selected everything I want to put "All Regions" as a label in the header of the report. If they've selected only some, I want to list the regions they've selected [accomplishe...more >>

problem connecting report to database - 'null' user error
Posted by Rich at 2/3/2006 9:54:59 AM
Hello, I am modifying a report created by someone else. When I go to the data tab I get an error message that the report can't connect to the database. I have the proper windows account, I even have a sql server account - Administrator for everything. In the server explorer window, I can...more >>

Domain Security Groups unable to Browse Report Folders
Posted by qIjDraco at 2/3/2006 9:49:36 AM
I am user SQL/RS 2005 on a 2003 Server on a 2000 domain and I have created a domain security group and added a user to it. I then went into the security tab of reporting services Home and added the group with the role of Browser. I then added the same group to a child folder in the same mano...more >>

Input parameter
Posted by Jim at 2/3/2006 9:11:25 AM
Does anyone know how to mask the value of the input parameters? I need to mask the input value so that it will not be visible when entering. Thanks, Jim...more >>



URGENT! NEED HELP (jump to url doesn't work from IFrame)
Posted by Puhonien at 2/3/2006 8:15:47 AM
I'm having this problem also. Does anyone know of a fix or workaround? **************************************************** Subject: URGENT! NEED HELP (jump to url doesn't work from IFrame) 12/19/2005 7:32 AM PST By: ken_foust@hotmail.com In: microsoft.public.sqlserver.reporti...more >>

Ad-Hoc Reporting for users in RS 2005 with Visual Studio 2005
Posted by Alec Hardy at 2/3/2006 8:15:34 AM
My Supervisor and I attended a couple of Microsoft demos of SQL Reporting Services 2005, and during those demos, the end user development environonment was demoed. We are currently using SQL 2000 RS for a full set of Financial reports for our 800+ users and would like to make available report...more >>

Logon failure : (rsInternalError)
Posted by gaby at 2/3/2006 7:57:51 AM
On a SQL server 2000 SP4 on XP PRO SP2, I have installed Reporting Services. I have created an local administrator user and I have given this local account as "Domain user Account" during installation. When I try to acces report server, it fails with the message "Logon failure: unknown user n...more >>

URGENT HELP PLEASE - Unnamed Parameter using OLE DB Provider for Analysis Services 9.0
Posted by Rose at 2/3/2006 7:26:57 AM
I am trying my best to get the unnamed parameter ? to work with my MDX. My query works with FROM [Cube] WHERE ( [Customer].[User ID].&[415] ) Once I replaced it with FROM [Cube] WHERE ( ? ) and press ! to execute the query, I am prompted to enter a value for the parameter. I have trie...more >>

Render HTML content
Posted by Bruce at 2/3/2006 7:03:59 AM
I have a scenario where HTML is stored in the database and I want to use reporting services to retrieve the HTML and dipslay it in a report "as is". If I do this directly, I just get the html tags displayed. Is there any way easy way to get the html to render in the report? ...more >>

Dynamic subreport based on user group
Posted by Doris at 2/3/2006 6:29:11 AM
How would you set visibility in a report based on which user group the user is in?...more >>

Using data from 2 queries in one report
Posted by Denise at 2/3/2006 12:00:00 AM
Hello I'm using RS2000, and am trying to use data from 2 queries in 1 report. The first query is as follows:- SELECT tblanswers.questionid, subtopicid, description, answer1, count(*) as totalquestions, (100.0*Count(tblanswers.questionid)) / (SELECT Count(questionid) FROM tblanswers a WHER...more >>


DevelopmentNow Blog