Search results for query: *

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...

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...

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...

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...

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...

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...

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?

Crystal XI Hi, i'm using the formula below to work out the surname of a string: {@Surname} stringvar array x := split({tblPolicy.PolicyHolder}," "); x[ubound(x)] However whilst it is running i get the following error: "A subscript must be between 1 and the size of the array" and it...

Crystal XI Hi, i've created a bar graph in my report and the x axis is date by month, however it displays it as 01/2008 for say Jan 2008. How can i get it to show the full desciption?(i.e. Jan 2008, or January 2008) Would it require a formula in my report to force it to show full description...

Crystal XI Hi i've got a subreport sitting in details-a section of my main report. In details-b i have my shared numbervar bring through the value UWOutstanding. However when my report runs the value of UWOustanding keeps on repeating itself for the previous instance of the subreport. Is...

Crystal XI Hi, in my main report i've got a list of transactions, in my sub report i've got a list status's associated with them transactions and the subreport is linked to the main report by AccountID. What i'm trying to do is make sure that the parameter ran in the main report runs for the...

Crystal XI i have a formula field in the details section like below; if {tblPolicySplit.IntermediaryID} = "UWNET" and {tblPolicySplit.AccountID} <> Maximum ({@Account ID}, {tblPolicySplit.PolicyID}) then {tblPolicySplit.AccountID} It should only bring through one result in the details section...

Crystal XI Hi, i've got a report and what i would like to do is that when the report is run and the parameters appear, i would like to be able to pick a scheme group and then within that scheme group only the schemes for that scheme group appear and preferabley i would prefer this to be...

Crystal Xi Hi. I've got a list of dates that are stored as strings and would like to convert them all to a date. I was thinking about using: cdate({@Policy Docs Sent}) However, when i flick through my report i get this error: Bad date, format string What does this mean? Is this because...

SQL Server Management Studio 2005 Hi, i hope i'm posting on the correct forum. I'm trying to create a view using an SQL query on our SQL server. What i need to do is create a view showing ClaimID linked to Key Value, however Claim ID is a number and Key Value is a number stored as text. So...

Excel 2007 Hi I have a list of names that i've been given and i want to compare it to a list of names in our database. I've exported all of the names in our database out into Excel. The names from the database are in full strings, so not split into first, middle or last names ie: Mr John...

Crystal Reports 2008 Hi I've received an Excel spreadsheet of names (first and last names in different cells) and i have to compare this spreadsheet to the current list of clients on our database where there is a match. The best hope is by last name, i know this isn't a direct match cause...

Crystal 2008 Hi, i've got a field called group ID which sits at details level. I have a group above that called Name. What i'd like to do is create a field in that group with each unique number of group id in a string or array. ie: Gp Smith 1111, 2222, 3333 D Smith 1111 D Smith...