Microsoft CRM 4.0 annoyance number.....

Ok, follow me here...

 

I have a picklist.

 

I have in this picklist values that are meaningful to my client.  They are steps in a process that they use.  These steps have names.  I am able on the attribute to place these steps in any order I please.  I am able to move the order around.  Pretty good little tool so far.  Behind each text value is a numeric value (pretty simple from my end starts with one and goes up by one for each item on list).  So, for my user, these items are working well, logical, works for them.

 

I now need to add a report for this client.  We need to use the values from this picklist and know how many records are in each bucket.  We won't discuss the reporting tool here, it has good and bad.  It doesn't work the way my brain would expect it to work.  but it makes reports.  I wanted to show my client how to make and use reports from CRM without passing it off to a developer, so don't suggest that, it would defeat one of the main purposes of the exercise.

 

So, I get my records to report on.

 

I make a grouping by the values in this picklist.

 

Take out those with no data.

 

The only way for these values to appear is in ALPHABETICAL order, ascending or descending.  What the heck?  If I wanted alpha order, shouldn't I just put it in that order on the list?  Shouldn't it be the way I put it on the picklist for reporting too?  Maybe give me an option for alpha order or system order?  But, alas, I am stuck with alpha ordering on a report where it makes NO SENSE.

 

 

grr.

Previous Post

Signs that I'm doing ok as a parent

Jun 19
Driving home today with the kids, Queen blaring on the radio, I realized I'm doing an ok job. How do I know this? Well, consider... They each knows the words to at least 5 songs by Queen, including Fat Bottomed...
Next Post

Our teens are hooked on Baby Smash

Jun 23
This is what nerds do when they become parents- Baby Smash. With his young (toddlers and less) kids wanted to be like daddy, Scott needed something for them to do. Without causing harm to daddy's computers. So, tadah, Baby Smash....

Comments

Verify your Comment

Previewing your Comment

This is only a preview. Your comment has not yet been posted.

Working...
Your comment could not be posted. Error type:
Your comment has been posted. Post another comment

The letters and numbers you entered did not match the image. Please try again.

As a final step before posting your comment, enter the letters and numbers you see in the image below. This prevents automated programs from posting comments.

Having trouble reading this image? View an alternate.

Working...

Post a comment

Your Information

(Name is required. Email address will not be displayed with the comment.)