[RESOLVED] Question for Randem about Crystal Merge Module

[Nitesh]

Hi Randem,

I have include the Crystal Merge Module for CRXI in my app thanks to your advice in the past.

I want to know if my app is supposed to run Crystal Reports without the actual Crystal being installed on the P.C, since I have the merge module. At the moment it doesn't work until I install Crystal on each P.C.

[randem]

If that is the case you probably aren't installing the merge modules... That is what they are for. You need to show exactly how you are deploying them.

[RobDog888]

You can not just install Crystal Reports on other systems just to get your reporting to function correctly. This is what the merge modules are for, redistributing. Its a licensing violation to install CR onmore then one system unless you purchase multiple licenses of CR.

Thread Moved

[Nitesh]

Hi Guys,

I am distributing the Merge Module, this is what I have in my Script, i'm using InnoSetup:

[Files]
Source: c:\program files\randem systems\**********\********** 7.0\vb_dcom_mdac_jet_autosetup.exe; DestDir: {tmp}; Flags:  deleteafterinstall ignoreversion nocompression; 
Source: e:\Downloads\Crystal Merge Module\CRXI_RDC_ReDistribution\CRXI_RDC_Redistribution.msi; DestDir: {tmp}; Flags: nocompression ignoreversion deleteafterinstall;

[Run]
Filename: {tmp}\VB_DCOM_MDAC_JET_AutoSetup.exe; Parameters: /NORESTART /VERYSILENT; WorkingDir: {tmp}; Flags: skipifdoesntexist; Tasks: AutoOSUpdater
Filename: msiexec.exe; Parameters: /package {tmp}\CRXI_RDC_Redistribution.msi /passive; WorkingDir: {tmp}; Flags: skipifdoesntexist

I get the following Error:

Run-time error '339'

Component 'crviewer.dll' or one of its dependencies not correctly registered: a file is missing or invalid.

I tried registering it as follows and registering the dll was successful, but I still get the error.

regsvr32 "C:\Program Files\Business Objects\Common\3.5\crystalreportviewers115\ActiveXControls\CRViewer.dll"

please help again.

[randem]

Search your computer to see if you have this file - msiexec.exe

or better yet go to Start->Run then type msiexec.exe into the box and run it to see what comes up.

If this file is not on your machine then you cannot run msi files.

[randem]

To see if you did install the merge modules, look in the registry for this key

HKEY_LOCAL_MACHINE\SOFTWARE\Business Objects\Suite 11.5

[randem]

I just installed one of my apps with the merge modules and it did not work. I go the message that crviewr.dll was missing or invalid. This error is correct for I am deploying a CR 8.5 app with the CR XI merge modules. However if I deploy the CR 8.5 Installation with my app it works. This could possibly be your issue. Look in your references to see exactly which version you are using.

[Nitesh]

Hi Randem,

Thanks for the help. I have checked the registry and it contains:

HKEY_LOCAL_MACHINE\SOFTWARE\Business Objects\Suite 11.5

I am using CRXI and the PC's do have the msiexec.exe on them. I am confused.

[randem]

Ok, did you check the references and components to see what version they are?
Do you have another CR installed on your development machine?
When you checked the registry was it on the target machine?

[Nitesh]

Yes I did check my references and components. All are cersion XI. I have only CR XI installed on my machine and yes, I checked the target machine registry. please help me.

[randem]

Did you run your project through Inno Script?
Please do and post the results. We can work from there.

[Nitesh]

I have posted my script to your vbcode address. I would really appreciate your help. Thanks Randem.

[randem]

I will take a look see

[randem]

OK, One problem is that I see no CR references or components listed so I don't know how you are using CR.

[Nitesh]

I don't know which references to include in the script. U use the reportviewer mostly. I have attached a screenshot of the references I use. For components, I use the Crystal ActiveX Report Viewer Library 11. Please fix my script for me.

[randem]

You don't need to include any references in the script they will automatically be included. Post you vbp file.

Did you update?

[Nitesh]

Hi again,

I have posted my vbp file to your other address. Please have a look. I downloaded the ********** but I cant run it. It comes up with the registration form.

[randem]

This is what I get. Mind you I don't have CR XI or your project exe...

; ********** Version 8.0  Build 0  Beta
; Randem Systems, Inc.
; Copyright 2003-2008
; Website:  http://www.***********
; Support:  http://www.***********/cgi-bin/discus/discus.cgi
; OS: Windows XP 5.1 build 2600 (Service Pack 2)

; Date: November 27, 2007

;              VB Runtime Files Folder:   E:\Server Data\Randem\Develop\**********\VB 6 Redist Files\
;     Visual Basic Project File (.vbp):   E:\Works\Nitesh\Plant Maintenance\plant.vbp
; Inno Setup Script Output File (.iss):   E:\Works\Nitesh\Plant Maintenance\Scripts\Plant Maintenance Release.iss
;         Script Template Files (.tpl):   C:\Documents and Settings\Ralph James\Application Data\Randem Systems\**********\Templates\Release.tpl

; ------------------------
;        References
; ------------------------

; Visual Basic For Applications - (MSVBVM60.DLL)
; Standard OLE Types - (OLEPRO32.DLL)
; OLE Automation - (STDOLE2.TLB)
; Microsoft ActiveX Data Objects 2.1 Library - (msado21.tlb)
; Microsoft Internet Controls - (shdocvw.dll)
; Unknown Component (Possibly not registered) - crviewer.dll - 11.0 - (crviewer.dll)
; Crystal Reports ActiveX Designer Run Time Library 11.0 - (craxdrt.dll)
; Crystal Reports ActiveX Designer Design and Runtime Library 11.0 - (craxddrt.dll)
; Microsoft Scripting Runtime - (scrrun.dll)


; --------------------------
;        Components
; --------------------------

; Microsoft Winsock Control 6.0 (SP6) - (mswinsck.ocx)
; Microsoft Windows Common Controls 6.0 (SP6) - (mscomctl.ocx)
; Microsoft Windows Common Controls-2 6.0 (SP6) - (mscomct2.ocx)
; Microsoft Tabbed Dialog Control 6.0 (SP6) - (tabctl32.ocx)
; Microsoft FlexGrid Control 6.0 (SP6) - (msflxgrd.ocx)


[Setup]
AppId=Project1 Release

;-----------------------------------------------------------------------------------------------------
; Taken from VBP Project File Parameters AppName, AppName AppVersion and Company
;-----------------------------------------------------------------------------------------------------

AppName=Project1
AppVerName=Project1 1.0.0
AppPublisher=Network Support

;-----------------------------------------------------------------------------------------------------

AppVersion=1.0.0
VersionInfoVersion=1.0.0
AllowNoIcons=yes
DefaultGroupName=YardMan
DefaultDirName={pf}\YardMan
AppCopyright=
PrivilegesRequired=Admin
MinVersion=4.0,4.0
Compression=lzma
OutputBaseFilename=YardMan18100Release

[Tasks]
Name: AutoOSUpdater; Description: Install Support for Database Operations; GroupDescription: Install Database Support:
Name: CRInstallation; Description: Install Crystal Reports Runtime Files; GroupDescription: Install CR Runtime Files:

[Files]
Source: e:\server data\randem\develop\support\scripts\output\vb_dcom_mdac_jet_autosetup.exe; DestDir: {tmp}; Flags:  deleteafterinstall ignoreversion nocompression; Tasks: AutoOSUpdater
Source: e:\server data\randem\develop\support\cr merge module installation\version xi\rdc\out\crxi_rdc_redistribution.mm\msi\crxi_rdc_redistribution.msi; DestDir: {tmp}; Flags:  deleteafterinstall ignoreversion nocompression; Tasks: CRInstallation
Source: e:\works\nitesh\plant maintenance\opendb.dsn; DestDir: {app}; Flags:  ignoreversion; 
Source: e:\server data\randem\develop\deployable system files\mswinsck.ocx; DestDir: {sys}; Flags:  regserver restartreplace sharedfile; 
Source: e:\server data\randem\develop\deployable system files\mscomctl.ocx; DestDir: {sys}; Flags:  regserver restartreplace sharedfile; 
Source: e:\server data\randem\develop\deployable system files\mscomct2.ocx; DestDir: {sys}; Flags:  regserver restartreplace sharedfile; 
Source: e:\server data\randem\develop\deployable system files\tabctl32.ocx; DestDir: {sys}; Flags:  regserver restartreplace sharedfile; 
Source: e:\server data\randem\develop\deployable system files\msflxgrd.ocx; DestDir: {sys}; Flags:  regserver restartreplace sharedfile; 
Source: yardman18.exe; DestDir: {app}; Flags:  restartreplace sharedfile; 
Source: E:\Works\Nitesh\Plant Maintenance\Reports\*.*; DestDir: {app}\Reports; Flags: ignoreversion

[INI]
Filename: {app}\YardMan18.url; Section: InternetShortcut; Key: URL; String: 

[Icons]
Name: {group}\Project1; Filename: {app}\YardMan18.exe; WorkingDir: {app}
Name: {group}\{cm:ProgramOnTheWeb, Project1}; Filename: {app}\YardMan18.url
Name: {group}\{cm:UninstallProgram, Project1}; Filename: {uninstallexe}

[Run]
Filename: {tmp}\VB_DCOM_MDAC_JET_AutoSetup.exe; Parameters: /NORESTART /VERYSILENT; WorkingDir: {tmp}; Flags: skipifdoesntexist; Tasks: AutoOSUpdater
Filename: msiexec.exe; Parameters: /package {tmp}\CRXI_RDC_Redistribution.msi /passive; WorkingDir: {tmp}; Flags: skipifdoesntexist; Tasks: CRInstallation
Filename: {app}\YardMan18.exe; Description: {cm:LaunchProgram, Project1}; Flags: nowait postinstall skipifsilent; WorkingDir: {app}

[UninstallDelete]
Type: files; Name: {app}\YardMan18.url

[Registry]

[randem]

As I look at your previous script you did not include your rpt files and that was probably what your error was from (aside from deploying other useless files).

[Nitesh]

Hi Randem,
my boss just purchased ********** for me. I am running it right now. But it may take me a while bcos I still have to get familiar with what goes in the unsafe.fil and what should go in a safe folder and stuff.

[randem]

Ok, But what about the rpt files you never deployed???

[Nitesh]

Hi Randem,
quick question. Where in ********** do I specify the Crystal Merge module information. Those rpt files I did yesterday bcos the designer reports of mine where displaying weird text so I changed my method. I will deploy them now.

[randem]

You use the templates to deploy the merge modules...

[randem]

Oh yeah, Don't worry about the unsafe file. Just download the updated one and replace the one you have now...

[Nitesh]

Ok I selected the added the merge module tpl file under templates. But shouldn't inno show the merge module info under tasks and files etc. How do I get these into my script in inno:

[Tasks]
Name: ScriptingRuntime; Description: Install Microsoft's Scripting Runtime; GroupDescription: Install Scripting Runtime:

[Files]
Source: e:\Downloads\Crystal Merge Module\CRXI_RDC_ReDistribution\CRXI_RDC_Redistribution.msi; DestDir: {tmp}; Flags: nocompression ignoreversion deleteafterinstall;

[Run]
Filename: {tmp}\VB_DCOM_MDAC_JET_AutoSetup.exe; Parameters: /NORESTART /VERYSILENT; WorkingDir: {tmp}; Flags: skipifdoesntexist; Tasks: AutoOSUpdater
Filename: msiexec.exe; Parameters: /package {tmp}\CRXI_RDC_Redistribution.msi /passive; WorkingDir: {tmp}; Flags: skipifdoesntexist
Filename: {tmp}\scr56en.exe; Parameters: /r:n /q:1; MinVersion: 4.1,4.0; OnlyBelowVersion: 0,4.01; WorkingDir: {tmp}; Flags: skipifdoesntexist; Tasks: ScriptingRuntime
Filename: {tmp}\scripten.exe; Parameters: /r:n /q:1; MinVersion: 0,5.0; OnlyBelowVersion: 0,5.02; WorkingDir: {tmp}; Flags: skipifdoesntexist; Tasks: ScriptingRuntime

[Nitesh]

Hi again,

would this be a problem Randem:

; Unknown Component (Possibly not registered) - crviewer.dll - 11.0 - (crviewer.dll)

Why would inno say that.

[randem]

Please don't confuse the two when referring to the programs. Inno Setup is commonly referred to as Inno, Inno Script is a different program...

Why would you think the merge modules should show under [Tasks]?

Are you just copying things or running your app thru Inno Script????

Please post the whole script... I can't tell what you are doing...

[Nitesh]

Hi randem,

I mean, after I run ********** my script looks the same as the one u posted above. However, I don have this under tasks:

Name: CRInstallation; Description: Install Crystal Reports Runtime Files; GroupDescription: Install CR Runtime Files:

and I dont have this under run in **********:

Source: e:\server data\randem\develop\support\cr merge module installation\version xi\rdc\out\crxi_rdc_redistribution.mm\msi\crxi_rdc_redistribution.msi; DestDir: {tmp}; Flags:  deleteafterinstall ignoreversion nocompression; Tasks: CRInstallation

How do I specify in ********** where the merge modules are. Do I have to put the path in in the search path.

Or do I have to add these manually to my script after it has been generated by **********. Sorry, but i am confused. This is the last issue I have, thereafter I can test it and hopefully it works.

[randem]

You shouldn't you are not running the same version that I am... You seemed to miss that part of the script.

You seem to miss all the important parts of reading... Post the script....

[randem]

I am ready to leave for food and sleep. It's 1:30am here.

[Nitesh]

ok randem, i read in the help file to point the tpl file to the folder where the merge module is on my system. I've done that, but it still doesn't appear in my script. Ok then, i think u should sleep, it's very late there. .

I will try to figure it out. Thanks so much for your help. it's greatly appreciated.

[randem]

You don't point the .tpl file anywhere You add the msi file to your script using "Add Files" and you add the Template using "Templates" If you ever post you script things would go a lot smoother...

[Nitesh]

thanks randem,

I am getting an error when compiling my script in innosetup on this line:

DefaultDirName={code:GetAppFolder}\YardMan

it say's required function or procedure 'GetAppFolder' not found.

[randem]

Which part of POST THE WHOLE SCRIPT is not understandable?????

You probably don't have the VISTA template file included...

[Nitesh]

sorry Randem.

I have pointed the template to where my merge module is. should this appear under tasks in my script:

Name: CRInstallation; Description: Install Crystal Reports Runtime Files; GroupDescription: Install CR Runtime Files:

and this under run:

Filename: msiexec.exe; Parameters: /package {tmp}\CRXI_RDC_Redistribution.msi /passive; WorkingDir: {tmp}; Flags: skipifdoesntexist

forgive me for being dumb, but i don't fully understand ********** as yet

; ********** Version 7.3  Build 2
; Randem Systems, Inc.
; Copyright 2003-2007
; Website:  http://www.***********
; Support:  http://www.***********/cgi-bin/discus/discus.cgi
; OS: Windows XP 5.1 build 2600 (Service Pack 2)

; Date: November 28, 2007

;              VB Runtime Files Folder:   C:\Program Files\Randem Systems\**********\********** 7\VB 6 Redist Files\
;     Visual Basic Project File (.vbp):   E:\David\VBDev\Plant Maintenance\plant.vbp
; Inno Setup Script Output File (.iss):   E:\David\VBDev\Plant Maintenance\Improved Script\release Release.iss

; ------------------------
;        References
; ------------------------

; Visual Basic For Applications - (MSVBVM60.DLL)
; OLE Automation - (STDOLE2.TLB)
; Microsoft ActiveX Data Objects 2.1 Library - (msado21.tlb)
; Microsoft Internet Controls - (shdocvw.dll)
; Unknown Component (Possibly not registered) - crviewer.dll - 11.0 - (crviewer.dll)
; Crystal Reports ActiveX Designer Run Time Library 11.0 - (craxdrt.dll)
; Crystal Reports ActiveX Designer Design and Runtime Library 11.0 - (craxddrt.dll)
; Microsoft Scripting Runtime - (scrrun.dll)


; --------------------------
;        Components
; --------------------------

; Microsoft Winsock Control 6.0 (SP6) - (mswinsck.ocx)
; Microsoft Windows Common Controls 6.0 (SP6) - (mscomctl.ocx)
; Microsoft Windows Common Controls-2 6.0 (SP6) - (mscomct2.ocx)
; Microsoft Tabbed Dialog Control 6.0 (SP6) - (tabctl32.ocx)
; Microsoft FlexGrid Control 6.0 (SP6) - (msflxgrd.ocx)


[Setup]
AppId=Project1 Release

;-----------------------------------------------------------------------------------------------------
; Taken from VBP Project File Parameters AppName, AppName AppVersion and Company
;-----------------------------------------------------------------------------------------------------

AppName=Project1
AppVerName=Project1 1.0.0
AppPublisher=Network Support

;-----------------------------------------------------------------------------------------------------

AppVersion=1.0.0
VersionInfoVersion=1.0.0
AllowNoIcons=no
DefaultGroupName=YardMan
DefaultDirName={code:GetAppFolder}\YardMan
AppCopyright=
PrivilegesRequired=Admin
MinVersion=4.0,5.01sp2
Compression=lzma
OutputBaseFilename=YardMan18100Release

[Tasks]
Name: AutoOSUpdater; Description: Install MDAC's for Database Operations; GroupDescription: Install MDAC's:
Name: ScriptingRuntime; Description: Install Microsoft's Scripting Runtime; GroupDescription: Install Scripting Runtime:

[Files]
Source: c:\program files\vb_dcom_mdac_jet_autosetup.exe; DestDir: {tmp}; Flags:  deleteafterinstall ignoreversion nocompression; Tasks: AutoOSUpdater
Source: e:\david\vbdev\plant maintenance\scripting runtime\scripten.exe; DestDir: {tmp}; Flags:  deleteafterinstall ignoreversion nocompression; MinVersion: 0,5.0; OnlyBelowVersion: 0,5.02; Tasks: ScriptingRuntime
Source: e:\david\vbdev\plant maintenance\scripting runtime\scr56en.exe; DestDir: {tmp}; Flags:  deleteafterinstall ignoreversion nocompression; MinVersion: 4.1,4.0; OnlyBelowVersion: 0,4.01; Tasks: ScriptingRuntime
Source: e:\david\vbdev\plant maintenance\opendb.dsn; DestDir: {app}; Flags:  ignoreversion; 
Source: e:\downloads\crystal merge module\crxi_rdc_redistribution\crxi_rdc_redistribution.msi; DestDir: {app}; Flags:  ignoreversion; 
Source: c:\windows\system32\mswinsck.ocx; DestDir: {sys}; Flags:  regserver restartreplace sharedfile; 
Source: c:\windows\system32\mscomctl.ocx; DestDir: {sys}; Flags:  regserver restartreplace sharedfile; 
Source: c:\windows\system32\mscomct2.ocx; DestDir: {sys}; Flags:  regserver restartreplace sharedfile; 
Source: c:\windows\system32\tabctl32.ocx; DestDir: {sys}; Flags:  regserver restartreplace sharedfile; 
Source: c:\windows\system32\msflxgrd.ocx; DestDir: {sys}; Flags:  regserver restartreplace sharedfile; 
Source: e:\david\vbdev\plant maintenance\exe\yardman18.exe; DestDir: {app}; Flags:  restartreplace sharedfile; 
Source: E:\David\VBDev\Plant Maintenance\Icons\*.*; DestDir: {app}\Icons; Flags: ignoreversion
Source: E:\David\VBDev\Plant Maintenance\Reports\*.*; DestDir: {app}\Reports; Flags: ignoreversion

[INI]
Filename: {app}\YardMan18.url; Section: InternetShortcut; Key: URL; String: 

[Icons]
Name: {group}\Project1; Filename: {app}\YardMan18.exe; WorkingDir: {app}
Name: {group}\{cm:ProgramOnTheWeb, Project1}; Filename: {app}\YardMan18.url
Name: {group}\{cm:UninstallProgram, Project1}; Filename: {uninstallexe}

[Run]
Filename: {tmp}\VB_DCOM_MDAC_JET_AutoSetup.exe; Parameters: /NORESTART /VERYSILENT; WorkingDir: {tmp}; Flags: skipifdoesntexist; Tasks: AutoOSUpdater
Filename: {tmp}\scr56en.exe; Parameters: /r:n /q:1; MinVersion: 4.1,4.0; OnlyBelowVersion: 0,4.01; WorkingDir: {tmp}; Flags: skipifdoesntexist; Tasks: ScriptingRuntime
Filename: {tmp}\scripten.exe; Parameters: /r:n /q:1; MinVersion: 0,5.0; OnlyBelowVersion: 0,5.02; WorkingDir: {tmp}; Flags: skipifdoesntexist; Tasks: ScriptingRuntime
Filename: {app}\YardMan18.exe; Description: {cm:LaunchProgram, Project1}; Flags: nowait postinstall skipifsilent; WorkingDir: {app}

[UninstallDelete]
Type: files; Name: {app}\YardMan18.url

[Registry]

[randem]

Ok, that looks good. Just a few things. You did not have the CR XI template included. That is where the [Run] section comes from for the CR file.

Also you are installing the reports into your app folder in a folder named Reports. Is that where your app will be looking for them or will they be looked for in the app folder. If they will be looked for in the app folder you cannot use the "Add Folder" tab to add the files you must use the "Add Files" tab to the rpt files. The same goes for your Icons...

[randem]

Also you did not include the Vista template. Click on Template Processing to have the templates used...

[Nitesh]

this is what's in my CR XI RDC Redistribution.tpl:

[Files]
Source: "E:\Downloads\Crystal Merge Module\CRXI_RDC_Redistribution\CRXI_RDC_Redistribution.msi"; DestDir: "{tmp}"; Flags: nocompression ignoreversion deleteafterinstall

[Run]
Filename: msiexec.exe; Parameters: "/package {tmp}\CRXI_RDC_Redistribution.msi /passive"; WorkingDir: {tmp}; Flags: skipifdoesntexist

I have added this template to **********, but it still doesn't appear when i run **********.

P.S What about that required function or procedure error.

[randem]

Please you must read what I write....

Select from the main menu the templates button.... then re-run.

[Nitesh]

oh ok. Thanks randem. That worked. I still get the error on the GetAppFolder function. Is there any way to fix that.