Search results for query: *

Hi Freinds, Please can anyone help me with these: Which is the best answer for the Q 1. In Teradata's parallel environment, response time is as fast as -the fastest AMP invloved -slowest AMP involved -sum of all AMPs involved - average performance of all AMPs 2. Does a full table scan require...

Hi Group, How do you find the size of a cube? Regards, ashark

Hi Group, I wnat to insert more than one row in table. Can you please tell me how that can be done in one SQL statement Thankyou. ashark

Hi Group, I am receiving error while trying to connect to Linked Server Error 7399 OLEDB error trace OLE DB Provider 'Microsoft.Jet.OLEDB4.0' IDBInitialize returned Authentication failed. What can be the error? Regards, ashark

Hi Group, What is the difference in the following queries : use pubs select t.title, p.pub_name from publishers as p inner join titles as t on p.pub_id = t.pub_id Order by title asc use pubs select t.title, p.pub_name from publishers as p ,titles as t where p.pub_id = t.pub_id Order by title...

Hi Group, I have a very strange problem. I have a table and have built Views on that Table. I have built a view which fills the value 1 into a Column which is Grouped by OrderNumber and Position Number. I hve built another view on the top of this view which is Grouped by Order Number, Position...

Hi Group, Can following Condition be placed on the input paramteres? There are 2 input parameters A and B and the Sum of A and B should not be greater than 100 eg 1. A - 85 B - 15 should be allowed 2. A - 25 B - 15 should be allowed but A - 55 B - 55 should not be allowed...

Hi Group, I have some data which is Grouped by Items. I do some calculations and then divide Items into A, B, C. I have a calculated field for dividing Items into A, B, C. Now I need a Line graph on which X Axis is the Calculated field (which contains A, B, C) and on y axis some amounts. Can I...

Hi Group, I have some data which is Grouped by Items. I do some calculations and then divide Items into A, B, C. I have a calculated field for dividing Items into A, B, C. Now I need a Line graph on which X Axis is the Calculated field (which contains A, B, C) and on y axis some amounts. Can I...

Hi Group, Is there a function in crystal report which returns the number of days in a month if given a particular month and year. For eg. if i input 01-2003 it should return 31 02-2000 then 29 02-2001 then 28... Please tell me if there is a function...

Hi Group, I have customized a group name. It consists of a number field and a string field. eg. I have employee Number and Name 123456Employee1 My problem is I am getting a comma (,) 123,456Employee1 How can I remove the (,)???? Regards, ashark

I have Sales Data and have to find the 'Period' the Customers are Associated with the Company. Data is as follows : Customer1 01/01/2001 02/10/2001 01/11/2001 06/24/2002 12/25/2002 Customer2 03/01/2001 09/24/2002 I have to find the DateDiff of...

Hi Group, I am using CR 8.5. Some of my Reports are 8" in width and some are 8.5" in width. When I create a new Report it is 8" wide. How to change it to 8.5" ???? Regards, Programmer

Hi Group, Is it possible to pick multiple values from Parameter Field in Crystal Reports 8.5 ? For e.g.. When a company has 10,000 items and they wish to see the Sales report of some random 4 items, then they should pick up just the required 4 items from the Parameter Field.

Hi I read the thread for Running totals and tried out the same. But what if I don't use formulas? I am receiving the zero values as Blank. I am trying to use the inbuild Running Total functionality.

Hi Group, I have a doubt. In CrystalReport 8.5 there are functions for YearToDate and MonthToDate. I need functions for QuarterToDate and DayToDate. Do I have to create formulas for them or are they available in some other format. Please help.

Hi, We are preparing some Crystal Reports and need some help. We have a report which has groups Country, Customer and Items We have some parameters which specifies the range of Items to be considered. We want a report which first gives us the sales figures for all the countries. Then clicking...

Hi, We are preparing some Crystal Reports and need some help. We have a report which has groups Country, Customer and Items We have some parameters which specifies the range of Items to be considered. We want a report which first gives us the sales figures for all the countries. Then clicking...

Hi, We are preparing some Crystal Reports and need some help. We have a report which has groups Country, Customer and Items We have some parameters which specifies the range of Items to be considered. We want a report which first gives us the sales figures for all the countries. Then clicking...

Hi, We are preparing some Crystal Reports and need some help. We have a report which has groups Country, Customer and Items We have some parameters which specifies the range of Items to be considered. We want a report which first gives us the sales figures for all the countries. Then clicking...