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 bkrike 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: *

  • Users: Legion13
  • Content: Threads
  • Order by date
  1. Legion13

    How do you set default field values in ADO?

    I am building a tool that will create a dynamic load table that can be imported into a database, for legacy data conversion. The premise is that I can get the legacy data and map the appropriate fields for the CMMS application I implement. Then the tool checks which fields are present in the...
  2. Legion13

    Forcing Print size with ActiveX Viewer.

    Here is my problem. I have a report that is formatted to be 4"x6". If I print it directly from Crystal Reports 8 it prints fine. However, if I access the report through the web browser and the ActiveX Viewer it shows up on the screen twice as large as it should, with the printed...
  3. Legion13

    Help with Info and Lotus

    Anybody know how to configure Seagate Info 7 to e-mail via NotesMail? I found the dialog box for the config, and the name and password fields are self explanatory. But what is the Post Office Path? I pathed it to a local instal of Lotus Notes R5 but it failed saying that it was unable to find...
  4. Legion13

    Help with triggers

    I have a trigger that is fired off when a location field in a workorder record is updated. The problem is, the trigger needs to update 6 other fields in the same record and this causes a deadlock in SQL Server 7 because the record is already in the middle of an update. Does anyone know a...
  5. Legion13

    Exporting groups individually.

    Is it possible to get CR8 to export each group (or subreport) in a report into a separate Excel file? I have a report that I need to run for 25 or 30 facility managers and I would love to be able to run it once instead of once for each one. Thanks in advance.
  6. Legion13

    Help with web based parameters.

    I have a report that I am running from an asp page. I am using input boxes to get text from the user that is passed to the report like so: set session("ParamCollection") = Session("oRpt").Parameterfields set Param01 = session("ParamCollection").Item(1)...
  7. Legion13

    Charts

    I am trying to chart a running total on workorders that are grouped by month. If I set the chart on change of reportdate it gives me totals up to the change, i.e. for 3/2000 I get the total through the end of 2/2000 and what I want is the total through the end of 3/2000. How do I get around this?
  8. Legion13

    Problem passing variables from subreport

    Here is my problem, I have a subreport that gives me five separate counts on a number of workorders and sets them as shared variables. It is in invoked in my group footer #1. In my group footer #2 I print the five formulas that have retrieved the variables along with the group name which in...
  9. Legion13

    Date Format

    Is there any way to set the date format in Sequel Server 7 to only use the month and year, e.g. 09/2000?
  10. Legion13

    Does crystal write data too?

    Hello, I am fairly new at this whole database business so bear with me. :-) I am working on a report where the client wants to be able to keep a monthly history of the report data so they can use it to track trends. The data in the selected tables is liable to change over a period of months...

Part and Inventory Search

Back
Top