Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
mrm23
Posting Yak Master
198 Posts |
 Posted - 2010-05-28 : 01:09:39
|
| 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 |
|
|
mrm23
Posting Yak Master
198 Posts |
Posted - 2010-05-28 : 05:42:39
|
| 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.0Is it possible ? Please guide meThanks,Malavika. |
 |
|
|
|
|
|
Retaining primarykeys in report builder .smdl file