Search results for query: *

I wrote the formulae wrong thats why i could not get the correct result, wow!!! that was a very intelligent solution!!hats off to you LB.. but now the problem i have is if the report is sorted by qty shipped, the order is qty shipped amount but if the report is sorted by sales amount the values...

so group by table.level

This doesnot sort based on the GRAND total of the qty shipped or sales amount, it sorts based on the total (which is grouped by the month- 2/2005, 3/2005).. so for one item i see multiple records,

Is there a possibility of the user choosing the sort option, grand total of qty shipped or sales amount? Ex: if the user chooses parameter sales amount the report is sorted on sales amount.

crystal version8 pervasive sql 8 I have a cross tab report which summarizes the item information by qty shipped and sales amount by month. 2/2005 3/2005 total item A 120 10 130 qty $235 $240 $470 salesamt item B 12 110 122...

Click on Database- database expert-create new connection- ODBC RD0 here you should be able to see all the databases , if you have not set up a dsn click on OLE DB (ADO) and you can set up an ODBC connection here.

also the "suppress label" check box under supress subtotal is disabled..

<quote> Add this as a third row field in your crosstab. Then go to the customize style tab and select your first row field and check "Suppress subtotals". </quote> when I do this, I cannot see the item number for which it displays the values I am able to see only Qty 12 amount12 qty 13 amount...

Thank you for the suggestion.. But now, 1. how do we label these rows 1) as qty and 2) as amount?? 2. Can we have more than one chart in one report?? Right now I have a chart with qty ,invoicemonth now i want a chart based on amt,invoicemonth.. thanks,

crystal version8. Hi I want to create a sales report in cross tab format. Jan feb MAR ... total qty amt qty amt qty amt Item1 120 1200 20 200 Item2 1 1 2 2 customera 121 1201 22 202 Item3 Item1...

Hi, I have downloaded the new crystal server evaluation version 11.. I have only used crystal reports version8 and want to explore the new server functionalities..can someone send me a link or suggest a book that can be good for me to start with?

crystal version 8 hi, i have 3 groups in a report and each user needs a group sort by a different group, instead of creating 3 different reports can we sort using a parameter? if user1 selects parameter "group1" then the report should be sorted by group 1 and so on,..

hi, can someone suggest me what material i have to be in touch to have a broad view of what are the capabilities of crystal reports .i have worked in version 8 but donot know anything about v9,10 or 11.. i have installed the eval version of 11.. but am not sure where to start to look for the new...

can you give me more information on this ?

is there is a possibility to export this table into another database and refresh the table periodically.. so that i can create indexes on this exported table and use it as i want?

thank you!

how did u link the tables, i have a feeling if you linked table1.invoice# to table2.invoice# , it should print what you need. check to see if record selection formula or suppressing sections on any condition are leading to this out put .. also look at the linking of the tables one more time

try this: when the report >1 page, go to the preview page of the crystal report then drag the lines only till where you want it.. with trial and error it should be ok..if you set these line positions once, you will not have any problem later..

currently i have crystal reports v 8 . I use this every day. Now as v11 has come out i want to browse the new version..can i install v11 on the same m/c as v8? will it corrupt my v8 installation?

actually no one has permission to create index on this table, as this database is a backend for a software program and tampering with the indexes might lead to major issues.. hence, i want to know if i can export this table into another database and create an index on the field..