gordk
gordk
About
- Username
- gordk
- Location
- St.Catherines On. Canada.
- Joined
- Visits
- 0
- Last Active
- Roles
- FR Team
Comments
-
it is simple use the engine.showband method. read the usermanual on using the engine object. typically on the code page var ds: TfrxDataSet; begin //this block of code runs first before any other. ds := Report.GetDataset('frxDBDataSet1');// …
-
are you using the internal ado engine in the report if you are, look at the main demo internal datasets internal query report to see how to set the params and use a dialog box built into the report. Note when you pass string values into a categor…
-
Assuming your memtable is tdatset compliant populate your temptable and do not closeit, connect to a frxdbdataset making sure it does not open and close the table or all data will be lost.
-
you cannot pass multilined strings in this manner youse the an frxdbdataset and in the tfrxmemoview use [datasetname."fieldname"] and set the band and memo to stretch. there are other methods that can be used but this is the simplest.
-
Not the way you are trying to do it. Read the programmers manual on working with categorized variables, and the ongetvalue event as well. you can set the values of categorized variables after a report is loaded and before calling show or prepare i…
-
in textbox 3 write an expression using the iif function provided [iif(() > (),'Yes', 'No')]
-
the band that contains the the long rtf memo object must be set to stretch and allow split
-
you can change the memo's text from the obp event of its band or use the iif function inside the memo. do not connect the memo to a dataset field. from the band obp if table.currency = 'EURO' then memoname.text :='[(
*)]' else memoname.te…
yes it can print any nuber of times you want. Don't connect the databand to a dataset. set it's row count property instead and write code to control the movement of the dataset. you may need to use a variable to track where you are. write code i…i remind you again You can use the ?«Page,?» ?«Page#,?» ?«TotalPages,?» and ?«TotalPages#?» system variables for displaying a page number or a total number of pages. In composite reports, these variables work in the following way: Page ??? p…it is unclear what you mean by between two pages is this some thing in your design if a band and its objects output spread over more than one page you turn on allow split for the band. Also when you post please state build and version number of fr.first when you create the frxdbdataset did you set its username property. frxReport.LoadFromFile('FR\report1.fr3'); is this the same report as the one above as it does not have a form reference // DataBandMaster := ADatForm.frxReport.FindObj….fp3 is a file of preview pages frxReport1.LoadFromStream(reportdata); this would be fine for a report design .fr3 .fp3 is the preview pages produced by design. try instead frxReport1.previewpages.LoadFromStream(reportdata); frxreport1.showprep…see the main demo basic reports nested groups report for how to nest. the key is that the orderby clause of the query corresponds to the grouping conditions of the group headers. See the dialogs and script Totals in group header report for how to…you have still not given any useful information for any one to be able to help you.As you have given no useful information, i can only guess that you may have had to set up some thing for the old printer that you have not done with the new printer eg. custom page size maybethe report script is actually fastscript using the pascal language. there is no goto in pascal but there is a try except finally construct. Just for your info you could write this differently IF =mydate THEN MASTERDATA1.VISIBLE:= TRUE ELSE MAS…i have no idea what you are asking please explain in more detail.first declare that variable where i told you making it global to all procedures and lasts for the life of the report. not within a procedure (local) when the procedure is finished so is the variable. When you use typed variables in code you do not…Larry i can't be sure of what they have given you to work with but you must convert the inbutbox result to a tdatetime as it is returning a string. in design mode on the codepage at the top of the page declare your variable this makes it global t…in such cases do not set page or band into columns but control the output using the engine object to control curx cury. read the user manual on using the engine objectset page columns for vertical columns. 1 3 2 4 set band columns for horizontal. 1 2 3 4 5 6Fr installer will set up everthing for you. help files are downloaded seperately, you will find them where you downloaded the fr installer.if you are trying to create a new report yes. if you are trying to work with a report stored in dfm or stored in a file you must use the findobject method to get the design page first, then create the memo in the context of the page. Also, if you…where are you trying to do this from Delphi or within the report code?see my second response to your topic in the news groupcreate a variable prefx and give it the value of 'IN ' then build your expression using the expression builder +IntToStr()look in the demos folder masterdetailuds demo it should give you some ideas on using the userdataset along with variables and the ongetvalue event. how you create your temp table is up to you and the tools you have available to you in delphi,Your problem is the weird field arrangement of the table. you will need to fix it before anything else. columns should probably be accountnum date paymentamount you could then use a query with an orderby clause to supply data to fr and use a g…[IIF(='USD',, )] so your underlying field is a string so enclose the second value in ()and concantenate the string the last portion should appear as ,(()+'yourstring'))]