Print Layout Default to Inactive

[former_member458725]

Hi All,

I have two Print Layout designed in CR version 1.0 and 2.0. When am trying to INACTIVATE V 1.0  Layout, It shows - "Cannot set default layout status to In Active".

So where can I get this list of user who is using this layout as default. Is there ant Table SBO using for saying these information ?

Thank You

Vibin

[pierrecanali · Accepted solution]

Hi Vibin,

you cannot set inactive an layout that is set as default for one user, business parter or for all.

Try to set the new layout as default :

1. open the form to which the layout is related
2. click the pencil icon in the top tool strip
3. select the new layout
4. click set as default to all users and businesss partner to override previous configuraton
5. update each form
6. set the old layout as inactive

you can use this query to see current default layout with scope:

select
  t1.CODE as TypeCode
  ,t1.NAME as [Description]
  ,t1.DEFLT_REP as [Default ReportId]
  ,coalesce(t2.DfltReport, t1.deflt_rep) as ReportId
  ,coalesce('BP: ' + bp.CardName, 'USER: ' + us.U_NAME, 'ALL') as Scope
  ,case isnull(t2.CardCode,'-1') when '-1' then convert(nvarchar(max),t2.UserId) else t2.CardCode end as [Key]

from RTYP t1
  left outer join RDFL t2 on t1.CODE = t2.DoumntDode
  left outer join OCRD bp on t2.CardCode = bp.CardCode
  left outer join OUSR us on t2.UserId = convert(nvarchar(max),us.USERID)

order by TypeCode, t2.UserId, t2.CardCode, ReportId

Regards,

Pierre

[KennedyT21]

Hi Vibin...

Set the latest as the Default and try to remove..

Hope helpful

Regards

Kennedy