Hi
We have moved a customer from VFP to SQL SE.
I have been informed by Pegasus that any XRL reports will need to be rewritten for Opera 3 SQL SE.
Does anyone have any quick ways of doing without re-writing the reports as its very time- consuming and they have a large quantity of XRL Reports.
Regards
Darpal
Hi Darpal - as far as I know, you need to re-write. The table names are listed differently in XRL SE to the VFP version, and some of the filters work slightly differently/have different options available.
I found lining them up side by side and copying the fields and filters etc the easiest way and then amending filters as necessary the best option. Not sure if formatting can be copied across i.e. save as Internal or External Definition on the old report and load them on the new - not tried that as the reports I dealt with didn't have formatting as such.
Tony
hi im afraid, tont is correct. The table names are different. Even if you save as internal & extrenal definition ect, it filps over to the VFp version
So Ive done exatcly what Tonys done & had both open, as in the VFP verion & made a note/screenshot ofthe XRL formula, then created it in the SQL
Would have been good if there was a conversion!!!
Hi Darpal
We have some fieldnames are different and some fields don't exist , so its not truly like for like!
Jason
The only advise I can add is make sure that you are on the latest version. I have logged a lot of calls regarding missing links between tables and missing filters and Pegasus have made a lot of changes which is ongoing.
Hopefully it will get better !
Felicity
yes I would agree with Felicity!!! XRL doesnt appear to be like for like, eg unit price in the purchase orders is not there!!!
Thank you all for your help , its appreciated.
I also had the following FROM PEGASUS in case this question comes up in the future
We have also been asked about DataSends in XRL and these are not available for SE and, there are no plans to add these.
It is also worth noting that you cannot access any bespoke fields in SE with XRL as you cannot write custom Serducts with SE
I've created a bespoke serduct for a customer on SQL SE.......
That's frustrating as we have a fair few customers using the Data Send to update Special Prices.
We are struggling with simple reports for example using IT1 ( Itran transactions table ) creating a Summary report we keep crashing as soon as we enter the Line Quantity.
Product=Opera 3 SQL SE Platform=MS-SQL Table=IT1Error -2147217911 The EXECUTE permission was denied on the object 'pgfnFormatVal', database 'Opera3SECompany00A', schema 'dbo'.
Seems to be the same with other reports where we pick the Quantity fields.
Also, does anyone know how we add a sum to a field ?
Hi Darpel
Did you find a solution to the 'EXECUTE permission was denied error on the object 'pgfnFormatVal ...' error you were getting when creating a report on IT Transactions
We are getting the exact same issue when creating a detail report on IT Transactions when we add the line quantity or the goods value field. This happens in 3 companies we have written the report for (migrated from VFP) and also on the Z company (not migrated accross) on customer site but doesn't happen on our own SQL installation
Kerry
FWIW pgfnFormatVal is a user defined function on the SQL Server database. So it's a permissions issue with EXECUTE on that.
Hi Alan
Many Thanks for the response, much appreciated.
Hope you don't mind me asking, would you be able to give us any more information to point us in the right direction
Hi Kerry
Please could you try and check in SAM > Reporting , Users , Edit the user and check if the role have been assigned, so for example I have the Invoicing SOP processor ticked.
Also, in SQL , Security , Logins , User , Login Properties > User Mapping > I have Opera_SE_Role_Salesprocessor ticked as well.
Hope this helps
Kind Regards
The SAM side was all okay
Have followed your settings within SQL and reports are now working
Many thanks for the information
