



bits and bytes of my life experiences
First of all I must say I hate politics. But at the moment my county is at war because of political madness. Majority of the Colombo community is jubilant by the war, but for me no matter who gets most of the kills at the end of the day we have lost HUMANS. I really disappointed about the way things happening around me. What I seen every where is growing disappointment in Tamils, Sinhalese as well as Muslims. I believe this can drive us in to a major conflict than what we have now. One of my friend told me in England, inside of some Tamil dominated restaurants they have banned using Sinhala. Everyday both LTTE and SL Forces kill some people for both parties they have good solid reasons (everything is humanitarian missions) but what about the people who get stuck in between?
I have one of my cousin work in Sri Lankan Airforce Palali camp and I know how hard for their parents and relatives to bare it. Every news which says about LTTE attacks are brings them sleepless nights. I think some fundamentalists in down south of the Island does not feel this as they always cry out for blood.
Your comments are welcome.
When I was doing some customizations on standard CRM 3 reports I found that it is much difficult to edit existing complex Datasets. Visual Studio 2005 IDE itself does not support to edit these complex datasets in Query builder. So it is really a headache to edit the SQL statements instead. The really bad thing is if you manage to change the SQL statements (which is a nightmare) when you trying to save the dataset VS 2005 get stuck (most of the time) or will take lots of time (actually more than that).
So I went mad trying to do this tedious work. Finally found a work around which is worth sharing. Inside SQL Reporting services, report file(.rdl) is actually XML file which contains connection details, dataset queries, reporting fields and every detail which required generating the report. So what I did was editing this XML file, but one thing you should remember is never try to understand the XML file. Just find the required query you want to edit and change it and save the XML file. Now you can open the dataset it in the VS and modify the report.
Happy coding..