Custom Reports backup

[atul557]

Hi Team,

We wanted to know if we can take backup of custom report made in LS.
Apart from DB backup is there any other way so that a backup can be taken for all reports created.

Regards,

Atul S

[miek_g]

I am receiving this error "The function is not recognized by SQL Server Compact. [ Name of function = Object_Id,Data type (if known) = ]"

[esr]

I'm using this currently....

Select Top 1000000 tsysreports.Reporttitle As Title,
  OBJECT_DEFINITION(Object_Id(tsysreports.Reportquery)) ViewScript
From tsysreports
Where tsysreports.Created Is Not Null
Order By Title

[Duncan_Miles]

esr wrote:
I'm using this currently....

Select Top 1000000 tsysreports.Reporttitle As Title,
  OBJECT_DEFINITION(Object_Id(tsysreports.Reportquery)) ViewScript
From tsysreports
Where tsysreports.Created Is Not Null
Order By Title

Just what I was after! great, thanks

[atul557]

esr wrote:
I'm using this currently....

Select Top 1000000 tsysreports.Reporttitle As Title,
  OBJECT_DEFINITION(Object_Id(tsysreports.Reportquery)) ViewScript
From tsysreports
Where tsysreports.Created Is Not Null
Order By Title

thanks for the report
Its really helpfull

[miek_g]

I would also love to be able to do this, a full backup can be done https://www.lansweeper.com/kb/94/backing-up-your-installation.html But I would like to just backup any custom reports