TechSpoken

"Any ideas?" is the most frequently-asked question in technical forums. My answer is: yes.

All things must pass and all things change

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.

Comments (18) -

  • fishing organizations

    11/25/2009 2:31:49 AM |

    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.

  • >L<

    11/25/2009 3:44:35 AM |

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

  • Tenchy

    11/25/2009 8:34:35 AM |

    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!

  • >L<

    11/25/2009 9:53:52 AM |

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

  • Leonard

    11/29/2009 2:48:02 AM |

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

  • Furacoua

    11/29/2009 3:46:17 PM |

    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?

  • >L<

    11/29/2009 11:14:07 PM |

    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...

  • Health Strength Fitness

    12/7/2009 1:37:32 PM |

    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

  • Physiotherapist

    1/2/2010 3:20:22 PM |

    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!

  • Peluang Usaha Ahasu Gnaulep

    1/8/2010 3:19:22 AM |

    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.


  • Harrison Stuart

    1/12/2010 11:19:39 AM |

    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!


  • >L<

    1/12/2010 12:59:23 PM |

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

  • Informasi Teknologi

    1/17/2010 11:53:40 AM |

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

  • The Stop Snoring Exercise Program

    2/7/2010 10:48:11 AM |

    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.

  • help animals

    2/22/2010 12:14:04 AM |

    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.

  • Massage School Chicago

    4/1/2010 12:57:42 PM |

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

  • Used Trailers

    5/3/2010 5:43:15 PM |

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

  • Clinical Research

    6/29/2010 11:59:18 PM |

    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..

Comments are closed