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 >>
Don't see what you're looking for? Search DevelopmentNow.com.
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 >>
|