Search results for query: *

Thanks Markros, this worked! This is going to be very useful for me. Appreciate your help! PS

Hi Markros, I'm having problem with paranthesis if I try to include the original query in place of "Results" in your response above. Do I have to create a Temp table first and then use it in your query or is it possible to do it all together in 1 query. Please elaborate and thanks for your...

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

Thanks a lot! Yes, you are so right. Thanks again! PS

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

Hi Dilettante, Thanks for providing a detailed code. My point behind providing the end-user with a text box to enter the Precinct value is that there are a total of 160 Precincts here and it doesn't seems okay to provide a drop down for 160 values and let the user scroll thru (and also to make...

Hey Strongm, I started with the DataGrid, but my problem is that I don't want to use the ADODC control to dump the whole table into the Grid and then move from one record to another. Since I wanted the results in the grid to appear based on the user entered key, I'm not sure how I can use my...

Hi Andrzejek, Thanks for your response. I like the 2nd option better, but since I'm just a beginner at VB programming, would you please help me little more with the code to make the grid work like that. Can I use the MSFLEXGRID for the 2nd option above and if so what property I need to set to...

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

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