Copy query print layout

[Former Member]

Hi Experts,

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

Thanks,

Don

[Former Member · Accepted solution]

Hi Don.......

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

Regards,

Rahul

[Former Member · Accepted solution]

Hi Rahul,

Thanks! I will use Copy express.

[former_member186095]

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.

Rgds,

Jimm