Threads Replies Last Post 253 Pages: 1  2  3  4  5  6  7  8  9  10  11  12  13  14  15  16  17  18  19  20  21  22  23  24  25  26  27  28  29  30  >>   Is it possible to use subreport caption in main report's page head Hi, I have created a main report with several subreports (with page breaks between the subs) and would like the subreport's caption to appear in the main report's page header. Is this possible and if so, how? Thanks in advance. Best regards, Allan... 1 13.09.2006 22:00:02 Displaying categories in a report The items in my cataloges database are categorized by major category, sub category and division. Not all sub categories have divisions. In order to show how cataloges are filed in the library I would like my report to print major category, sub category and division, but I need the sub categories to print even if they don't have divisions. Thanks... 1 13.09.2006 21:43:01 Example of a crosstab report with dynamic column headings Can someone point me to an example of a crosstab report with dynamic column headings? Mine does not carry Months or Quarters as do the other examples I've found. They will have an invoice number with either "-1", "-2", "-3", or "-4" added on to it. I don't know if there will be 1 or 4 invoices for the current month, so I need to account for that in the design of the report. I'm using a ... 2 13.09.2006 21:41:47 tick box Hi Any advice or suggestions on how to overcome the following would be appreciated: On a report there are some tick boxes. What I want to appear is just the tick if the boxes value is -1. What I do not want to show is the outline of the tick box or the grey background if the tick box value is 0. Using Access 2002. TIA Tom ... 3 13.09.2006 20:24:19 How can I change information in an existing Access Report footer? I've inherited a database from a former employee. I need to make changes to the footer on a report, but can't figure out where it's been entered. I see where the footer was created in Design View, but not where the actual data was entered into the footer.... 2 13.09.2006 20:06:17 Report Header/Footer on Page 1 only - Separate H/F on Pages 2 on u I have a report that has worked well until now. It has a Report Header and Footer with a Memo field in between. If the Memo field has enough entered it will create a page 2,3.. etc. I need pages 2 on up to have a simpler Page Header and Footer but I want the current Report Footer to print only on Page 1, not on the last page. Is this possible ? The Report Header was recently modifie... 1 13.09.2006 19:51:02 Repeat Section Problems I have 3 group headers on a report. Repeat Section is set to Yes for all 3 sections. When I preview the report it just hangs. I changed the repeat section to No and the report now previews. This just started happening about a month ago. The reports worked fine before then. Can you give me some ideas on what is causing this now? ... 10 13.09.2006 19:39:47 modifying reports is ridiculously SLOW... Any idea why when modifying an existing report that reponse time is so slow? Just widening a field takes moments rather than seconds to get mouse control back. Its very odd. I have 1.5 GB of RAM and only Access 2003 open when doing this. Office is patched up to date and so is Windows. When I create a new report in design view, its fine. ... 1 13.09.2006 19:00:02 Combine field data I am trying to combine field data from various records to display on an Access report. For example, If I have the field "Community", how can I take all the different values in the Community field for each record and display them in a text box on a report instead of listing every record and the corresponding community for each one? I would like to display something like this: Co... 2 13.09.2006 18:26:48 Show The top valued fields in a report Say I have 7 fields in a form. Out of the 7 fields I wish to pull the top 3 highest feild on a report. So if (field1=1),(field2=3),(field3=9),(field4=4),(field5=8),(field5=7),(field6=11),(field7=15) so on the report for this record only fields 7,6 and 3 would show up on the report. How would I go about trying to to this? Thanks... 7 13.09.2006 18:17:46 2 Charts on 1 Report problem I have a report that produces a a listing of all defects over a length of a product (fabric). There are 4 subreports in the Detail section, each displaying defects within a meter distance range. (0-325m, 325-650m, 650-975m, and 975-1300m) In the Report Footer, I have 2 Charts (one for 0-650m and one for 650-1300m) that plot the defects as "dots" where they occur over t... 5 13.09.2006 18:11:45 Urgent Help Needed !!! I have a report with group totals. In one field (groupPortfolioAmt) of the group totals, if the value of another field (groupPortfolioNo) is greater than zero, I want to sum groupPortfolioAmt. If not, I want to just print 0 in groupPortfolioAmt. Why is the following code in the Control Source property for groupPortfolioAmt not working? =IIf([groupPortfolioNo]>0,(Sum(Abs([portfolioAmo... 2 13.09.2006 17:20:01 Make a report zoom to a certain percentage with macro I've read posts about editing the code to make a report open to a certain zoom, but what if you have a macro opening the form. Is there a way to make the macro got to a specific zoom?... 3 13.09.2006 16:18:02 combine 'same' data in 2 fields in report I am designing a membership database which also records committees people serve on. However, I have two separate "sets" of fields where I can put info in for one person who serves on 2 committees (Committee-1 and Committee-2). I am battling to understand how to set up a query which will group on the name of the committees (I can do that), but will also give me the name of the same perso... 3 13.09.2006 16:04:01 Cannot load report filter from DoCmd.OpenReport command Access 2003: Try to open a report to print with the following: ReportFilter = "PoId = " & Me!PoID & "" StDocName = "PurchaseOrder" DoCmd.OpenReport StDocName, acViewPreview, ReportFilter, , acWindowNormal Report.OnActivate: MsgBox Me.Filter shows it to be empty. I've tried filter on = yes and no I've tried to set the filter from the calling form after the report is open us... 3 13.09.2006 15:46:21 last label is blank in report? Why when creating labels in an access report, is the last label blank? can anyone tell me how to avoid this please?... 1 13.09.2006 15:24:02 print total of the percentage at the end of the column Hi, I have this query below: SELECT IIf(Q7b=1,'Yes',IIf(Q7b=0,'No')) AS Q7b2, Count(TB_PN.Q7b) AS TotalOfQ7b, Count(Q7b)/(SELECT Count(Q7b) From TB_PN) AS Percentage, DSum(Percentage,"Q7b") AS TotalPercentage FROM TB_PN GROUP BY TB_PN.Q7b; I use this query for my report, but it shows the TotalPercentage in every row... I want it only display once.... but I don't know how.. can someo... 1 13.09.2006 15:20:19 P.O. Box and concatenation hiccup So far, I have successfully concatenated a full address in a parameter query, the code is below. I have a report based on the query. The concatenation is successful but for the situation of a P.O. Box; I need the text "P.O. Box" to appear when there is a P.O.Box involved. I also plan to try and do the same concatenation in VBA behind the report, which I may have to do to solve my pro... 3 13.09.2006 14:43:53 Cannot load report filter from DoCmd.OpenReport command Access 2003: Try to open a report to print with the following: ReportFilter = "PoId = " & Me!PoID & "" StDocName = "PurchaseOrder" DoCmd.OpenReport StDocName, acViewPreview, ReportFilter, , acWindowNormal Report.OnActivate: MsgBox Me.Filter shows it to be empty. I've tried filter on = yes and no I've tried to set the filter from the calling form after the report is open us... 1 13.09.2006 14:36:02 If in report display amout is "0", how to set into "-" sign ? I'm having problem about making report in MS-Access that if the amount is "0" and then I want it to show in "-" sign. I used the command "IFF" but the result is "#Error". Could you help me please? The command that I used is =IFF([amount]=0,"-",[amount]) ผมมีปัญหาการออก report ใน MS Access ว่า ถ้าจำนวนเงินเป็น 0 จà¸... 3 13.09.2006 13:12:55 Vertical line? I have a report with two memo fields. I have a vertical line that separate these 2 fields. When I view the report the height of the verticle line is the same, How can I extend this vertical line as per the height of the field. SF ... 2 13.09.2006 12:15:38 Preview Specific Page Hi all, My report always has 2 pages, and we print Double side (Printer is one side only - HP1300). In my form, I put 2 buttons: Page1 and Page2. I want to Preview the report before print it out. So how can you code the Page1 button to preview only Page 1, and Page2 button to Preview only Page 2 ? I've tried: docmd.OpenReport "ReportName",acViewPreview docmd.PrintOut acPages,1,1 But th... 7 13.09.2006 04:37:02 Fiscal Year and Quarter This fantastic expression was posted by Duane Hookom. I have no idea how it works but it displays the fiscal year and quarter for FY starting on October 1. =Format$(DateAdd("q",1,[Onset Date]),"\Qq yyyy",0,0) It displays the first quarter for FY 2007 as Q1 2007. However I would like to display this as 2007 Q1. I couldn't get this to work. JohnC ... 3 13.09.2006 03:49:24 Add a blank row to an Access report to separate data I would like to show a blank row in a report to separate out groups of data in order for the reader to more easily view the report. I am sorting on 8 fields in grouping/sorting. I don't want to add subtotals or force groups to print on a new page, and I don't need to relist any header information - only show the detail by breaking it up with a blank row after a change in item cost (one... 2 13.09.2006 03:13:09 Too many pages in report I have created a report that prints a main section that has the customer information, including a serial # for each piece of equipment, it also prints a subreport that reports the components used by that customer. When I have just the customer and one component, it prints fine. When I add components associated with a, a page for each component prints out. If the customer has 20 compon... 5 13.09.2006 01:46:02 253 Pages: 1  2  3  4  5  6  7  8  9  10  11  12  13  14  15  16  17  18  19  20  21  22  23  24  25  26  27  28  29  30  >>