Search results for query: *

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

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

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

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

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

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

yeah, Thanks!

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

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.

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

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.

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

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

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

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

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

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

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