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...
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...
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...
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...
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.
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)...
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?
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...
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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.