How to retain Primary keys in Report Builder

• malavika.ramanathan

  SSCrazy

  Points: 2790

  More actions

  May 27, 2010 at 10:50 pm

  #387037

  Hi All,

  In the Report Builder Reports, In the DSV i have changed the table query by selecting the primarykey twice with different aliases and i have made the alias as LOGICAL PRIMARY KEY.

  I did this because i need to take COUNT on this Primary key column in my report.

  But now after deploying i am not able to see either of them in the report builder.

  Without this i cant proceed with my report.

  Can anyone please suggest how can i overcome this?

  Any help/suggestion in this regard is greatly appreciated.

  Thanks

• malavika.ramanathan

  SSCrazy

  Points: 2790

  More actions

  May 28, 2010 at 3:34 am

  #1173803

  Hi All,

  I could solve this. No w am getting my matrix report correctly.

  I would like to share this with you all so that it may help some....

  I did the following:

  1. My requirement was to show the count of PK of a table against different status.

  So in that table in DSV, i selected the "Replace Table with New named Query" option.

  There i changed the query by selecting the primary key of the table twice by giving alias to one of them.

  (Ex: Select empid, empid as ID , ....(other columns) from employees)

  and set that ID as LOGICAL PRIMARY KEY.

  Then i deployed the project.

  2. I could now see the ID column in the Report Builder column list.

  3. I used that column according to my requirement.

  Now i am getting totals based on this ID column!!!!

  Hope this helps someone...

  Also, experts, please guide me if there is a better way of achiving this.

  Your suggestions are always welcome.

  After this i have one more issue....

  I need to create a drill down report for this report now. This is a matrix report. I am using Report Builder 1.0

  Is it possible ? Please guide me

  Thanks,

  Malavika.