Hi,

I am try to fetch the data from advertisements status to PDF & i am not able to get complete data in single page,

In those reports don't required few pages & please let me know how to create the custom reports for advertisements. 

Regards,

Siva.V

So to be clear the data already exists within one of the built-in report but when printer it is 2 ore more pages?

If this is the case, clone the report and remove any unwanted columns.

Thanks for the reply.

How to remove the unwanted columns from reports.

Regards,

Siva.V

You can use Report Builder for that.

Thanks for the reply!

Can you please help on navigate to delete the unwanted columns deletion.

Regards,

Siva.V

You will need to remove the unwanted data from the report query.

For example if you have a report displaying 5 field the query will look like this :

Select Field1,Field2,Field3,Field4,Field5
From SCCM
Where xxx

Remove the unwanted information by removing the field from the Select.

Sorry if it's a bit generic, paste the query and we'll be able to tell you what to remove.

You can also refer to this link :

http://blogs.technet.com/b/gary_simmons_mcs/archive/2013/12/10/creating-a-custom-report-for-system-center-2012-r2-configuration-manager-part-3.aspx

Thanks for the reply

below is the query

declare @Total int
              declare @Accepted int

              select @Total=count(*), @Accepted=sum(case LastState when 0 then 0 else 1 end)
              from fn_rbac_ClientAdvertisementStatus(@UserSIDs) 
              where AdvertisementID=@Deployment

              select LastAcceptanceStateName as C013, count(*) as C015,
              ROUND(100.0*count(*)/@Total,1) as C016,
              stat.AdvertisementID, advert.PackageID, advert.CollectionID
              from fn_rbac_ClientAdvertisementStatus(@UserSIDs)  stat
              join fn_rbac_Advertisement(@UserSIDs)  advert on stat.AdvertisementID = advert.AdvertisementID
              where stat.AdvertisementID=@Deployment
              group by LastAcceptanceStateName, stat.AdvertisementID, advert.PackageID, advert.CollectionID

We need exclude the below columns from report

Exclude columns

Last acceptance Mesage ID 

Last acceptance Mesage Name

Last acceptance Mesage Status Time

Last Execution Result

Last Execution User Context

Use Name

Client Type

Use Domain

Include columns 

package name

Regards,

Siva.V