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 strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: psharma1
  • Content: Threads
  • Order by date
  1. psharma1

    Query to only bring back Maximum of a Count field

    I have a SQL statement (below) for SQL Server 2008 DB that returns a Division, a Dept Code, and a count of employees grouped by the Division & Dept Code. All I want to display is the MAX count, so a sample of my SQL is: Divison Dept_Code Count_Emp 1011 100 1 1011 101 122...
  2. psharma1

    String field comparison with IF then ELSE statement

    I'm using Crystal Report XI to create a simple report with 4 columns using 2 tables and 1 view. The tables are: Table - District_Master has only 2 fields County_Code & District_Code. View - VW_V1Master that has the distinct County_Code & District_code selected from another table called...
  3. psharma1

    How to insert/update/delete records using MSHFlexGrid control in VB 6

    I'm having problem in my project where I've to display a data grid based on a Master/Child relationship where the Master Data is entered as a value by the user in a text box and the data from the Child table is displayed in a grid. I'm able to accomplish this much using the MSHFLEXGRID control...
  4. psharma1

    Main report is displaying duplicate records based on subrpt records

    Hi, I'm a new member and I hope I would find some solution to my problem here. I'm using Crystal XI to create a report with 1 subreport attached to it. The report prints 1 record per page where the detail section is from Main report and the group footer has subreport. Based on the parameters...

Part and Inventory Search

Back
Top