gordk
gordk
About
- Username
- gordk
- Location
- St.Catherines On. Canada.
- Joined
- Visits
- 0
- Last Active
- Roles
- FR Team
Comments
-
there is no 3.5 vcl, do you mean 2.5#? if you are just starting to use FR i would recommend you look at ver 3.## to start rather than ver2.
-
are you talking about using a lookup on the fr dialog form or just having the data from the 2 tables available in the report?
-
if your programmer included the export components in the app when you preview the report you should be able to export to the format of your choice. read the usermanual chapter on working with aggregates around pg 61 IIRC BTW what version of fr an…
-
since everything is contained in one memo look at what you missed in your true value and false value. To display a data field value in a memo you use [] [Medlemmer."Navn 1"], [Medlemmer."Call"] you are going to replace text on line 2 of the memo…
-
in your situation it will depend upon what your programmer made available to you. when he created your report design app.
-
It is even more excellent when using code script. You are probably setting values in the wrong place or event. Frustration usually comes from hacking code from demos and trying to adapt without understanding why and where it was written. Been the…
-
not really sure of what you are asking or trying to acheive more info Please?
-
Actually we are having an unusually mild winter I'm in St.Catharines Ont. just outside Niagara falls yesterday was +8c. normally would be -8 and a foot of snow, today rain, east coast of Canada is getting really bad cold and snow. From an accoun…
-
in the obp of the band test for null or '' depending upon engine option settings then modify the lines of the memo, or in the memo itself use the iif function provided to swap the datafield used starting at line2 of the memo and repeating untill la…
-
Hi Graham. yes its that time of year. if you want to control the band position read the chapter on using the engine object in the user manual. the real question is, do we wanto to move the position of the band or the memo that contains the datafi…
-
in the summary band it no longer nows what or where "price" is aggregates need to know what they are aggregating as all the databands have finished processing the reason it worked in the footer is that it was in a logical place the full syntax…
-
if you are writing script on the code page run the script from the runscript button in the code window it should stop with the cursor positioned at the error.
-
there are many possibilities here. first remember that a band is only a place holder on the design page even tho we have a master and detail band names they are not necessarily related to master/ detail data only 2 each others position on the outp…
-
run the main demo look under dialogs and script category at the grouptotalsin header report to see how we gathered the total from the footer into the array created using the set method in the event of the footer and how we transfered it to the memo…
-
first make the report 2 pass assuming we will display the % in a memo on the mdband create a variable of type extended on the code page ie "mypct" it will be used to display the value in the memo [mypct] initialize it to 0 at the start of the report…
-
Yes it is. Download the version for d10.
-
Hi Graham Your are probably using the wrong bands for what you want to achieve. just from the description of whats on the masterbands, i would expect payments and receceipts to be detaildata belonging to either orders or customers as the master. …
-
Hi Graham here is somthing you can try for the master band set print if detail empty move the subreport into a detailband do not associate the detailband to a dataset set its rowcount to 0.
-
Hi Brian this might be a shorter route and no additional code required using the same sample db as earlier adoquery1 customers table ok adoquery2 on orders table initially set the where clause of adoquery2to Where CustomerID = CustomerID this …
-
Hi Brian my apologies i haven't worked with ado mich so i tried a test using the MSoffice northwind .mdb sample db using the jet 4 provider and frxado components. and i have to agree with you. i now see your problems. tried 2 querys on customers a…
-
This should work 1st make the report 2 pass in the first pass gather the line count of the subreport in an array whose index is related to the mdband, in the obp event of the mdband write code to check if you are in the finalpass and the array value…
-
one could read the user manual. assuming you have created a series in the chart object and selected fixed data type Chart completion from Script leave empty XValues and YValues fields in chart editor. In report script obp event of chart object …
-
Hi Brian assuming you are working with the frxado components internaly set query2 master to query1, paramaterize the query, in the parameter editor set the type in the value box select the function button at the right select the desired function …
-
assuming a is in memo 1 b is in memo 2 and result is in memo3 ie in memo3 [ + ]
-
where you call the report typically, var dgpage: tfrxdialogpage; begin frxreport1.loadfromfile('path&filename'); //write code here to find dialog page and set its visible property to false. dgpage := frxreport1.findobject('DialogPage1'); d…
-
create multi designpage reports designpage1 original, designpage2 duplicate and so on control the number of copies in the normal way
-
you will probably have to run a separate query to sum each group for the prior period and store values in variables.
-
Without knowing more about the detail dataset it is hard to say here is a scenario all detail data comes from same dataset use child bands but rather than set them visible or invisible control which one is connected to the detail databand and whic…
-
since it works when you hard code the value in the variable "sql_msg= format('select * from tbl a where a.fld in %s ',) its runnig good from report desiner" the problem is usually in the code where we pass the value from delphi to the variable, d…
-
Assuming you are talking about setting the height in the designer. did you set the option for unlimited height of design page?