Recent content by LMGroup

I just created several more formulas to cover the extra sort fields and added them into the record sort expert since I couldn't come up with a formula that would work with all of them together. Thanks for you time!!

All 4 fields are numeric. When I add anything besides + between the fields in the first condition, it wants a string for the second condition. If I use ToText on the second, the sort order changes.

I've changed the group to use the formula but it still isn't working for type 1. This is what it currently says: if {?ReportType} = 1 then {SalesmanN}//+{CustomerN}+{InvoiceN}+{JobN} else {CustomerN} I removed the other sort fields from the Record Sort Expert so it only has Group...

I'm using CR2008 with a SQL DB and need to create a conditional sort. The report has 2 RH, 2 PH, 1 group and 1 detail section. If the user selects the detailed sales report, the first RH, PH and detail lines are displayed and I need to sort by salesperson, customer, invoice. There is no...

I'm using CR2008 v12.3.0.601 with SQL Server 2008. I need to pull a date value from a system parameter table. I need to use the date to filter the required data but there is no link between the parameter table and the production data. The parameter table has 2 fields: Cell (the one I need is...

I figured it out :)

I'm using SQL Server 2005. I got a lot of help on here a while ago getting this set up and it works perfectly except when someone enters one of the codes after one has already been used. They aren't supposed to, but it happens. I need to prevent this because it is doubling (or tripling) the...

Thanks. That's very helpful :)

Temporary tables could work. I'll give that a try. Thanks!

I'm using SQL Server 2005 and trying to create a view from a single table that will select a myriad of different records based on other records it finds. I have to manipulate the dates to calculate time intervals. I have to find the time between the filedate and enddate and also the time...

It makes perfect sense :) I hate messy code but hate messed up data even more. I thought the variables would make things easier to deal with. Oh well. The data itself is much more important and I'll be the only one looking at the code. I started working with triggers about 2 months ago...

I figured out what the required formulae are. Now it doesn't like the code again. I hate those "could not be bound" errors. I know they're coming from the way I set the variables. Do I have to embed everything into the SELECT statement? (I modified the code to turn it into a query and look...

Fantastic! Thanks :)

Thanks for replying so quickly. I thought it was looking a little complicated. Will this insert multiple records into JobMaterial is there are multiple records for the job in PrintItems? I guess I better check it out.

I'm using SQL Server 2005, trying to create a conditional trigger that will fire when one of 2 status codes are entered. Once they are entered, I need it to get all the records from the PrintItems table that have the same job number and also have an MCC code and generate records in a 3rd table...