Cross Joins Error

[mark123]

Hi,

I am getting the following error for my query in Report Studio.
Is there problem in Framework model or in my report.

[BigChris]

Hi,  Really difficult question to answer. I would assume it's a problem with the report, since I would have thought the Framework would have been tested before it got to that stage. Have you got queries joining together? If you have then make sure you've defined the links between the queries.

[MFGF]

Hi,

I am getting the following error for my query in Report Studio.
Is there problem in Framework model or in my report.

Hi,

Bear with me for a moment. Mmmmmmmmmmmmmmmmmmmmmmmmmm. Oooooooooooooooooooooooooooooooooo. Aaaaaaaaaaaaaaaaaaaaaaaaaaaaa.
Sigh. Nope - no luck. Trust today of all days for my clairvoyant psychic mind-reading thought-induction machine to be malfunctioning. Sorry - we're going to have to do this the old-fashioned way.

Can you tell us how your report is written? What queries are there? Are you trying to reference an item from a query in an object belonging to a different query?

MF.

[bdbits]

Not a lot of info to go on, but that kind of looks like handwritten SQL to me. If you have a handwritten SQL statement and are trying to join it to another query subject (handwritten or not), I am thinking that would be considered a cross-product join. Which might not be allowed by your model.

And if that is handwritten SQL then to me... well, you're doing it wrong. In my opinion.