You might find it better to use 2 fields & store as 'FirstName' & 'LastName'. The names are stored in your table as 'John Doe' that is christian name followed by surname. You will notice that there are blank areas at the bottom of some pages that is because the groups have been kept together in order to aid readability.Ĭlick on the text boxes in the footer of group 'Arrival' & hit the data tab in properties to view the functions/formulas or view same using the navigator.įinally the report is sorted first by 'Name' then 'Arrival'. The tax rate is 10% so where necessary this is simply calculated (amount*.1) Only one function has been created an accumulation function named 'SumActualCost' which is located in the group 'Arrival'. The report itself has been written from scratch. Only the fields which are necessary to enable the report to function have been selected. i.e.(order by).īecause this forum is for english speaking users who may also find this topic useful i have used aliases to make the fields more descriptive. No calculations have been made & no calculated fields have been used. 'qTVA_UITREKSEL_For_Report' exactly the same functionally but can be edited in design view & is used to generate the report. 'qTVA_UITREKSEL_Direct_SQL' saved as direct SQL to preserve the formatting. I have made some changes to your query 'tva uitreksel' on which the report is based. Please look at the attachment 'lachass tva uitreksel_chrisb.odb' i have not downloaded his example but suspect it is far better than mine. I am just about to make a further post & see that Sliderule has contributed to this topic. it may not be exactly what you wanted but should point you in the right direction. ![]() Drag out a text box in the report footer. our function needs to access the entire record set so we create it under 'Report'ħ. This post shows how: viewtopic.php?p=210650#p210650įollow the steps 1 to 12 with these exceptions.Ģ. The answer is YOU NEED TO DEFINE A FUNCTION. ![]() how can i show the sum total for ('AMOUNT' + 'TAX') * 'DAYS' – 'ADVANCE'?” I further assume that the question is “i use report builder. ![]() 'CUSTOMER' varchar, 'AMOUNT' decimal, 'TAX' decimal, 'DAYS' integer, & 'ADVANCE' decimal. This post is obviously related to your previous topic ' How to calculate with a calculated field?' posted to this forum on Wed 4:56 pm.īased on the previous topic i will assume that we have 5 fields:. You are not providing sufficient detail to enable others to help you,
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |