Recent content by cheyney

ro, Thanks for your response. Unfortunately this doesn't work - making the formula field's keep together property true does keep the *formula* together, but it does nothing to keep the *section* together. As said before, the detail section itself is set to keep together. I've read another...

Hello, I am using CR v10. I have a formula field that conditionally concatenates database values together with carriage returns. The resulting string will be between 1 and 3 lines. (If it is important, the records that I am concatenating together are not from different database rows, but all...

Bang on with both counts, lbass. Thanks so much, Cheyney

ooh la la, sounds promising. I'll try it as soon as I get a chance. Another slight twist on this, the "Sum Price" sort has to be DESC and the "Title sort has to be ASC, but I should just be able to just change the then expression in the if statement to -1 * {table.price} and emulate a DESC...

synapsevampire, Thanks for your response as well. What I think was misunderstood is that I don't want to sort the records within a group by the title or price, I want to sort the group entries by either the title (the grouped field) or the SUM(price). So assume the following data: A...

Madawc, Thanks for your response. Your first paragraph was what I assumed, and its what I was going for with the algorithm to convert a string to a sortable number. I didn't quite understand what you meant by your second paragraph, but it game me an idea. First I tried creating a group for...

Hey, I'm using Crystal Reports 8.5. I've been on this problem a while. I need the ability to dynamically change the sort order of a group based on a input parameter. The group has to sort either by sum(price) or alphabetically by its title. Its automatic that it sorts by its title, no...

I would create this as a scheduled job in SQL. You can set this to execute on a schedule. You can also set the SQL Server agent (which runs the jobs) to start on system start, so the job will always run. You can also set it up to notify you on sucess/failure events As for the locking, here...

I have read that Transactional replication probably isn't what I want to use. For one, both the servers are peers, with (foreseeably) the same amount of inserts/updates/deletes. Secondly, they may not have a consistently available communication link between them. Does this sound like a fair...

Here’s my dilemma: I have a system in which users have a balance. A user’s balance is basically the sum of their credits and debits, inputted as transactions. In order to avoid a sum calculation every time a user’s balance is requested (there may be MANY transactions), the balance is just a...

This link might be useful to you in trying to iterate through a delimited string in a stored procedure http://www.sqlteam.com/item.asp?ItemID=637 Cheyney

SELECT Avg(DateDiff(d, start_date, end_date)) as AverageDurationDays FROM claims

quoted from http://www.databasejournal.com/features/mssql/print.php/1565961 5. Don't use the prefix "sp_" in the stored procedure name if you need to create a stored procedure to run in a database other than the master database. The prefix "sp_" is used in the system stored procedures names...

Assuming your table name is Table1 and your 6 digit char column is DateNum: select cast( case when cast(substring(datenum, 5, 2) as int) < 5 then '20' else '19' end + substring(datenum, 5, 2) + '-' + substring(datenum, 1, 2) + '-' + substring(datenum, 3, 2) as datetime) from table1...

This appears to be an ADO question, not a direct SQL Server question. You'll have more luck asking in the VB forum. Cheyney