slxdeveloper.com Community Forums

The Forums on slxdeveloper.com are now retired. The forum archive will remain available for the time being. Thank you for your participation on slxdeveloper.com!

Reporting & Notification Forums - Reporting
Forum to discuss reports for SalesLogix including Crystal, SQL Reports, etc. View the code of conduct for posting guidelines.

Forums RSS Feed

Back to Forum List | Back to Reporting | New Thread

View: Search:

Author

Thread: How Can I Instantiate Crystal Reports Object in SLX

Ron Hendel
Posts: 1

How Can I Instantiate Crystal Reports Object in SLX Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 05 Feb 08 8:45 AM

I have created a form that manuvers data from five disparate recordsets into a finished recordset as a datasource for a Crystal Report. I need to get the data to the Crystal Report now. Any Ideas?

[Reply][Quote]

John Gundrum
Posts: 632

Re: How Can I Instantiate Crystal Reports Object in SLX Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 05 Feb 08 12:21 PM

When you say disparate recordsets, do you mean the data is coming from up to five different databases or is all the data coming from the SalesLogix database?

Is the finished recordset being created by a view?

I usually find the best way to create a recordset for a Crystal Report is by creating a SQL view. Trying to do this in Crystal via linking tables and creating various filters is very cumbersome and tends to waste a lot of time. Using a SQL view allows you to create the recordset exactly how you need it for Crystal. A SQL view also is more versatile later when you might want to add a field or another table. You should have to only worry about presenting the data in Crystal.

John G.

[Reply][Quote]

Ryan Farley
Posts: 2265

Re: How Can I Instantiate Crystal Reports Object in SLX Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 08 Feb 08 9:50 PM

Sorry for chiming in late on this one. It is no different to instanciate an RDC object in a SLX VBScript than how you would do it anywhere else. I have some RDC help files here: http://www.slxdeveloper.com/page.aspx?action=viewarticle&articleid=29

Even the report view can be added to the toolbox in the Architect and dropped on a SLX form (this is how the built in report manager screens in v7 is constructed)

-Ryan

[Reply][Quote]

Snow Monkey
Posts: 214

Re: How Can I Instantiate Crystal Reports Object in SLX Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 11 Mar 08 4:52 PM

Do the following from slx and you can call anything with a report you have created. Make sure that the varibles are crystal parameters.Firther , you can always edit the record selectionformula from slx if you wanna go that way

Also when you buy CR separate from slx , they give you the dev guide which has excellent examples ofhow to call and manipulate crystal.

Also this code from my shop can help you

Dim objReport, objReportMV

Set objReport = Application.BasicFunctions.GetCrystalReport("Plugin Family:Report Name")
With objReport
.DiscardSavedData
.EnableParameterPrompting = False

On Error Resume Next
.ParameterFields.Item(1).ClearCurrentValueandRange
.ParameterFields.Item(2).ClearCurrentValueandRange
.ParameterFields.Item(3).ClearCurrentValueandRange
.ParameterFields.Item(4).ClearCurrentValueandRange
'loop Thru the various contact Ids for this org selected and pass them to the parameter value in
Dim objRS
Dim strsql
Dim objSLX
strsql = "sql statrement"

Set objRS = objSLXDB.GetNewRecordSet
objRS.Locktype = adLockBatchOptimistic
objRS.Open strSQL, objSLXDB.Connection
If objRS.RecordCount > 0 Then
objRS.MoveFirst
Do While Not (objRS.EOF or objRS.BOF)
If (hasData(objRS.Fields(0).Value)) Then
.ParameterFields.Item(1).AddCurrentValue objRS.Fields(0).Value
objRS.moveNext
Else
objRS.moveNext
End if
Loop
End If

.ParameterFields.Item(2).AddCurrentValue (Cint(txtFrom.Text))
.ParameterFields.Item(3).AddCurrentValue (CInt(txtTo.Text))
.ParameterFields.Item(4).AddCurrentValue (lueOrganization.LookupID)

End With

Set objReportMV = Application.MainViews.Add("Personal:Crystal Reports Viewer", 0, False) ' create this plugin with the crviewer OCX
objReportMV.Caption = "BBBBB"
objReportMV.Maximize
objReportMV.Show
Application.BasicFunctions.ProcessWindowMessages
objReportMV.DetailsView.Script.ShowView objReport

[Reply][Quote]

Khevna Mehta
Posts: 34

Re: How Can I Instantiate Crystal Reports Object in SLX Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 19 Mar 08 5:11 PM

How to create this plugin with the crviewer OCX

[Reply][Quote]

Snow Monkey
Posts: 214

Re: How Can I Instantiate Crystal Reports Object in SLX Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 20 Mar 08 1:59 PM

C:\Program Files\Common Files\Crystal Decisions\2.0\crystalreportviewers\ActiveXViewer\crviewer9.dll

Then add this activex to the controls and this should have a viewer component defined in it. SLX std toolbar should not have this by default.

The only problem i see is that i cannot get the progress bar to show any progress no matter what i do.Let me know if you get it to work.

[Reply][Quote]

Khevna Mehta
Posts: 34

Re: How Can I Instantiate Crystal Reports Object in SLX Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 20 Mar 08 3:51 PM

What table will be the main view associated to? My solution is working but it seems to be freezing for 3-4 minutes before developing the pdf file, so I am trying to follow your code. I am also working at creating the progress bar.

'

[Reply][Quote]

Snow Monkey
Posts: 214

Re: How Can I Instantiate Crystal Reports Object in SLX Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 20 Mar 08 4:36 PM

you are using slx(a vb script engine based product) which is calling a crystal object to out put to a pdf file which obviously has to pass thru another one to get it to the pdf format. What do you think? it is going to be slow no matter what....

as far as the view goes, it can be anything as it is invoked from the code. I tried it recently with an account view and it worked.

My Report are slow and cr 8.5 sucks! waiting to get on cr 11 with slx72.

and...about the pgbar, i tried it with different settings and even the events dont act the way we want to...Searched google and nobody was able to get it to work. i tried to put a "processing...." window with no title but cr wont even pass the control back to the form to make my processing screen go away

))

[Reply][Quote]

Khevna Mehta
Posts: 34

Re: How Can I Instantiate Crystal Reports Object in SLX Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 24 Mar 08 2:07 PM

This works only if the user has Crystal installed on their machine?

[Reply][Quote]

Ryan Farley
Posts: 2265

Re: How Can I Instantiate Crystal Reports Object in SLX Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 24 Mar 08 7:54 PM

Quote:

Originally posted by Khevna Mehta

This works only if the user has Crystal installed on their machine?

Only Crystal runtimes are needed - which are installed by SLX already.

[Reply][Quote]

Page 1 of 1

You can subscribe to receive a daily forum digest in your user profile. View the site code of conduct for posting guidelines.

Forum RSS Feed - Subscribe to the forum RSS feed to keep on top of the latest forum activity!

slxdeveloper.com is brought to you courtesy of Ryan Farley & Customer FX Corporation. This site, and all contents herein, are Copyright © 2024 Customer FX Corporation. The information and opinions expressed here are not endorsed by Sage Software.	code of conduct \|

page cache (param): 11/25/2024 10:53:11 AM