all groups > sql server reporting services > march 2006 > threads for thursday march 2
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
Bold on Matrix subtotal
Posted by anthonysjo at 3/2/2006 8:45:15 PM
Hello all,
Does anyone know how to make a subtotal column on a matrix report bold? I
can bold all data but can't seem to figure out how to only do the subtotal
column.
Thanks!!... more >>
blank page in pdf report
Posted by joshua at 3/2/2006 2:41:11 PM
When I export my report to PDF, I get a blank page that shows up. The
header and footer are on the second page, but the body is blank. There
isn't enough data for a second page. Why is one being created? Any ideas?
... more >>
Error in deployment of Reports
Posted by Vince Keller at 3/2/2006 12:54:29 PM
Hello,
I have built a report on SSRS 2005 and wanted to deploy that report as a
URL. However, it gives me an error which reads - "The permissions granted to
user '<Machine Name>\IUSR_<Machine Name>' are insufficient for performing
this operation. (rsAccessDenied)". Any idea whats causing th... more >>
Ctype from string to double not behaving as expected.
Posted by Nathan at 3/2/2006 12:21:27 PM
I tried posting this earlier, but it never showed up. Hopefully I don't
double post.
I was writing code for a custom dll earlier this morning where I ran into
some strange behavior for the IsNumeric function.
IsNumeric("$1,0562.00") was returning false
I thought that maybe this behavior ... more >>
Group Sorting in a Table
Posted by abillmeier at 3/2/2006 9:51:04 AM
Good morning,
I am having a little bit of an issue with the sorting of data in a report.
The report works great, but the sorting could be better.
I have the data in a Table.
I have a list of data that is grouped into three groups. The groupings are
by Project, Phase, and CostCode, in t... more >>
Sql Code being modified automatically
Posted by jhoge123 NO[at]SPAM yahoo.com at 3/2/2006 9:42:45 AM
I'm writing a simple query against an OLEDB database that needs a
conversion function.
What I want to do is like this:
SELECT CONVERT(ardtl.SIZE, integer) AS ItemSize, SUM(SHIPPED_QTY) AS
shipped_qty .....
Once I type this SQL in the Data tab of the my Reporting Services
project, Visua... more >>
Conditional Parameters
Posted by KimB at 3/2/2006 9:30:31 AM
Does anyone know if there is a way to have conditional parameters? Ex: User
asked would you like to run report by representative or area? Then when the
user chose representative a mulit select prompt would appear with a list of
representatives to choose from or if they chose area then a multi... more >>
Report Engine
Posted by davidswain2005 NO[at]SPAM yahoo.co.uk at 3/2/2006 8:53:17 AM
Does Report Services 2005 have a Report Distribution engine. So that I
can for instance say; I want user 'A' to get report 'B' in a format of
'C' at 17:05 every day.
Many thanks
David
... more >>
Don't see what you're looking for? Search DevelopmentNow.com.
Report Layout
Posted by Chris Kye at 3/2/2006 8:51:33 AM
I have a page with a List of about 12 fields with text labels.
Something like this:
Label1
Field1
Label2
Field2
Label3
Field3
Label4
Field4
IS there any way to scale this so that if, for example, Label3/Field3 are
empty, I can move Label4/Field up? Right now, it leaves a big bla... more >>
Programmatically chosing an image in table
Posted by Clint at 3/2/2006 8:28:32 AM
So we've got a report, and some external images (i.e. sitting on the
server's HD). I don't really want to put them in the SQL 2000 database if I
don't have to (mainly because I don't know how), but I want one column of
the report to be one of 5 images, depending on the value a column in the
... more >>
Fields tab not populating in Data set setup
Posted by Bill at 3/2/2006 8:21:31 AM
I using a SP for my dataset
problem is the Fileds tab is not populating with the fileds from the SP thus
I do not have anything to drag in the Layout Tab to build the report.
I know I missing something here, just can not rememebr what to do to get it
to populate the fileds
can anyone tell m... more >>
Excel Export Report Footer Problem
Posted by Frank Hoover at 3/2/2006 7:44:31 AM
We have a footer in our reports which displays a disclaimer in a textbox.
The disclaimer shows up fine when exported to PDF, but when exported to Excel
it chops off everything but the first 255 chars. Can someone explain why
this is happening?... more >>
Q: access rights in report manager
Posted by JIM.H. at 3/2/2006 7:27:22 AM
Hello,
Our users are launching reports through report manager, is there any way I
can arrange access rights so that they can only run report but not do
anything else in the report manager.
... more >>
Deleting reports
Posted by Mathias at 3/2/2006 6:14:21 AM
So I've got a couple of reports deployed in reporting services 2005 and
Well I want to delete them but I have no clue how. I was wondering if
anybody could either
A) walk me through how to do it.
B) point me in the direction of some sites that explain how to do it
(I'm having no luck with go... more >>
Error when Exporting to Excel
Posted by Dave Peake at 3/2/2006 2:00:27 AM
For the last couple of weeks we've been experiencing problems when try to
export reports to Excel either from the VS IDE or the Report Manager Web.
After some tinkering and investigation (maybe more luck than judgement) we
found it to be an issue relating to Page Breaks on tables. If we unche... more >>
|