Search results for query: *

I am building a report to return payroll data with one line per paycheck. There will be a column for each earnings type. It will be zero of the employee had no earnings of that type, and populated once if he did. The data is structured with one line for every earnings type. CHK#, CHKSEQ#...

I need to join on table to various others, but need to create the field to do so. Table P contains fields: RunNo, sequence, weight. I need to build the field RunNum, and use it for joins. There is always a sequence 1 for each RunNo, but there can be a sequence 2 or 3 as well. If there is a...

I have two tables, SALES and INVENTORY. In INVENTORY, I have PART_CODE and QUANTITY_ON_HAND. There is a record for each individual item; if I have 25 in stock of an item, I have 25 records. In SALES I have YEAR, PART_CODE and QUANTITY_SOLD. I have a QUANTITY_SOLD for each item I have sold...

I am working with a model in Microsoft Reporting Services Report Builder 3.0. I need to take a string date field from the model that is formatted mm/dd/yyyy hh:mm:ss and display it as only hh:mm:ss. Please advise as to how that can be accomplished.

I am trying to develop an extended price for an order report. The hitch is that a single order line may refer to a single quantity of one product that needs to be split out into four or more different ledger accounts. Here is an example of some data, as I want it to display. OrderNo...

I have a report that uses data from two tables containing header data, with a linking table containing detail data used solely to create the relationship between the two header tables. Call one CustomerInvoiceHeader, the second CustomerOrderHeader, and the third LinkOrderInvoice. I need one...

I am trying to figure out how to get the appropriate data to appear on a report and need help. I have data that looks like this. TransNo ActedOn Date 123221 Mary 9/1/2012 8:15 123221 John 9/1/2012 22:15 123221 Fred 9/1/2012 18:15 123222 Mary 9/1/2012 9:15 123222 Fred 9/1/2012 21:13 I need one...

I want to display my report header, my page header, some grouped non-dollar statistical data, then another area where I insert additional statistics that come from formulas where I don't have any data in the main column to group by. Next I want to insert headings for $Cost and $Unit. Then I...

This may not be the right forum; please feel free to repost to one more appropriate. We have recently begun using Microsoft Report Builder 3.0. When we export reports to Excel and wish to further manipulate data, it is not working out well. We cannot do a data sort/data subtotal as we could...

We have had 35 macros in a particular Excel spreadsheet for many years; well prior to Excel 2003. Each macro is on top of one of 35 different data columns. We upgraded to Windows 7 and Excel 2010 a few months back. Now when we press the macro keys, they begin to resize and move. It appears...

I am using Crystal 2008. I have two tables. First table has all employees. Second table has their banking information. I want to obtain the population of all employees with no banking information. I have links on employee#, SSN, etc. What kind of join should these tables/links have? I have...

I need to change a large number of regularly formatted dates in Excel 2007, like 03/08/1997, into yyyymmdd format 19970308. Doing it with the custom format feature is not sufficient, as the actual data needs to be converted to have content saying 19970308. I did a =year(), =month(), and...

I am trying to write a projected receipts aging report by week. All weeks are specifically numbered, begin on Sunday, and end on Saturday. My buckets need to be 1 ($ in openAmount field due prior to this week, plus anything due this fiscal week), 2 (due next fiscal week), 3 (due next fiscal...

I am having a similar problem to the user in thread131-1550453. I recently reinstalled reportsmith on a PC. I installed it from our payroll server, logged on as myself, since rights to our payroll server are limited. The installation went smoothly, and the software works fine FROM MY WINDOWS...

I have a report where I would like the user to be able to select all records based upon the field {Parts.PartNo}. This field will not always have data in it, and it is string data. I'd like them to be able to free text for a particular part#, such as J123, select multiple part numbers, select...

I have a report for sales orders and am trying to add a price component from a new table. OrderTable: OrderNo OrdLine Units PricePerUnit 1234 1 15 20.00 1234 2 12 22.00 1237 1 11 21.00 PricingTable: OrderNo OrdLine...

I have a report with a parameter identifying it as detail or summary. For the summary version I have one group in my report; vendor ID. I want to be able to subtotal by that group, in group decending order. That part works fine. Next, based upon choosing a detail parameter, I need the report...

I am writing a report that shows employee loan payments. This formula worked fine when employees could only have 2 open loans at once. My approach is not working when trying to get data to go to a third set of columns. This is the loan calculation: Local NumberVar SumDedJ := Sum ({@DedJ}...

I have a report with multiple fields on it. Each field is required to be a specified width upon export, whether it is text or numeric. All numeric fields are to have leading zeros to fill in the required field size of 9. All numeric fields must be multiplied by 100 so there are no decimals...

How should I go about this? Data is structured like this: Last_Yrs_Sls Customer Order# Order_Amt $25000 ABCD 1212 $ 2500 $25000 ABCD 1213 $ 2000 I am grouping on customer, and entering a subtotal for the group for order amount. I want to be able...