All things must pass and all things change

by Lisa Nicholls Thu, November 26 2009 13:02

Kami-cat has left us.

She was a snuggly, loving friend.  She tried very hard to be a good sport about things that were difficult for her, including many changes she didn't understand.  But at each stage, she had (we think) a good life. The last part was hard, but it's over now.

I'm going to choose to remember her proudly bringing a very large bird into the house only a few weeks ago.  We don't really think she hunted it herself (although she was fierce and strong when she was younger), but we let her think she fooled us.

I have a pile of work not done and a pile of unanswered questions from many of you, too.  I don't much feel like writing anything extensive today, but it is Thanksgiving, and I am thankful for many things, including the friendship of my team and the people who write to me from this blog. 

So, I will quickly answer Tenchy, who would like to know how to follow my instructions for applying XSLT to an RDL in the vastly-changed dialogs supplied with Report Designer 2008.  As he says "I don't see a Data Output tab in the newer version.", and this is true, the dialog I wrote about in that walkthrough is no longer present.  But the capability is still there:

... and of course the ability to do this is still based in the RDL schema, which includes this in the updated version:

<?xml version="1.0" encoding="utf-8"?>
<Report 
xmlns:rd=http://schemas.microsoft.com/SQLServer/reporting/reportdesigner 
xmlns=
http://schemas.microsoft.com/sqlserver/reporting/2008/01/reportdefinition>
  <Body>
    <Height>2in</Height>
    <Style />
  </Body>
  <Width>6.5in</Width>
  <Page>
    <LeftMargin>1in</LeftMargin>
    <RightMargin>1in</RightMargin>
    <TopMargin>1in</TopMargin>
    <BottomMargin>1in</BottomMargin>
    <Style />
  </Page>
  <DataTransform>x.xslt</DataTransform>
  <rd:ReportID>c6393baa-3c07-4d3d-a47d-15699770ddbe</rd:ReportID>
  <rd:ReportUnitType>Inch</rd:ReportUnitType>
</Report>

Tenchy would also like to know whether the technique shown in that post will allow him to get the Excel sheet names based on some data in a subreport.  This will depend on what data he's talking about.  The subreport output is contained in the XML, just like the "main" report, because it's part of the report output.  (You will see nodes like this

<Report Name="AggSumsSubReport"></Report>

... with the details of the subreport contained in them.) However, if the layout controls that Tenchy wants to leverage are in the subreport page header or page footer, they won't be available, same as the main report.

Same as it ever was.  And yet, somehow, all changed.

Tags:

Comments (18) -

11/25/2009 1:31:49 AM #

fishing organizations

I am very sorry to hear about the loss of your cat. I have lost several cats myself and I know the heartache associated with it. It is easier to get through when you remember that she lived a good life with good time and is in a happier place.

fishing organizations United States

11/25/2009 2:44:35 AM #

&gt;L&lt;

Thank you.  She definitely did live a good life with good times.  Appreciate your thoughts.

>L< United States

11/25/2009 7:34:35 AM #

Tenchy

Thanks Lisa, First foremost, I'm sorry to hear about your cat, when we lost our family pet of 18 yrs, we were heartbroken, but it helped so much to remember all the good times.

Secondly, I'm a female. Lol, felt weird reading all "he's" lol...I'm all She.

Thirdly, THANK YOU THANK YOU THANK! I havent had a chance to full work through it, but i think it will work. My layout controls are not in the header or footer, so i think i will be good. I'll let you know in a couple days. Thanks for all the help again!

Tenchy United States

11/25/2009 8:53:52 AM #

&gt;L&lt;

I am so sorry about the gender mix-up Tenchy! <rofl> Usually I am much more careful when I don't know for sure.

>L< United States

11/29/2009 1:48:02 AM #

Leonard

Poor Kami, on the top of the page, is that she?

Leonard People's Republic of China

11/29/2009 2:46:17 PM #

Furacoua

I´m sorry for the loss of your cat. I think she had a great life with you and she will always be thankful. Is it her on your banner?

Furacoua Sweden

11/29/2009 10:14:07 PM #

&gt;L&lt;

Yes, to both Furacoua and Leonard, Kami is the cat on my banner.  In our yard, where she happily ignored us and was teased by the birds, for many, many pleasant hours...

>L< United States

12/7/2009 12:37:32 PM #

Health Strength Fitness

I am very sorry to hear about the loss of your cat. I have lost several cats myself and I know the heartache associated with it

Health Strength Fitness United States

1/2/2010 2:20:22 PM #

Physiotherapist

THANK YOU THANK YOU THANK! I havent had a chance to full work through it, but i think it will work. My layout controls are not in the header or footer, so i think i will be good. I'll let you know in a couple days. Thanks for all the help again!

Physiotherapist United States

1/8/2010 2:19:22 AM #

Peluang Usaha Ahasu Gnaulep

Nice information, valuable and excellent design, as share good stuff with good ideas and concepts, lots of great information and inspiration, both of which we all need, thanks for all the enthusiasm to offer such helpful information here.


Peluang Usaha Ahasu Gnaulep United States

1/12/2010 10:19:39 AM #

Harrison Stuart

Great detailed tutorials.  You've made a pretty hard job when you tried working even if you're not doing alright.  More than that, I'm amazed how you considered your cat as part of your family.  
Condolence to you...  Enjoy life and adopt a new cat!


Harrison Stuart United States

1/12/2010 11:59:23 AM #

&gt;L&lt;

Thank you Harrison... to be honest, I'm amazed how the cat considered us part of *her* family <g>.

>L< United States

1/17/2010 10:53:40 AM #

Informasi Teknologi

hi lisa, thanks for post. ur blog is very informative. Smile

Informasi Teknologi United States

2/7/2010 9:48:11 AM #

The Stop Snoring Exercise Program

This is a nice article about the cat. I am feeling about the cat. That was very nice. I have also lost my cat long time ago. So i can understand what is the feeling of loosing any pet.

The Stop Snoring Exercise Program United States

2/21/2010 11:14:04 PM #

help animals

I always have the feeling my rescued cat Dylan thinks he owns us, not the other way around. It is so sad to lose a pet and people who don't live with them often can't understand the gap they leave.

Thank you for expanding on your previous post - a great help.

help animals Australia

4/1/2010 11:57:42 AM #

Massage School Chicago

very very helpful article , i am really happy.I have also lost my cat. i am thankful to this sharing. nick

Massage School Chicago United States

5/3/2010 4:43:15 PM #

Used Trailers

Bless you " daylight is good arriving at the right time , it is not always going to Grey " here come the sun

Used Trailers Indonesia

6/29/2010 10:59:18 PM #

Clinical Research

This is a great loss according to me! Even i had experienced this when i lost my dog, momo, last year!

I have bookmarked your blog so that i can visit it in future and know more about your life..

Clinical Research United States