Search results for query: *

Hi.. we are using Excel 2010 and are looking to develop a Kanban board in Excel... has anyone out there tried this? Please share pros and cons... I was looking at Visio but not everyone in the group here has Visio... Thanks

Hi... we just upgraded to Excel 2007 and some of the functionality we are used to working with in 2003 appears to have disappeared. We used to be able to drop a CPU/LPAR/Subsystem field into the top of a pivot table chart and then filter the chart to display a given element...

Hi.. I am using SAS Enterprise Guide 4.1 (4.1.0.471). I am wondering if anyone has had a problem with the Legend option disappearing from certain chart types. It doesn't appear for the bar/line combo charts for me - but all the research I have done says it should. The rest of the chart types...

Hi... we are using Excel 2003... I was wondering if there was a way to carry font characteristics between cells and worksheets e.g., I have 2 worksheets in the same workbook... (A & B) Worksheet A is an 'overview' sheet and worksheet B is a 'Detail sheet'... I have cells on A that are pulled...

Hi... we are using Excel 2003... I was wondering if there was a way to carry font characteristics between cells and worksheets e.g., I have 2 worksheets in the same workbook... (A & B) Worksheet A is an 'overview' sheet and worksheet B is a 'Detail sheet'... I have cells on A that are pulled...

Hi... I am using Excel 2003 SP3... I have a formula on a worksheet 'B' that I want 'posted' as a value on worksheet 'A'... e.g., Worksheet 'B' Formula: =26144/262.5 Worksheet 'A' Formula: =CONCATENATE("(zIIP) ",'PRSM Parms'!O104) I want the value posted as: (zIIP) 99.5962 (4 decimal...

Hi.. we are on CR 9... I have a field named project.status that contains a number of choices, but I want to exclude 4 or 5 of those from appearing on the report. I seem to remember some type of statement to do this with like: <table>project.status not in ["Scope","Production Pending"] - but I...

Hi, I am using CR9... I want to exclude entries in my reports that start with the words "IN QUEUE" in a brief description line... I put this entry in my Group selection formula (but it still selects tickets with this as the first characters in the field)... and not...

Hi... I am using CR9... I have a user who wants a report heading (in this case RHb) to appear at the top of each page of the report. RHb has the labels/names of the fields that were selected in the Detail section... the user wants these labels as reference points when the report gets to 2 or...

Hi... I am using CR9.0... I have a subreport that has a group (assignee.name)... the report shows all the tickets that are assigned for each person - works great - except I want to suppress those assignee.names that have no tickets... Thanks for any help!

Hi - we are on CR 9... I would like some help with how I would go about selecting records that contain a number in the field. We have a field called updated.by... in the last 203 positions of some of the IDs in this field have a number (like xyz01 or zzz123. Some of the IDs do not have the...

Hi everyone... We are on CR 9... I haven't worked on CR for a while and I am having trouble getting started again. I have a field named project.status. Developers are supposed to be filling in this field (WIP, onHold, etc). I would like to produce an audit report to pull tickets that have...

Hi... We are using CR 9.0 - reporting from Peregrine Service Center P4 Database... I have a requirement to add a field to a report that shows a count of the number of 'hits' reported from the formula below... Currently the formula below lists all the SCAutomate updates - we want to tally...

Hi... I was wondering if there is any way to pull specific information from a freeform text field. Wea re CR9.0, using Peregrine Service Center P4 database... Here is an example: (I want to pull the words SCAutomate and the 6 character code after it - every occurrence) 05/02/06 08:52:24...

Hi.. we are on CR 9.2... running reports from Peregrine Service Center DB... We have an array field called assignment history in Service Center - this field keeps track of all the department names a ticket has been assigned to... We want to extract the first element in this array and put it on...

Hi... we are currently using Service Center 5.01 with 5.1 clients... We can successfully query "current.pending.groups" on our change system, but receive 'no records" when querying future.groups (like approver seq 8 or 9) both are defined under the same structure in the dbdict. Anyone have...

Hi... we can successfully query "current.pending.groups" on our change system, but receive 'no records" when querying future.groups (like approver seq 8 or 9) both are defined under the same structure in the dbdict. Anyone have any ideas or hints on where to start to debug this? Thanks

Hi... after a merger of two companies about a year ago, it has been decided we will now merge Service Center databases. One instance is on NT; the other on UNIX... it looks like we will be going to the Unix side and merging the current NT into it. Does any one who has done something like this...

Greetings... We are on CR8. I have a crosstab that contains 4 rows: Informational, Normal, Exception, Emergency. Three columns: High, Medium, Low I want the High column to show even if there are zero counts in it (it disappears if there are zeros) I have read some previous postings that...

Hi... I am trying to export a crosstab report to Excel... the Crosstab is in the Report Header. Everything is coming across fine except the column and row names are missing... I have tried all three XL formats as well as Extended... Could somone please point me in the right direction to...