Need Help migrating from CR 9 to CR 10 (which is now on its own server 1

[canimrod]

I am not sure how to modify my VBScript code that currently uses the CreateObject command -- Session("oApp") = Server.CreateObject("CrystalRuntime.Application.9") -- to call Crystal. How do I change that code to call Crystal when it is no longer installed directly on the WebServer?

How do I connect the webserver to the CR 10 Server so I can run reports?

Any help on how to get through this, no matter the solution, is most appreciated.

-Colman

 

[AndrewBaines]

You need the developer components installed on the server where your VBScript is running.

Andrew Baines

http://www.pursuittechnology.co.uk

 

[canimrod]

OK if I only need the developer portion how do i tie that back to the CR server? I have never really worked with CR before so I am a complete novice when it comes to administration for CR. Sorry, but thank you.

-Colman

 

[AndrewBaines]

What component do you have on the server? Is this RAS or CE?
Crystal.Runtime.Application.9 to my knowledge just runs locally.

Andrew Baines

http://www.pursuittechnology.co.uk

 

[canimrod]

On our current set-up we are running Enterprise on the local webserver (CR 9). On the new server set-up CR 10 will be running on its own server. How do I get my legacy VB/ASP code to see the new CR server.

If I have to load the CR Dev components that is fine but how can I tie that to the new external CR 10 Server? Also I am sure that there is a newer version of the SmartViewerActiveX.asp for CR 10 as well, but I think I can find that.

I appreciate you help this has become a real pain for us.

-Colman

 

[AndrewBaines]

It's not the CR dev components you want, it's the CE dev components. Do a custom install and you'll see the SDK options.
Then it's just a case of referencing the correct CMS/APS from your code.

If you're using Session("oApp") = Server.CreateObject("CrystalRuntime.Application.9") , then you're not using Enterprise whether it's installed or not!

Andrew Baines

http://www.pursuittechnology.co.uk

 

[canimrod]

OK, so if I need the CE components will they work without referencing the CR 10 Server, or how do I configure it to point to the new server? Again, I apologize for my relative ignorance. No one here (even our sys-admins) has any clue on what to do with CR Servers.

Thanks

-Colman

 

[AndrewBaines]

In you code, do you have a line that calls EnterpriseSession?

Andrew Baines

http://www.pursuittechnology.co.uk

 

[canimrod]

No we do not have that call anywhere in our code. Does this mean all along we have never been using the CR Enterprise server? If so how do we go about connecting our VB/ASP to the CR Server, rather than continuing to overload the webserver by using the local components?

-Colman

 

[AndrewBaines]

Looks like you've never used Enterprise for the reports. You're probably just loading the report from a local file and running on the server.
There's too much involved to explain it all here. You really have two options:
1) Work your way through the CE SDK documentation and start again
2) Get someone (like me!) in to do the work.

Advantages/disadvantages of the two options are pretty obvious time vs money etc etc.

Andrew Baines

http://www.pursuittechnology.co.uk

 

[canimrod]

Thanks, I am not surprised that we were never really using the Enterprise at all. Our system was started by someone who had never even programmed VB before so everything is extra screwy in the code. We keep our reports on the webserver, in a directory with the rest of the website, and call them through VB using Session("oApp") = Server.CreateObject("CrystalRuntime.Application.9"), and then use the following code excerpt to define the report to run (where ReportName is a variable passed in by the user when they select a report by clicking on a button).

Set Session("oRpt") = Session("oApp").OpenReport(BMSReports & ReportName, 1)
Set DBTable = Session("oRpt").Database.Tables.Item(1)
DBTable.SetLogonInfo "Budget", "BudgetData", "uid", "pwd"
Session("oRpt").MorePrintEngineErrorMessages = False
Session("oRpt").EnableParameterPrompting = False
Session("oRpt").DiscardSavedData

How do I go about showing that we don't use the Enterprise Server with our current method?

-Colman

 

[AndrewBaines]

If the reports are being accessed using a 'proper' file path, then it's not enterprise. In Enterprise, you pick up the report by querying the CMS using an InfoStore. The code above has nothing to do with Enteprise at all!
If anyone has any doubts, just turn all the Enterprise services off and see if it still works.

Andrew Baines

http://www.pursuittechnology.co.uk

 

[canimrod]

I turned off all the Crystal-related services from a deve server and everything seems to still work as expected. I am not sure if there are other services I have missed (without Crystal in the service name), but I have made the general assumption that we aren't using Enterprise at all.

With that said can you give me a brief overview on how we can tie into Enterprise using VB, rather than how we do it now? There is no way we can bring in a CR expert to do this for us, and I just am not sure where to start.

Thanks

-Colman

 

[AndrewBaines]

TBH, you just need to work through the developer documentation. There's no 'just write these 5 lines'.
Sorry
Andrew

Andrew Baines

http://www.pursuittechnology.co.uk

 

[canimrod]

Thanks, any how. Hopefully we can figure out how to make that change.

-Colman