Skip to Content
avatar image
Former Member

Exporting to PDF in webi report

Hi,

While exporting to PDF in webi report. the layout is not proper and is cutting my report on the rside and format is not proper.

Can anyone share how to export to PDF with full layout.

Thanks

Sham

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Feb 02 at 02:01 PM

    in the page setup section ->Display->select the page mode and page "landscape" and see how many columns are going in the second page. according to that adjust the layout and columns width.

    Add comment
    10|10000 characters needed characters exceeded

    • The only other reason I can think of is if the datatype for both the objects are diffrent. for e.g. First objects is of type String and other one is of number. Check the data type. See if that helps.

  • avatar image
    Former Member
    Feb 27 at 03:38 PM

    Hi Ehethesham Kadagi,

    Please add the todate before Concatenation string and check the result

    =if FormatDate([start];"dd/MM/yyyy")>= Formatdate(ToDate(Concatenation("1/1/";ReportFilter([Year]));"dd/MM/yyyy");"dd/MM/yyyy") and FormatDate(ToDate([Finsh];"dd/MM/yyyy");"dd/MM/yyyy")<= FormatDate(ToDate(Concatenation("31/1/";ReportFilter([Year]));"dd/MM/yyyy");"dd/MM/yyyy") Then "Jan"

    Thanks,

    Anish

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Hi Ehethesham Kadagi,

      Please check what value you are getting in [Year] and Reportfilter[Year] and let me know. Because i try the same formula and i am getting the year in 2,016 format so i changed that format to 2016 and completed the formula.

      Please see below and check from your end.

      =If [Start Date] >= ToDate(Concatenation("01/01/";FormatNumber(Year([End Date]);"####"));"MM/dd/yyyy") Then "Jan" Else "Feb"

      capture.jpg

      capture.jpg (26.7 kB)
  • avatar image
    Former Member
    Feb 27 at 03:12 PM

    Hi Amit ,

    Formula below is not working , can you please look into this.

    Logic for below formula is if start date is greater than 1/1/2018 and Finish date is less than 31/1/2018 then Jan

    =if FormatDate([start];"dd/MM/yyyy")>= Formatdate(Concatenation("1/1/";ReportFilter([Year]));"dd/MM/yyyy") and FormatDate(ToDate([Finsh];"dd/MM/yyyy");"dd/MM/yyyy")<= FormatDate(ToDate(Concatenation("31/1/";ReportFilter([Year]));"dd/MM/yyyy");"dd/MM/yyyy") Then "Jan"

    Can you please help resolve this issue. I have attached the error message also.

    Thanks

    Sham

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi AMit,

      Thanks for the reply

      I used this formula still showing error as "incompatible Todate function"

      =if todate([Start];"MM/dd/yyyy")> todate(Concatenation("01/01/";ReportFilter([Year]));"MM/dd/yyyy") and ToDate([End];"MM/dd/yyyy")< ToDate(Concatenation("31/1/";ReportFilter([Year]));"dd/MM/yyyy") Then "Jan"

      Thanks

      Sham