all groups > sql server reporting services > may 2005 > threads for wednesday may 18
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
Reporting Services Install error on Windows 2K
Posted by Marc Hensley at 5/18/2005 4:55:32 PM
I am trying to install Reporting Services on a Windows 2000 Server with SP4
and SQL 2000 SP3. I keep getting an error as it is finalizing installation.
I opened the RSMSIO.log and found the error entry -- 'Error 1935. An error
occured during the installation of assembly component
{D825F1C6-... more >>
What is the ValueLocID property used for ?
Posted by DaveD at 5/18/2005 4:47:01 PM
Did this just appear with the latest patch....... can you tell me what it is
about ?... more >>
Report Hidden in Excel Export
Posted by Brian at 5/18/2005 2:36:33 PM
I have an ASPX page that I build to display a report generated in
Reporting Services. The report is a table and is built using the
Render command, generating HTML and inserting into the page. This
work fine, but I have functionality that allows the report to also be
exported to excel. I agai... more >>
Drilldown and charts fail to show
Posted by Olof at 5/18/2005 2:36:01 PM
I have multiple reports where drilldown doesn't work & chart doesn't show.
It works on my local machine & and on a test-server.
The server I want to implement it to has "_" in it's name so I tried to use
the IP-adress instead. I get my total & subtotals but not the detail.
Anyone got a idea h... more >>
Passing Value from Report to SubReport
Posted by Benjamin at 5/18/2005 2:32:09 PM
I have a Report that looks like this:
Department Number of Employees
MKT 58 Details...
And i have a subreport displaying the info of the employees for a given
department.. i want if its possible, that the user clicks on Details.. and
... more >>
SecurityException when running RS scripts
Posted by JoeA at 5/18/2005 1:05:01 PM
I'm getting an CAS exception when I run various RS scripts, though the
scripts seem to work correctly... I'm running RS SP2. Any idea what might be
wrong?
- the dump looks like:
Unhandled Exception: System.Security.SecurityException: Request for the
permissi
on of type System.Security.Per... more >>
Expect Parameters which was not supplied when hit the preview tab
Posted by MissQti at 5/18/2005 12:30:01 PM
I'm creating my reports and connect to the stored procedure. The results of
data returned when I'm on Data Tab. However when I hit the Preview Tab I got
the error said "An error has occured during report processing. Query
execution failed for data set "TheNameOfMyData". Procedure
"MyWebProce... more >>
Conditional page breaks
Posted by B Shaffer at 5/18/2005 12:15:02 PM
I want to set a page break at the change of a group conditionally based on a
parameter value. Is there any way to do this in Reporting Services?... more >>
Don't see what you're looking for? Search DevelopmentNow.com.
Question for CHART Experts: How to show Percentages?
Posted by neokortex at 5/18/2005 11:42:07 AM
We want a PIE chart to show the PERCENTAGE of each TYPE of a particular
product for all the orders in a dataset. How do we get at the TOTAL number
of orders in the dataset? When editing Chart properties. the VALUES editor on
the DATA tab seems to apply only per category, which does not lend ... more >>
Weekly Activity Chart
Posted by Bethany at 5/18/2005 11:16:07 AM
I need to create a chart that tracks activity on a weekly basis. I am using
SELECT
MIN (datecompleted), COUNT(activity)
from table
GROUP BY DATEPART(ww,datecompleted), DATEPART (yy,datecompeted)
This gives me a date for the beginning of each week and the amount of
activity for all weeks ... more >>
How to use windows-based authentication (rsAccessDenied)
Posted by tabbey at 5/18/2005 9:45:50 AM
Hi,
Question on how to setup the windows-based authentication correctly.
From what I read so far, it seems that RS uses windows-based authentication
as default security measure. However, other users who are on the same domain
are getting the ACCESS DENIED error when accessing RS reports vi... more >>
Duplicating Chart Line Colors
Posted by BW at 5/18/2005 9:42:10 AM
Hello,
We have several reports that we use that contain charts with several
servers. The issue is that we have more than 16 servers in these charts and
the colors start to duplicate. Is there a way to make the color palette use
more colors? Any assistance would be appreciated.
--
Th... more >>
Filter based on a parameter
Posted by Myles at 5/18/2005 9:29:53 AM
Hi all,
How would you go about creatig a filter that is used based on the value of a
parameter? Can this be done?
Lets say we have a report parameter called 'Show cases missing <attribute>
data?'
If the user sets this to true, then the filter would kick in, which is a
filter that wou... more >>
Report Dev
Posted by Gael Le Mouhaer at 5/18/2005 7:30:59 AM
Hello,
I'am developping a report.
In this report, I have a big table.
I want to only one record per page.
How can tell Report Services ti put the second table on the second page,
the third .... ?
Thx
Gael... more >>
data-driven subscription not available
Posted by RMac at 5/18/2005 6:18:09 AM
I would like to setup a data-driven subscription for a report, but the New
Data-driven Subscription button is not available on the subscription page -
only the New Subscription button appears. I have checked that the report
uses a custom data source and stores the user name and password crede... more >>
Page number reseting
Posted by Dave Sundell at 5/18/2005 5:51:34 AM
Are there any plans in RS 2005 to have greater control over page numbers with
regard to group breaks?
For example, if we have a multi-page report for each group with page numbers
"page x of y" in the page footer, we would like the page number reset on each
group break so that group 1 may h... more >>
Export to Excel fails - ASPNET_WP.EXE consumes 60% RAM
Posted by Nick Prudhoe at 5/18/2005 4:50:03 AM
I'm trying to export a report to Excel that contains 60,000 rows (but not
more than Excels 65,000 limit) and I get an "internal server error".
When I check the event log on the server it states that aspnet_wp.exe
terminated the report process because it had consumed more than 60% of the
ser... more >>
RGB background color problem in Report Designer
Posted by Wolfgang Himmelsbach at 5/18/2005 3:05:09 AM
Dear Report Designer Developers,
FYI - when I am using (e.g in a table) a RGB background color (e.g.
="#003399“ = blue) instead of a color of the selectbox there is always a
white background displayed in the Report Designer (layout view). Together
with a white font color I do not see anyt... more >>
Datasource properties while publishing report
Posted by Jasvinder at 5/18/2005 2:18:04 AM
Hi,
I am having problem where I am uploading report and setting its datasource
properties using rs.setproperties. I had defined datasource but it says “data
source in not published on report server†or
“System.Web.Services.Protocols.SoapException: The required field DataSource
is mi... more >>
Linked report rendered out of custom iFrame
Posted by GG at 5/18/2005 2:15:17 AM
I render my reports in the ReportViewer control on a aspx page of a corporate
intranet. When I try to generate a linked report from within the control, the
report is rendered in the web browser and not in the iFrame of my aspx page,
taking the user out of my site and taking him to report manag... more >>
|