SQL SERVER – Building Interactive Reports in Quick Moments – From CSV to Excel Pivot Table – A Conversation turned to Webinar

12 years ago

“I have text files and I need to create interactive reports for my boss – do you have few minutes of time right now? Let us discuss.”

I often get questions from people who are new to technology and struggling to get something done. However, this time it was not a question from any beginner. This question was from an expert – a friend and an excellent technologist. Wiqar and I have known each other for a long time and often discuss various technologies. He works at expressor Technologies as a product manager and has built the complete product using .NET framework (woohoo!).

I received his message on Messenger and my reaction was “yeah, let us discuss it.” Well, we talked for about an hour and ended up with a fantastic outcome. When we were done with our conversation we realized that we had multiple technologies and ended up one great resolution. We did not exactly know what his boss needed so we wanted to build a report in such a way that his boss can customize it and generate new reports.

Wiqar and I had a great experience while discussing this integrating/reporting issue. We live around 20,000 KM away from each other and are separated by a 12 hour time difference. He works in .Net predominantly and I work on SQL Server. He has built a product which natively connects with SQL Server, Excel, Powerpoint as well other technologies like QlikView, Mellisa Data etc. I am glad to have such a wonderful friend. While we were talking about what a good experience we had, he suggested that we should convert our friendly discussion into a quick learning experience. I agreed with him right away.

This webinar is not going be like a usual webinar. This is a conversation between two friends in a real world environment. We are going to keep the real problem in front of us and build reports from CSV in only a few minutes. We will see how an innocent looking CSV becomes an interactive report. Together we will be discussing the subject in webinar format. I hope you will enjoy our conversation and we will be looking forward to your questions and additional feedback during the seminar.

Conversation of Wiqar and Pinal CSV to Interactive Report
Feb 16, 2pm EST – Register at https://t.co/EFsfd27L

UPDATE: I have embedded the video of the conversation over here.

[Original poster have removed the video]

Reference: Pinal Dave (https://blog.sqlauthority.com)

SQL Utility

SQLAuthority News – Business Intelligence features of SQL Server 2012 RC0 – Download Virtual Machine

SQL SERVER – T-SQL Errors and Reactions – SQL in Sixty Seconds #002 – Video

9 Comments. Leave new

Ganesh Narim
February 13, 2012 9:02 am

Hi Pinal,

Good morning,

It is not opened. after registration also it will not show the conversation. Please check it out.

Reply
- pinaldave
  February 13, 2012 9:53 am
  
  Hi Ganesh,
  
  If you are registered you will get email soon with the link.
  
  Reply
Ganesh Narim
February 13, 2012 1:40 pm

Pinal,

after clicking the link it shows like this

“Come Back Later
This Webinar is not yet open to attendees. Please come back at the scheduled time below.

expressor 3.5.2 GA Webinar with guest speaker Pinal Dave
Thursday, February 16, 2012 2:00 PM – 3:00 PM EST”

Reply
- pinaldave
  February 13, 2012 2:49 pm
  
  Ganesh,
  
  That is exactly I wrote in my blog post.
  
  Reply
Ganesh Narim
February 13, 2012 3:24 pm

Hi Pinal,

Ok i’ll wait for that,

Thanks for your reply.

Can i ask one help..???

Reply
Ganesh narim
February 13, 2012 7:23 pm

Hi pinal,

can you please help me in this,
i have one scenario

having table like this

(1,’AAA’,’BBB’,’CCC’),
(2,’DDD’,’EEE’,’FFF’),
(3,’GGG’,’HHH’,’III’),
(4,’AAA’,’BBB’,’CCC’),
(5,’DDD’,’EEE’,’FFF’),
(6,’GGG’,’HHH’,’III’),
(7,’AAA’,’BBB’,’CCC’),
(8,’DDD’,’EEE’,’FFF’),
(9,’JJJ’,’KKK’,’LLL’),
(10,’JJJ’,’KKK’,’LLL’)

desired result:-

1 GroupA
4 GroupA
7 GroupA
2 GroupB
5 GroupB
8 GroupB
3 GroupC
6 GroupC
9 GroupD
10 GroupD

Reply
bhupendra tailor
February 17, 2012 6:26 pm

Hi pinal,

Please can send me simple example to written a trigger.

Thanks.

Reply
- Velmurugan P
  February 24, 2012 3:56 pm
  
  Hi Ganesh,
  
  Try the following code… it must work…..
  
  declare @id1 int,@grps varchar(150),@i int,@TXT VARCHAR(15)
  DECLARE @TBL TABLE(ID INT,GROUPS VARCHAR(150),GROUP_NAME VARCHAR(150))
  
  set @i=65
  SET @TXT=’GROUP’
  
  declare result cursor for
  SELECT t.id, t.g1+’,’+t.g2+’,’+t.g3 as Groups from grouptest t with(nolock)
  OPEN result
  fetch next from result into @id1,@grps
  WHILE(@@FETCH_STATUS=0)
  BEGIN
  IF EXISTS(SELECT 1 FROM @TBL WHERE GROUPS=@grps)
  BEGIN
  INSERT INTO @TBL(ID,GROUPS,GROUP_NAME)
  (SELECT TOP 1 @id1,@grps,GROUP_NAME FROM @TBL WHERE GROUPS=@grps)
  END
  ELSE
  BEGIN
  INSERT INTO @TBL(ID,GROUPS,GROUP_NAME)
  SELECT @id1,@grps,(@TXT+CONVERT(VARCHAR,CHAR(@i)))
  SET @i=@i+1
  END
  
  fetch next from result into @id1,@grps
  END
  CLOSE RESULT
  DEALLOCATE RESULT
  
  SELECT ID,GROUP_NAME FROM @TBL
  ORDER BY GROUP_NAME
  
  Thanks,
  Velmurugan P
  
  Reply
deeray82
February 2, 2013 12:39 am

Pinal, I’d love to watch this embedded video, but it seems to be set to private. Help please?

Reply