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

“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 (http://blog.sqlauthority.com)

About these ads

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

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

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

    • 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

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s