asked on

CRM 2011 SSRS Question

We have added some new fields to a Quote and now when I add them to my report, the new fields (plus an existing field) do not appear.

I am going to the Query Designer, adding the fields, refreshing fields, basically the same process I have been following. I am using an expression in a text box that looks like this: =Fields!salesmanemail.Value & vbcrlf & Fields!salesmanphone.Value and neither field's content appears on the report.

I have checked visibility, any hide conditions, allow height increase, created a new text box in the report, nothing seems to make the new fields appear

Any advice would be appreciated.

Arifhusen Ansari

Could you please post some screen shot of your data and report?

apollo7

ASKER

Can I share my desktop with you? There is a lot involved for screenshots. If that works for you, I can send you an invitation

Thanks

Arifhusen Ansari

I can not be online now. I can only communicate and see the screen shots but not have live view of desktop. Still you want live help, we can do that.

apollo7

ASKER

I will try screen shots and then we can go from there

apollo7

ASKER

Here is the big picture of VS 2010 rdl, using Dataset1. I continue to zoom in on the fields that are not appearing
C--Users-David-Pictures-big_picture.png

apollo7

ASKER

Here is a textbox that I am having problems with. With a single field, it works but not with an expression
C--Users-David-Pictures-single_field.png

apollo7

ASKER

Here is the same textbox with an expression (second field is a newly added field) - when I enter this expression, it doesnt display either field value
expression_used.png

apollo7

ASKER

Does this help? If you want more detail, let me know where I should go

apollo7

ASKER

Quick question, I have embedded datasets and the main one had a parameter that seemed to be preventing certain report functions.

I copied the parameter and changed it to null but this didnt help and now I am getting a parameter error.

I have copies of the report on several servers, if I copy from a different report will it bring the dataset with it?

Thanks

ASKER CERTIFIED SOLUTION

Chris Luttrell

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

apollo7

ASKER

Chris, thanks for the suggestion. I will add IIF statements in the expression to test for nulls.

apollo7

ASKER

Looking for the nulls, it revealed that my multiple datasources were in the wrong order, giving me the parameter error (CRM needs to be first), after that I could get the report to run and work with my datasets to get the non-null values.

Thanks