Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by gopat

  1. gopat

    Parameters in Command Objects

    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?
  2. gopat

    Parameters in Command Objects

    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...
  3. gopat

    Parameters in Command Objects

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

    Parameters in 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...
  5. gopat

    Reporting from multiple tables for a single report

    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...
  6. gopat

    Reporting from multiple tables for a single report

    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)...
  7. gopat

    Reporting from multiple tables for a single report

    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...
See more

Part and Inventory Search

Back
Top