Recent content by coco86

Well, the message box should be showing the SQL not the result...that's what you've told it to do. If you want to see the result move the line down to after you open the recordset and change it to msgbox rst![Acro] Since you're only looking for a single record, though, I'd use dlookup rather...

Ok thanks it's showing up correctly in the results pane now. I guess I have two different problems going on here because it still gets truncated when I pass it to the Persits Mailsender object (ASPemail) I guess there IS a limit for method calls. Thanks for your help though. -Coco [auto]

Add a footer for your unique ID and then in the properties for the footer section set "force new page" to "after section" -Coco [auto]

I have a stored procedure that contains a variable that is supposed to be varchar(1000). However, it insists on truncating the data I put into it at 255 chars...no error message, it just chops the end of the string off. Is this a limitation of SQl Server and if it is is there any way to get...

Well, I don't know if this will work or not but try SELECT *, IIf([FieldName],"Yes","No") as DisplayName FROM DynamisPoints ORDER BY Job ASC -Coco [auto]

You can have a query inside an MDB file but I don't know how coldfusion works so I don't know how to specify to use a query instead of a table. Do you include a table name inside your connection string? If so, you can probably use the query name instead. -Coco [auto]

If you want to use the default printer, why don't you just set the report to use the default printer (file=>page setup=>page)and not worry about setting it in code? As for your problem Is Ne01 the printer you want to use? NO: is the report set to use that printer? Can you remove the printer...

IIf(DepartDiff > 330,"Late",IIf(DepartDiff < -30, "Early", "On-Time")) -Coco [auto]

Try select temp1.partnum, count(temp1.PONum) as PoNumbCount from [select distinct partnum, ponum from tablename] as temp1 group by temp1.partnum Or, use two queries Query1 select distinct partnum, ponum from tablename Query2 select partnum, count(PONum) as PoNumbCount from query1 group by...

sxschech brought up a good point. If you use a query as the datasource for your page, you can have it return yes/no instead of -1/0 (using the technique he described) and you won't have to do any special formatting on your page. "DisplayName" (or whatever you change it to) would be the new...

Sorry, didn't notice you were using coldfusion...thought this was an access report. Still, the coding will probably be different (I don't use Coldfusion) but the approach would probably work. I've used similar techniques in ASP. -Coco [auto]

Try putting a textbox control on the form and setting the control source to: =IIf([FieldName],"Yes","No") -Coco [auto]

OK, I tried that too, still isn't working -Coco [auto]

Thank you for your response but I've already made sure "Keep group together" is not checked for all the groups. That's why this is so confusing. I'm not using sub reports. Any other suggestions? -Coco [auto]

I hope someone can help me here. I've developed a report as part of a VB.net application. (This is the first time I've used crystal reports and I'm learning as I go.) I've got "keep together" set to false for all sections on the report but it seems to be keeping the sections together anyway...