SSRS Report Generation From RDD

[mlp]

After some experiments, I believe the issue lies within the RDD.

So let me pivot…

I have a plain JobTrav RDD here that I copied from the original. I was able to create the PlantWhse data source, but when I go to add the relationship, it says the key ID is invalid.

Original that is successfully used in a Crystal Report:

My attempt:

[dcamlin (David Camlin)]

@mlp

I have a plain JobTrav RDD here that I copied from the original.

Yup… I think the “Potential Gotcha” I mentioned earlier gotcha after all.

@dcamlin

POTENTIAL GOTCHA…. I know you have a custom RDD… just verify PartNum is not excluded on JobHead, because it IS by default. Since it is “excluded” by default, you won’t be able to use it in a relationship. But again, that may have already been accounted for by the previous Crystal requirements.

Since you’re working with a new copy, you should be able to uncheck the excluded checkbox on JobHead for the PartNum column. That may allow you to add it as a key.

You’ll need to do this anyway so you can use it in a relationship.

[jkane (John Kane)]

Do not select a Key.

[mlp]

Using the query above and remaking the RDD solved my issue. I now have a report that shows the main bin location! Thank you!!