Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi
I need to restrict the number of rows while exporting the table into an excel sheet. Is there a function or document setting that will help me achieve? appreciate your assistance on it.
How do you exporting data to excel via macro function or by just Send to excel functionality?
Please come up with more detailed description.
I am using Send to Excel functionality
Well than you need just to prepare the straight or pivot table whatever you're exporting to that you wish to see in excel.
Hi,
check this Can I apply Excel formatting to my Excel reports?
where does the 'Keep Source Format' box appear after i right click on the properties of the table box in QV?
By Converting it to Straight table i can maintain a limit of only 100 rows but I need to export around 1000 rows only
Hi,
Select View -> View-Grid View -> right click your straight table select -> Custom Format Cell
and format as per your requirement
May be you can try with 'calculated Conditon' in the Table Box -> General Tab..
like
=count(ID)<100
Then apply the error message 'More than 100 Lines'