HELP Reports!

[ajh1584]

Hi Guys am trying to modify a report in sql server so that it will print all email adress as well as phone numbers and adress but it wont pick up the email adress any ideas on how to do it?

 

[r937]

i would use a SELECT statement

r937.com | rudy.ca

 

[ajh1584]

u mean something like this? im struggling to get it working!!

BEGIN
SELECT E-Mail insert inserted into "report name" As result
End;

 

[checkai]

I think you're going to need to give some additional details...i have no idea what you're attempting.

 

[SQLSister]

What is your table structure, what is some sample data and what results would you like to see?

"NOTHING is more important in a database than integrity." ESquared

 

[genomon]

What version of SQL Server are you using, and what is your reporting tool?

"Time flies like an arrow; fruit flies like a banana."

 

[ajh1584]

Its ok guys n girls thanks ive done it and i was using sql server 2005