Search results for query: *

Thanks Any idea what is the code to have a timer in the code below please - any link, was not successful in googling. Right now using a Msgbox to make execution wait to receive response from the called url because it takes about 10 seconds to receive response. If I don't use the Msgbox, it...

The below code is part of an ASP file. The objective is to pass some data to the unix shell script in a Apache server and after all processing it returns the message - success or failed. 'Send the Transmit values through a popup window to Apache server <script type="text/javascript"> url =...

Hi, When trying to open connection 'Conn.Open strConn' in the code below, getting the following message: Any cluee/link please. I am trying different things like reinstalling teradata odbc driver but not successful. [Teradata][ODBC Teradata Driver] invalid Attribute But this connection works...

bkclaw113, thank you very much. appreciate your help. saj

Hi all, There is the following query in Oracle fetching 11 rows. In Teradata this sql gives error with the message ' SELECT Failed: 3706: Syntax error: expected something between '+' and ')'. How this query could be translated into Teradata syntax please. In Oracle (+)= is used for kind of...

Hi All, Have a Crystal Report developed in 9.0. Need to schedule this report - 1. the report has to burst for each Group 1 (GH1) ID and appended to Excel file in the same sheet1/tab but not in different tabs. like below. There are about 6 IDs. - the report need to be picked from location...

Hi All, Appreciate all your replies. My mistake! There were like 50 columns in table and I Wrongly interpreted the sort column that Business mentioned fundCode. When I chose the correct column name for sorting all is Okay. Thanks all for the help. Pls don't curse me.. saj

Hi All, Using Crystal Reports 9. Modifying an existing report developed by someone earlier. Need to sort records. In 'Record Sort Expert', I see on the right side, already the 4 Groups that is on the report. The 3 other fields I added from left side and got added below these Groups. But when I...

Hi I am trying to get date excluding holidays and weekends. Holiday stored in variable listOfMonthAndDays. I have set system date December 02 , purposely given Nov 29 and 30 as holiday in the listOfMonthAndDays varibale. UText15 = "Monthly" set monthly. So it needs to give the final result...

Thanks Madawc, The link shows calculating number of business days between 2 dates. I need to loop the holidays in the holiday table. Is there a ways I can do it crystal.

Hi, There is a 'Holiday' table in SQL Server with holiday list for 2010. In CR9 report, have to show AsOfDate as a previous business day which will be excluding holidays from this table and weekends. This AsOfDate is placed in GH1 in report. Should I create a subreport only with this...

@ActName is the group formula and placed in the GF1a. The subreport is also placed in the same GF1a. For each mid( {Account.Name},3,10 ) i.e. '2682980500' there are 2 rows - one starting with L and one with S. and the report needs to look like AccountName "GL" Balance 'OT' Balance...

Account.Name has value S-1234567890-50 L-1234567890-50 S-1234567891-50 L-1234567891-50 and so on

Thanks for the response. Sorry, it is actually 10. While writing here my mistake. The formula is as follows and Account.Name is like S-1234567890-50 In subreport-> Record selection mid( {Account.Name},3,10 ) = {?Pm-@ActName}and mid({Account.Name},1,1) = "S

Hi All, Using CR9. Passing a formula to a subreport and trying to match this formula with part of a column value. But there is no data returned though each Account.Name has 1 or 2 rows in table. Is my record selection in subreport proper because in 'Show SQL' I do not see this criteria in...

Hi, There is a Group Header2 with Section a and Section b. Both are set to 'Keep Together' in Section Expert. But on some of the pages Section A header of Gh2a keeps printing at the End of Previous page as well as Next page. Need to avoid printing at end of previous page. Also tried a...

Hi, I tried lbass suggestion, thanks. Have a 'Class' table with Id 12, 13,5, and 6. Second table 'Item' with ClassId 12, 13, and 5 but there is a selection criteria needed on the second table for the manager name. So I am not able to get header if ClassId is 12 but the manager name is different...

Hi, Working on CR 9. Creating a dynamic group header label with a formula '@groupLabel': Formula @groupLabel: if {table.column} = 12 then " Level 1: One" else if {{table.column} = 13 then " Level 2: Two" If there are no rows returned for {table.column} = 12, then the group label...

Is it possible to take an existing Hyper V vm and convert it to a VMware VM. How is it accomplished thanks

Thanks Turkbear, I will try sample report on this logic. Thanks lbass, still need to get the actual report to be modified, then I will have more data/details to provide. Always appreciate the support from this forum.