Forum Discussion
Paginated Report (Report Builder), when setting subscriptions as excel I am loosing data
Hi, When I create a report in report builder, I run it it works great, when exporting data to excel it works great, but when I schedule a subscription to be sent automaticaly as .xlsx I loose so...
when I use subsciption so the report gets sent as .xlsx file, it gets sent as .csv and two of the columns are loosing data, I've tried data txt conversion in .rdl but still samething, as you can see tracking number in reality contains 25 or more charachters, but I get this E+ and loosing data, I did find a work around it by using power automate and send it as .xlsx file that captures all data, please note that this is a paginated report.
if you can help with it it will be much appriciated, now every report i have (painated) i have to create a work flow using power automate, but having subscrption running directly will be perfec, not sure if it's a bug or something ..
Thanks