This is probably a strange request as most want to suppress duplicates, I on the other hand want to duplicate a record based on number of occurrences per year.  So if the activity is weekly I should see 52 records with a generated due date based on frequency code and the last  duplicated records calculated due date.

I am trying to forecast a preventive maintenance activity based on frequency code such a YR, MO, DY, WK, etc.

WhilePrintingRecords;
DateVar NextDt;
StringVar IntervalType;
NumberVar Interval;

Interval := ToNumber({FREQUENCY_UNIT});

if {FREQUENCY_UOM} = 'YR' then IntervalType := 'yyyy';
if {FREQUENCY_UOM} = 'MO' then IntervalType := 'm';
if {FREQUENCY_UOM} = 'WK' then IntervalType := 'ww';
if {FREQUENCY_UOM} = 'DY' then IntervalType := 'd';


NextDt := Date(DateAdd (IntervalType,Interval,{@Due Date}));

NextDt;

Hopefully this makes some sense.

I had this question after viewing Calculate Percentage in Crystal Report Formula.

I have a percentage calculation which calculate percentage based on a variable dao.t47:

if isNumeric({dao.T47}) then
     (if toNumber({dao.T47}) in 91 to 100 then "A1" else
     if toNumber({dao.T47}) in 81 to 90 then "A2" else
     if toNumber({dao.T47}) in 71 to 80 then "B1" else
     if toNumber({dao.T47}) in 61 to 70 then "B2" else
     if toNumber({dao.T47}) in 51 to 60 then "C1" else
     if toNumber({dao.T47}) in 41 to 50 then "C2" else
     if toNumber({dao.T47}) in 33 to 40 then "D" else
     if toNumber({dao.T47}) < 33 then "E")
else {dao.T47}

Now I had changed the variable to a custom made which doing sum for some variables so I have @gtotal now. How to set percentage like above for this, when I wrote it, it was givign me error:

if isNumeric({@gtotal}) then
     (if toNumber({@gtotal}) in 91 to 100 then "A1" else
     if toNumber({@gtotal}) in 81 to 90 then "A2" else
     if toNumber({@gtotal}) in 71 to 80 then "B1" else
     if toNumber({@gtotal}) in 61 to 70 then "B2" else
     if toNumber({@gtotal}) in 51 to 60 then "C1" else
     if toNumber({@gtotal}) in 41 to 50 then "C2" else
     if toNumber({@gtotal}) in 33 to 40 then "D" else
     if toNumber({@gtotal}) < 33 then "E")
else {@gtotal}

Please help...

Hello,

I wish to create a custom formula field in Crystal Reports to display data from a field. The data is:

COSS00537<XXXXXXXXXXXX

I want to remove the CO away and the anything pass < xxxxxxxx

So only leaving SS00537.

Thanks.

I have a Crystal Report Formula that I am trying to get converted into a SQL expression that I can add as a calculated field in my report.   The Crystal Reports formula is:

if{p21_view_process_x_transaction_detail.qty_in} >0  and
{p21_view_process_x_transaction_detail.qty_in} <> {p21_view_process_x_transaction_detail.qty_out}then
    "CURRENT JOBS"
else
    "Future Jobs"

I'm always having problems with the syntax in SQL.  I have even tried just dealing with one criteria and can't get that right either.  My last attempt looked like the following:

=iif(Fields!qty_in.Value >0  and
(Fields!qty_in.Value <> (Fields!qty_out.Value,"CURRENT JOBS","Future Jobs"

I need to create an MS SQL query that shows the date-time difference involving Vehicle Stop & Vehicle Start times, for a given Operator using a particular Vehicle.
Then I need to SUM these values, so we have a total running time for an Operator for ALL Vehicles.
Here is the SQL I've used to come up with all the records needed.

                             SELECT [EventLog].[Date Time], [Events].[Description], [EventLog].[Operator Name],
                                           [EventLog].[Operator Code], [Vehicles].[Truck Type] AS 'Forklift ID'
                                           FROM EventLog INNER JOIN Events ON [EventLog].[Event ID] = [Events].[EventLog Number]
                                           INNER JOIN Vehicles on [Vehicles].[Serial] = [EventLog].[Serial Number]
                                           WHERE (([Date Time] between '" & StartDateTime & "' AND '" & EndDateTime & "') AND
                                            ([EventLog].[Event ID] = '3' OR [EventLog].[Event ID] = '4')) ORDER BY
                                            [EventLog].[Operator Name], [EventLog].[Date Time], [EventLog].[Serial Number] ASC;

I'm using data / database structure from a 3rd party, that can't be altered.
Here is the Database Table Structures:

EventLog
Key - ID
Date Time - YYYY-MM-DD HH:MM:SS
Event ID - (3=Vehicle Start & 4=Vehicle Stop)
Operator Code - ID
Operator Name
Serial Number - (Vehicle serial number)

Events…

I have an old version of Business Objects Crystal Report Server Software that we are trying to reinstate for Project Management.  My owners don't want to spend the money for the latest/greatest in similar software.

I have everything running except for the CMC.  As soon as I start it, it falls on its' face and goes right back to a stopped state.  When I go to check the connection for the CMC I get the following pop up:  
The event logs list the following, similar, error:  
The environment is a virtual Windows Server 2012 R2 with a SQL Server 2016.

I have deleted and added the DSN numerous times with different drivers to no avail. (In the 32 Bit ODBC)

It should be noted that when I set up the DSN, and the connection in the CMC, it successfully connects to the database.  The error only happens when I go back to the connections tab in the CMC.  

The only possible issue I thought about was that this is a 64 bit virtual and the software is 32.  However, I have never had an issue with this in the past on physical servers. (64 vs the CS 32 software)

Is there a way to see what the CMC is submitting for the connection string?

Hi Experts,

i have to add some custom code to SAP gui scripting code, we have customized code like the script read the data from the excel.
but we want to add more customization in the code.

If Not IsObject(application) Then
   Set SapGuiAuto  = GetObject("SAPGUI")
   Set application = SapGuiAuto.GetScriptingEngine
End If
If Not IsObject(connection) Then
   Set connection = application.Children(0)
End If
If Not IsObject(session) Then
   Set session    = connection.Children(0)
End If
If IsObject(WScript) Then
   WScript.ConnectObject session,     "on"
   WScript.ConnectObject application, "on"
End If

Dim cnnExcel, rstExcel
Dim strExcelFile
strExcelFile = "C:\Users\kt5775\Desktop\Engie work\SAP info\Tcodes input.xlsx"

Set cnnExcel = CreateObject("ADODB.Connection")
    cnnExcel.Open "Provider=Microsoft.Jet.OLEDB.4.0;" & _
               "Data Source=" & strExcelFile & ";" & _
               "Extended Properties=""Excel 8.0;HDR=NO;"""

    Set rstExcel = CreateObject("ADODB.Recordset")
    rstExcel.Open "Select * from [Sheet1$A1:G1000]", cnnExcel, adOpenStatic

session.findById("wnd[0]").maximize
Do Until rstExcel.EOF or UCASE(rstExcel.Fields(0).Value) = "LAST"


session.findById("wnd[0]").maximize
session.findById("wnd[0]/tbar[0]/okcd").text = "/npfcg"
session.findById("wnd[0]").sendVKey 0
session.findById("wnd[0]/usr/ctxtAGR_NAME_NEU").text = rstExcel.Fields(0).Value
session.findById("wnd[0]/usr/btn%#AUTOTEXT003").press
…

When trying to create a union in crystal reports XI i'm getting the error 'SQL command not properly ended'

Here's my sql, to me it looks correct? Any ideas?.

SELECT * FROM db.table1
UNION ALL
SELECT * FROM db.table2
UNION ALL
SELECT * FROM db.table3
UNION ALL
SELECT * FROM db.table4
UNION ALL
SELECT * FROM db.table5;

Select all Open in new window

I am trying to install just the Microsoft ODBC for Oracle 6.01.7601.23391 MSORCL32.DLL on a
Windows 2012 Server It needs to be able to be installed on the 64 bit ODBC Admin.
I already have one installed on a Windows 7 machine but I did not install it.
When I go to the 2012 Server I notice it does not have it listed in the Drivers Tab of the ODBC Administrator tools.
Since this is going to be used with Crystal Reports and an Oracle Database. I assume it does not matter if it is a 32 bit version?
Currently the report is working and running just fine installed in ODBC Admin 64 bit version on another machine. Windows 7 Pro

I have searched most of today and cannot seem to get the correct file on the correct machine. Is there something unusual I have to do since it is a 32 bit and I need it on the 64 bit ODBC Admin location. Please advise. Thank you.

Hi, I Used Crystal Report in C# Desktop application. My database is in access and i set Jet Password there.Can you help me to set Jet Database Password dynamically in Crystal Report.

Hi, I have a parameter that's a number which is accepting a year (ex: 2018). But it displays as 2,018.00 when I printed on the report.
I need to pass 2018 to the database rather than 2,018.00 in Record Selection Criteria
I don't want to convert into string because my database field is smallint.
I tried truncate, Round.  It is still displaying as 2,018.00
How can I make this parameter to display as 2018
Please help.

Hi experts,

I have the following issue

I need to have my data viewed as follows
GH1   Vegetables
D:Carrots
D:Celery
D:Tomato

GH1 Beef
D:Turkey
D:Chicken
D:Beef

GH1:Oils
D:Butter
D:Sunflower
D:Olive

I need the for Each GH1 to have the data displayed as follows in a subreport1
Carrots        Celery        Tomato

I need the for Each GH1 to have the data displayed as follows in a subreport2
Turkey       Chicken     Beef

I need the for Each GH1 to have the data displayed as follows in a subreport3
Butter        Sunflower       Olive

There could be dozens of records in each GH1

Any assistance would be appreciated

I have 2 Windows Applications which already contains a CrystalReports1.rpt, CrystalReport11 and CrystalReportViewer1 in Form1 design.
Questions:
1. How do I merge the 2 into 1 Windows Application AND
2. What changes do I need to make (where), so there isn't any confusion between the 2 reports?

Both reports will be accessed via a separate  button for each.

Thank you,

Russ