Wednesday, June 21, 2006

rsRepeatWithNotPeerDataRegion

[rsRepeatWithNotPeerDataRegion]
The textbox ‘gDfA’ has ‘table1’ as the value of its RepeatWith.
A RepeatWith must be a data region within the same containing object as the report item.

The only Data Region on my report is my data table [table1], right? Does each group in a data table become its own Data Region? Not from my understanding of RDL

SSRS RDL Export Error

Having not worked out the "Column should remain visible while scrolling" nor the Excel format issues, I decided to try another approach. In an attempt to get something like freeze column and/or Excel’s “Columns to repeat at left” and “Columns to repeat at top” working on my report viewer and printed versions of a SQL Server Reporting Services RDL report data table, I broke the table up into four copies each with the same structure and a continuation of the original fields (table 1 fields A-O, table 2 fields P-AD, table 3 fields AE-AS, table 4 fields AT-BG). Each table has the same five groupings (gA, gB, gC, gD, Details). The tables and groups are all individually identified by name, and XML Collections and Elements. The XML export renders fine as does the XML Schema. The report renders fine in the Visual Studio.Net 2005 report viewer and on the web (deployed to report manager). It renders well to PDF, and web archive (.mhtml), but when choosing to export to excel, the following error is thrown.
[Export Error;
An error occurred during local report processing;
An error occurred during rendering of the report; An error occurred during rendering of the report;
Item has already been added. Key in dictionary: 'Group B Value' key being added: 'Group B Value']

What? Why?

If I can just find a direct way to “freeze” the Table Columns within a SSRS Table for the reader and excel export, I’d be good to go!

Exercise tiny step

I woke at 5 am Tuesday and go out on my mountain bike by 5:15. I road around the neighborhood for 15 minutes by which time my legs were spongy and my body covered in sweat. The rain and high humidity of the morning were annoying, but I have to start somewhere even if it is with such a tiny step. I am currently weighing in at 260 pounds up 20 from December 2005 when I took this job in Baltimore and increased my commute from York, PA by 20 miles.
If I get much higher, I will start having trouble with the weight induced apnea that spurred my original weight reduction quest in 2002 from over 300 pounds.
My nature one of extreme nostalgia, as such I constantly hear/see in my mind segments from past events, thoughts, dreams, life experiences (real or imagined).
In every case regarding fitness or my lack thereof, I see my high school freshman gym teacher Ms. Voeller saying, “you keep laughing it off, but if you don’t get into shape now your going to be 30 and it will be ten times more difficult to get where you need to be. I did a lot physically, but never pushed myself and was therefore quite overweight and not physically fit.
Funny thing is that I did listen to her and from that point through high school and my failed attempt at a military career (1988-1992) , I managed to go from nearly 300 pounds to 198 pounds; from being able to endure to actually being fit.
I am lacking in good self discipline and in organizational skill even to this day and repeated this cycle being back at 280 pounds by 1994, getting back on the fitness loop in 1999 when my back started bothering me due to a compressed disk earned humping shingles (roofing) as I paid my way through college. Somewhere in 2000, I dropped the proverbial ball again and started the loop again in 2002 due to the apnea issue.
What a mess.

I checked http://www.park1.k12.wy.us/powell_high/faculty.asp Ms. Voeller is reported as still on the faculty, I sure hope whoever the current fat active kid is she’s talking to today, has a stronger resolve then I did.

Tuesday, June 20, 2006

SSRS Report: "Column should remain visible while scroling"

Okay, I am a database developer sucked into some hundred different tasks due to the nature of my work. One is to build a ton of SQL Server 2005 Reporting Services reports. I have one table based report loved by the parties that be with one request. That the report render in Excel with headers, and left columns mimicing Freeze Pane as well as doing this on the web display. Web display table header was simple enough, "Header should remain visible while scroling" and Report header/footer rows on each page" when a long way, but this doesn't answer the export format nor the left column remain visible requests.
Everything I can find suggests "Repeatwith" property should be set to a data region, but there doesn't seem to be a way of doing this within a single SSRS table.

Monday, June 05, 2006

A new bike!?

Well, I will probably destroy this bike before it is well used. I am six foot two inches tall and weigh in at 245 pounds. I just purchased and put together a $60 26" bike from Wal-Mart with a maximum carrying capacity of 198 pounds ... No, I will return it tomorrow night and find a bike I can ride without blowing the tires! LOL I haven't been on a horse since high school due to my weight, I was at 300# back in 2002/2003. The lightest I've been since 1992 is 190#... There is a place in Baltimore just a few blocks from where I work, I'll check there to see what's available for a little guy like me! LOL Anyway, I had fun this evening reading to the kids while they went nuts in the bath and I made myself an awesome fish soup for dinner... my daughter and I are going in for an allergy work up in the next few weeks... the girl's reacted with anaphylaxis symptoms twice in the past year (eggplant and cranberry juice) .. I've always had allergies, but not to kill me just make life suck for a good portion of the spring, summer and fall. .. LOL ... I didn't really go through much pain growing up in Powell, Wy ... a barren, dry, and cold climate with beautiful evergreens, cactus, sage, thermals, animals and wild life to no end, but here in the seasonal climates of South-Central PA and Baltimore, well ... yuck! ... I love the weather, climate, etc, just not what it does to my body... LOL ... I just saw an article that most people who live in the region also have the same allergy issues ... just further proof that we're all nuts... suffering these symptoms by will is no better then choosing to live on the crest of a volcano, the path of a hurricane, the middle of a flood plane, or voting for Bush, we bring misery on ourselves by our own will and actions ... LOL Anyway, off to bed...