xsabatea

Hi all! I wonder if it's possible to use a crosstab as a datasource? I'd like to combine 2 or 3 crosstabs results to build a final table. I'm doing that manually to build a final report. I've read an old topic related with that, where someone asked for creating charts from crosstabs. Is it possible right now? Thanks in advance. Viersa.

Hi! for this purpose I use a sort of “sql-injectionâ€. It works for me because the used parameter is generated by an application, not by a user. Your query: Select * from countries where city=’London’ and … My stuff: Select * from countries where ( city=$P!{CITY} ) and … CITY is a string param. When you want to filter by city, CITY = “a city name†When you want to skip the filter CITY = “ ‘anything’ or 1=1 “ Maybe there’s a better solution but this works… ;) Regards Viersa