-
Ever had one of those days that just doesn't end?
I'm still in CRM customization heck. I have no beer at home and I only drive by the beer store every day on the way to the customer's site, but I'm too damn tired and lazy to stop and pick some up on the way home.
Tonight, about 9:00pm, I figured I still had at least another hour or two of work remaining and I just couldn't stand it any more.
I live in a "dry" city (no packaged alcohol ) so the nearest place for beer and wine ( but no booze ) is a little Texaco about 3 miles away. Believe it or not, they have excellent selection and I am now the proud owner of two bottle of Young's Double Chocolate Stout.
Well, one and one half, at this point.
Anyway, I figure that I can write this butt-ugly SRS report sans beer or not. And after last night, I need something to help me sleep.
Of course I'll also be up all night peeing, so what the hey?
Later, Mitch
PS. Don't tell my Mom I'm drinking. Says its bad for me. Causes AIDS and stuff. No wait; that was the hookers. Never mind.
Love you Mom.
Meanderings, Misc 839 views -
Removing Sub-Accounts from the Dynamics CRM 3.0 Account Form
Ben Vollmer had an excellent post on how to hide navigation items using a bit of JavaScript.
I decided to put that into play tonight to remove the Sub-Accounts navigation option when the user displays the Account screen. We don't want Sub-Accounts on this solution so the following code will remove it.
Just put it into the Account Form OnLoad event.
var navSubAcct = document.all.navSubAct;
if (navSubAcct != null) { navSubAcct .style.display = "none"; }
Thanks Ben.
Customization, Dynamics CRM 1,771 views -
Blog category for Convergence 2006 in Dallas
Misc 1,532 views -
Interesting Dynamics CRM 3.0 Reporting Issue
So this afternoon, as we're going our customer a demo of their system ( of course ), we noticed that two of our reports had magically disconnected themselves from their data sources.
I have no idea how this happened, but when you ran the report, you got an SRS error mentioning an invalid the data source or something.
Editing the reports via http://crm/reports (report, properties, data sources ) allowed me to reconnect the report to a pre-defined, shared system datasource and things were back to normal.
What I find alarming is the fact that these two reports have not been touched since Feb 23rd and we've made no configuration changes regarding reporting services or anything.
Anyway, if this happens to you, just go reset the data source connection and you should be back in business.
Oh, this is SRS 2000.
Later, Mitch
Dynamics CRM, Reporting 1,458 views -
Thought for today
So, I've had 5 hours of marginal sleep, I'm neck deep in CRM and SQL Reporting Services development and customization, and the weather here in Dallas is just wonderful today.
But I'm stuck inside typing my life away and all that I can think about is, "It sure would be a good day to run away and join the circus."
If only it were so easy…..
Meanderings 765 views -
Combining MSCRM 3.0 data fields in SQL Reporting Services
If you are working with SRS and need to combine two CRM fields together, but having each on its own line, use the following expression:
=Fields!ShipToName.Value & vbCRLF & Fields!ShipToAddress.Value
vbCRLF is a special system constant that contains the values of carriage return and line feed characters.
Dynamics CRM, Reporting 1,767 views




