Search results for query: *

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

...as etco2compensation, V_CUST_LLA_Trip_Vitals.status from V_CUST_LLA_Trip_Vitals where status=1 GO Code for the View: CREATE VIEW dbo.V_CUST_LLA_Trip_Vitals AS SELECT * FROM dbo.Trip_Vitals where Trip_Vitals.tdate > '2007-01-01' Thanks for the help! Laura

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!

Hi There, I need to take a datetime and add 7 hours to it to give me a new datetime in Crystal 7.0. Such as datetime 8/26/2008 20:00:00 and convert to 7 hours ahead: 8/27/2008 03:00:00. I know versions 8.0 and higher have the DateAdd ability -- what can be done in 7.0? I haven't been able to...

Also, the atddate, avldate, avltime and atdtime -- these are all strings with a format of 2006-11-03 and 12:14:13.

...AVL := DateTime(Date({Trips.avldate}), Time({Trips.avltime})); dateTimeVar ATD := DateTime(Date({Trips.atddate}), Time({Trips.atdtime})); (AVL-ATD)*86400; Of course, it runs in crystal but it is erroring out in RescueNet with "Not enough arguments". Could someone tell me if the above...

Thanks for your response. I tried to load the code but it does not like the AS A INNER JOIN.

Hi there, I'm fairly new to Access 2003 and am used to Crystal. I have a table of billed accounts (Acct, DateFrom, DateThru, Rebill, DropDate) -- there are other fields but these are the main ones. The options for Rebill are null and R2. Null means a first-time billing. This table covers...