converting rows to columns

[dmasterplan]

Hi,

Please use the second file that I attached (DrawingsAndRevisions2.mrt) and the database.

Regards

[dmasterplan]

Apologies, I attached 2 report files.

Please use the second one I sent, DrawingsAndRevisions2.mrt
and the database is themasterplan.

Thanks

[Lech Kulikowski]

Hello,

We use that file. Tables are not present in the sent database.

Thank you.

[dmasterplan]

Please try this one. I really need to finish the report.

Thank you

[Lech Kulikowski]

Hello,

Please check the modified reports in the attachment, 1 - grouped by SQL query, 2 - adding an additional data source.

Thank you.

[dmasterplan]

Hi,

I finally got it right!
Just one question, why create an additional connection and datasource
instead of creating two datasources in one connection?

I would love to know.

Thanks a lot!

Just right for the deadline.

[Lech Kulikowski]

Hello,

> Just one question, why create an additional connection and datasource instead of creating two datasources in one connection?

In some cases, users did not allow to add SQL queries.

Thank you.

[dmasterplan]

I see.
Thank you for answering that

[Lech Kulikowski]

Hello,

You are welcome.