Page 2 of 2
Re: converting rows to columns
Posted: Mon Aug 15, 2022 7:48 am
by dmasterplan
Hi,
Please use the second file that I attached (DrawingsAndRevisions2.mrt) and the database.
Regards
Re: converting rows to columns
Posted: Mon Aug 15, 2022 9:17 am
by dmasterplan
Apologies, I attached 2 report files.
Please use the second one I sent, DrawingsAndRevisions2.mrt
and the database is themasterplan.
Thanks
Re: converting rows to columns
Posted: Mon Aug 15, 2022 9:21 am
by Lech Kulikowski
Hello,
We use that file. Tables are not present in the sent database.
Thank you.
Re: converting rows to columns
Posted: Mon Aug 15, 2022 12:30 pm
by dmasterplan
Please try this one. I really need to finish the report.
Thank you
Re: converting rows to columns
Posted: Mon Aug 15, 2022 8:36 pm
by Lech Kulikowski
Hello,
Please check the modified reports in the attachment, 1 - grouped by SQL query, 2 - adding an additional data source.
Thank you.
Re: converting rows to columns
Posted: Tue Aug 16, 2022 6:26 am
by 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.
Re: converting rows to columns
Posted: Tue Aug 16, 2022 6:57 am
by 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.
Re: converting rows to columns
Posted: Tue Aug 16, 2022 3:23 pm
by dmasterplan
I see.
Thank you for answering that
Re: converting rows to columns
Posted: Wed Aug 17, 2022 6:32 am
by Lech Kulikowski
Hello,
You are welcome.