Search results for query: *

Hi, Could someone please assist me with the below: I have two tables 1.) Table A - Which contains data that changes regularly 2.) Mapping Table - Which has a static table that will hold static data used in a lookup formula to allocate segments (groups) to table A My end goal is have a...

Hi, I have 2 tables both with a field 'COMPANY_NAME/CUSTOMER_NAME' but they appear in a different format on each table e.g. tableA COMPANY_NAME/CUSTOMER_NAME AMOUNT Mr John Smith 100 Doctor Andrew Brown 500 Microsoft...

Just wondering if any other people have been experiencing disappearing cells when using Excel 2007 to open Excel 2003 files? When scrolling through various different spreadsheets cell visability dissapears for some cells. Just to be clear its just the visibility that is hidden, when you click...

Not sure if this is possible but is there a way to copy any paste just the fill colour of a cell? I've tried "copy & paste special > formats" but that paste all the cells formatting. I am specifically looking for just the fill colour. If this can't be done with the usual features i would be...

HI, For displaying Multiple Discrete values separated by a comma, i generally use the below formula: whileprintingrecords; stringvar Output:=""; numbervar Counter; For Counter := 1 to ubound({?MyNumericParameter}) do( Output:= Output& totext({?MyNumericParameter}[Counter],0,"")& "," )...

HI, I'm currently trying to combine 2 crystal reports, One report had a load of subreports on and the other has a crosstab. So far i've managed to replace all the sub reports and add them to the crosstab as SQL Expressions except one. Problem: The subreport that im trying to replace has the...

I have created a Pie chart from an existing Pivot table. The chart itself is working fine my question is that when i hover over the pie chart segment to see the total figure that makes up that segment, excel displays the figures for the first period that ive selected and not the total of the...

Currently i am trying to protect a sheet containing a pivot table. I do no wish the user to be able to change the structure of the pivot table and/or be able to edit any cells outside of the pivot table. Although the user should be able to use all the filters in the pivot table to select...

Informix DB i was wondering if someone could help me writing a sub query using just a case statement (if possible) so far i got: ( SELECT CASE WHEN IS NULL (sum (po_order_line.order_line_amnt)) THEN 'ZERO' WHEN sum (po_order_line.order_line_amnt) > 0 AND sum...

Informix Database Crystal Reports 8.5 Hello, im trying to create an SQL expression (Sub Query) in Crystal Reports which based on a conditional statement. At current I have the below SQL expression: %INV. To Date: ( SELECT sum (po_order_line.order_line_amnt) FROM...

Informix Database Crystal Reports 8.5 Hello, im trying to create an SQL expression (Sub Query) in Crystal Reports which based on a conditional statement. At current I have the below SQL expression: %INV. To Date: ( SELECT sum (po_order_line.order_line_amnt) FROM...

Currently i am trying to protect a sheet containing a pivot table. I do no wish the user to be able to change the structure of the pivot table and/or be able to edit any cells outside of the pivot table. Although the user should be able to use all the filters in the pivot table to select...

I currently run a report with one set of parameters The parameter allows you to select a 'Business Area' and has the below properties are selected: -Allows Multiple Values -Discrete Value/s -Allow editing of default values when there is more than one value My issue is that i would like to...

I am trying to create a Macro that sorts data and then adds subtotals. This macro is to be used on different spreadsheets with different numbers of columns. Although the macro is to be used on different spreadsheets the first 4 columns are to always be excluded from the subtotaling so at current...

I am trying to create a a single string from a list of values. e.g. Col A A/C CODE 05FFF564 06DDD555 07YYY222 08UUU333 09III222 Desired output (Single String): ['05FFF564','06DDD555','07YYY222','08UUU333','09III222'] I've got basic knowledge of VBA and not sure where to start on this...

Not sure if ive posted this in the correct forum...Please advise. I'm trying to return data from an ODBC source using MSQUERY to Excel 2003. There are two tables iv'e joined one containing Customer Information and the other containg Fixed Contract information. The tables are joined by Customer...

I am trying to perform a minimum summary on a 2nd pass formula and not entirely sure how to go about this. Ive previously performed Grand Totals on 2nd pass formulas by using variables & subtotals, so assume it will be a similar process. My formula looks like: if previous...