Search results for query: *

Hello, I have a Commissions report that I'm trying to finish but there is one final percentage that I'm having trouble with. Groups in the report: Group#1: Region Group#2: EmployeeName Group#3: SiteName All employees only work in one region, but there are times when one employee works at...

pmax9999, thank you again. That did the trick. I didn't enclose the formula you gave me in parenthesis so the order of operations must have been off. As soon as I added the parenthesis everything started working as I expected. Thanks so much! I really appreciate it.

Thanks AndyMc and pmaxx9999! pmaxx9999 - I used your solution and it seems to be working as far as selecting the appropriate terminals, but for some reason when I select "ALL" or "Wash" from the drop down list in the parameter, it displays ALL of the sites (this report is being group by sites)...

Hello, I'm not all that experienced with Crystal formulas, and have a parameter issue I can't figure out. I have the report working perfectly, and this parameter is the last step. I have a field in the report called "Terminal" that has almost a hundred different values, but here are examples...

Hello, I'm not even sure if this is possible, but I have two seperate reports right now that I need to make one. I don't work with subreports much but when I do, I normally put them in the main report footer, so that the subreport will just appear at the end of the main report. The reports...

Thanks for your help! I had to take a different route in the query but if this comes up again I'll know :)

I'm not sure how (or if it's possible) to concatenate the data in the way that I need it. Here's a sample of my data: Service1 Serivce 2 Service 3 Code Date NULL TS NULL 05S6 2011-01-09 00:00:00 FS NULL NULL 05S6 2011-01-09 00:00:00...

Oh sorry! the query wasn't working at first but got it now. Works perfectly...thank you so much!

Maybe I'm missing something but how would converting my field help in selecting all numbers to the right of the leading zeros?

I have a table that I need to select the correct location numbers from but I can't seem to select the right numbers that I need. The location number is always the last number after all of the zeros to the right of it. For example, if in my table it reads "0000000004" then the location number...

I need to rename it because I'm creating a dstx package with it and I need a set file name to map the columns in that file. jebenson - that worked perfectly. I used a variation because the job will run before the current days file is in the folder, so I had to use -1 on the date, but other...

Andy- that's exactly what I need to do. I need the same set file name because I will be deleting every file as soon as its processed. There will be no duplicate names in the folder. Jebenson- I can't have a date in the name. I just want the file name to be renamed to "Emailunsubs.txt" every...

Hello, I have the follwing code that I'm using to renam a text file, which works fine: My.Computer.FileSystem.RenameFile("d:\FTP\Void\Unsubs\Test\CW_EmailUnsubs022912.txt", "EmailUnsubs.txt") My problem is that the file that I need to rename ("CW_EmailUnsubs022912.txt") always has the date...

SQLBill you are a life saver!! I had no idea how I was going to get this if this didn't work. Adding the "GO" between the )) and the INSERT statement did it. Thank you sooo much everyone! I really appreciate all of your help.

I deleted everything after the last two close parenthesis and re-typing it but stll no luck. If I comment out the insert statement everything works normall. The query pulls all the data I need perfectly. But as soon as I add that statement back in it always gives me the same error: Msg 156...

Can you explain the date style I should use? I'm not familiar with them so I'm not sure what you mean. But yes, the select statement alone without any insert statements works just fine. That's why I'm so confused as to why adding a simple insert statement would mess up the query.

No luck :( Here is the message I get: Msg 102, Level 15, State 1, Line 67 Incorrect syntax near ')'. I already have the table created that this data needs to go into, so I took out the #SWTable and just put the following code right after SET @SQL = ' Insert Into...

I thought about the quotes too, but I don't think that's the problem. I tried taking out one of those quotes but I still get the same error. Also, the query works perfectly if I take out the Insert into statment and the "Select* INTO #SWTable From " So I don't think quotes are the problem. I...

Yeah I tried that and that's not it. Thanks for the idea though.

Sure, sql tried to execute the query for a few seconds then gives me the following error: Msg 156, Level 15, State 1, Line 70 Incorrect syntax near the keyword 'Insert'.