tag:blogger.com,1999:blog-233187136454569065.post6699924202959746019..comments2023-09-15T15:06:55.514+05:30Comments on Sonali's Blog: Dynamic Column RDLsSonali Mendishttp://www.blogger.com/profile/08997949638768111953noreply@blogger.comBlogger33125tag:blogger.com,1999:blog-233187136454569065.post-53161869131339300822021-04-06T01:57:00.723+05:302021-04-06T01:57:00.723+05:30Thank you so much for this easy to understand arti...Thank you so much for this easy to understand article!Randallhttps://www.blogger.com/profile/07617518179424669960noreply@blogger.comtag:blogger.com,1999:blog-233187136454569065.post-78579976901232798122018-12-13T13:30:39.554+05:302018-12-13T13:30:39.554+05:30Thank you VERY VERY MUCH!
You saved my Day! :)Thank you VERY VERY MUCH! <br />You saved my Day! :)Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-233187136454569065.post-57315028360035661152017-12-22T02:52:14.881+05:302017-12-22T02:52:14.881+05:30Thank you for this post! This worked wonderfully. ...Thank you for this post! This worked wonderfully. Very grateful.Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-233187136454569065.post-64700713671356642182017-03-15T14:54:21.636+05:302017-03-15T14:54:21.636+05:30I've just implemented this and it works great!...I've just implemented this and it works great! I have an unknown number of views created dynamically, each having an unknown number of columns. This allows the user to select any of the views in the report. Thanks.Stevenoreply@blogger.comtag:blogger.com,1999:blog-233187136454569065.post-21772553018863056782015-08-08T02:52:58.232+05:302015-08-08T02:52:58.232+05:30AWESOME post...saved me a lot of grief. I've ...AWESOME post...saved me a lot of grief. I've used this combined with a stored procedure to provide a report served up through an ASP.NET web forms application.Markhttps://www.blogger.com/profile/14720740829872126529noreply@blogger.comtag:blogger.com,1999:blog-233187136454569065.post-70548862279883946432015-06-25T14:55:09.602+05:302015-06-25T14:55:09.602+05:30ok its fine but can we generate a report in asp.ne...ok its fine but can we generate a report in asp.net c# using reporting tool RDLC?<br />Anonymoushttps://www.blogger.com/profile/00009346310710892162noreply@blogger.comtag:blogger.com,1999:blog-233187136454569065.post-48752030849602033352015-06-01T21:35:41.969+05:302015-06-01T21:35:41.969+05:30understood the concept. If you can add a project w...understood the concept. If you can add a project with the report that would be helpful. Anonymoushttps://www.blogger.com/profile/18235153815931427459noreply@blogger.comtag:blogger.com,1999:blog-233187136454569065.post-77405761663624977862015-05-19T19:49:34.027+05:302015-05-19T19:49:34.027+05:30After repeatedly being told that it wasn't pos...After repeatedly being told that it wasn't possible, this was perfect. I just wish I could figure out how to make the column headings appear on every page.Anonymoushttps://www.blogger.com/profile/10274836749657451905noreply@blogger.comtag:blogger.com,1999:blog-233187136454569065.post-35978451332358688582015-02-20T07:26:51.671+05:302015-02-20T07:26:51.671+05:30Thanks!!Thanks!!Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-233187136454569065.post-88383686319795032782014-01-28T14:44:11.180+05:302014-01-28T14:44:11.180+05:30The matrix component can be used to pivot a table....The matrix component can be used to pivot a table. Lets say as an example we have a dataset where it contains employee attributes such as name, age, address, designation, dob etc as name value pairs. I.e. a particular employees particular attribute is a row (EmployeeID | Attribute Name | Attribute Value). So, by using matrix component you can convert (pivot) those attributes to columns and show. Anonymoushttps://www.blogger.com/profile/02974232870894186828noreply@blogger.comtag:blogger.com,1999:blog-233187136454569065.post-35396291867277393062013-09-30T17:21:17.740+05:302013-09-30T17:21:17.740+05:30Dear Sonali,
If you can not compromise on the str...Dear Sonali, <br />If you can not compromise on the structure of the table, then how is it possible to create columns dynamically / on run time. I mean if you have to show the data in table's columns rather than matrix's rows. Hope you got my question!Faisal Ahmad Khanhttps://www.blogger.com/profile/06248138697879982094noreply@blogger.comtag:blogger.com,1999:blog-233187136454569065.post-16353835282483550122013-02-22T21:48:29.743+05:302013-02-22T21:48:29.743+05:30I don't entirely understand how this works? I...I don't entirely understand how this works? If I simply have a "SELECT * FROM Table1" for my dataset and my report displays all columns, how would I do this? Would I have to modify my dataset output to match above? It doesn't make sense to me.Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-233187136454569065.post-62715617863431853682012-12-28T01:06:07.825+05:302012-12-28T01:06:07.825+05:30Thank you - I think you just saved me - Hopefully ...Thank you - I think you just saved me - Hopefully - Mikenoreply@blogger.comtag:blogger.com,1999:blog-233187136454569065.post-36529924792003925712012-10-12T19:51:53.637+05:302012-10-12T19:51:53.637+05:30Hi, How to dynamically add new columns to report c...Hi, How to dynamically add new columns to report created with Reporting Services? How to dynamically add new columns to report rdlc? I want to use the rdlc very times with different information.<br />Thank you!!!Anonymoushttps://www.blogger.com/profile/03034371276218538709noreply@blogger.comtag:blogger.com,1999:blog-233187136454569065.post-55050539998373426542012-10-10T18:06:57.011+05:302012-10-10T18:06:57.011+05:30Hi, Thanks for vaulable post. Wondering if we don&...Hi, Thanks for vaulable post. Wondering if we don't know the column names and number of columns at design time, I mean, the number of columns and table differs at runtime then how would we arrive with a dataset with following structure?<br />Column Name (col_name) , Column Value (col_value)<br /><br />If someone can post the t-sql query for above format, it would be great help. Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-233187136454569065.post-50394336419601916732012-10-10T16:40:22.532+05:302012-10-10T16:40:22.532+05:30This comment has been removed by the author.jitenderhttps://www.blogger.com/profile/16326358659645051783noreply@blogger.comtag:blogger.com,1999:blog-233187136454569065.post-50580534773947503632012-09-14T07:42:59.154+05:302012-09-14T07:42:59.154+05:30Thanks a lot for the article.Thanks a lot for the article.Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-233187136454569065.post-6854013355524573162012-09-13T19:36:04.186+05:302012-09-13T19:36:04.186+05:30Nothing is useless dude...Nothing is useless dude...Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-233187136454569065.post-66042372255924557892012-09-10T19:39:58.720+05:302012-09-10T19:39:58.720+05:30thanks alot for your post,i have a question how i ...thanks alot for your post,i have a question how i can color the record that contains an employes whose age is greater than 25 for example with Red Color ?<br />as i am new to SSRS ,i know that i can do that by the background color expression <br />=IIF(Fields!Age.Value > 25, "Red", "White")<br />but this is with static columns ,how can i do that with the dynamic ones?Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-233187136454569065.post-32157601069723234112012-08-31T06:51:55.187+05:302012-08-31T06:51:55.187+05:30That's of course if the Designation is a many-...That's of course if the Designation is a many-to-many relationShay Nhttps://www.blogger.com/profile/15645110518526453755noreply@blogger.comtag:blogger.com,1999:blog-233187136454569065.post-84223183250411063762012-08-31T06:48:55.523+05:302012-08-31T06:48:55.523+05:30My guess will be:
SELECT emp_id, 'Name' A...My guess will be:<br /><br />SELECT emp_id, 'Name' AS [col_name], Name AS [col_value]<br />FROM empTable<br />UNION<br />SELECT emp_id, 'Age', Age<br />FROM empTable<br />UNION<br />SELECT t1.emp_id, 'Designation', ed.designation<br />FROM (<br /> SELECT e.emp_id, des.id, des.title<br /> FROM empTable e FULL OUTER JOIN designation des ON des.Title IS NOT NULL<br /> ) AS [Shay Nhttps://www.blogger.com/profile/15645110518526453755noreply@blogger.comtag:blogger.com,1999:blog-233187136454569065.post-75782195178698502042012-08-31T06:37:28.593+05:302012-08-31T06:37:28.593+05:30Thanks! helped tremendously!!Thanks! helped tremendously!!Shay Nhttps://www.blogger.com/profile/15645110518526453755noreply@blogger.comtag:blogger.com,1999:blog-233187136454569065.post-23045841062975554952012-08-31T02:32:57.934+05:302012-08-31T02:32:57.934+05:30hi,
could you share the DB sql query that resulted...hi,<br />could you share the DB sql query that resulted the following query results in the format you mentioned above ?<br /><br />Employee ID (emp_id) ,Column Name (col_name) , Column Value (col_value)Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-233187136454569065.post-62556402157692784662012-08-14T17:41:19.163+05:302012-08-14T17:41:19.163+05:30you saved my life ;-) thxyou saved my life ;-) thxAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-233187136454569065.post-67124684136104194652012-08-10T00:19:54.814+05:302012-08-10T00:19:54.814+05:30Thank you very much! This is exactly what I needed...Thank you very much! This is exactly what I needed!Anonymousnoreply@blogger.com