Hi All, I have a problem processing subreport. Here is the situation. I have two reports 1) Report1.Rdl, 2)Report2.Rdl. Report1.Rdl acts as the main...
Hi All, Even I am getting this same error. I am using ASP page to query (Select statement) on SQL table. I get this error sometimes but not always....
Hi All, I had posted the same question in Microsoft Technet and I got this answer: --- This is expected behavior. What you are doing is a...
Thanks Haywood, But during execution of the first Select statement there is no error raised. Infact, the result is displayed as "0 rows affected"....
Hi All, I am facing a wierd problem condition where SQL compiler is not trapping compile/run time error. Here is an example to illustrate: Create...
I guess, the string concatenation you are making with Int datatype, while firing EXEC is causing problem. Try typecasting the Int variables to...
Roji, Thanks for the SQL statement that lets us know the version and service pack info. Thanks, Bijesh
Adriaan, I thought of doing the DB changes but as this is a legacy system being converted to SQL server 2000 sometime back, I thought better not to...
Thanks a lot. We use the kind of query as suggested by Adriaan and MMarovic. But just wanted to know if there is any other way to avoid this NULL...
Hi All, I have an application that runs on SQL Server 2000 (don't know the Service Pack). In the application, I have a few SQL Select statements...
Hi, I am also experiencing the same problem. I have set the page size to 14X8.5 for one of my reports and when I export it to PDF, it compresses the...
As far as I know, custom error handling is not possible. RS displays its own Error message as "#Error". Thanks, Bijesh
Hi, Do you mean to say Report header or the part of the RS where you get text boxes to enter Report Parameters. If you want to format data anywhere...
Store all the values separated by commas. Thanks, Bijesh
Hi All, I have a wierd problem in executing a Stored Proc from ASP page and Query Analyzer. The problem is when I run the stored proc from ASP page...
Thanks Adriaan, I agree with you. I was under the impression that insertion of duplicate data in DTS needs to be aborted. Thanks once again....
Hi, I think you need to put a constraint (User_id and Group_id) on your destination table. If there are any duplicate values the constraint will...
Hi, Try out for some Web services. Some of them do provide these kind of data. Don't know whether they are free or paid services. Thanks, Bijesh
Hi, I guess you need to create a trigger in Table2 on insert. As, Table2 is a txn table, i guess you have referential integrity with table1. So now...
Thanks Pete! It seems I will have to change my SP to make it work. Thanks, Bijesh
Separate names with a comma.
