Sitemap

Amicuk Programming Answers

Array in formula to use in a cross-tab

-0001-11-30   Views:4

Advertisement

Post Author: eliasc CA Forum: Formula I am using CR 10.  I have a report where I am using a formula to use as a column header for a cross-tab.  Below is an example of what I am trying to achieve. ATLANTA INVOICE  ATLANTA SERVICE  ATLANTA WARR.  BIRMI

Post Author: eliasc
CA Forum: Formula
I am using CR 10.  I have a report where I am using a formula to use as a column header for a cross-tab.  Below is an example of what I am trying to achieve.
ATLANTA INVOICE  ATLANTA SERVICE  ATLANTA WARR.  BIRMINGHAM INVOICE BIRMINGHAM SERVICE BIRMINGHAM WARR.  ETC..
Below is the array in my formula.
Shared NumberVar i;Shared StringVar CompanyName;Shared StringVar Array Companies := ["HFSE - FW","ATLANTA INVOICE","ATLANTA SERVICE","ATLANTA WARR.","BIRMINGHAM INVOICE","BIRMINGHAM SERVICE","BIRMINGHAM WARR.","BGSI INVOICE","BGSI SERVICE","BGSI WARR.","PEN INVOICE","PEN SERVICE","PEN WARR.","JACKSON INVOICE","JACKSON SERVICE","JACKSON WARR.","FORT WORTH INVOICE","FORT WORTH SERVICE","FORT WORTH WARR.","JAX INVOICE","JAX SERVICE","JAX WARR.","LOUISVILLE INVOICE","LOUSIVILLE SERVICE","LOUISVILLE WARR.","OKLAHOMA CITY INVOICE","OKLAHOMA CITY SERVICE","OKLAHOMA CITY WARR."];0;
local stringvar tString;shared numbervar CompName;
CompName :=UBound(Companies) +1;i := CompName;
For i := 1 to CompName step 1 do(  ReDim Preserve Companies[i];    tString :=Companies[i] );
tString;
Can someone please help me.  I don't know where I am going wrong and why it isn't putting the above names in the cross-tab columns.
Thank you for your help.
Chris

The replay answer
Advertisement
Hi,
The "buffer" variable in DIG_Block_Out is an array of short integers (16 bit integers). It expects you to pass the array pointer as the function value. In the example below, "buffer" would be the parameter value.
Dim buffer(5) as Integer
Ron

Go to See the other 2 answers

Array in formula to use in a cross-tab

Category:DefaultRelease time:-0001-11-30Views:130

Post Author: eliasc CA Forum: Formula I am using CR 10.  I have a report where I am using a formula to use as a column header for a cross-tab.  Below is an example of what I am trying to achieve. ATLANTA INVOICE  ATLANTA SERVICE  ATLANTA WARR.  BIRMI[More]

Print time formula error when used in cross-tab

Category:DefaultRelease time:-0001-11-30Views:130

I have a cross-table that I'm using to calculate revenue, which is based on a conditional formula.  Within that formula is a Running Total field.  When I use this field I get the following error message: "A PRINT TIME FORMULA THAT MODIFIES VARIABLES[More]

Bug – CR 2011 cross tab number decimal formula not executing

Category:DefaultRelease time:-0001-11-30Views:130

I have a formula to format the number of decimal points in both the column and row header values in a cross tab subreport. The formula does not appear to execute.  If I display the data in a simple table format and use the same decimal formula the fo[More]

Displaying Alternate row as colored in Cross tab

Category:DefaultRelease time:-0001-11-30Views:130

Hi, I have a report where I need to display alternate rows as colored. There is some data in detail section followed by a cross tab in the report header section. While I am able to display alternate rows as colored in Detail secction for displaying a[More]

Seconds to Time Conversion for Display on a Cross-Tab

Category:DefaultRelease time:-0001-11-30Views:130

Post Author: [email protected] CA Forum: Formula I am doing a cross-tab report of login times for hours logged into a system. In the cross-tab if i use the time, I can't sum. So i have the time converted to seconds to allow for a sum and totals.  Now[More]

Conditional highlighting on cross-tabs

Category:DefaultRelease time:-0001-11-30Views:130

Does anyone know if it is possible to conditionally highlight a field in cross-tab based on another field in the table? The field we're using to condition is not in the cross-tab, nor do we want it to be in the cross-tab. We need to highlight a repor[More]

Cross Tab - Suppress info

Category:DefaultRelease time:-0001-11-30Views:130

Post Author: llcoolt CA Forum: Formula I just created a cross tab report that works beautifully, with one exception.... I want to suppress one of the column headings.  How do I suppress ONE column sumary and it's heading?  The heading is called "Job[More]

Custom formula in cross-tab?

Category:DefaultRelease time:2015-10-11Views:130

I have a cross-tab like this                   JAN    FEB    MAR ....... DEC (the 12 months as columns) year 2006    item 01     150    205      300 .......    550    item 02       80    190      284 ........   620 year 2007    item 01      458    23[More]

SAP Crystal Report - Formula in Cross Tab Report

Category:DefaultRelease time:-0001-11-30Views:130

I have a below requirement in a cross tab report, Category          Name          Valu1          Value2    %ge A                       Car               40                  50        80 A                        Bike             30                  60[More]

Running Totals and Formulas with Cross Tabs

Category:DefaultRelease time:-0001-11-30Views:130

Hi, I'm using Crystal Reports 2008 and am having two issues using Cross Tabs. The first is that I want to have two crosstabs. They both will have a common Y axis (Oppourtunity.Sales Rep), and on the Y Axis I want one to show all (Opportunity.Create D[More]

Diffrent Data Type & Formula in Cross Tab

Category:DefaultRelease time:-0001-11-30Views:130

Post Author: ade CA Forum: General I using crystal reports 8.5. I make cross tab like this to viewing reportsSubject           Evaluation Aspect                          Score1        Score2            Score3        Score4        Score5 Math         [More]

Hot
Attached a video that demonstrates a problem with my iPhone 5s: http://youtu.be/zOnQsrdgURI Tried restoring - didn't work. Tried disabling Touch ID - didn't work. Tried removing the case and the screen protector - didn't work. Any suggestions other t [More]
Hey everybody! I am currently getting ready to buy my wife and I our first Mac. But I need some advice in making sure I'm picking the right one. I'll give you the rundown: I'm looking at the 13" MacBook Pro because I'm double majoring in communicatio [More]
Hi I am having an issue with cascading prompts in Crystal Reports 2008.  I have two cascade levels in this report.  The report worked fine for a few months until we recently noticed some items were not showing up on the first list.  In the database, [More]
There appears to be something going on between the FB webpage and Firefox web browser. On my page it comes up with a pink background instead of the usual grey. Also posts that are linked to outside FB sometimes end up turning various shades - green, [More]
Hello, I have my editing hardware hooked up to a surround sound processor (via HDMI) which feeds 7.1/5.1 speakers and an HDTV.  The HDTV displays the output monitor content just fine, but I have been unable to get Premiere Pro CC 2014 to output 5.1 s [More]
Post Author: anandad CA Forum: Data Connectivity and SQL Hi, I have installed Crystal Reports XI Developer version but in my Field Explorer I dont see SQL Expression Fields tab or item. Did I miss installing any perticular component? I can see the fo [More]
hi, What is the step by step process to create a table in data dictionary? regards.sorry, question resolved.Read other 2 answers [More]
COMO ACTUALIZAR LA VERSION EN ADOBE PHOTOSHOP CS6 DE CAMARA RAW PARA LAS CAMARAS NIKON D4s y D800EToda la información y los enlaces de descarga de Adobe Camera Raw 8.5, para los que utilizan diversas versiones de Photshop y de sistemas operativos de [More]
Can anybody tell me why images in my photo libraries have been replaced by the photoshop symbol? Thanks.What operating system? What file types? Read other 2 answers [More]
Finder crashes intermittently when moving files, and has done so for probably a year now. It happens pretty much daily. I was hoping the problem would go away when upgrading from Mountain Lion to Mavericks, but it didn't. Is anyone able to tell from [More]