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 ...
|
Report level time conversion
Thu, 18 Mar 2010 08:24:10 -0700
Reporting services server is based in London. When reports are accessed in
New York, it shows report run time in London time zone. We would like to show
the time in New York time zone. Can anyone please help me here. ...
|
SQL 2008 x64 SP1 SSRS
Wed, 17 Mar 2010 15:05:54 -0700 (PDT)
I've installed SQL Server 2008 x64 SP1 SSRS on a server running
Windows Server 2008 x64 Standard and am having major issues. I
installed and configured SSRS using documentation provided by our CRM
application (ConnectWise). They appeared to be pretty standard
options. For SSL I chose the certificate for mydomain ...
|
