SSRS AdHoc model project: Entity Name - lable problem
Hi, I have created AdHoc model project. I have few entities, designed as parent-child (to handle one to many and many to many relation) Parent1 has Child_Entity11, Child_Entity12, Child_Entity13 and Parent2 has Child_Entity21, Child_Entity22, Child_Entity23 and Parent3 has Child_Entity31, Child_Entity32, Child_Entity33. Parent1, Parent2 and Parent3 are connected to each other but not the other parent's child directly. Now, when I deploy this model to report server and access in Report Builder 2.0, it looks good when nothing is on report design. but when I drag one field and when it will filter entity list and show only related entity only. then it's Child name label are not populating correctly. It is showing Child2, Child3 instead of ChildEntity11 or ChildEntity12. Any help would be appreciated!
November 19th, 2010 5:17pm

Does anyone get chance to look at this, or is it not clear. Basically, after deployment of model in SSRS2005, when I am trying to access model/ trying to design a report in Report builder 2.0, Label of child entities (related to that parent entities) do not look good. (not showing full name e.g. ChildEntity11, it showing Child2, Child3). how to show full label/name in report builder. Thank you so much in advance.
Free Windows Admin Tool Kit Click here and download it now
November 22nd, 2010 2:57pm

Hi Mahesh, Currently, there is no way to correct this in SSRS 2005 except you modify them one by one. However, i tried this in SSRS 2008, the entity columns like your formatting displayed normally. If you have any concern about this, submit a feedback http://connect.microsoft.com/SQLServer/Feedback and hope microsoft release any pack to fix it. thanks, Jerry
November 23rd, 2010 4:34am

Hi Jerry, Thank you so much for your time and help. you said: "except you modify them one by one" - where should I change. dsv/smdl of the model (all the enitities/fields) looks good before deployment. Now, when I deploy that model to Report Server, then also Entities looks good. BUT when I drag one if the Field from Entity then the related entities label are not showing correctly. e.g. We have 10 Entities, TableTabA, TableTabB, TableTabC,... they are related to each other. now when I see this model in the report builder (without dropping any field on the 'designer') it looks good. BUT when I drag one of the field from one of the entity, then related entities do not show correctly. e.g. Table1, Table2, Table3... I do not know is it a bug or what. Thanks! a lot in advance.
Free Windows Admin Tool Kit Click here and download it now
November 23rd, 2010 11:14am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics