How to set format number(integer,numeric) on Cross Tab Report?
26 November, 2013
Hi Support,
I want to display data on report following format below:
I create report using Data Output as Cross Tab from sql query freehand. I want group data separate between Quantity(interger not set decimal places) and Cost(numeric set decimal places) when I run report then the column numbers and the value is the quantity have set default numeric and decimal places 2.
But I want set the quantity value not decimal places and I want to show column totals separate between Quantity and Cost as sample the xls file.
I have attached sample the xls file for you. Could you please kindly advise me about this?
Please let me know if you have any question or suggestion.
Thanks and Best regards,
Ann
I want to display data on report following format below:
I create report using Data Output as Cross Tab from sql query freehand. I want group data separate between Quantity(interger not set decimal places) and Cost(numeric set decimal places) when I run report then the column numbers and the value is the quantity have set default numeric and decimal places 2.
But I want set the quantity value not decimal places and I want to show column totals separate between Quantity and Cost as sample the xls file.
I have attached sample the xls file for you. Could you please kindly advise me about this?
Please let me know if you have any question or suggestion.
Thanks and Best regards,
Ann
Hi Ann,
Thanks for the screenshots, I think I know what you're after, though I would like confirmation, as I could simply be misunderstanding.
Are you trying to get the values in the table as whole numbers, though then have the totals as a decimal?
E.g.
ITEM
A 1
B 3
TOTAL = 4.00
Is that what you're after?
Regards,
David
Thanks for the screenshots, I think I know what you're after, though I would like confirmation, as I could simply be misunderstanding.
Are you trying to get the values in the table as whole numbers, though then have the totals as a decimal?
E.g.
ITEM
A 1
B 3
TOTAL = 4.00
Is that what you're after?
Regards,
David
Hi David,
I want to show column about Quantity not a decimal , show column Cost as a decimal and show totals follow group Quantity columns and totals group Cost column.
E.g.
Thanks,
Ann
I want to show column about Quantity not a decimal , show column Cost as a decimal and show totals follow group Quantity columns and totals group Cost column.
E.g.
Thanks,
Ann
Thanks Ann,
It looks like to get the report in the requested format and style, you would need to create 2 cross-tab reports, and display them as co-display.
One report would have the quantity metric (not decimal)
One report would have the cost metric (with decimal).
E.g.
Hope this covers what you were after.
Regards,
David
It looks like to get the report in the requested format and style, you would need to create 2 cross-tab reports, and display them as co-display.
One report would have the quantity metric (not decimal)
One report would have the cost metric (with decimal).
E.g.
Hope this covers what you were after.
Regards,
David
To David,
Thanks for your quick response.
There is another way? Sample I can setting format number to integer or numeric.
We cannot do it the way you suggested. Because the customers want to display a combined report and export to excel format to use in the form of the other.
Best Regards,
Ann
Thanks for your quick response.
There is another way? Sample I can setting format number to integer or numeric.
We cannot do it the way you suggested. Because the customers want to display a combined report and export to excel format to use in the form of the other.
Best Regards,
Ann
Hi Ann,
The only way I could see you having both metrics in the cross-tab report would look like this;
Regards,
David
The only way I could see you having both metrics in the cross-tab report would look like this;
Regards,
David
Hi David,
I have proposed this format to customers, but they still want the original format.
I may be required to change the format to make it the closest to the original.
Thanks and Best Regards,
Ann
I have proposed this format to customers, but they still want the original format.
I may be required to change the format to make it the closest to the original.
Thanks and Best Regards,
Ann