Welcome to MSDN Blogs Sign in | Join | Help

What is that extra column of 'AB.gAAAA=' values when I run a report model query?

Most people using Report Builder 2.0 with a report model soon ask the question, what is that extra column I get back with strange values like “AC8AAAA=” in it?

Answer: It's an entity key value. If you’re going to create a group on that entity in your report, you should use this field as the group expression. This is especially important if you’re going to create Clickthrough links, because those key values will be used to filter the target report, and filters on keys usually have better performance.

Published Friday, March 06, 2009 9:36 AM by bobmeyers

Comments

# re: What is that extra column of 'AB.gAAAA=' values when I run a report model query?

Tuesday, March 10, 2009 9:22 AM by idybil

Hello Bob's,  thanks for this anwser, I finally know why the extra column appears.

But, is it possible to hide it by some kind of settings in the report model or report builder ?

Because report builder at our place is used by end-users and a lot of them are very confused about it, they don't pick the right column, execute the report and found the "Ab.gaaa="

Thanks

# re: What is that extra column of 'AB.gAAAA=' values when I run a report model query?

Monday, August 10, 2009 7:19 AM by Exigy

Hi,

Im having the same issue. For user simplicity we would like this column not to be auto-generated, or at least not shown.

Is there a solution for this please?

Anonymous comments are disabled
 
Page view tracker