Search results for query: *

lbass: Thanks but I never tried your formulas. Solved this by using the command feature instead. (A more convenient solution for me in this report since I have many objects using the same query). http://www.tek-tips.com/viewthread.cfm?qid=1586378&page=1

lbass: Thank you very much. The command feature in Crystal Reports is extremely good and flexible. A very good alternative to using views or procedures. This did the trick. I realized now that sybase sql anywhere 8.03 also works with a simple "select top 10" query! set rowcount 10 may be petter...

I do have rows but I'm using the summarized fields as rows. Not the actual "rows" section in the cross tab expert (if you understand what I mean). In the cross tab expert I'm using reported dates as columns and the values (different table columns) in the summarized fields section). But I have...

lbass: Yes, top 10 relates to 10 most recent records. My crosstab looks like this: I have colums with different dates and rows with different data (all rows in my crosstab are different table columns in my database table). Would it have been easier not using a crosstab for this? (at least for...

Thank you, I will try. I'm using Sybase SQL Anywhere 8 as database. I have a sql query working in interactive sql tool. If I use set rowcount 10 my sql query..... set rowcount 0 So I will need to add my s2et rowcount 10" line before the actual query beings. The last set rowcount 0 may not...

lbass: Hmmm but if i do this it gives my crosstab a totally different look which I don't want? In my crosstab the columns are "reported date" and the summarized fields the values (using no rows). This gives the crosstab the look I want if I also surpress row grand totals.

Top N of individual recorts. I will look at record sorting with supression, will that work in a crosstab? My crosstab and charts are placed in the report header. About your last interesting suggestion: How do i use a command as my datasource building top 10 directly into the query? This...

Using Crystal Reports XI I have a report with a crosstab and a couple of charts. I need top N functionality to limit my result to last 10 rows (both in my crosstab and my charts). My SQL query is a simple select * from table In my crosstab I only have Columns and Summarized fields. Since I...

Hi, I'm building a report against sybase sql anywhere 8. I need a top N limitation to 10 in my query. I know that it works if using "set rowcount 10" before sql query and then "set rowcount 0" after. I have succesfully tried this in interactive sql, no problem But how do I implement this in...