| :: A few questions please... :: (3) | Post a New Message | Post a Reply |
 A few questions please... | Post a Reply |
from: New York
1. The contains in the where clause does exactly that, is there any way to have it do a LIKE?
Select * from test where name like "ACT%" will get all names that BEGIN with ACT and not names that may contain the letters "ACT"
2. Anyway to change the names of the summary columns (SUM1, SUM2), when saved to Excel these are the columns that get downloaded and not the name of the actual summary column.
3. When I have a lot summary records (100+) and a graph, the resulting datagrid gets streched out in the browser due to the graph having to display all the info. Any way to just graph based on the what is showing on the first page. I have 13 lines per page, can I just graph on the first 13, then go to page 2 and have it graph just page 2?
4. Anyway to do a page break based on grouping breaks?
5. The print icon does a print preview without the graph, anyway to have it go directly to print and print the graph? anyway to control the printing? page size, etc..
6. Anyway to format (mask) the summary totals columns, some of my calcs have 15 decimal palces, can I cutr that down to 2?
Thanks so much for some insight..
 Re: A few questions please... | Post a Reply |
from: New York
 Re: A few questions please... | Post a Reply |
from: Washington, DC
I'm not sure. I will have to check and get back with you
3. When I have a lot summary records (100+) and a graph, the resulting datagrid gets streched out in the browser due to the graph having to display all the info. Any way to just graph based on the what is showing on the first page. I have 13 lines per page, can I just graph on the first 13, then go to page 2 and have it graph just page 2?
This functionality will be available in version 2.50 which will be released later today.
4. Anyway to do a page break based on grouping breaks?
I will see if we can add this functionality
5. The print icon does a print preview without the graph, anyway to have it go directly to print and print the graph? anyway to control the printing? page size, etc..
We are trying to improve the printing of reports but however, It doen't matter because the graph will always be printed on a different page.
6. Anyway to format (mask) the summary totals columns, some of my calcs have 15 decimal palces, can I cutr that down to 2?
Format the field as decimal, number or currency from the Add captions (aliases) to field names screen of the wizard dialog
-------------------------
Ghost