on 05-16-2011 12:47 PM
Hi Folks,
I have requirement of modifying an existing report which contains SKU,LableName,LableValue,RTSM. SKU and RTSM are unique across whole report. But they are repeating due to different values in LableName and LabelValue. For example,
SKU RTSM LableName LabelValue
10914010 5000-3013-7767-9931 HostName available
10914010 5000-3013-7767-9931 HostName trns00
The requirement is user wants unique records for each SKU,RTSM combination. I have thought of setting Master-detail. But any of you could please tell me any other alternative by which i can include lablename and labelvalue columns.
Thanks,
Manish
In Master Detail (Seciton) also you can add the lablename and labelvalue columns in the table. Just insert the balank column and use the coulmn lablename and labelvalue.
Also, try using apply brack on lablename and labelvalue columns. use brak Property for the required seeting you want to be display.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
I could see that there are 2 value trns00 & available in a column. So you are getting 2 rows respected to each value of "trns00 & available".
If you will remove this coulmn you will get distinct value.
You can user "Distinct" in the SQL query.
Also you have table propert "avoid duplicate row". But this will work only if you have duplicate rows. But here I can see there are 2 different value in a cloumn which is causing the display of the 2 rows.
Explain to the user the situation, ask how they want it presenting.
They cannot have both unique values of A and B as well as showing both versions of C and D! It's not physically possible.
You can present it whichever way they want once they know what they want. Welcome to the world of making the user decide what they actually want.
User | Count |
---|---|
88 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.