Search results for query: *

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...

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, 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...

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...

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, 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

Hi, At run time, need pick up the text from Table1.column1. If it is 'Currency' then it should be grouped by Currency, if it is 'Country' then it should be grouped by Country. Is this possible in Crystal report 9 pls. I googled for sometime but could get an answer for this scenario. thanks

Hi All, We have a report built in Crystal Reports 9. When the report is run, parameter-> Manager name is typed in and the report generates data for that Manager. Now we would like to schedule this report so that the report is send in pdf format to managers' Email id. There are some 5-6...

Hi All, Using Crystal Reports 9.2. when the report is run, I need to display a dropdown list of managers and when a manager is selected from the list, pass it as parameter to the query and retrieve the rows. The manager needs to be picked from table at runtime. I was googling and see this...

Hi, Have 2 Groups and details. Would like to Hide and Display the Group1 header if the rows in the details are greater than 0. The report brings in all the records and then filters in the Section Expert of the Details. Right now using the following formulas in the report (CR9)but the variable...

Hi, I have a problem with duplicate rows. There are two tables - Emp and Rep. EMP table EmpName Rep1 Rep2 Rep3 John 1 2 null Jim 1 2 3 REP table RepNo RepName 1 Aril 2 Ben 3 Cate I want the result as EmpName Rep1 Rep2 Rep3 John Aril Ben null Jim Aril...

Trying to install crystal enterprise 10. Logged on to the windows 2000 server through Remote Desktop Connection. Logged user has admin rights. The initialization screen runs for about 2 minutes after starting the custom installation. In the custom installation 'web server connector' and the...

Hi, Whille accessing a crystal enterprise report via URL from a client browser, the ActiveX viewer installation prompt pops up 4 times. After 'Yes' to the fouth time, the report displays. Anybody had this scenario...any hints/links? First, I had installed the 'CE10' in 'C:'. The ActiveX...

Hi, Will appreciate any hints / links to call Crystal Enterprise / Reports ver 10. via URL . (Using Win 2000, CE 10 and CR 10, Tomcat 4.1.30, IE 6.0). Right now I give 'http://localhost:8080/crystal/filename.rpt' in the brower and the filename.rpt is in the foler 'C:\Program Files\Crystal...