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...

Skipvought: Yes you right, I think I need to improve expressing my requirements Lionelhill: 99.9% of the time I would use a unique key or request the DBAs to provide me with something unique. In this situation I have no option for this due to the nature of the source of the data (bank...

SkipVought Thanks for your advice on this. The text to column method does work but I was hoping to find a formula based method that would work. Suppose my question is, is it possible to complete a vlookup (or alternative) based on a string appearing in the target range?: e.g. tableA: NAME...

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...

old post but found some useful VBA code thats solved my problems: http://www.contextures.com/xlPivot12.html

xlhelp: Thanks thats what i was looking for. Petermoran: Cheers i will look into that plugin as im sure i may have other uses for it. Regards,

I've tried all three 'IS' functions unsuccessfully, the 'ISREF' funtions conditional formatting always returned TRUE? I've found a macro which is doing the job, but cant help thinking theres an easier method... Macro...

fair point. i am trying to conditionally format a cell (fill colour) if the cell contains any formula. any suggestions?

Possible i have been attempting that method unsuccessfully. Additional info: I am trying to fill a cell conditionally with colour is the cell contains a formula. I have been using a custom function (VBA) to identify if the relevant cell has a formula and then coditionally format the cell if...

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...

Spot on. thanks

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,"")& "," )...

Was not entirely sure what you suggestion meant as i would be running this report for a large amount of customers so i was a bit unsure how to pass the MAX's to limit the data in the report. I have found a SQL solution though which is working in the Crosstab: ( SELECT...

if your parameters included in yor record selction criteria then the only invoices for the year will be returned. So if you add a Grand Total summary (Insert>Grand Total) on the {Invoice.TotalGst} then that should return what you are looking for.

Madwc: syntax error "A syntax error has occured" I'm using an Informix database if that makes a difference. lbass: SQL Expressions. I think you are right about the one value per faux group condition, as i think my results are returning more than one value. Maybe if i give more detail it may...

thanks for the suggestion i have previously tried: ( SELECT po_fi_cnrct.cnrct_amnt FROM popes:popesdba.po_fi_cnrct po_fi_cnrct WHERE po_cmpny.cmpny_id = po_fi_cnrct.cmpny_id ORDER BY po_fi_cnrct.start_dt DESC ) with the same syntax error. alternatively i could link the...

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...

there is a space function in crystal but not sure it will work for your purpose. if {Data.Primary Payer}= 'xxxxxxxxxxxxxxxxxxxxxxxxx' then space(25) else {Data.Primary Payer} You could also use a conditional formula to white the contents of the field. Crystal Reports 8.5 Microsoft Office...