Search results for query: *

How can stored procedure help when I need to display c1, c2 & c3 in the report? stored procedure would help if I am looking only for the total, which is not the case. Or am I missing something?

This is what my problem is. I have a database which is not really normalized, more like a flat file. anyway, there is this one report that I want to create which utilises multiple tables. These tables CANNOT be joined. I need to count the number of records from each table based on seperate...

but the stored procedure can only return one value & I need multiple values, hence the different command objects

Database : SQL Server 2000 Crystal : 10 Connection: OBDC I understand it is possible to have parameters for command objects. In my report I have multiple command objects with date as a parameter. So instead of feeding seperate dates for each command parameter, I would like to have it all done...

What about query 1 ? Also, is there some thing that can be done by creating views ? Since subreports are not supported by adhoc, this approach will disable the adhoc capability. Also this would involve creating 3 reports to create one report. Is there no easier method possible? easier in the...

Sorry for not providing enough info. Here goes Connectivity : ODBC Sample Query 1: select count(*) from t1 where a=1 and b=2 and t1date > '01/01/2005 Sample Query 2: select count(distinct a) from t2 where c=1 and b=2 and t2date > '01/01/2005 Sample Query 3: select count(xyz)...

Database used: MS SQL 2000 Crystal Version: 10 In my database, there are multiple tables with the same structure but not having any link between them For a particular report, I need have seperate counts from each table (each query having seperate selection condition). I am not using any...