tag:blogger.com,1999:blog-1661221027110337510.post1741508716424089406..comments2019-09-11T03:31:23.068+01:00Comments on SQL Server, SSRS and Crystal Reports: Display dataset query in the report - SSRSDom Hortonhttp://www.blogger.com/profile/04194530098048137883noreply@blogger.comBlogger11125tag:blogger.com,1999:blog-1661221027110337510.post-27557117425352835302013-08-30T19:34:08.754+01:002013-08-30T19:34:08.754+01:00It does not display the values of parameters - Can...It does not display the values of parameters - Can it be done?Pavithrahttps://www.blogger.com/profile/08043155572749075359noreply@blogger.comtag:blogger.com,1999:blog-1661221027110337510.post-87262535922542134932012-08-08T09:34:03.005+01:002012-08-08T09:34:03.005+01:00No worries James. Glad it was of use. Not been blo...No worries James. Glad it was of use. Not been blogging much lately...the birth of my first son has taken precedence!Dom Hortonhttps://www.blogger.com/profile/04194530098048137883noreply@blogger.comtag:blogger.com,1999:blog-1661221027110337510.post-8134374644592732692012-08-06T20:16:00.496+01:002012-08-06T20:16:00.496+01:00Thanks for posting this. Was struggling with debug...Thanks for posting this. Was struggling with debugging a query. My error was obvious once I was able to see the query.Jameshttp://jamesdocs.blogspot.comnoreply@blogger.comtag:blogger.com,1999:blog-1661221027110337510.post-54360055017897357912012-04-02T17:28:11.360+01:002012-04-02T17:28:11.360+01:00Gaston,
glad it's been of useGaston,<br />glad it's been of useDom Hortonhttps://www.blogger.com/profile/04194530098048137883noreply@blogger.comtag:blogger.com,1999:blog-1661221027110337510.post-57035889074429389502012-04-02T08:10:58.830+01:002012-04-02T08:10:58.830+01:00Thanks for the replies!
I used
=datasets!DataSet...Thanks for the replies!<br /><br />I used <br />=datasets!DataSet1.CommandText<br /><br />In the expression editor the CommandText property is red underlined, but is seems to work in the report anyway. <br /><br />Best regards,<br />GastonGastonhttp://www.f-a-q.benoreply@blogger.comtag:blogger.com,1999:blog-1661221027110337510.post-18187946249132148282011-04-12T15:39:44.633+01:002011-04-12T15:39:44.633+01:00Thanks Dom. I'll look into the RewrittenComma...Thanks Dom. I'll look into the RewrittenCommandText.<br /><br />Anonymous: I'm also using SSRS 2008 and the query I'm using is shown on the preview:<br /><br />="Query: " & vbcrlf & datasets!AutoGL.CommandText<br /><br />Maybe it has something to do with placement, or using the Data set in the Report.Unknownhttps://www.blogger.com/profile/12465423057278389956noreply@blogger.comtag:blogger.com,1999:blog-1661221027110337510.post-2895557194256913142011-04-12T09:59:54.890+01:002011-04-12T09:59:54.890+01:00Josh, this may help:
http://www.sqldev.org/sql-se...Josh, this may help:<br /><br />http://www.sqldev.org/sql-server-reporting-services/displaying-dataset-query-in-report-53077.shtml<br /><br />Anon, I'm using 2005 but not sure whether that has a bearing on thingsDom Hortonhttps://www.blogger.com/profile/04194530098048137883noreply@blogger.comtag:blogger.com,1999:blog-1661221027110337510.post-74940025860043728812011-04-11T15:10:02.715+01:002011-04-11T15:10:02.715+01:00Doesn't work for me in SSRS 2008 using BIDS 20...Doesn't work for me in SSRS 2008 using BIDS 2008. Just comes out blank for me. I'm using this expression <br />[code]<br />="SQL Query: " & DataSets!DataSet1.CommandText<br />[/code]<br />And yes my dataset is called DataSet1.Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-1661221027110337510.post-8698080077472563142011-04-04T23:38:42.532+01:002011-04-04T23:38:42.532+01:00Thanks Dom. I'm using that method now, but wa...Thanks Dom. I'm using that method now, but was curious if there was a way to display it in the query, and without having to specifically reference each parameter. It would be nice to have a single expression I could use as a template for any report.Unknownhttps://www.blogger.com/profile/12465423057278389956noreply@blogger.comtag:blogger.com,1999:blog-1661221027110337510.post-82945235508690985852011-03-28T09:56:21.269+01:002011-03-28T09:56:21.269+01:00Hi Josh,
thanks for the comments, this post shoul...Hi Josh,<br /><br />thanks for the comments, this post should help with <a href="http://sqlreportingservicescrystalreports.blogspot.com/2011/03/display-parameter-label-field-ssrs.html" rel="nofollow">displaying parameter values</a>Dom Hortonhttps://www.blogger.com/profile/04194530098048137883noreply@blogger.comtag:blogger.com,1999:blog-1661221027110337510.post-20659631892742767712011-03-24T19:09:27.080+00:002011-03-24T19:09:27.080+00:00Nice tip. Do you happen to know how to display th...Nice tip. Do you happen to know how to display the Parameters chosen in the Query also?Unknownhttps://www.blogger.com/profile/12465423057278389956noreply@blogger.com