Жыл бұрын
Жыл бұрын
Жыл бұрын
Жыл бұрын
Жыл бұрын
Пікірлер
@noumanahmad1607 Ай бұрын
This tutorial works 100% to download basic report layout available in faceted
@chandrasicerio5255 Ай бұрын
Hi great help by the way, but i am getting the error "ig$.interactivegrid is not a function"
@rendramaulana9358 2 ай бұрын
Do you know how to create a freeze header with an interactive report that has been pivoted like your video above ??
@kas6245 2 ай бұрын
How download in Single excel with Multiple sheet
@EasyLifeCentral 2 ай бұрын
Ok it will be done and share soon. Please stay with us .
@kas6245 2 ай бұрын
@@EasyLifeCentral thanks
@hhhhhh-v2h 2 ай бұрын
great and where is the script?
@EasyLifeCentral 2 ай бұрын
pls see in description .
@hhhhhh-v2h 2 ай бұрын
@@EasyLifeCentral thanks
@yakaka1 3 ай бұрын
let me know how to format excel report
@EasyLifeCentral 3 ай бұрын
You want set format as per your requirements other then report ??
@yakaka1 2 ай бұрын
@@EasyLifeCentral i want headings, then column headings etc etc in excel
@salvadorfajardo234 4 ай бұрын
Pivot option is so limited you end exporting the report to excel for better pivoting. Frustrating.
@VivekanandTiwari-o9d 4 ай бұрын
wowowowowowowo sir very helpful viedio for beginer🥰
@abhishekmagdum2354 4 ай бұрын
hi is there any way to download two reports in single excel ?
@yashyrt2 6 ай бұрын
is there a way to export multiple reports in a page into a single excel? Example :- 2 sheets for 2 reports
@ritikatrivedi3017 7 ай бұрын
from where will i get the code
@Ramdut369 7 ай бұрын
How to download all multiple Interactive grid on single button click which is present in single page but after download all ig showing in single xlsx or CSV file
@muhammadadilmoin1396 7 ай бұрын
A very good idea to store records temporarily; however, there should have been an option to save only rows selected by the user before permanently saving into EMP table. By the way, a very good work👏
@ManikantaPogula 8 ай бұрын
One or more errors have occurred since the page loaded. Open the Browser's JavaScript console to see the errors. I am getting this error how to fix this.
@EasyLifeCentral 8 ай бұрын
what errors are you getting? I suggest you please watch and try again and follow steps carefully.
@swamyvivekam 8 ай бұрын
How to add more than 3 columns in pivot option . Please suggest
@EasyLifeCentral 8 ай бұрын
Use Oracle APEX plugins or JavaScript libraries (like PivotTable.js) to enhance your interactive report capabilities.
@vidyeshranade8849 6 ай бұрын
use || operator (field1 ||'-'||field2 ||'-'||field3 AS f1-f2-f3) to combine multiple fields into single field
@EasyLifeCentral 5 ай бұрын
@vidyeshranade8849 nice
@safdarhassan 8 ай бұрын
hi this video is very helpful. I am just starting apex. I created master detail form in IG. i want serial no to auto calculate in detail block. i.e. 1st line would show 1 in serial_no database column and then on next line it should show 2 and so on.
@EasyLifeCentral 8 ай бұрын
Ok will do that in next video and share here .
@ilanitarbib4482 9 ай бұрын
Great Video . Is there a way to add collapsible on the left pannel ? Thanks
@yakaka1 9 ай бұрын
i want customize csv or excel file download
@parthparth8680 9 ай бұрын
GOOD VIDEO XLSX file to be displayed on screen instead of Downlod for that What to do ?
@EasyLifeCentral 9 ай бұрын
Thank you . Let me work on it , will be shared here
@Ramdut369 10 ай бұрын
i want to download multiple ig on single click but in single file.
@Ramdut369 10 ай бұрын
please reply me give me code
@EasyLifeCentral 9 ай бұрын
@@Ramdut369 // region static id ig_modal_test var ig$ = apex.region("ig_modal_test").widget(); ig$.interactiveGrid("getActions").invoke("show-download-dialog"); // modal page has IG static id followed by ig_download_dialog in aria-describedby attribute // IG static id is ig_modal_test, so modal div attribute will be ig_modal_test_ig_download_dialog $("div[aria-describedby='ig_modal_test_ig_download_dialog']").find("button").each(function(){ if ($(this).html() == "Download") { $(this).trigger("click"); } });
@Ramdut369 4 ай бұрын
@@EasyLifeCentral but I have 2 interactive grid in single page I want to download this 2 grid in single excel..please provide me code on download button
@Ramdut369 4 ай бұрын
I have to combine 2 grid data in single excel file
@souravrs5394 10 ай бұрын
Is there way to export hyperlinks to excel as well using this method or any other?
@yassinebazri8641 10 ай бұрын
Thank you, very useful for me
@desktopwizard 10 ай бұрын
Can you share the column names of "department" and "emp" table?
@Apex-p8c 10 ай бұрын
sand code
@Apex-p8c 10 ай бұрын
sand code
@MdHabibullah-l3s 10 ай бұрын
I am applying according to your video. in my online workspace but it isn't working .
@EasyLifeCentral 10 ай бұрын
What was the issue ??? Share any error .
@MdHabibullah-l3s 10 ай бұрын
@@EasyLifeCentral sir inline CSS isn't responding .
@EasyLifeCentral 10 ай бұрын
Please check your css code again if not working I will post here
@jamil6982 11 ай бұрын
Dear Sir, I am working oracle apex Product Build 23.2.4 , I have created master and details , when I add new row in the intractive grid the application change the prevouse row calculated Values to zero in the Total_Tax , Total_Invoice, and Grand_Total And this is the following programing steps I am using in the intactive grid details to calculate Total_Tax , Total_Invoice, and Grand_Total I create Dynamic actions on the Quantity field Name : Total_Tax When Event Change Selection Type Columns Column(s) QUANTITY,UNIT_PRICE,V_TAX_RATE True Name Get_Total_Tax Action Set Value Set Type PL/SQL Expression (round(nvl(:quantity,0) * (nvl(:unit_price,0)),2) * (nvl(:v_tax_rate,0) /100)) I am using the same logic for calculating Total_invoice and Grand_Total waiting for your valuable answer Best regards Jamil Alshaibani
@EasyLifeCentral 10 ай бұрын
Please try to use "execute JavaScript Code" instead of PL/SQL Expression, as I used in my Video.
@alexandrecrocha1 11 ай бұрын
Hello. Friend, is there a way to center the "Salary" column? If yes, what is the command? Thank you very much.
@EasyLifeCentral 10 ай бұрын
Under the "Layout" property Set the column alignment Center.
@alexandrecrocha1 10 ай бұрын
@@EasyLifeCentral hello. I had already done that. It has no effect.
@alexandrecrocha1 10 ай бұрын
Another problem: I would like the "total salary" column in the center of the matrix to display "0" instead of null. Thank you very much.
@shabbirhussain706 11 ай бұрын
Plz send the code here
@EasyLifeCentral 10 ай бұрын
var sal = ($v("T_SAL") != "")?parseFloat($v("T_SAL")):0; var comm = ($v("T_COMM") != "")?parseFloat($v("T_COMM")):0; var tot = 0; if(!isNaN(sal) && !isNaN(comm)){ tot = sal*comm; } $s("TOTAL", tot);
@MuniraYesmin-e2w 11 ай бұрын
where is the code?
@EasyLifeCentral 11 ай бұрын
You can see in the video .
@EasyLifeCentral 9 ай бұрын
// region static id ig_modal_test var ig$ = apex.region("ig_modal_test").widget(); ig$.interactiveGrid("getActions").invoke("show-download-dialog"); // modal page has IG static id followed by ig_download_dialog in aria-describedby attribute // IG static id is ig_modal_test, so modal div attribute will be ig_modal_test_ig_download_dialog $("div[aria-describedby='ig_modal_test_ig_download_dialog']").find("button").each(function(){ if ($(this).html() == "Download") { $(this).trigger("click"); } });
@franklagerweij287 Жыл бұрын
I think this can also apply for interactive reports but with slightly different Javascript. Can you also provide an example of the code for that?
@EasyLifeCentral Жыл бұрын
Sure. Give me time .
@harishadikusuma512 Жыл бұрын
Tetapi ketika klik action dan download dalam bentuk excel, bentuknya tidak akan sama.
@EasyLifeCentral Жыл бұрын
Sorry didn’t get your point . Not able to understand your language.
@allpractical Жыл бұрын
Yahan tak to sab kr lety hein tell me how to show the result on page load
@EasyLifeCentral Жыл бұрын
What do you mean ???
@EasyLifeCentral Жыл бұрын
You can do with the help of DA on page load.
@krk-bu2ws Жыл бұрын
It made my day. Thank you so much!!!
@swamyseeta1482 Жыл бұрын
Hi, Video was great and working on Interactive Report. But is is not working with Classic report and IG. Is there any special command to use for these in the request
@EasyLifeCentral Жыл бұрын
I have another video for interactive grid kindly see my channel .
@saraandtheraichu Жыл бұрын
Thank u so much for sharing,very useful
@luantingyap5530 Жыл бұрын
it works! thanks!
@EasyLifeCentral Жыл бұрын
Thank you
@mohammedalhebshi5212 Жыл бұрын
Impressive me
@EasyLifeCentral Жыл бұрын
📌 Streamline data entry and boost productivity by automating the process of copying item values into interactive grid columns. Watch till the end to learn how! Let us know in the comments if you found this technique helpful. Enjoy!
@kitchenwithdoublefun9351 Жыл бұрын
Uuuuuuuuuuuuuuuuuuuuu
@marwanbsais6285 Жыл бұрын
Thank you for this video ...; please can you publish the javascript Code ?
@EasyLifeCentral Жыл бұрын
This tutorial is a must-watch for anyone looking to create dynamic pivot and matrix reports in Oracle Apex.
@abhisheksrivastav6139 11 ай бұрын
Which version of oracle apex is used to create a pivot report
@EasyLifeCentral 11 ай бұрын
@abhisheksrivastav6139 I am using v22.1
@mrvictor2010 Жыл бұрын
First 🥇 like
@EasyLifeCentral Жыл бұрын
Thanks
@EasyLifeCentral Жыл бұрын
Thank you so much for watching my video on how to generate interactive Excel reports with just one click using Oracle Apex. I hope you found this tutorial helpful and that you're excited to start using this method to save time and increase productivity in your own work. If you have any questions or comments, please feel free to ask - I'm here to help and would love to hear your thoughts. Thanks again for your support!
@EasyLifeCentral Жыл бұрын
I'm here to help with a wide variety of topics, so feel free to ask me anything you'd like. If I'm unable to answer your question, I'll do my best to point you in the right direction or suggest other resources that may be helpful.