Recent content by rpal

Hello, I need guidance on selecting good book on ASP. I Have good knowledge on database and Crystal Reports but now I need to work on ASP. Thanks for your time. --Raj.

Hi, I am having problem to write parameter in following procedure. CREATE PROCEDURE Emp_proc @EmpNoMin varchar(6) ,@EmpNoMax varchar(6) AS BEGIN SET NOCOUNT ON SELECT E.EMPNAME E.DEPARTMENT FROM EMP_TBL WHERE EMPNO between @EmpNoMin and @EmpNoMax END The above procedure...

Using ROUND function I can get round after decimal but I want to display only 2 decimals after the point. Ex: ROUND(2275.4559, 2) Results: 2275.4600 But I want to display only 2275.46 Thanks in advance.

But It displaying results 2275.4600 I want to take out 00 and want to display only 2 decimal places.

Hello, I have amount column with two 4 decimal places. EX: 2275.4559 , I want get out put only 2275.46, how to do in SQL server, I am using Sql 2000. Thanks.

I have RAS 9 , Crystal Report 9 and I am developing application in ASP and I am using CrystalReportsInteractiveViewer.asp as viewer. But problem with this viewer is if my users want to print report they can't print directly. When we choose to print first it will exports to PDF and then we have...

Hi, I have installed RAS 9 on Development server. We have application, through that application I want to run the reports for that I am trying to write ASP pages. I got samples from Businessobjects but those are good if I am using CrystalReportsInteractiveViewer as viewer i am able to enter...

I am converting CR 8 to CR 9 versition as database is SQL server 7. In pts_change_log table there is column called change_closed, data type of this column is "bit" and data stored in the column as 1 or 0. When i am trying to access this column in Crystal Report 9.0 (in CR 8 this...

Thanks for your post. But it is giving info on viewing on web. I got error message when I am trying to open "RAS Configuration Manager " from Programs-> Crystal 9 Tools.

I installed RAS-9 on XP pro on standalone machine. First I installed ISS web server and I did make sure that it is running properly. Then I installed RAS 9 successful, but when I am trying to access RAS Configuration Manager I am getting following error message "Class not registered-Agent...

So Guyute do I need to worry about NT/SQL server authentication at any point. And in the documentation they are saying I have to create some account for ASP (Automated Process Scheduler)? Can you please explain what they mean. Thanks, Raj.

I am installing Full stand-alone installation for CE 9. Setup program can install its own Microsoft Data Engine (MSDE) database by default. I should go with default? I should first install SQL Server and make SQL server as default. Should I choose Windows NT or SQL Server Authentication when...

Hello Synapsevampire, I am going to install CE 9 version. In your post you said CE will install automatically "MS SQL Server engine" is this same as "ASP" (Automated Process Scheduler)? If not please let me know what is the difference between two. Thanks, Rajani.

Hello, I am very good at Crystal Reports. But I do not have knowledge on Enterprise 9 and I was asked by manager that how much time will takes to install CE and ready for work on that. Initially we got CD to install in stand alone machine, later we are going to install in server. But either...

Hello, I am very good at Crystal Reports. But I do not have knowledge on Enterprise and I was asked by manager that how much time will takes to install CE and ready for work on that. Initially we got CD to install in stand alone machine, later we are going to install in server. But either...