I would try this:

(left([First name],1)+left(surname,1))

to computer you initial column.

Hope this helps

Coops

Try to add an Order by Clause:

Select ()

From()

Where()

Group by ()

Order by ()

Hope this helps

thanks for the help.. but I researched...

and the value for Yes is "-1" and the value for No is "0"

I substituted the above values and the query ran fine.....

Actually this can not be done.

yes You can import tables and report bodies but the actually queries never import quite the way you want them to.

Best advise is...

Depending on what you are using to create your query. In Query Analyzer you can highlight a specific part of the query and execute that alone. If you do not...

Without executing the query there is no way to see the results.

a query must be executed for the commands to take effect.

Is there a problem why you can...

I have not tried pulling the data from simply a Table. The information that I am grabbing is from multipal tables rather than just one. so I didnt think it...

I can not run the query from the datatab.

It gives me an error pop up: Undefined function 'IsMonthOK' in expression.

but the data tab is not displaying anything except...

From Query analyzer the same command can be used:

Select Top 10 *

From Some-table

Where Whatever-you-want

I render all reports through QA before trying to process in RS

Hope this helps...

D or I State theyear YTD Totals Jan Feb Mar Apr May June

DomesticAL2007...

I'm glad to see I'm not alone on this boat. I too am a novice at SQL and have been trying to build my knowledge base. I like and appreciate...

Thanks again.. You're the best!

thanks,

from reporting Services manager -

I clicked on Report Definition (it asked if I wanted to save) - I did (to the desktop)

then I could not open that .rdl file...

Thanks, I am not really familiar with Reporting Service.

Seemed simple, but extremely helpful, Thanks again.

Right now there are people working in the database mentioned. I will try later tonight and let you know if it works. Thanks...