Search results for query: *

Hi, using both SQL Srvr 2K DBs & OS and SQL 2005 DBs/OS. Using t-sql, I need to extract the end of a string where the part I need is of a variable length: I cannot obviously use RIGHT(<string>,<int>), as this needs to return a specific number of characters it's nae use. I've fallen off my...

Hi, using cr8 and sql2k db. Can't seem to get this right: - I have two groups 1. SecId, 2. Deal Type Deal Type has two values B or S I need to return the minimum price amount for B in group footer for SecId but unsurprisingly it's not working! I have the following formulas: - GH2...

Hi, had difficulty working this out, wonder if anyone can help... I'm using cr8 to a sql w2k database. I would like to hard code the date range so that the previous 18 months of data automatically renders based on a particular data field. For instance, I refresh the report on any day in July...

Hi, I have a SQL2K dts package that deletes and creates an excel file but the server (2003) does not have the excel app (no intention to add it either). This means the file cannot be created. Is there a method by which I can overwrite the existing file without having to open excel. I have...

Hi, Using cr8 & a sql 2k db. I'm trying to create an array to use in a graph but keep getting the error "the result of a formula cannot be an array". Here's some code: - //@arraytitle whileprintingrecords; StringVar Array ArrayTitle; ArrayTitle:=...

Hi all I'm using CR8 against a SQL2K db. My prob is that a summed variable I have in the group footer is not behaving the same way in the header. I need to be able to suppress the group header and footer based on a number formula using a particular summed variable. Here are some details: -...

Aaaaah!!!! I have spent ages trawling this forum but couldn't resist any longer. I am using cr8, sql server odbc link. I have been trying to share a number variable FROM the main report to the subreport. The reports are not linked. Main report: - In group header (only one group)...

Hi, getting confused about variables and searching the forum hasn't helped. Working on CR8 to a SQL server. I have a shared number variable where either 1 or 0 appears against an account code in the main report. I want to sum these to produce a total in the report footer. Here is some...

Festive Greetings! A wee bit help please! Using CR8 / ODBC / SQL Shared variable is staggered to the next unassociated record but I cannot remember how to fix this... Example Code Company Name CompanyA CoA CompanyB CoB CompanyC CoC CompanyD CoC CompanyE CoC...

Help! Working in CR8 to a SQL database thru' ODBC. I need to create a report of exchange rates where I have divided a foreign rate by the gbp rate applicable on the same day, e.g. (USD) 1.00000 / 0.52308 (GBP) = 1.91175. All of the rates are in the same table so I have tried to split it up by...

Hi, Using CR8 thru' ODBC to a SQL server. I have a table that contains cash balances for various funds. The layout is: - FundCode BalDate BalAmt ABC 31/01 10000 ABC 28/02 10000 ABC 30/04 25000 In my report I want to show the balances on one line, thus: - FundCode 31/01...

Hi, Using CR8 connected thru' ODBC to a SQL server. I have two tables, ACCOUNT and RECON. The ACCOUNT table is a list of accounts held. The RECON table is a history of reconciliations performed. For any given rec date in the RECON table there will not necessarily be a record for all the...

Hi, I'm using CR8 connecting to a SQL Server thru' ODBC. The object of the report is to reconcile fund holdings between ourselves (US) and our custodian (CUST). The data is grouped by 1. account type (CUST and US) 2. effective date (constant) 3. security id (variable) All the fund totals...

Hi, I'm using CR8 with a Lotus Domino server. I have this string field that lloks like this: - CN=Joe Bloggs/OU=Investment/O=Company/C=GB Does anyone know how I could extract the name "Joe Bloggs" from this field? Ta Trev

Help! From a transaction file I need to determine if stock has been sold within 2 months of being bought. Here is some simple data: - assetcode tradedate tradetype ASSET01 20040130 BUY ASSET02 20040130 BUY ASSET01 20040215 SELL ASSET03 20040130 BUY ASSET04...

Hi, How would the formula look if I wanted to suppress a section based on there being at least one distinct value in a set of values under each group? e.g. For GroupName {Account.Name} I have three accounts; ABCD, BCDE and CDEF. Each has transactions where a particular field has either a...

Hi I've no idea how to start this, so I would appreciate a kickstart from someone. I need to estimate when a dividend tax reclamation is going to be paid based on the allowable timeframe from date of submission to a foreign tax authority, e.g. the SLA for Germany is 17 months and if the...

Hi! Does anyone know if it is possible to link two sub reports being fed into a main report? T

I currently have three parameters that require the user to select a Pool Side, Custodian and a Currency (or more than one value of each). What I would like to do is: - 1. to give them the ability to select one or a combination of them without the non-selected parameters affecting the result...

Hi, I am trying to return the from and to dates in a message string when there are no records returned after the user enters the dates to parameter named ?date. The formula is currently: - if(isnull(GroupName ({AccountPool.Name}))) then "NO DELETIONS FOR PERIOD FROM " +...