Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Westi on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. mflahive

    Stringvar only displaying on last page

    I have to use the template given to me by Management which is such: TEXT BOXES BOXES Borrower name [ ] [ ] [ ] Borrower Address [ ] [ ] [ ] SSN [ ] [ ] [ ] FICO/Date [ ] [ ] [ ] etc... After the text boxes (i.e. Borrower Name) there are 3 boxes per row to...
  2. mflahive

    Stringvar only displaying on last page

    If there was a way to start the multiple columns 1.5" from the left margin so I could keep my text boxes and then use 1.75" wide with a 1" gap, the report would work but I'm not sure if it's possible.
  3. mflahive

    Stringvar only displaying on last page

    The problem with using the multiple columns on the main report is with the text boxes in the page header which takes up 1.5" so I need the subreport set 1.5" from the left margin so the borrower information won't cover the text boxes. Setting 2" wide only allows me to see .5 inches of each...
  4. mflahive

    Stringvar only displaying on last page

    It probably is the format to multiple columns in the subreport that is the problem. I tried not using a subreport and I used the multiple columns on the main report but because the template in the Page Header contains text boxes on the left side to label the borrower's fields, the report then...
  5. mflahive

    Stringvar only displaying on last page

    Also, when I preview the subreport everything shows up correctly. It's only previewing the entire report that shows one borrower per page.
  6. mflahive

    Stringvar only displaying on last page

    I am able to link the {table.borrowerID} and {table.RelaID} to the subreport, however, because the {table.PoolID} field is a Number I am not able to link it to the Group #1 name. When I create a formula to change the field to a string and link that to the Group #1 name I get the same issue as...
  7. mflahive

    Stringvar only displaying on last page

    The subreport is linked on all three groups. Pool ID and Rela ID are parameters set up in the Main Report and the subreport is linked to those parameters as well as the Borrower ID field is linked to the Group #3 Borrower name. {@sharedvar} whileprintingrecords; shared stringvar X := X +...
  8. mflahive

    Stringvar only displaying on last page

    Hello again, I am hoping that if I show how the report is set up now since I've made a few changes, maybe it will help to show what I am doing wrong: MAIN REPORT Page Header a {@Page Reset} Page Header b Template (Underlay is used) Group Header #1 (Pool...
  9. mflahive

    Using 2 date fields in Subreport

    I only need to see expenses paid on the date the Pool was acquired and the last four months (from today's date). If I were to change the inner and outer groups per your suggestion then I would get all of the months where expenses were incurred and only the months that had expenses. I hope...
  10. mflahive

    Using 2 date fields in Subreport

    Using CR9 - I am trying to get expenses per month for a pool of NoteID's. I am working on a Subreport which is located in the main report's group header (Grouped by {table.as of date}. Here is how the subreport is setup now: Group Header 1 {table.As of date} Group Header 2 {table.expense paid...
  11. mflahive

    Help with Running total

    Thank you very much LB! It works great! M
  12. mflahive

    Help with Running total

    I'm sorry, I thought that I had put that this is a subreport but I didn't. I didn't mean for you to do more work than you had to.
  13. mflahive

    Help with Running total

    Thanks LB, but I can not specify the state in a formula because the report will be run for different Pools and the states will vary from Pool to Pool. I had to group on State so the report will only list the states for a particular Pool. The example I referenced is just what I am using to test...
  14. mflahive

    Help with Running total

    Hi LW - I don't have that option available as a "type of summary" for a running total. Thanks though. M
  15. mflahive

    Help with Running total

    Using CR9... I created a report that shows different states within a Pool of Note ID's. I am having a problem calculating the percentage since there can be more than one state per Note ID. Here is what I need the report to show: State #ofLoans $Balance %Balance IL 4...
  16. mflahive

    Stringvar only displaying on last page

    That's the strange part, I don't have the report formatted for a new page after any group so even when I put that formula in the section expert in the borrower group it just changes how the comment field acts on the report and doesn't include 3 borrowers per page. I don't have a new page format...
  17. mflahive

    Stringvar only displaying on last page

    I think I figured out why they work for you and not me. My main report did not have the same group by borrower that the subreport did. Meaning the subreport and formulas were on a different group. The problem with having that borrower group on the main report is then only one borrower prints...
  18. mflahive

    Stringvar only displaying on last page

    Here is what the subreport looks like: Report Header a Report Header b Group Header #1 Group Header #2 - {@sharedvar} group is by borrower ID Details The main report - Report Header Page Header a - {@pagereset} Page Header b - template Group Header #1 - {@resetx} Group Header #2 -...
  19. mflahive

    Stringvar only displaying on last page

    Hey LB, I needed a break from this report :-) I did solve the subreport not previewing but I am still working on displaying on 3 borrower comments per page. I have since moved the comment field into it's own subreport which is now located in the Page Footer on the Main Report. I think the...
  20. mflahive

    Stringvar only displaying on last page

    I just found another issue with this report. When I try to preview the subreport, the preview pane is blank and showing zero records which may perhaps be the cause of the comment field not showing??? It's strange that all the information on the subreport shows on the main report preview though.

Part and Inventory Search

Back
Top