Search results for query: *

Seems so simple if you look at it properly, thanks for your help i've managed to be able to do what i needed.

SQL Server 2005 Sorry i'm a bit of a novice when it comes to SQL but i can just about get by. what i need to do however is Insert data from an excel spreadsheet into a table that already exists in my database, basically just to add to the list i already have there. Basically it is a table...

perfect!! thats got it, thanks a lot lbass

but surely lbass if you see in the formula's above i have declared both variables as shared?

lbass, i tried exactly as you suggest and still no luck. do you have any other ideas or suggestions?

i've tried a reset in the Group header 4a of: WhilePrintingRecords; DateTimeVar mincalldate := DateTimeValue (1899, 01, 01, 00, 00, 00); however it still pulls through data from the line above instead of the current record if the current record doesn't have a value from the subreport. my...

Crystal 2008 Hi, I've got a subreport which i'm sharing datetimevar to the main report. My problem is, if there is no data in the subreport which matches the account ID in the main report the subreport is obviously blank, however my shared variable is pulling through values from the line...

gmmastros what you've suggested i've tested on about 10 rows and it seems to have worked fine, so thanks for your help and i'll give it a go on the rest of them. Cheers

Well what i've been thinking of doing is just inserting the data into a brand new table. And then updating from the updated table using an sql script. I've never used the update feature before, so how would i update ExtraInfo 1 & 30 making sure i match the accountID's from both tables?

Sql Server 2005 Hi, i've got an .xls file with about 500 lines in it and only 3 columns. What i would like to do is match this file to the table Account by the AccountID in the .xls file, and then update the ExtraInfo 1 and ExtraInfo30 with the two columns i have in my excel file. I've looked...

The problem is that i am using running totals to evaluate in the summary page in the Report Footer. So am i safe to assume that this is now impossible? Any advice for how i could change my report around so that i could have the summary page as page 1?

Crystal XI I have a report which has a summary page in the report footer with various formulas in there to show a summary of everything in the report above it. Obviously this summary comes out last the report. I was wondering if there was anyway in which i can code this section to print as...

i've tried: If Not({tblInsuredPerson.PremiumID} like "X*") then Split({tblInsuredPerson.InsuredName}, ",")[2] however i get the following error, "A subscript must be between 1 and the size of the array" any ideas?

Crystal XI Hi, i have a string like below: Single trip, Age 18-35, England What i'd like to do is split this string first two commas into its own seperate fields and then group upon them. the first one i've done with the following formula: If Not({tblInsuredPerson.PremiumID} like "X*") then...

yeah i'm sorry, didn't realise. the left outer is going from the AgentID field in the policy table to the AccountID in the spreadsheet. The null appears in the AgentID in the policy table. I don't have any selection criteria in my select that references the spreadsheet.

Crystal XI Hi, i've got a report and i'll like to link in an excel spreadsheet. i've got a field called AccountID in the spreadsheet and i wish to link that from the policy table using AgentID field to the spreasheet using a left outer join. My problem comes when i run the report, if the...

Thats perfect, thanks a lot for your help.

Crystal Server Management Studio 2005 Hi, i have a query with this line in it: MAX(CASE tblTrans.PremiumID WHEN 'PI' THEN tblTrans.Premium ELSE 0 END) AS PINetPremium i would like it now to say when it starts with PI, i know how to use the like and %, but am just not sure how to do it, any...

Crystal XI Hi i've created a report and would like to link an excel spreadsheet in, so i've linked it in from AgentID in the Policy table to AccountID in the Inter table (the excel spreadsheet) using a left outer join. Now i've create a formula which says: if isnull ({tblPolicy.AgentID}) then...

Hi I've created the following formula to calculate the last day of the month 2 months ago in date format: DateAdd("m",1,DateSerial((Year(currentdate)), (Month(currentdate)-2),1))-1 However it returns in DateTime format, how can i rejig this formula so it is only in date format?