based on what i read on these discussion groups i see that i can use a pass-through query. I was wondering if there are any plans to make the sp_reports more like the other tables. i am familiar with SQL of Access but not of QODBC. also, is there can i find a list of commands that i would be able to use for my pass-through query? i already saw some of the posts here, and i am not asking for the basic example of a pass-trhough query, rather i would like to take advantage of other commands that are available.

btw, i am going to use: sp_report ProfitAndLossByClass show Amount_Title, Text, Label, Amount parameters DateMacro = 'ThisYearToDate', SummarizeColumnsBy = 'Class'

thanks,

sam 

See: Are there any special stored procedures that can assist me in programming? 

See also: What do the new stored procedures SP_REPORTS and SP_PARAMETERS do? 

THanks for the quick reply.

what i am looking are commands for the pass-through query. for example, i would like to combine two columns, e.g. instead of: sp_report ProfitAndLossByClass show Amount_Title, Text, Label, Amount parameters DateMacro = 'ThisYearToDate', SummarizeColumnsBy = 'Class', i would like to have Text & Label as NewLable but i don't know the syntax. do you have a list of syntax, or which language is this based on, so that i can find it on the internet.

thanks,

sam