Recent content by shenay921

Thanks for the response! I will study on that idea that the parameters are either a single value or an array of values. I had already tried the indexing and even adjusted the query to pull fewer records but the performance was still poor when selecting all.

Hi There, I am working in SSRS 2008. I have a parameter to pull 'All' of a set of records or it will pull one. What it won't do is allow someone to select two or more. It is either one or All. I found the standard 'Select All' was killing my report -- like 5 minutes. This 'All' workaround runs...

I tried running the SP alone -- took about 5-6 seconds and in the report. Takes about 15 minutes.

Ok, I ran the index and it took the same amount of time. Thanks for your help!

First, if I just run the query without any additional indexing it only takes 6 seconds. Something in the report is killing it.

Index name: PK_FDC_Descriptions Index description: clustered, unique, primary key located on PRIMARY INdex Keys: type, code

Sure! CREATE PROCEDURE CUST_LLA_TRIP_VITALS AS SELECT tdate, job, vdate, vtime, pulse, resprate, bps, bpd, palpitation,spo2,etco2,painscale, who_text as crewname, temperature, comments, PTA, RespReg.descr as respreg, Pulsereg.descr as pulsereg, PulseStrength.descr as pulsestrength...

Well, I changed the code and the procedure ran but it is still taking 15 minutes to pull the data into the report. This maybe a crystal issue as it is running as a subreport. Thanks for your ideas.

I am converting the code right now but am confused by the line: (SELECT descr FROM FDC_Descriptions WHERE type = 6021 and code = V_CUST_LLA_Trip_Vitals.ecgectopics) as ecgectopics, glucose The additional glucose is throwing me off. Am I to insert: ecgectopics.descr as ecgectopics, glucose...

Hi Markros, Thanks for the ideas! Why would explicity specifying the columns speed up the processing? I think I can do it but was wondering what that mattered as opposed to using the * symbol. Thanks! Laura

Hi All, I have a stored procedure and am having to use it in a Crystal 7.0 report on Windows XP. The report doesn't like the way the procedure pulls so I had to alter the stored procedure: I took the table that it was pulling from "Trip_Vitals" and created a view "V_CUST_LLA_Trip_Vitals" that...

Hi There, I read that in Crystal 10 you can create a new line in a string series using chr(10) or chr(13). Is there anything that works for Crystal 7.0? Example: 'Cancellation Reasons Count' + chr(10) + 'Cancelled by FD PTA: ' & {#CancelbyFDPTA}

Thanks for the help Ian. --Ok, I tried putting the @part1 into the details along with the global variable -- it did not like any array number except 1: -- Whileprintingrecords; stringvar array map := split({CorrectLargeIndex_.Ext# Map Page},";"); if ubound(map) >= 1 then map[1]; global...

Hi There, Using Crystal XI, Windows XP I've been reading through the posts and have had some luck with (@reset,@accum,@display). I have for fields: StreetName, PrimKey, BigPage, SmallPage The data example: Group: 1st Street Details: 1st Street; 21976; 3104; 2073; 1st Street; 21972; 3104...

Nice job! That worked! Thank you!