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!

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

Recent content by computek353

  1. computek353

    Can LastFullMonth be pushed down to database server

    Lastfullmonth works fine in my record selection formula too. You shouldn't have any problems using it in there.
  2. computek353

    count on a field when the field value is 2

    Another way that you could do without the variable is to use this formula: if {dbt_Patient.pt_Sex} = 2 then 1 else 0 then you can do a summary on that.
  3. computek353

    First Line of Field only

    Yea I just did and it seems to work ok. I think it would really slow the report down if I had more records but as it is I think it will work great. Thanks for the suggestions.
  4. computek353

    First Line of Field only

    Do you think it would cause any problems to just remove the can grow option on the field and size it so that only the first line is displayed? I should only have about 30 - 40 records on this report.
  5. computek353

    First Line of Field only

    Do you think it would cause any problems to just remove the can grow option on the field and size it so only the first line is displayed? I should only have about 30 - 40 records on this report.
  6. computek353

    First Line of Field only

    Sorry should have mention that in the first place. It is a memo field.
  7. computek353

    First Line of Field only

    I need formula that will pull only the first line of a notes field. The line are seperated by a single returns in the DB.
  8. computek353

    Paging through subreport pages

    You are correct. The subreport does not process immediately when opening the preview page. I believe this is because the subreport makes a seperate connection to the Database and does not use the one already established by the main report. One thing you could do so that you don't get the delay...
  9. computek353

    Subreports do not run after Passing Parameters

    I didn't get the problem solved but I found a better solution for my problem. Since I mainly do the report for the previous month I just used "lastfullmonth" to pull the dates in automatically. Thanks for all the suggestions.
  10. computek353

    Creating a TOC

    Is there a way to create a Table of Contents that updates automatically when the report is run? Currently I have to modify the TOC every time because the page numbers change. I don't know if this makes it simpler or more difficult but I'm using subreports to display a majority of the data...
  11. computek353

    Subreports do not run after Passing Parameters

    I've checked that and the correct information is being passes on. It's just that the subreport won't run. I don't any errors and it runs fine standalone. It just won't run as a subreport. Anything else I can try?
  12. computek353

    Subreports do not run after Passing Parameters

    Does anyone have anything I can try??? I desperately need working.
  13. computek353

    Subreports do not run after Passing Parameters

    Here is the record Selection formula for the Subreport: {PROBLEM_VIEW.ORGANIZTION_ID} = "5" and {PROBLEM_VIEW.OPEN_DATE} in {?Pm-?Startdate} to {?Pm-?EndDate} The report that I'm inserting does not contain any subreports and the report does work when I put values in instead of the...
  14. computek353

    Subreports do not run after Passing Parameters

    I'm using CR 8 and am now adding a couple of parameters to a couple of subreports. The parameters are being used in the selection formula. The problem is as soon as I put in the parameter the subreport no longer runs. I can run the subreport by itself and it will run but it doesn't run as a...
  15. computek353

    Sorting "others" with Top 5

    Does anyone have any Ideas that I can try?
See more

Part and Inventory Search

Back
Top