Hello,
Currently, we are trying to copy/clone an existing report from a current folder to a new folder. Everything works well except for the SQL Server Stored Procedure that is used to query the data. Inside this stored procedure, we must declare a schema name (like SEED. / DEMO. / TEST. ) before each table that we want to query, just as below example:
FROM DEMO.GACCENTRYD D
LEFT JOIN DEMO.GACCENTRY E ON D.NUM_0 = E.NUM_0
LEFT JOIN DEMO.COMPANY C ON D.CPY_0 = C.CPY_0
LEFT JOIN DEMO.GACCOUNT A ON (D.COA_0 = A.COA_0 AND D.ACC_0 = A.ACC_0)
LEFT JOIN DEMO.BPARTNER P ON (D.BPR_0 = P.BPRNUM_0 OR (ISNULL(D.BPR_0, '') = '' AND D.OFFACC_0 = P.BPRNUM_0))
So the issue is here: this stored procedure only works for 1 particular folder only, which is specified inside the stored procedure to tell which schema/tables that we query the data from.
For another folder, we have to replace the schema / folder name accordingly and we have to create a copy of the same stored procedure and maintain them all the time.
Do you have any better idea for us to resolve this issue? Many thanks!