Search results for query: *

Thank you hilfy, that did solve most of the issues, but I am not home free yet. I grouped on a concatenated field of check#, check sequence number, and name. The idea of using a maximum as a total worked great for the most part. However, the data set has both positive and negative numbers in...

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 have RunNo, Sequence and Weight as below, and need to produce RunNum per the rules above RunNo Sequence Weight RunNum AZ15123 1 42.5 AZ15123A AZ15123 2 41.7 AZ15123B AZ15124 1 82.0 AZ15124 AZ15125 1 81.3 AZ15125 AZ15126 1...

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

Thanks, that is working great.

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

Thank you, that worked like a charm!

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

I followed Skip's suggestion in #1 and made sure anything that did not say "don't move" said so. That mostly fixed the problem. When the macros are run, the buttons still move according to my user. But when she reopens the document, they are where they need to be. Works for us.

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

This is what the SQL looks like: "SELECT V_EMPLOYEE.FILE#, V_EMPLOYEE.SOCIALSECURITY#, V_EMPLOYEE.NAME, V_BANKING_INFO.SOCIALSECURITY#, V_EMPLOYEE.COMPANYCODE, V_EMPLOYEE.STATUS FROM REPORTS.V_EMPLOYEE V_EMPLOYEE, REPORTS.V_BANKING_INFO V_BANKING_INFO WHERE...

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