No print/ export options for Matrix reports accessed thru Sharepoint report viewer web part
Thu, 7 Aug 2008 17:13:06 -0500
We have a number of SSRS 2005 reports that are delivered through the
Sharepoint Report Explorer and Report Viewer webparts. I noticed that while
the tabular reports have the print/ export options the matrix reports do
not.
If I directly access the matrix report on the report server I do see these
options. ...
|
Datetime parameter constraint
Thu, 7 Aug 2008 11:05:00 -0700
is there a way to limit the date range that a parameter value could be? in
other words, i have a report with @beginDate and @endDate parameters and i'd
like to ensure that the @endDate passed in is later than @beginDate. i'd
also preferably like to ensure that the @endDate is in the same year as the
@begin ...
|
Visual studio 2005
Thu, 7 Aug 2008 10:34:59 -0700 (PDT)
Hello,
Can anyone tell me what I need to do to see the report designer in VS
2005? I have it working VS 2003, but can't get to grips with VS 2005
Should I see a Business Intelligence option when I create a new
project or do I need to install some other s/w on my client pc, or is
there a report designer fea ...
|
Reporting Services Double Execution of SPs
Thu, 7 Aug 2008 09:58:05 -0700
Hello All, I have been delving into a performance issue with our reports in
SSRS and have discovered a very strange problem.
Essentially it appears that SSRS executes all the SPs required to load the
report for a second time once view report is clicked whereas visual studio
doesnâ??t. This of course has a ...
|
Extract specific value from dataset
Thu, 07 Aug 2008 16:18:51 +0200
Hi there
If I have a dataset that looks like the following:
Division PeriodType Budget Actual
A 1 500 200
A 2 700 300
A 3 100 500
B 1 300 800
B 2 400 700
B 3 100 300
How can I extract a specific value from this query?
Say, I want to get the Actual for Division A in Period 2 which is 700
Thank ...
|
https in Report Server but http in Report Viewer
Wed, 6 Aug 2008 21:01:01 -0700
Navigating in Report Server, I getting:
https://www.mywebsite.com/ReportServer/?%2fxxx%2fyyy&rs:Command=ListChildren
But when I click on a report, I get:
http://www.mywebsite.com/ReportServer/Pages/ReportViewer.aspx?%2fxxx%2fyyy%2fzzz&rs:Command=Render
Why is the https changing to http? What configuratio ...
|
Reporting servicves subscriptions
Wed, 6 Aug 2008 19:10:53 -0700 (PDT)
Hi All,
I am using Reporting services subscriptions to deliver daily reports.
These work fine when you view the e-mail (subscription) through an E-
mail client like Outlook. However if the report is viewed in webmail ,
like gmail, the HTML does not render properly. Images are sent as
attachments instead of bein ...
|
|
|
How to execute stored procs before populating datasets.
Wed, 6 Aug 2008 16:04:02 -0700 (PDT)
Two questions
1. How do you execute code (or stored proc) that populates/updates
tables BEFORE the datasets in the report are populated? Additionally,
it needs to wait until the code is finished.
EX: User opens report, it executes code to load/update tables, WAITS
until it is complete, and then populates teh da ...
|
The 'abc' parameter is missing a value.
Wed, 6 Aug 2008 14:04:05 -0700 (PDT)
I have an ASP.NET applications which displays several SSRS reports.
The webforms have controls for various parameters - StartDate,
EndDate, GrowerID and some boolean values to show/hide various
columns.
All of these parameters have default values that are set during the
Page_Load() method. Most are specific t ...
|
That assembly does not allow partially trusted callers
Wed, 6 Aug 2008 09:49:36 -0700 (PDT)
Hi,
I am getting the following error when I am trying to run any report.
Failed to load expression host assembly. Details: That assembly does
not allow partially trusted callers. (rsErrorLoadingExprHostAssembly)
The application was running fine till a few days ago. I am not able to
figure out what has cha ...
|
