processing

[sdkramer]

Okay I have two views 1 has a boatload of data (10 columns with 15,000 records, with a groupID and datetime, and the second has a group ID and diferent tolerance values. I've created a subreport linked them together, and created a formula field that checks to see if each of the entries exceed the High High limit and adds a ++ before and after if it does, else if it exceeds the high limit it adds a + before and after, and so on for - , and --. The problem is the report takes forever, if I remove this checking it's lightning fast. This is Crystal 6.

The tolerances don't change for each entry, so I think it'd make it much quicker if I could get the value once, and just pass it to the subreport that would be ideal, but my main report already has data in it and I dont' want to screw it up.

Thoughts? Does any of this make sense?

Thanks,

 

[IdoMillet]

Why not join the two tables on groupID?

Cheers,
- Ido

Visual CUT & DataLink Viewer:
view, e-mail, export, burst, distribute, and schedule Crystal Reports.

http://www.MilletSoftware.com

 

[sdkramer]

I tried that. The problem is the main table has about 15,000 records, and between the query, the series of if comparisons, as I preview the report it processes rows at a rate of about 2 a second. Interestingly if I leave the two tables joined it returns quickly. It seems to be getting cought up when I get to the
if(number1>highhighlimit)then("++"+totext(number1)+"++")
else if(number1>highlimit)then("+"+totext(number1)+"+")
else if(number1<lowlowlimit)then("--"+totext(number1)+"--")
else if(number1<lowlimit)then("-"+totext(number1)+"-")
else totext(number1)

 

[IdoMillet]

I'm not sure why your join is not performing well. What is the data source, connection method, and are you sure you actually create a join?

In any case, one way to speed things up is to place the subreport in the group header, not in the detail section.
Load the limits into shared variables, and use those shared variables in the detail section formula. This would reduce the subreport processing from once per each record to once per each group.

hth,
- Ido

Visual CUT & DataLink Viewer:
view, e-mail, export, burst, distribute, and schedule Crystal Reports.

http://www.MilletSoftware.com