Forum Discussion

bro10's avatar
bro10
Frequent Visitor
4 years ago

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 some data, and it gets sent as .CSV

 

note that the column that I am loosing data on is a Varchar column in the DB, it contains numbers and sometime txt too,

ex: GR1256547896548965 (someting like that), when I do the subscrition it will show as GR125E+654.... 

ex2: 12345678910111213   it will show 1.23E+111213... as CSV.

I've tried a lot of functions in report builder and am still getting the same results (Common functions ).

any help will be appriciated.

Thanks

Need Help

2 Replies

  • v-henryk-mstf's avatar
    v-henryk-mstf
    Icon for Community Support rankCommunity Support
    4 years ago

    Hi bro10 ,

     

    I can't reproduce this kind of problem for now, can you provide more step-by-step information screenshoots or data for me to do further testing.


    Looking forward to your reply.


    Best Regards,
    Henry

     

  • bro10's avatar
    bro10
    Frequent Visitor
    4 years ago

    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