22:00 dynamic column adding part in SSRS is at - uses Matrix. Thank you. I was trying to send pivoted results to SSRS, and didn't know how to handle the columns, but one does not have to as the Matrix structure will handle the unpivoted data for you.
Thank you so much! I am learning your technique how to create stored.proc in this video. Also i like the fact that you are making mistakes and then troubleshoot it in front of audience... for us to learn what has happened :-)
Hello Aamir, thanks for all the videos for SSRS. I find it very helpful. I referred the query given by you, but I am having difficulty understanding the 4th line from last - Exec sp_executesql @SQL; I don't see if we have already created the procedure earlier in the video/query. your help is much appreciated! Thanks
Hi Amit, thanks for kind words. I am not creating any stored procedure, the Exec sp_executesql @SQL; line is executing the code that is saved in @SQL variable. If you notice I have DECLARE @SQL NVARCHAR(MAX)=' ' , that means I am saving all query in @SQL variable before execute. I hope this help. All the best.
Hi Kris, thanks for leaving the comments. I am not sure why I should redo this report. There are already 5k views and 6 likes, seems like this is working for people. I would like to know more details what problems you see and I might be able to resolve in another video.
I step back. Retain this video. Create another clean video. There were too many back and forth steps where user get confused and looses focus on the subject matter that you are expressing.. I know that you are expressing that how the life in SQL is but our focus is on Report. So just do the same with few steps expressing the subject. If you have not understood my statements please let me know know that I can explain again. When you make another video retain same title of the video and at the end add one of these words CONCISE or SHORT FORM or COMPRESSED Thanks a lot
@@TechBrothersIT I like seeing that you get similar errors we are bound to see. Sure of everything goes good then your video has some fluff.. But when we issues this helps understand the thought process behind troubleshooting. 100% awesome
I am facing error "invalid object name ##temp.(Microsoft SQL server,error 208)" at SSRS dataset creation ,while my Stored procedure working perfect at SSMS.Please help me to resolve this.
Try putting database prefix - This error happens primarily due to database context mismatching. When people open SSMS, they usually do not notice that their default database context is set to master in the most of the cases. We just have to change the database context to whatever database our current object is and everything will start working immediately.
This was just what I need to help me resolve an issue I was having. Thanks!
22:00 dynamic column adding part in SSRS is at - uses Matrix. Thank you. I was trying to send pivoted results to SSRS, and didn't know how to handle the columns, but one does not have to as the Matrix structure will handle the unpivoted data for you.
Thank you for this very interesting topic, one question what if I need to group by some of the columns, how would I do that dynamically? Thanks
Thank you so much! I am learning your technique how to create stored.proc in this video. Also i like the fact that you are making mistakes and then troubleshoot it in front of audience... for us to learn what has happened :-)
Glad to hear that you learnt the way I tried to explain. Thanks for watching and support.
Very good.
Thank you
Helpful video
Thanks
this is help full thanks ! but , what if the datatype column have 'datetime ' data type . how will i handle the conversation of data type ?
Great! Thank you!
Great
Thanks. I have a scenario to execute stored procedure with dynamic columns with SSRS?
Hello Aamir,
thanks for all the videos for SSRS. I find it very helpful.
I referred the query given by you, but I am having difficulty understanding the 4th line from last - Exec sp_executesql @SQL;
I don't see if we have already created the procedure earlier in the video/query.
your help is much appreciated!
Thanks
Hi Amit, thanks for kind words. I am not creating any stored procedure, the Exec sp_executesql @SQL; line is executing the code that is saved in @SQL variable. If you notice I have DECLARE @SQL NVARCHAR(MAX)=' ' , that means I am saving all query in @SQL variable before execute. I hope this help. All the best.
Thank Good job
You are welcome, thanks for watching.
ɷ Heeyy Frienddsss I Have Foundddd W0rikinggg Online Hacck visittt : - t.co/vOFsUFqOI7
Thanks...very usefull
Thanks!
Plz give me some clue how can i implement this scenario in RDLC report
is there anyway to reorder the columns? the output is in alphabetical order, as opposed to the order that the columns may be in within sql?
I think you should redo this video. Users may not like or get confused
Hi Kris, thanks for leaving the comments. I am not sure why I should redo this report. There are already 5k views and 6 likes, seems like this is working for people. I would like to know more details what problems you see and I might be able to resolve in another video.
I step back.
Retain this video.
Create another clean video.
There were too many back and forth steps where user get confused and looses focus on the subject matter that you are expressing..
I know that you are expressing that how the life in SQL is but our focus is on Report.
So just do the same with few steps expressing the subject.
If you have not understood my statements please let me know know that I can explain again.
When you make another video retain same title of the video and at the end add one of these words CONCISE or SHORT FORM or COMPRESSED
Thanks a lot
Hi Kris, Sure, I will take a look and will do more videos on this topic. Hope all going well with you!
@@TechBrothersIT I like seeing that you get similar errors we are bound to see. Sure of everything goes good then your video has some fluff.. But when we issues this helps understand the thought process behind troubleshooting. 100% awesome
How to show 10 record per page in this approach. Rownumber and ceiling are not working in this. Thanks in advance
Can anyone help me with this?
Can any one help me with this?
I am facing error "invalid object name ##temp.(Microsoft SQL server,error 208)" at SSRS dataset creation ,while my Stored procedure working perfect at SSMS.Please help me to resolve this.
Try putting database prefix - This error happens primarily due to database context mismatching. When people open SSMS, they usually do not notice that their default database context is set to master in the most of the cases. We just have to change the database context to whatever database our current object is and everything will start working immediately.
You mind sharing TSQL code of your SP?