Showing results for 
Search instead for 
Did you mean: 

Copy query print layout

Former Member
0 Kudos

Hi Experts,

Is there a way to copy a PLD designed in query print layout from one database to another?



Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Hi Don.......

You may use Copy express to do that........



Former Member
0 Kudos

Hi Rahul,

Thanks! I will use Copy express.

Answers (1)

Answers (1)

Active Contributor
0 Kudos

Hi Don,

There is no query to copy PLD from one database to other except manually create the PLD in the new database.

You can try this query but only for the development only:

INSERT into [dbname2].[dbo].[RDOC]
SELECT dbname1.[dbo].[RDOC].* FROM dbname1.[dbo].[RDOC]
WHERE dbname1.[dbo].[RDOC].DocCode = 'INV20006'

INSERT into [dbname2].[dbo].[RITM]
SELECT dbname1.[dbo].[RITM].*
FROM dbname1.[dbo].[RITM]
WHERE dbname1.[dbo].[RITM].DocCode = 'INV20006'
AND dbname1.[dbo].[RITM].[Doccode]
IN (SELECT Doccode from [dbname2].[dbo].[RDOC])

The above query is only applicable for development db.

if you use crystal report, you can move the report from one db to other db.