How to format measure descriptions

When using a matrix in Reporting Services to design a
report based on a cube, you are presented with a detail
column for your measure and a column to the left of that
for the description of the measure. My report has several
rows of measures that present (for example) both units
and dollars. I want to be able to leave a blank line
between the units section and the dollars section. I also
want to be able to place a heading for each section. The
preference is that the heading be off to the left rather
than above -- but i am not able to add a second
description column. So I placed text in the description
column to simulate the desired formatting.
For example:
Units Prod1
Prod2
Prod3
Total
Sales Prod1
Prod2
Prod3
Total
This approach looks fine in the designer. But when i
publish the report and view it in IE, all extra spaces
are gone (both horizontally and vertically) so the
descriptions look as below:
Units Prod1
Prod2
Prod3
Total
Sales Prod1
Prod2
Prod3
Total
Any suggestions on how to get a better presentation of
the descriptions?Try Using Padding ?
"Daniel Edwards" <DanielEdwards@.discussions.microsoft.com> wrote in message
news:A5663DB5-D5DD-4132-AEA5-A9D19EDFE713@.microsoft.com...
> When using a matrix in Reporting Services to design a
> report based on a cube, you are presented with a detail
> column for your measure and a column to the left of that
> for the description of the measure. My report has several
> rows of measures that present (for example) both units
> and dollars. I want to be able to leave a blank line
> between the units section and the dollars section. I also
> want to be able to place a heading for each section. The
> preference is that the heading be off to the left rather
> than above -- but i am not able to add a second
> description column. So I placed text in the description
> column to simulate the desired formatting.
> For example:
> Units Prod1
> Prod2
> Prod3
> Total
> Sales Prod1
> Prod2
> Prod3
> Total
> This approach looks fine in the designer. But when i
> publish the report and view it in IE, all extra spaces
> are gone (both horizontally and vertically) so the
> descriptions look as below:
> Units Prod1
> Prod2
> Prod3
> Total
> Sales Prod1
> Prod2
> Prod3
> Total
> Any suggestions on how to get a better presentation of
> the descriptions?
>

How to format leave detail into tabular/pivot format?

Hello Expert!

I need help to I translate this data...

Table "LeaveDetail"

StaffNo | StartDate | EndDate | LeaveType |
1 | 23/04/2006 | 26/04/2006 | AL |
2 | 24/04/2006 | 25/04/2006 | MC |
3 | 26/04/2006 | 27/04/2006 | EL |
1 | 30/04/2006 | 02/05/2006 | EL |

Into this format...

|Apr|Apr|Apr|Apr|Apr|Apr|Apr|Apr|May|May|May|May|
StaffNo |23 |24 |25 |26 |27 |28 |29 |30 |01 |02 |03 |04..

1 |AL |AL |AL |AL | | ... |EL |EL |EL |
2 | |MC |MC | | |
3 | | | |EL |EL |

Parameter:
Date From e.g. 23/04/2006 to 23/05/2006

Using only query statement...

Is this possible?

TIA

Regards.

WOuld be very heavy query, do you have a calendar table to join to ?

HTH, Jens Suessmeyer.

http://www.sqlserver2005.de
|||You could do it in a SELECT statement or using PIVOT operator in SQL Server 2005. But there is no dynamic aspect for the query i.e., the names of the columns (Apr 23, Apr 24) should be hard-coded in the SELECT statement unless you generate the column names at run-time and use dynamic SQL to execute the query. So your options are fairly limited. On the other hand, this type of pivot operation is a breeze to do on the client side. Any reporting tool wll handle this without a problem. So if it is a one-time affair then you can write a SELECT statement to get the expected results. Otherwise you will have to use a solution that is easy to maintain and extend based on what I described above.|||

Hmm..

No I don' have, appreciate if you can guide me on that

|||

I forgot to mention I’m using MS SQL Server 7

I found similar solution in MS Access. All done with 1 Table for days + query to convert to pivot/crosstab format, no coding in client side and no formatting in reporting tool needed

e.g.

TblDay e.g.: 1,2,3,4....31

The query:

PARAMETERS [Enter Month] Text ( 255 ), [Enter Year] Text ( 255 );

TRANSFORM First(LeaveDetail.LeaveType) AS FirstOfLeaveType

SELECT EmpNo
FROM tblDays, LeaveDetail
WHERE DateSerial([Enter Year],[Enter Month],[Day])) Between [LeaveDetail].[dStartDate] And [LeaveDetail].[dEndDate]
GROUP BY EmpNo
ORDER BY EmpNo

PIVOT tblDays.Day In (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);

The result will look like this:

StaffNo |1 |2 |3 |4 |5 |6 |7 |8 |9 |10 |11 |12..

1 |AL |AL |AL |AL | | ... |EL |EL |EL |

I know there are no such functions for tabular format in SQL Server 7, so I’m here to find similar solution that producing result as I have mention earlier which not depend on client or reporting tool

Is this possible?

|||

this thing looks like a cross tab queries.

maybe some examples from here will help.

http://www.sqlmag.com/Article/ArticleID/15608/15608.html

pls see the zip files

here some more

http://www.sqlteam.com/item.asp?ItemID=2955

you have do it thru dynamic query

|||

Thanks, I'll try

Regards

How to force linked rpt to open in new window?

This seems like such a simple thing, I must be missing something obvious. I have linked reports to view detail in my humongous main report, and I want them to open in their own windows for the sake of speed of navigation. How do I force a new window in Jump to URL?

Here you go: http://msdn.microsoft.com/library/default.asp?url=/library/en-us/RSPROG/htm/rsp_prog_soapapi_dev_3i49.asp

|||

Thanks, I appreciate your answer, but I'm still left trying to figure out WHERE to put the html code. It would make sense that it should go in the main report's RDL, but the code for this hyperlink looks like this:

<Action>

<Drillthrough>

<ReportName>BusDev_Detail</ReportName>

<Parameters>

<Parameter Name="Who">

<Value>=Fields!tkinit.Value</Value>

</Parameter>

<Parameter Name="Begindate">

<Value>=Parameters!Begindate.Value</Value>

</Parameter>

<Parameter Name="Enddate">

<Value>=Parameters!Enddate.Value</Value>

</Parameter>

</Parameters>

</Drillthrough>

</Action>

So the <LinkTarget=blank> tag doesn't seem to go here. Can you point me in the right direction?