Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. donalexander

    Lookup with multiple rowes

    Hello, I am using SQL Server 2014 I have two tables one is the item master the other customer sales. In the item master I have a column call item and from the customer sales I have the following columns customer, salesitem, salesAmount. The primary table is item master I want to show the all...
  2. donalexander

    Exporting to Excel give wrong total amount using custom code to total.

    Sorry, please see below for my post disregard old post. Thank you. Hello I am having an issue when exporting to Excel I am not getting the correct total amount. I get the correct amount on the screen or exporting to pdf. Below is my code Custom Code Public Shared Value as...
  3. donalexander

    Exporting to Excel Total Column is not correct, only when exporting to pdf.

    Hello Custom Code Public Shared Value as Integer=0Public Shared Function GetValue(Item as Integer) as Integer value= value + Item return Item End Function Public Shared Function GetTotal() return value End Function On the row to store the numbers I here is my code -...
  4. donalexander

    Custom code show zero instead of Grand Total amount, but when export the dollar amount is shown

    Hello, I am using 2014 SSRS I created a custom code to get Grand Totals for a monthly trend report, when I generate the report in IE I get zeros Grand Total amounts on the report, but when I export the report to Excel the Grand Total is shown and is correct. Why is this happening? How can I...
  5. donalexander

    Combine 9 SSRS reports into one report

    Jacque, That is what I did also, but I did not put rectangle in my report it comes out nice. I had to have the user be content without the subreports name. Thanks for taking the time in replying. At least I know I am not the only one doing that. Cheers
  6. donalexander

    Combine 9 SSRS reports into one report

    Hello, I am using SSRS - 2014 my IT manager challenge me to combine 9 reports into 1 report. In another words have the user just enter the dates of the report and press View Report all 9 reports will be printed. I am not sure how to go about it. Here is my idea: Create a SSRS report with...
  7. donalexander

    Upload from db2 data into SQL Server 2014

    yeah, Thanks!
  8. donalexander

    Upload from db2 data into SQL Server 2014

    Hello, I am running the latest version of iSeries (AS/400) I want to do a nightly upload into SQL Server table (2014). My problem is the invDate field is 6 digits (year/month/day): for the date 160620 is really 06/20/16. How do I get to read only today's date? Below is my code, but I...
  9. donalexander

    Simple Store Procedure to delete rows in SQL Server 2014

    Olaf, Thanks for guding me on now I have a better idea. You are right I think I better do Truncate then delete. I really appreciate the help. Thanks again.
  10. donalexander

    Simple Store Procedure to delete rows in SQL Server 2014

    Hello, I want to create a store procedure, which I have never done before and intimidating. I want to delete all the rows in a table my coding will be below USE [ATAS00_app] GO SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO --Delete rows in General Ledger table DELETE dbo.GLDetl Do I...
  11. donalexander

    Convert to date

    bibulous, fredericofonseca Thanks for the tip I appreciate your insight, but fredericofonseca what is the function even if it doesn't remove leading zeros. How would I code that as a sql statement for example I am using Select DateShip, ShipAmt From ShippedOrders Again thanks for your help.
  12. donalexander

    Convert to date

    Hello, I am using version db2 9.1 I need to convert numeric field that holds dates defined as DECIMAL (8,0) in YYYYMMDD format. I would like to convert it to MM/dd/YYYY.I would perferred to remove leading zeros in the month and day part. for example 7/3/2015 not 07/03/2015. any tips will be...
  13. donalexander

    Adding row when using lookup without a match

    Hello, I am using SSRS 2013 I have a budget report getting displaying actual sales amount for the month and Budget using lookup against the product line (Budget will look up the product line in Actual Sales). Works great, but if there is no actual for a given period than the lookup for the...
  14. donalexander

    lookup two fields in SSRS 2008R2

    Hello, I can do a lookup in SSRS 2008R2 for a single field to lookup on, but I have two fields to lookup on and I trying to figure it at. Can anyone assist me. For example Dataset1 I have two fields: "Company", "Storage Unit" I need to pick up "Amount" from Dataset2 that has "Company"...
  15. donalexander

    Get two sales item code exclusively from an invoice

    Thanks OlafDoschke looks like what I needed. Thanks again for your help I appreciate the tip.
  16. donalexander

    Get two sales item code exclusively from an invoice

    Hello, I am using 2008R2 SQL Server I am trying to get sales data with two particular sales item code (111, 222) what I am looking for if an invoice having both these sales item code exclusively with the invoice number (invno) Unfortunately I get invoices with 111 sales item code only or...
  17. donalexander

    Add data to SQL table from SSRS nightly subscrption run

    Hello, I am using the latest version of SSRS I have a report pulling data from AS400 on a nightly basis - subscription. What I want to do is have the data populate from the nightly run into a SQL table (already created) each night at least 4 rows will get updated to the table. I have no idea in...
  18. donalexander

    Create one row results from union all instead of two rows

    Hello, I am using the latest MySQL and I am doing a union all given me two rows result, but what I really want is to have my results in one line instead of two. Here are the following fields: Day of Week, Date, Month Number, Month Name, Day of the week, year, Total Calls, Answ, ABND, and...

Part and Inventory Search

Back
Top