Data Set Error

What does the following error message mean?
ERROR:
[rsMissingDataSetName] The data set name is missing in the data region
â'DataSetNameâ'.Well, perhaps you didn't bind the data region to a valid data set. Why don't
you check out the data region's properties? Remember that the data set name
is case sensitive.
I hope this helps

Data Region/Matrix Control Wrapping Around

Hello All,

In my report, I have a Matrix control placed next to a table. It renders properly and displays data aligned in two controls in Visual Studio Preview. However, when I deploy to production, it wraps the matrix control below the table, in fact puts the entire matrix control underneath the table. Why such strange behavior and not in the Preview of the report but only in Production? Any ideas how to fix this?

In VS Env. Preview --> [Table][Matrix]

In Report Svr Prod --> [Table]

[Matrix]

Thanks,

Try making a 2 column, 1 row table with the table and matrix in the left and right cells, respectively.
Set the datasource of the table to be one of your already used datasets.|||

Do you mean in the Details or Header/Footer of the table? If I put in the details it returns with following errors dialog

Microsoft Report Designer

Cannot place a Table/Matrix at this location in the table

|||I didn't specify. I know I've received that error and have tried to place the piece in the header instead. I believe that works fine - but there's one way to find out.|||Well, I tried that but it din't work. The thing is that the table and matrix have different data sets. And the containing table can only have one data set name, that is why the report designer is complaining... May be I am missing something but it really sucks that the control renders one way in development and differently in production.|||

In my experience, Matrix reports almost always do not render properly on deployment. I do not know of any one method to fix such alignment issues, but in general try making sure that the components do not overlap even slightly with each other.

Also, try putting both inside a single rectangle, if they are not already in one.

Hope this helps,

-Aayush

|||

Yes, that worked. I use three rectangles though. One for table. Second for Matrix. The third one is the container. So, its sort of like the table header solution as suggested above by TU5 but without a table. The problem indeed was the overlapping report items --> "SSRS does not support overlapping report items in all rendering formats".

Thanks.

Data Region/Matrix Control Wrapping Around

Hello All,

In my report, I have a Matrix control placed next to a table. It renders properly and displays data aligned in two controls in Visual Studio Preview. However, when I deploy to production, it wraps the matrix control below the table, in fact puts the entire matrix control underneath the table. Why such strange behavior and not in the Preview of the report but only in Production? Any ideas how to fix this?

In VS Env. Preview --> [Table][Matrix]

In Report Svr Prod --> [Table]

[Matrix]

Thanks,

Try making a 2 column, 1 row table with the table and matrix in the left and right cells, respectively.
Set the datasource of the table to be one of your already used datasets.|||

Do you mean in the Details or Header/Footer of the table? If I put in the details it returns with following errors dialog

Microsoft Report Designer

Cannot place a Table/Matrix at this location in the table

|||I didn't specify. I know I've received that error and have tried to place the piece in the header instead. I believe that works fine - but there's one way to find out.|||Well, I tried that but it din't work. The thing is that the table and matrix have different data sets. And the containing table can only have one data set name, that is why the report designer is complaining... May be I am missing something but it really sucks that the control renders one way in development and differently in production.|||

In my experience, Matrix reports almost always do not render properly on deployment. I do not know of any one method to fix such alignment issues, but in general try making sure that the components do not overlap even slightly with each other.

Also, try putting both inside a single rectangle, if they are not already in one.

Hope this helps,

-Aayush

|||

Yes, that worked. I use three rectangles though. One for table. Second for Matrix. The third one is the container. So, its sort of like the table header solution as suggested above by TU5 but without a table. The problem indeed was the overlapping report items --> "SSRS does not support overlapping report items in all rendering formats".

Thanks.

Data region in RS allows only 1 data source - virtual cube solutions?

I have a report requiring two different data sources be compared in one
data region. For example, I'm comparing a measure for a client against
a national average. The client measure comes from one cube and the
national average is stored in a sql database. RS won't allow two data
sources to be used in a data region unless you can use an aggregate
function on the second data source. I attempted to solve this by
creating a cube for the second data source (national averages) and then
a virtual cube to make one data source (i.e. one MDX statement from the
virtual cube per data region) for RS. The orginal MDX used for the
first data source required slicing by dimensions not included in the
national average cube and visa versa. I have been able to get the
correct answer for each cube before combining into the virtual cube,
but I can not get the measures correctly in the virtual if, for each
measure, I need to slice by a dimension that is not shared. I haven't
been able to find the information anywhere (and I've tried internet and
2 books), but because my measures are not correct I assume that a
virtual cube in only useful if the correct results are obtained by
slicing into only the shared dimensions? Are there any other solutions
to the rediculous RS limitation of only being able to provide one data
source to a data region? What we they thinking'oops, should have used spell check before submitting. it is a
ridiculous RS limitation.|||Hi Carrie,
I believe you can refer to more than one datasource from a data region such
as a table. Try putting in two data sources on a report and drag data from
them both into a table (note, you have to set the tables data source to one
data set).
see how that goes
<cwilliams@.choosehmc.com> wrote in message
news:1104767162.584780.225260@.z14g2000cwz.googlegroups.com...
> I have a report requiring two different data sources be compared in one
> data region. For example, I'm comparing a measure for a client against
> a national average. The client measure comes from one cube and the
> national average is stored in a sql database. RS won't allow two data
> sources to be used in a data region unless you can use an aggregate
> function on the second data source. I attempted to solve this by
> creating a cube for the second data source (national averages) and then
> a virtual cube to make one data source (i.e. one MDX statement from the
> virtual cube per data region) for RS. The orginal MDX used for the
> first data source required slicing by dimensions not included in the
> national average cube and visa versa. I have been able to get the
> correct answer for each cube before combining into the virtual cube,
> but I can not get the measures correctly in the virtual if, for each
> measure, I need to slice by a dimension that is not shared. I haven't
> been able to find the information anywhere (and I've tried internet and
> 2 books), but because my measures are not correct I assume that a
> virtual cube in only useful if the correct results are obtained by
> slicing into only the shared dimensions? Are there any other solutions
> to the rediculous RS limitation of only being able to provide one data
> source to a data region? What we they thinking'
>|||The answer is to create a calculated member using the ValidMeasure
function for each measure in the virtual cube. Just in case anyone is
interested...sql