Search results for query: *

Thank you both for equally able solutions, though Esquared's has worked better in SQL2005. One slight typo in it: select statement should read: - SELECT Right(Fld1, CharIndex(' ', Reverse(Fld1) + ' ') -1) Thanks again

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

Thanks for your input both of you, I plumped for the running totals on the correct group and it worked fine! Thanks again, Trevor

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

lbass, Perfect! Is there any documentation you know of that actually explains generically what each part of the formula is doing, as the cr help is vague, so I can understand it! Thanks T

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 Leigh Thanks for your reply. Installing Excel on the server is a non-starter and the requirement is for an xls file. However, I have discovered a way to get round this by using the FileSystemObject and overwriting the target file with a template file that only contains headers and I am...

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 dgillz, The last two lines of code are not part of the formula, they are showing the type of string value that is to go into the array; //@title03 is the first value in the array - {@Title03} Apologies for not being clearer. T

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

Thanks lbass, worked a treat, must stop using variables and go back to basics! Thanks again T

Hi lbass, Yes, I know the result is the month number. After the totals are available, I wanted to suppress deals from the header and footer with a formula such as: - if Remainder({@DealMthSum3}, month(minimum({?DateRange})) ) = 0 Then True Else False The reason for this is that a buy and...

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

Hi lbass, I wondered if you might be able to comment on my hypothesis that the report is falling over when there are too many arrays being passed to the subreport. For instance, I have 1800 records and this should produce two arrays, the forst for 1 to 1000 and the second for 1001 to 1800...

Hi lbass, The error message appears against the subreport formula and when I click OK the cursor is at the start of the formula window at "whileprintingrecords". Not sure that this is helpful. T

Hi lbass, I've put the following syntax into the reports: - Main report variables - whileprintingrecords; Shared StringVar array f; Shared StringVar array f1; Shared StringVar array f2; Shared StringVar array f3; Shared StringVar array f4; Shared StringVar array f5; Shared StringVar array...

Maybe you could set up a formula using an array of possible dates and then check actual dates against this in order to display the missing date(s) per PoolId." lbass, how would I do this? Thanks T

Thanks lbass, I'll have a look at those suggestions. The array works well, as you say only up to the 1000th record. Is there any way I could start an array from the 1001st record and so on? T

Thanks lbass, I tried this but the count of no recs may include days over the period that should not be included e.g. holidays and weekends where there was no activity. To try to resolve this is tricky, I know. I also need to show the detail of the poolids that have no rec; there must be a...

Apologies for the vagueness in my earlier post. "Rec" means reconciliation (rec); I am reporting on account reconciliations. The rec table is in the main report and indeed has many dates and within each date a poolid (account) can have more than one successful rec as well as recs on each of...