Search results for query: *

CR2008 Question. I have searched and found answers on line counting, etc., but none seem applicable. I have two groups. Let's say Group A = State, Group B = City. Detail is list of people named "Bob Smith". In the "Group Expert", Group A is set to "Repeat Group Header on Each Page" (and...

I have a table that is basically: Year, Month,Co, Division, GL account, amount (+ or -) It is a detail transaction table. I want to create a trial balance from this, which will list the debits (positives) in one column and credits (negatives) in a second column. It would also need to sum by...

Is there a way to include logic in a propercase scenario where some words do not get adjusted? For example, let's take two vendors: HARDWARE SUPPLY SHOP ABC HARDWARE USA, INC. Propercase will turn them into: Hardware Supply Shop (this is good) Abc Hardware Usa, Inc. (this is "okay") Prefer...

I'm looking for an efficient way to build this selection. I have a table with vendor number. Problem is the value is actually an alpha value (9 char, right justifed, left padded with spaces). So, vendor 1234 is really ' 1234'. I have a report where the user could enter (optionally) a...

I have two groups in my report. Let's call them Company (group 1) and Division (group 2), with detail division records in the main report. Group 2 Header is blank, but I want to leave it in because it provides a nice visual break between the Group 2 footer subtotal and the start of the next...

I had a post yesterday where I have two report footer subreports that I wanted to appear back-to-back vertically. I got the tip of splitting them into their own report footers (i.e., RF_a and RF_b). Now, in a few scenarios, I have a new situation to address. It occurs when subreport2 is more...

I have a report with two subreports in the Report Footer. Each subreport calls a unique table (with distinct information) based on one parameter in the main report. For example, it might be "ITEM ID" in the main report. Subreport1 shows the item history for the past week. Subreport2 shows...

I am close, but I can't get past this hurdle. Using the following MSDN website: http://msdn.microsoft.com/en-us/library/cc837974.aspx#MergeDataFromMultipleWorkbooks_MergingRangefromAllWorkbooks I have working code for merging multiple workbooks into one summary workbook. However, the code...

I've searched all over for this and do not have an answer. I have your standard financial report with Actual and Budget numbers. Then, I have a calculated "difference" column showing the dollar variance. The issue is that, for this report, I want this report to sort based on this variance -...

I have a table with financial information with the following (basic) layout: Year, GL Account, January, February, March,...December. So, for GL Account 40000, you might see: 2007, 40000, $100, $110, $90,....$150 2008, 40000, $105, $120, $95,....$160 The report will show the current...