SQL

[Aasin]

HEllo,

I have a report that i am pulling records from an sql database based on the date from ? to ? and fields in a column.

Now I want to be able to pull all the data for the same dates but based on all the fields in the column.

The fields are generated by a user clicking on a radio button which is tied to the field name in the column. I am having trouble adding another radio button to pull all the fields in the columns but at the same time still have the ability to choose from fields within that same column.

Any information is helpful.

 

[philhege]

What's the client app technology? This may be better answered in a forum that deals with your particular UI.

Phil Hegedusich
Senior Programmer/Analyst
IIMAK

http://www.iimak.com

-----------
I'm not as think as you confused I am.
-----------
Flabbergasted (a.): Amazed at how much weight one has gained.
-----------
Oyster (n.): One who sprinkles their conversation with Yiddish expressions.

 

[Aasin]

This is a current web application that is being used by users over an intranet. The application allows you to run a report based on a selection from a dropdownlist(sorry I put radio button on my first post)and dates. The items in the dropdownlist are fields in a column in a sql server database.

This application is written in visual basic but I think I just need to change the SQL statement to pull all the fields from the same column. For example.

I have a dropdownlist that has list items East, middle, west. These are for the United States. Now I want to add a item named all in the dropdownlist to generate a report for all( East, middle, west) in one report but still have the capability to pull the data for the list items individually.


Do you understand what I am getting at?