Search results for query: *

This worked out very nicely. Thanks a million! -Ic

Whoops! Sorry. Here's the error from query analyser Server: Msg 164, Level 15, State 1, Procedure sp_assigned_summary, Line 30 GROUP BY expressions must refer to column names that appear in the select list. Thanks, Ic

Hi, I'm trying to create a sproc that is using parameters for dynamic field names. The following sql statement is causing problems with using the sproc parameters in the GROUP BY clause. Is there a way around this apart from writing an IF statement for each field iteration. SELECT...

Here's the RDC vba code I have so far. I'm trying to run this in VBscript on a server to churn out 500+ reports for 100 clients. I have yet to include the various loops through the recordsets to pass the parameters. Public Sub ExportPDF() Dim crxApplication As New CRAXDRT.Application Dim Report...

Hi, I have a general question regarding the crystal RDC and VBScript. Currently I'm using the Crystal API to automate the running of over 500 reports which are exported to a file server as pdf. I'm using a VBA app on a workstation but now its time to migrate to the RDC and run these suckers...

Thanks Veep! Works good. I just had to also post the value of the x variable too in order for the target page to reference the correct form name.

I'm trying to do something very similar except I'm looping through a recordset and creating multiple hyperlinks. My problem is when I post to my target page the request variable is receiving the value of every hidden text box (hyperlink) instead of just the one that was clicked. <%if(!RST.eof...

Thanks. This is the select statement I was trying to come up with. More efficent than evaluating four IF statements. -Ic

found a solution. I'm slowly getting the hang of the way crystal parses expressions. if ({vw_compfieldmap.groupchoice}=&quot;dpt&quot;) then formula = ToText({vw_compfieldmap.dpt}) End if if ({vw_compfieldmap.groupchoice}=&quot;jobcode&quot;) then formula = ToText({vw_compfieldmap.jobcode})...

Was trying to use Basic but I don't have a preference. Easier is better in my book.

I'm a VB programmer just starting to get to grips with crystal formulas. I created a formula field @myField and I need to assign it's value based on another fields value. I tried a simple select case but I keep getting the error &quot;Statement expected here&quot; Select Case...

the 64000 row limit in Excel is not unconditional. It's based on width of the row. I'm not sure of the exact criteria that make up this limt but I'm sure it has a byte limit somewhere.

This seems like a basic question but unfortunately it's not obvious. I want to display the sender's email address in my inbox without opening the email. I'm not interested in the sender's display name because it's easy to spoof. I have checked the &quot;field Chooser&quot; with no luck. Thanks...

Hi, I'm trying extract the email address from a message without using CDO (this is a client side macro that strips the message down and inserts it's key elements into a db table). The closest thing I've fouund is Outlook.mailItem.SenderName which only returns the name and not the address within...

Nice one! Thank you.

I'm trying to convert a string in the format &quot;2002-03-04 00:00:00.00&quot; to a Date format. I have tried CDate(val(Mid({Query.Edate},6,2)), val(Mid({Query.Edate},9,2)), val(left({Query.Edate},4))) but get the error &quot;A month number must be between 1 and 12&quot; Thanks in advance.