Use this thread to post your product tips and tricks from th...

[Satya Prakash Jain]

ctrl+M and ctrl+R for commenting and uncommenting in text editor.

[Sharon Nesset]

Good to know, I have often struggled with this after the fact.

[Brendan Yano]

We definitely use the comma in the name to create a mult-line header. It really does help with formating reports and getting a little extra valuable space.

[Pierre CASTILLO 2]

TABLE FILE CAR

SUM SALES

BY COUNTRY

ON TABLE HOLD FORMAT ALPHA

HEADING

" Viewing extract # 1 "

END

PCHOLD FORMAT HTML

 

 

This will allow you to view an intermediate extract without replaying the extract !

[robert fuschetto]

After using App Studio for charting, we now must use InfoAssist since as of the 8207v27 release you can not access App Studio charts. We discovered an export to PowerPoint which is something that has been asked for in the past. It was not available in App studio and we did not see it in Design Studio. ts pretty cool. For some reason though the Table of contents appears in our Dev and Test environments but nor Prodweird. If you have encountered this, let me know. Otherwise we can open a case down the road.

[vi .]

hardwork with smartness is the key of success

[SATHEESH B]

Create JSON hold file

Integrate any JQUERY UI Controls

 

Telerik Kendo UI - Create CRUD Functions.

Calendar Controls

Project Plan and much more

[Naga Santosh Tadikamalla 2]

-SET &ECHO=ALL; is the one which I use mostly and CTRL + M and CTRL + R are the other two shortcuts which I use frequently.

[Todd Wallace]

Use COMT for creating comma delimited text files(CSV). I use it when I want to extract more than 1,000,000 rows from a table. Like the general ledger files for our yearly audit or when someone wants an extract from a huge table. You have to warn them not to open it in Excel though.

[Debra Waybright]

Really, the best tip is to be a member of this forum. You will almost always find an answer to your question or a new thing you didnt know you needed to try.

[Lindsay Gray]

Be part of the forums! that would be my best tip!

[Lauren Alvarenga]

Be a member of the forum!

[Thomas Vaught]

I am not sure if anyone has mentioned it or not, but I use F5 to run a report in development instead of clicking the run button.

[Jia-Lian Chang]

To find the data type of fields in HOLD files, especially useful when joins do not work:

FF hold_filename

[Alex Taylor]

SETTING YOUR ON TABLE SET TO:

ON TABLE PCHOLD FORMAT XLSX

EXPORTS IT DIRECTLY TO EXCEL INSTEAD OF DISPLAYING

[Bryan Oudomsouk]

One of the useful things that I have stumbled upon is the fact that you are able to have an interchangeable BY statement that you can filter based on the set of data you want your end users to see. The Syntax is very similar to how you would use a filter in the Where statements (as shown below).

I have used this to leave the content of my portals on the most generalized categories, but if the user wanted to get more granular or decided they wanted to see a different measure for the same date range, then it is a simple filter change!

BY &RP_FL01B01_Sort1.( <EXPERIENCE,EXPERIENCE_SORTED>, <D1D2,D1D2>, <WORKLIST, WORKLIST>, <VANFB,VANFB>, <LOCATION,LOCATION>, <MANAGER,MANAGER>).Group Breakdown.

[Ricardo Lara]

When I have too many lines of code, I leave a mark in the line that Im working or debugging (in my case I use XXX), so I can move around the code quickly.