Recent content by mnasuto

HI, I am getting message invalid object

Hi, Thank you for prompt replay. I am getting message: The number name 'Server2.data2.dbo.data2' contains more than the maximum number of prefixes. The maximum is 3. What I am doing wrong? Please advice M

Hi, Is it possile to create query where tables are from different databases on different servers? If yes what is syntacs for selecting one field from each table? Please help if you can Best Regards, M

Thank you very much! M

Hi, I am traing to convert datatime to data an applying it in where statement: WHERE DATEADD(d, 0, DATEDIFF(d, 0, CaseCloseDate )) = ({ fn CURDATE() }) Now I have to modify it for WHERE DATEADD(d, 0, DATEDIFF(d, 0, CaseCloseDate + 1 )) = ({ fn CURDATE() }) OR to get WHERE DATEADD(d, 0...

Thank a lot for replay. My reports are running from bespoke applicaion and Crystal is on different server then SQL database. As you suggested I will check if application cosing a problem.

Hi, I am using SQL 2000 and Crystal 8. Recently we have upgrated SQL server. After server change reports are running very slow. SErver setup looks identical to server befor upgrading. All reports are running on Stored procedures. Stored Procedures are running quick. There is problem with...

Thank you very much for this solution Lbass. Your idea is very good and you are getting star from me. Thank you! Is anyone who knows how to solve this problem compleately? Please help if you can. Best, Marta

Thank you for your reply. If I do that my stats are changing , but stats where ok, chart was returning errors. I have to display running Total = cumulative total not sum of order for month. Chart displays: 01/10/2004 25000 05/10/2004 35220 11/10/2004 85423 Chart...

I did. This time I created just one group date: Report looks like: DATE orderamount RT 01/10/2004 01/10/2004 25000 25000 05/10/2004 05/10/2004 10220 35220 11/10/2004 11/10/2004 50203 85423 11/10/2004 5000 90423 11/10/2004 9146 99569...

After changing to Evaluate For each record chart is exactly this same.

Thaks for you replay. My chart is placed in report header and I am using date field as the on change of field and rt as summary field. It looks like on chart is displaying only first records after group change. Data: date ordernumber orderamount 1-10-04 1 10000...

Hi ! I am using Crystal 8. Data: date ordernumber orderamount 1-10-04 1 10000 1-10-04 2 20000 1-10-04 3 4500 3-10-04 4 3000 3-10-04 5 41500 I have very simple report with 2 groups: 1st --...

Hi, I have problem with sp: DECLARE @U nvarchar(255) SET @U = 'user_id in (405,255,585)' SELECT user_id FROM tbl_user WHERE [@U] How can I use parameter or variable with where? Please help if you can. Best, Marta

Hi, I am need to create Pivot Cross-Tab as example below, but I do not now what pivot Values I am inserting. Below example is hardcoding we inserting values to Pivot table which we know example : INSERT INTO Pivot VALUES (1990, 1, 1.1). I have 2 tables tbl_Question fields...