Report Builder copy matrix from existing report to new report is not showing data when run

[garythomannCoGC]

Trying to resolve an issue which I believe is some sort of ghosting of rectangle objects (containers) where pdf export is not shrinking hidden sections in page header.

After much fing around now trying to recreate the report from scratch  ie start with a blank report, copy objects from the 'existing' report and test as we go.

The body has a tablix which displays the data.  But after copying the matrix from the 'existing' report to the 'new' one the matrix is not dispaying the data.  All the querys, parameters are there.  Comparing the matrix properties of both the 'new' and 'existing' reports are exactly the same.  And importantly the DataSetName points to the dax query.

I have inserted a simple matrix into the 'new' report to test and works fine.

What am I missing ?

[garythomannCoGC · Accepted solution]

<expletive>  the parameters are multivalue and so need to be referenced via the Join expression, otherwise the values will not be passed in correct format to the query.

=Join(Parameters!Directorate.Value,"|")

<expletive> <expletive> <expletive> 

[garythomannCoGC]

All parameter querys work in Query Designer.

Inserted table object connected to parameter query and returns data to form.

Main query runs in dax studio.

Main query validates in Dataset Properties mode.

It seems like the main query is not returning data.  Even though works in existing report.  Works in dax studio.

I avoid Query Designer like the plague.  Add parameters and default values to main query in QD.  And matches records returned to that of existing report.

So the dax querys within the 'new' report work within QD.  Inserting a simple table based on one of the parameter querys displays.  But inserting a table based on the main query does not work.

Using CountRows() shows we have 0 rows returned for the main query.  <expletive>

The main query Dataset Properties.Parameters have all the parameter links.  And cross checking to the 'existing' report matches.

Running the reports side by side we have the exact same parameter values.  And the reports display as such both in the parameter ribbon and the header parameter display section.

Definitely not a 'wrong database' scenario ... only one dataset to choose from.  No other environments like dev or test.

What brain-dead thing and I missing?   Has to be something simple "}

[garythomannCoGC]

Tried to make a duplicate copy of the matrix within the existing report as a test and get the following error.

The Value expression for the textrun 'Revised_Budget2.Paragraphs[0].TextRuns[0]' contains an error: [BC30456] 'RdlObjectModel' is not a member of 'ReportingServices'.

Can not find the object  Revised_Budget2.   

Maybe this is a furphy test but one would think that this would just work!?

Any other reporting tool I have used (power bi, ssrs, oracle reports, crystal reports) copying existing objects within and to other reports is standard practice without issue.