Search results for query: *

Hello, I need your help in excluding the suppressed amounts from the SUM in the group footer. In the details section, I am having duplicate deal no and amounts.So, in the Section Expert for the details sections, I performed a condition on the formula "Suppress" to suppress the duplicated...

Hi, I need your help and assistant in removing the duplicated deal_no from the details sections in my report. My report structure is as follows: #Group header 1: Type #Group Header 2: Deal_no Details: {Deal_no}, {Amount} #Group Footer : Deal_no #Group Footer 2: Type Example Data: Type A 12...

Hello team, I need your assistant in stopping the report no. parameter prompt in my main report. In my report, I am having a table which it is called {engine}.It has a field called {rptno} which it auto generates the report no. once it is running. I defined a parameter called “ReportNumber” and...

Hi all, Can you please help me in passing a parameter from the main report to the subreport. I got an error saying that Cannot find parameter field Report_Number in subreport ABCD.rpt. I have created a formula in the main report called {@report_number} which it has a value from the database...

Hello team, I need your assistant in passing a database field called {engine.rptno} to the subreport select expert from the main report. I tried to use shared variable in the main report. I created a formula in the main report shared numbervar report_number := {engine.rptno}; report_number...

Hello Team, I need your assistant in passing a value of a parameter in the main report to the subreport. I defined a parameter in the main report which is called {?ReportNumber} and its type is Number and it is static. In the Select Expert of the Main Report I added the below code...

Hello All, I need your assistant in getting the appropriate way to exclude some of the items from the subreport based on the items that are passed from the main report and to show the extra items which are in the subreport. What I mean is that I am having a main report that is displaying the...

Hello, I am facing some difficulties while developing a report. The problem is that I am getting a number of values in the Details section and I want only to display the record which it is having the maximum event number for each group (one record to be shown for each group). My report...

Hello All, I am having a label which it has in its action a hyperlink. The code which I am using: on (release) { get URL("Main/active.pdf","_blank") } and it will display the file after clicking on the label. Now, Instead I want the label to open the "Main" Folder directory. I tried to...

Hello All, I am having a problem while developing this report. In my report these are the fieldsL Deal No, Amount, Price, Type, Settle date, Deal Date, Total Value (E.x): 123, 121212, 22.2, AAA, 12-Dec-2009, 23-Dec-2010, 12321 124, 125885, 23.2, BBB, 1-Jan-2010, 23-May-2010, 454544 My...

Hello All, I am having an issue is that while exporting a report to excel sheet, there are lots of spaces and empty cells between the data, as well as, the cells are merged. Is there is a way to export the report and each field will be in a cell, suppose my report looks like this: No...

Hello All, I am having difficulties while getting the value of the running total forumla in Group Header 1. Here is the structure of my report: Group Header 1: CCY Group Header 2:Type @reset Group Header whileprintingrecords; numbervar sumpct4; if not inrepeatedgroupheader then sumpct4 := 0...

Hello All, I am having two subreports in my main report. They are placed in group header 1#: where it is called "Account Name". In Group Header 1A: I have created a subreport ((1))called market_Value which has to columns in the details. Details: Deal_no & Market_Value In the next subreport...

Hello All, I am having a problem while changing this process from a manual parameter to an automatic parameter. The problem is that the user is passing "30-june-2010" or any date in june for the report and there is one subreport which is getting the last day in the previous month. So, the user...

Hello All, I am having a sql expression which is already been created in an old report and it is working fine. When I have copied it to a new report and has the same tables and exact relations, it is giving an error: ORA-00942 table or view does not exist. Here is the SQl Expression: (select...

Hello All, I am having 2 fields in the group footer: {@Rate} and {@Balance} 895,449.00 * 0.00436 The result formula is showing 3,904.06237 where it is actually 3904.15764. The result formula is only having {@Rate}*{@Balance}and I am not using any rounding! Can you please help. It is a...

Hello All, I am having difficulties while calculating the sum of the a field. My report structure is: Group Header 1#: Account Name Group Header 2:# ACC_groups Details: Deal_No, Amount Group Footer 2#: Sum (Deal.Amount), Account Groups Group Footer 1#: Sum (Deal.Amount), Account_Name For...

Hello All, I am having Group Header 1: Account No. in my main report and in the details, I am having deal_No & amount. In the select expert I have defined a set of accounts like (123, 456, 223, 124). IF there is data, the report will show the figures correct otherwise if there aren't any...

Hello All, I am having a structure of this report: Group Header 1#: Account No.(different Accounts) Group Header 2#:Type{Short-Medium} for each account Details: {@Amount}, {Market_Total} Group Footer 2#: {@sum_Type}, {@sum_Market_Total} Group Footer 2#: {@grand_sum_Type}...

Hello All, I am having two rows which are duplicated and here is the structure in the details in my report. Deal_no Comments Account No. Date Amount How do I suppress the whole row based on the deal_no if it is duplicated. Is there is a way to do that in the select expert? Thanks and regards