I enjoyed watching this video and recommend others to watch. Host explains how to create Report using Query Builder. Thanks for educating the community and appreciate your efforts. Thanks a bunch
Joined tables query: SELECT Person.SalesPersonFName, Person.SalesPersonLName, Region.RegionCD, Region.Region, COUNT(Region.RegionID) AS RegionID_Count FROM Region INNER JOIN Person ON Region.RegionID = Person.RegionID GROUP BY Person.SalesPersonFName, Person.SalesPersonLName, Region.RegionCD, Region.Region HAVING (Region.RegionCD = 'AS') ORDER BY Person.SalesPersonFName, Region.RegionCD DESC
It would have been helpful if you would have provided the scripts to create and populate the dbo.Region and dbo.Person table. Here they are: --CREATE AND POPULATE TABLE dbo.Region CREATE TABLE [dbo].[Region]( [RegionID] [int] NOT NULL, [Region] [varchar](100) NULL, [RegionCD] [varchar](100) NULL ) ON [PRIMARY] GO INSERT INTO [dbo].[Region] ([RegionID] ,[Region] ,[RegionCD]) VALUES ( 1 ,N'Asia' ,N'AS' ) , ( 2 ,N'Europe' ,N'EU' ) , ( 3 ,N'North America' ,N'NA' ) GO --CREATE AND POPULATE TABLE dbo.Person CREATE TABLE [dbo].[Person]( [id] [int] NOT NULL, [SalesPersonFName] [varchar](50) NULL, [SalesPersonLName] [varchar](50) NULL, [RegionID] [int] NULL ) ON [PRIMARY] GO INSERT INTO [dbo].[Person] ([id] ,[SalesPersonFName] ,[SalesPersonLName] ,[RegionID]) VALUES
I enjoyed watching this video and recommend others to watch.
Thanks for educating the community and appreciate your efforts.
Thanks a bunch
I enjoyed watching this video and recommend others to watch.
Host explains how to create Report using Query Builder.
Thanks for educating the community and appreciate your efforts.
Thanks a bunch
Basics of Query Builder
Interesting video
Thanks a lot
Thank you.
never knew i can import rdls
Joined tables query:
SELECT Person.SalesPersonFName, Person.SalesPersonLName, Region.RegionCD, Region.Region, COUNT(Region.RegionID) AS RegionID_Count
FROM Region INNER JOIN
Person ON Region.RegionID = Person.RegionID
GROUP BY Person.SalesPersonFName, Person.SalesPersonLName, Region.RegionCD, Region.Region
HAVING (Region.RegionCD = 'AS')
ORDER BY Person.SalesPersonFName, Region.RegionCD DESC
It would have been helpful if you would have provided the scripts to create and populate the dbo.Region and dbo.Person table. Here they are:
--CREATE AND POPULATE TABLE dbo.Region
CREATE TABLE [dbo].[Region](
[RegionID] [int] NOT NULL,
[Region] [varchar](100) NULL,
[RegionCD] [varchar](100) NULL
) ON [PRIMARY]
GO
INSERT INTO [dbo].[Region]
([RegionID]
,[Region]
,[RegionCD])
VALUES
(
1
,N'Asia'
,N'AS'
)
,
(
2
,N'Europe'
,N'EU'
)
,
(
3
,N'North America'
,N'NA'
)
GO
--CREATE AND POPULATE TABLE dbo.Person
CREATE TABLE [dbo].[Person](
[id] [int] NOT NULL,
[SalesPersonFName] [varchar](50) NULL,
[SalesPersonLName] [varchar](50) NULL,
[RegionID] [int] NULL
) ON [PRIMARY]
GO
INSERT INTO [dbo].[Person]
([id]
,[SalesPersonFName]
,[SalesPersonLName]
,[RegionID])
VALUES
(
1
,N'Aamir'
,N'Shahzad'
,1
)
,
(
2
,N'M'
,N'Raza'
,1
)
,
(
3
,N'Christy'
,N'Ladson'
,1
)
,
(
4
,N'John'
,N'Rivers'
,1
)
,
(
5
,N'Najaf'
,N'Ali'
,2
)
,
(
6
,N'Sukhjeet'
,N'Singh'
,2
)
,
(
7
,N'Chirag'
,N'Patel'
,2
)
,
(
8
,N'Aleena'
,N'Aman'
,2
)
,
(
9
,N'Petra'
,N'Henry'
,NULL
)
,
(
10
,N'Rita'
,N'Roger'
,3
)
,
(
11
,N'Tamara'
,N'Tony'
,3
)
GO
Thank for sharing the script. Most of the time I do have them on website. please check www.techbrothersit.com/search/label/SSRS%20Video%20Tutorial