logo

Warning: The forum is now for consultation only. Please use GitHub Discussions to post any questions or comments.


Welcome Guest ! To enable all features please Login or Register.

Notification

Icon
Error

Options
Go to last post Go to first unread
Mandar  
#1 Posted : Monday, January 20, 2020 8:13:03 AM(UTC)
Mandar

Rank: Newbie

Groups: Registered
Joined: 12/26/2019(UTC)
Posts: 6
India
Location: Mumbai

Hi,

I have created a report which has many columns. Some columns have zero value for all rows. I want to hide such column.
I can hide columns on the basis of column number, but there is no way found to hide columns on the basis of row value.
epf  
#2 Posted : Monday, January 20, 2020 8:26:58 AM(UTC)
epf

Rank: Administration

Groups: Administrators
Joined: 12/20/2013(UTC)
Posts: 1,209
Switzerland

Thanks: 14 times
Was thanked: 205 time(s) in 198 post(s)
for this you should create a task with the step 'Models generated',
then in your script you take your result table, check the column that has only 0 values,
then recreate a result table without the column...

manipulating your result table requires to know C#and the object models,
check Final Script of sample 54, or samples provided in the task script editor....
Users browsing this topic
Forum Jump  
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.