Search results for query: *

Hi, I'm working on a Java project, Which is to design an appointment scheduling software. In my code,I have a TimeSlot class which gives the user the option to select the date and time. But once the user selects a particular time slot for a particular day,then that must be removed from the...

Hi, I'm using CR 8.5 and SQL server 2005. When I run my report I get an error message, The page size was not large enough to format the contents of an object in the report. Can some one please help why does this happen and how to overcome this. Thanks, Rahul.

Hi, In my report I want to display the Month and year for a date entered by the user. Say if the date entered is [1/1/2007] My report should display As of January 2007 And for that I'm using the following formula MonthName(Month({?Start_Date})) + " " + totext(tonumber...

Hi, I have been struggling with this report for quite sometime now. I have a problem,which is counting the number of calls for each employee. Here is how my data looks EMP_ 1.EMP_ID 2.EMP_GID 3.PID 4.EMP_NAME 5.EMP_TITLE ... ... EMP_GOALS 1. EMP_ID 2. EMP_GID 3. EMP_PID 4. NAME_EMP 5...

Hi I'm using CR 8.5 and SQL Server 2005. In my report when I run it for some employees it gives me duplicates. How do I eliminate them. I have developed a report which looks something like this: Emp_NAME (Main_Grp) Peak_Flag (sub-grp1) 2007 fld1 fld2 fld3 2008 fld4...

Hi, I have a sub group in my main group. But when I print the totals I need to print the values or sub-totals(totals of sub-groups) again in the main group too. How do I do that. Here is how it looks... Grp 1 sub-grp1 fld1 fld2 fld3 ... ...

Hi, I'm new to SQL Server and I'm currently using SQL Server 2005. In my database, I have a field in EMP_Property in a table named GOALS. But unfortunately there are some entires as 'The Westin' instead of 'Westin' and I need to update all the records with 'The Westin' to 'Westin'. Can...

Hi I'm using Crystal 8.5 and SQL Server 2005. And when I run the report my reports displays the same data repeatedly. I'm not sure where it is goin wrong. I checked my database and it has multiple rows with the same name.But I just need the data to be displayed just once. Can someone help...

Hi I'm new to SQL Server and I'm trying to run the following query SELECT NSS_REPORT.dbo.ALLOCATE."DATE_ALLOC", NSS_REPORT.dbo.ALLOCATE."SEASON_ID", NSS_REPORT.dbo.DATECOLL."START_DATE" FROM NSS_REPORT.dbo.allocate oj left outer join NSS_REPORT.dbo.datecoll on...

Hi I have the data in a MS Excel file. How do I generate a report using that data. Is there any way that I can import the data from the excel file onto the report. By the way I'm using CR v 8.5 Please help. Rahul

Hi all, I'm using cyrstal Reprots 8.5 and SQL Server 2005. When I run the report I get an error ODBC error:[Microsoft][ODBC SQL Server Driver][SQL Server] Incorrect syntax near '{' I'm not sure what it is. Can you please help me. Thanks, Rahul.

Hi I'm using Crystal Reports 8.5 and SQL Server 2005. When I'm executing my report it gives me an error ODBC error:[Microsoft][ODBC SQL Server Driver][SQL Server] Incorrect syntax near '{' I'm not sure what it is. Can you please help me. Thanks, Rahul.

Hi I'm using SQL Server 2005. I need a table to be copied from one database to another. How do I do it. Please help. Thanks, Rahul.

Hi, I'm using CR version 8.5. I'm trying to pull two different tables using SQL Server 2005.I need two tables to generate my report, and those two are on different databases of the same server. Please help me how to add two tables on different databases to the report. your help is...

Hi, I'm looking for a particular field "Booking Role" and "Title" in my SQL Server 2005 DB. I'm not sure in which table it is. Can someone help me with the easiest and the quickest possible way to find the field from a huge DB with many tables. Your help is appreciated. Rahul.

Hi, I'm using SQL Server 2005 on my machine. I'm trying to import some data from anther server which has SQL Server 2000.I'm trying to get a particular table from SQL 2000-> SQL 2005. So I'm using the DTS wizard to do this. Rt Click on the table in SQL Server 2000-->All task--> Export Data...

Hi I'm using CR 8.5 and need to connect to a SQL Server Database on another server. Is it possible? If yes then how can I do it ? Rahul.

Hi I am new to SQL Server. And I have two databases on two different servers. I have SQL server 2000 on one server and SQL Server2005 on another server. How do I move the data in one table on SQL Server 2000 into the same table on 2005. And I access both the SQL via. the Remote Desktop on my...