Viewing 15 posts - 31 through 45 (of 84 total)
Hello,
Appears as:
NLD|Y7744||1315.53|10/06/2013
June 11, 2013 at 5:56 am
I have attached a screenshot of my report. I have cleaned out the AccountNames though!
Now currently the user can select a Year and Period and a depot and a CountyCode.
Rather...
June 10, 2013 at 9:25 am
Hi Sean
Thanks for your help so far.
The Parameters I am tryin to pass are:
@Year @Period , @Depot @CountryCode
The actual report is a matrix report. The fields are:
...
June 10, 2013 at 8:57 am
Customer Table
CREATE TABLE [dbo].[InstrastatCustomers](
[AccountID] [int] IDENTITY(1,1) NOT NULL,
[Company] [int] NULL,
[Depot] [int] NULL,
[AccountNumber] [varchar](30) NULL,
[AccountName] [varchar](50) NULL,
[CountryCode] [int] NULL,
[ContractCode] [int] NULL,
)
INSERT INTO [dbo].[InstrastatCustomers]
...
June 10, 2013 at 3:20 am
Customer Table Sample Data:
001|08|C3000|Company1|014|6020
001|08|C3001|Company2|014|6020
001|08|C3002|Company3|014|6030
001|08|C3003|Company|014|6030
001|08|C3004|Company5|014|6030
001|08|C3005|Company6|014|6030
001|08|C3006|Company7|014|6030
Sales Table Sample Data:
01|C3000|2013|1| 9191.16| 7335.65
01|C3001|2013|1| 0.00| 0.00
01|C3002|2013|1| ...
June 7, 2013 at 3:14 am
Apologies: Below are the full table structures, sql, datasets i am using
Customer Table:
AccountID int Primary Key
Company int
Depot ...
June 6, 2013 at 10:48 am
Thanks for reply.
My table structure is:
SalesID int Primary Key.
Company ...
June 6, 2013 at 9:50 am
Thanks Guys. Cant believe i missed that. It was the column names in first data row.
May 16, 2013 at 8:53 am
Viewing 15 posts - 31 through 45 (of 84 total)