Skip to Content
0

Exporting to PDF in webi report

Feb 02 at 01:31 PM

80

avatar image
Former Member

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

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

3 Answers

AMIT KUMAR
Feb 02 at 02:01 PM
0

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.

Show 4 Share
10 |10000 characters needed characters left characters exceeded
Former Member

Hi Amit,

I saw your question regarding Duplicate Prompts in Webi report. Even i am facing the same issue where i am getting duplicates prompts from different query. If you have the solution can you please share.

Thanks

Sham

0

keep the prompt text same as in both queries.after that prompt will appear once.

0
Former Member

Thanks for your answer but i have kept Prompt text same still getting duplicate prompts.do you anything we need to change.

0

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.

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

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

Show 2 Share
10 |10000 characters needed characters left characters exceeded
Former Member

Hi Anish,

Thanks for the reply

The below formula is not working in single variable. However if i use "ToDate(Concatenation("01/01/";ReportFilter([Year]));"MM/dd/yyyy")" in separate varible its working fine.I cannot create separate variable otherwise i have to create 24 i variables. can you help resolve.

=If [Start] >= ToDate(Concatenation("01/01/";ReportFilter([Year]));"MM/dd/yyyy") Then "Jan"

Thanks

Sham

0
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)
0
avatar image
Former Member Feb 27 at 03:12 PM
0

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


1.png (6.7 kB)
Show 2 Share
10 |10000 characters needed characters left characters exceeded

remove formatdate() function from the condition.formatdate() will not work with greater/less than operator as formatdate convert the date to string.

0
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

0