Notifications
Announcements
No record found.
Hi, how can I create a ssrs Report that Show cross Company data? I want to extend an existing Report but there I do have the Problem that cross Company is not allowed with tempDB.
*This post is locked for comments
If it's a system report that uses a TempDb table and therefore a data provider (DP) class to generate that data, then it may require some code modifications in order to loop through all companies and insert records from each into the TempDb table. You may also then be forced to add your own field to the TempDb table, such as Company since you can't add or use DataAreaId, to maintain a reference back to the original company so it can be printed on the report.
What report is it?
It's the TaxListReport (which has changed in R3). I did something similar in RTM but the Report completely changed in its Development inside R3
have a look at Procurement and sourcing>>Reports>>Vendor Requests>>Vendor Requests.
Thanks a lot for the advice but I am still struggling with the TaxList
It is completely different from creation point of view and I am absolutely not familiar with it.
I've looked at the DP briefly.
processReport() calls a bunch of instance methods. First, it calls insertTaxListTaxTmpData() which populated the TempDB table with a query, using an insert_recordset for performance. Then it calls updateTaxListTaxTmpData() to fill in secondary fields.
If the approach were simpler, I might suggest turning the query into a cross-company query, but this one looks pretty involved.
The easiest approach to this report might just be to loop through DataArea in processReport(), do a changeCompany(dataArea.Id), and let the report do what it does inside of each company context. You'll probably still want to add a Company field of type SelectableDataArea to the TaxListTaxTransTmp table, otherwise all the data will bleed together.
Does that make sense?
This looping basically sounds great and I just thought about something like this. But I still do have the problem to get a multiselect lookup on the queryform respectively get the Value List into the DP.
I played around and I have it on the form but therefore having all other Parameters 3 times as well and so on
I guess I assumed that your sales tax codes were shared among the companies as well as your chart of accounts. I'm not sure a cross-company report makes sense if they're not. Obviously voucher doesn't make sense at all.
yes for sure you are right in these cases but the Users want to create a TaxList for different companies (in one List) by a specific date. For all Tax Codes and basically all vouchers in such a case. for Voucher specific they only use it for one Company
That report does not look at all straightforward to turn into cross-company. Some reports are harder than others to achieve this.
What is your need here? To have a single PDF with all the pages together? To print many companies in one sweep without having to switch companies and print them individually? How many companies? To have all the raw data in a single Excel workbook? Perhaps there's a more inventive approach if what you're trying to achieve is flexible.
Hi
Exactly. Customer wants to print the data in just one report, grouped by company and Taxcode without changing companies
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
As AI tools become more common, we’re introducing a Responsible AI Use…
We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Martin Dráb 4 Most Valuable Professional
Priya_K 4
MyDynamicsNAV 2
