all groups > sql server reporting services > may 2007 > threads for thursday may 31
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
Matrix or Table?
Posted by Just Another Reporter at 5/31/2007 6:59:45 PM
I am trying to create a report that should have fixed columns. I
started out creating a matrix, but was having loads of trouble keeping
the columns I wanted. Here is what it should look like:
Total <0 days 1 day 2 days 3 days 4 days 5-10
days 11-15 days 16-30 days
... more >>
Parameter with @ sign
Posted by Ed at 5/31/2007 6:18:00 PM
Hi,
I would like to know under Data Set --> Parameter, do I have to add a @
sign right before the name of parameter? I know I have to use it in SQL like
select * from customers where customerID = @CustomerID. Can I just use
CustomerID in Parameter box or I have to use @CustomerID? which ... more >>
Turn off paging?
Posted by Eric at 5/31/2007 3:01:11 PM
Is it possible to turn off the paging feature at the report level?
I have some reports that a 3-4 pages long and the users just want to
scroll through it all. They are just viewing them through the
ReportServer virtual directory...
thanks!
... more >>
Change a subreports report source
Posted by Tim Kelley at 5/31/2007 12:47:00 PM
Is there a way to change a subreports report source on the fly? I would
like to change the report based on a parameter that is passed to the main
report.
Thanks,
Tim
... more >>
Impersonation not working correctly in custom code module
Posted by Jason at 5/31/2007 10:55:01 AM
I have a Reporting Server setup in a lab and one setup on my development
machine. Both use to run Reporting Services 2000. We recently upgraded to
Reporting Services 2005. I am having a problem on both machines impersonating
the logged-in user in my custom assembly that is called from the repo... more >>
Request failed HTTP status 504 (Gateway Time-Out)
Posted by Laurahn at 5/31/2007 10:35:20 AM
When i run my report from Win App with a Report Viewer control
("Microsoft.Reporting.WinForms.ReportViewer"), over a XP machine, i got this
error:
"The request failed with HTTP status 504: Gateway Time-Out"
Thanks, =)
... more >>
SSRS returned data too large
Posted by Rob at 5/31/2007 10:25:01 AM
I had a quick question regarding SSRS 2005 and the amount of data my reports
generate.
Is there any way to limit the report to only pull back the first page (or
first 5 pages) of data to a report?
Some of these reports bring back 50+ pages worth of data and I am getting
complaints that ... more >>
Cannot install BI Developement Studio
Posted by Mark at 5/31/2007 8:33:01 AM
I am able to install SSRS, and it works from my local machine. I also
installed SQL Server 2005 locally so the ReportServer and ReportServerTempDB
can be created locally on my computer. However, BI Development Studio will
not install. I get an message about APPCOMPAT. I tried another instal... more >>
Don't see what you're looking for? Search DevelopmentNow.com.
server mgmt studio can't connect to ReportServer
Posted by Bill at 5/31/2007 8:14:02 AM
Help. Recently, studio has not been able to connect to reporting services
(connects to db engine, analysis, etc ok). Only thing happening around that
time is failed VS2005 update <low c: space, downloaded to other drive & ran
from there OK>. Reporting services is still running, cranking out... more >>
Cannot Install Reporting Services Components!!
Posted by Ayman at 5/31/2007 7:24:29 AM
I have set up a Virtual Machine that runs Windows Server 2003 x64.
When I come to install SQL Server Express edition the Reporting
Services components don't even show up as options for installation.
Oh, I'm installing Express edition with advanced services by the way
and I have the 3.0 .NET serv... more >>
Referencing a total for a group inside that group?
Posted by Doug at 5/31/2007 7:18:00 AM
Is there any way to do this?? I am trying to display percentages of the total
along with the number of items. What I want to do would look something like
this.
Group header:
Detail X X/Sum of all X's
Group footer Sum of all X's
I can't seem to find a way to refer to the item in... more >>
Column width
Posted by Hasan Dalwai at 5/31/2007 1:31:00 AM
i am using reporting services 2000 & my backend is sql 2000.
In one of my reports, i have a parameter which needs to take value more than
1400 characters but in reporting services report view i can only give 1200
characters. Kindly let me know how do i resolve this issue. ... more >>
|