Basics of nVision
I plan to devote this week to nVision. The reason being that I have to produce an income statement report in Finance. The report looks demanding to me and it’s also a drill down report. There are two options for me : Using PeopleSoft nVision to do the report or using Microsoft Reporting Services to do the report. I initially thought I can do the report in reporting services. But I thought it will be rather better to look into the features of nVision and then decide whether to go with nVision or with Reporting Services. The first thing that I wanted to know is how will I know what is the SQL that is being used to generate the data in the nVision layout.
Well ,here is my first novice step of knowing nVision:
Go to the nVision report layout. In the tool bar, you will notice something called “nVision”. Click that.
Now you will notice a variety of options. One of them will be “Options”. Click that. A dialog box will open. One of the options will be “Show Report SQL”. Check this.
Now when you run the report using “Report Request”, every SQL that is used will be displayed one by one as the report is run and the data is being fetched.
I will be posting more of my basics findings in the subsequent postings. Also do remember that I got to tell you about “Add Attachment” feature. I will be visiting on this topic soon.
