Forum Discussion

Markzolotoy's avatar
Markzolotoy
Icon for Impactful Individual rankImpactful Individual
5 years ago
Solved

Problem showing image in paginated report

I have an image object in both paginated report and a ssrs report. Both images are bound to a field from a dataset. Both datasets show the same Base64 string. =Convert.FromBase64String(First(Fields!body.Value, "DataSet1")) works fine on ssrs report, but in paginated report it is the red X. the only difference is that ssrs report uses embedded connection string and paginated report uses PBI dataset. I also have a text field in the paginated report that shows correct Base64 string. Any idea what's wrong?

 

Thanks

  • Markzolotoy's avatar
    Markzolotoy
    5 years ago

    Yes, basically it was a limitation to the length of the text column. I had to break it into smaller peices.

     

5 Replies

  • Markzolotoy's avatar
    Markzolotoy
    Icon for Impactful Individual rankImpactful Individual

    I have a paginated report that uses PBI dataset for its data source. The data source looks like this:

    Web{"url":"http://computername:8090/endpointname"}Maps to: New data source 2

     

    In PBI service the dataset name is DS_HighchartExport.

     

    Here how it looks in report:

     

     

     

    DataSet1:

    Fields:

    In report a dataset based on that data source produces correct data. The data is a Base64 string. It is bound to an image in the report like this:

    =Convert.FromBase64String(First(Fields!body_1.Value, "DataSet1"))

    I also tried:

    =Convert.FromBase64String(First(Fields!body.Value, "DataSet1"))

     

    Same thing: Red X. 

     

    The same data with the same image object in SSRS report works fine.

     

    Please help.

     

    Thanks

    • v-easonf-msft's avatar
      v-easonf-msft
      Icon for Community Support rankCommunity Support

      Hi, Markzolotoy 

      Could you please tell me whether your problem has been solved?
      For now, there is no content of description in the thread. If you still need help, please share more details to us.

      Best Regards,
      Community Support Team _ Eason

      • Markzolotoy's avatar
        Markzolotoy
        Icon for Impactful Individual rankImpactful Individual

        Yes, basically it was a limitation to the length of the text column. I had to break it into smaller peices.