line break SSRS 2008
Sat, 20 Mar 2010 18:16:37 GMT
I am creating a SSRS 2008 report and there is a grouping in a column in the
table and i need to insert a line when the group changes. For example:
1 abc
1 def
1 ghi
1 jkl
------------------------------------
2 john
2 maria
2 Cheryl
2 ...
|
sql server report 2008 export options
Sat, 20 Mar 2010 09:54:01 -0700
I would like to know know what are the options of exporting in sql server
reports 2008:
I would like to export a report with about 10 sub or linked reports to a
format that you can work with a table of contents. From looking on the web
site looks like my best option is to export to Word.
Are there othe ...
|
reporting options in SQl Server
Fri, 19 Mar 2010 17:13:24 -0700 (PDT)
What are the options to do SQL Server reports?
I have done Access frontend SQL Server backend reports in Access.
I have a client with SQL Server. He has Filemaker for some kind of
front end.
What are the options for reporting?
I have SQL Server 2005 Express but I could probably download the 2005
enterprise t ...
|
list controls
Fri, 19 Mar 2010 10:51:03 -0700
I have the 2005 version of Reportiong Services. Is there a way to make my
list data display left to right and not top to bottom? If I use a list
control, the data is displayed as follows:
red
green
blue
However, I would like the list to be displayed as follows:
red green blue
Is this possible? I ...
|
Export to Excel?
Fri, 19 Mar 2010 10:36:26 -0500
Hi,
Running Reporting Services from SQL 2005 Server and my users like to export
to Excel so that they can play with formatting, sorting and what-not. We
have run into a problem where the export process merges cells in Excel and
then you have to go through this annoying process to unmerge the cells so
you ...
|
Reporting Services SUM(IIF(...) Problem
Thu, 18 Mar 2010 14:22:23 -0700
I have on my report a list grouped by username. What I need is to count the number of times the grouped username appears in another column within the dataset (both inside and outside the grouping).
I have tried everything I can think of (which is why I am here.)
What I have so far is some code and a "SUM(IIF( ...
|
Matrix Report Calculations
Thu, 18 Mar 2010 13:59:42 -0600
Hey I am very new to SQL 2005 Reporting Services
I am trying to create a matrix report.
I have created a matrix report as follows:
Columns > Month Name
Rows> Item Description
Details > MonthlySales
The report works as expected, totaling the $ amounts by Item Description for
each month.
Now the part I am ...
|
|
|
Quickly changing RDL files
Thu, 18 Mar 2010 10:41:51 -0700
Hello, I have a series of 50+ RDL files that had to get srestored from a
data drive, and I don't have the original .VS solution that created them -
the reports all use different data sources. Is there a quick way to
dynamically change the name of the SQL server they are pointed to?
...
|
SSRS 2005 matrix using rows as headings
Thu, 18 Mar 2010 10:18:01 -0700
Has anyone ever had to do this? Display a matrix on an SSRS report using the
row data as a heading and repeating the column headings for each row? I've
gotten pretty close using a matrix containing a rectangle in the Data area
which itself contains another matrix; however since the column data needs to
rep ...
|
SSRS2005, matrix but concat keys for last group level ?
Thu, 18 Mar 2010 16:45:16 +0100
Hello all,
Let's start with a matrix report that groups my data by area, status,
company and project. Now the problem is that it creates numerous columns and
actually :
- I don't care about the project sub totals but would still like to know
which projects are involved.
That is basically I would like to ...
|