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 strongm 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. hpl2001

    Fields missing in link window

    Hello. I'm hoping someone has seen this issue, because it's stopped my work. When I go into the database expert for my report, and look at the link window, I see only the names of the table. None of the fields show up so I can't work with my links. Any advice?
  2. hpl2001

    Multiple multi value parameters

    Hello. I'm wondering if I use 2 multi value parameters in my report of the entries from both parameters will match up. Ie, the report uses the first entry of multi A and the first entry of multiB, then it processes the second entry of multiA along with the second entry of MultiB, etc. TIA Holly
  3. hpl2001

    BI4/Crystal 2016 upgrade issue with scheduled reports

    Hello: We are in the process of upgrading to BI4 and Crystal 2016. We are having an issue with our existing reports - in the new environment, when reports are run on demand they run correctly. We are finding, however, that when we schedule reports some of the subreports are missing linking...
  4. hpl2001

    Calculating totals across a date range

    Works a charm. Thanks again. H.
  5. hpl2001

    Calculating totals across a date range

    Thank you for this. Gives me something to chew on. H.
  6. hpl2001

    Calculating totals across a date range

    There are no fields that have the actual calendar date. That's the problem for me. How to iterate through consecutive dates that aren't actually in the database. And thanks for your help.
  7. hpl2001

    Calculating totals across a date range

    Let me try again. Table has three fields: Name - text type arrival date - date type departure date - date type. When ordering the report, the user enters two parameters, report start date (date type) and report end date (date type) The output would look like this Jan 1, 2019: 10 Jan 2...
  8. hpl2001

    Calculating totals across a date range

    Ok. Let's say there are three fields in my table: Name, start date and end date. Given a report parameter of a date range, I need my report to display the number of people who are there of each day of the parameter range. Does that help?
  9. hpl2001

    Calculating totals across a date range

    Hello. This is making my head hurt. Here's the scenario. I have a group of customers that stay in a certain area. Customer 1 might be there Jan 5-10. Customer 2 might stay Jan 1-7, customer 3 Jan 6-20 etc. For my report, I need to iterate through all the days of January (although the date...
  10. hpl2001

    Report stored in history getting updated

    No currentdate or sysdate are being used. Can you think of any setting that might govern the SQL expression in terms of updating? I'm poking all around but I don't see a good candidate.
  11. hpl2001

    Report stored in history getting updated

    Yes, it's a poser. I'm just opening a report instance that is sitting in the history folder. H.
  12. hpl2001

    Report stored in history getting updated

    Hello. In my organization we provide report access to our users through a BOE webpage. I'm having an issue with a particular report when particular runs are being stored in the report history. When the report is later viewed from the history, some of the data is being updated. End result is...
  13. hpl2001

    Report in History auto updating

    Hello: I have a report that I'm scheduling, and when I look at the report instance in the history it is auto updating data on the report. It is NOT updating the runtime printed on the report, so it's very misleading. Is there a way to stop the report instance in history from auto updating...
  14. hpl2001

    Lost a ton of records from one table

    That's cool! Unfortunately no previous versions were found...
  15. hpl2001

    Lost a ton of records from one table

    Yikes! I have a multiuser database - the data sits on a central server and the application is distributed to the desktop. I came to work yesterday and one of the tables, that used to hold almost 200,000 records, only has 199 records in it. No records prior to midday July 18th. The other...
  16. hpl2001

    Open form without preloading data

    That works great. Thank you so much! Holly
  17. hpl2001

    Open form without preloading data

    Great. Would you be able to show me what the code would look like to reset the record source? The source is a query.
  18. hpl2001

    Open form without preloading data

    Hello: Is it possible to open a form without preloading the data? I don't want the query to run until the user clicks on a search button. TIA Holly
  19. hpl2001

    Shared Database doesn't open under Windows 8

    Thanks Lameid. Quick question...do you know if there's a place in Windows 8 where one configure how the database is being opened? I thought the ability to do this was set withing in the database itself. At the momment it successfully allows multi user access for our Win7 machines.
  20. hpl2001

    Shared Database doesn't open under Windows 8

    Hello: I'm doing some testing in preparation for an upgrade to windows 8 (I know...I'm in the government, we don't do things quickly). I have a shared access database. Currently users run the front end of the database from their desktop, and the backend is location on a remote server...

Part and Inventory Search

Back
Top