tag:blogger.com,1999:blog-8413638223026049990.comments2023-01-11T04:09:04.172-05:00<center></center>Bob Pearsonhttp://www.blogger.com/profile/16528166535649336177noreply@blogger.comBlogger145125tag:blogger.com,1999:blog-8413638223026049990.post-41833635755631072442021-12-27T04:56:18.453-05:002021-12-27T04:56:18.453-05:00Thanks for sharing the article.Thanks for sharing the article.Nickhttps://ptk.in.ua/prise_gib-mashin-univers.phpnoreply@blogger.comtag:blogger.com,1999:blog-8413638223026049990.post-44168305820960511972021-01-10T19:13:50.305-05:002021-01-10T19:13:50.305-05:00Thank you, still useful after so many years!.
Btw,...Thank you, still useful after so many years!.<br />Btw, the following also works (but not as clean!):<br />[CustNum]=="" ? NULL(DT_WSTR, 4) : [CustNum]<br /><br />Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-8413638223026049990.post-91383382992826201902019-06-27T11:25:05.093-04:002019-06-27T11:25:05.093-04:00Thank you!!!!!!!Thank you!!!!!!!Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-8413638223026049990.post-32635380848838787372018-06-05T06:04:55.295-04:002018-06-05T06:04:55.295-04:00Thanks a lot !
F**k SSIS !Thanks a lot !<br /><br />F**k SSIS !Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-8413638223026049990.post-22559814954589835902017-06-02T07:53:32.997-04:002017-06-02T07:53:32.997-04:00Definitely works, thanks!Definitely works, thanks!Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-8413638223026049990.post-56503388384046182212016-10-11T07:29:08.728-04:002016-10-11T07:29:08.728-04:00This indeed did the trick for hiding the zero valu...This indeed did the trick for hiding the zero values but leaving the borders!<br />My first attempt was to use the IIF(...), that hid the values as well as the borders.SpiderMarshttps://www.blogger.com/profile/14127963147847070570noreply@blogger.comtag:blogger.com,1999:blog-8413638223026049990.post-38273460978801523152016-07-12T10:41:31.307-04:002016-07-12T10:41:31.307-04:00Thanks, man! It helped me a lot!Thanks, man! It helped me a lot!Nilson Nescáonoreply@blogger.comtag:blogger.com,1999:blog-8413638223026049990.post-22192381929276603562015-11-04T10:23:21.689-05:002015-11-04T10:23:21.689-05:00supper helpfulsupper helpfulAnonymoushttps://www.blogger.com/profile/10236345635877889565noreply@blogger.comtag:blogger.com,1999:blog-8413638223026049990.post-80333656033098453822015-06-22T12:04:24.288-04:002015-06-22T12:04:24.288-04:00THANK YOU. thank you. wow thanks. super thank. ...THANK YOU. thank you. wow thanks. super thank. seriously many gratitudean SSIS amateurnoreply@blogger.comtag:blogger.com,1999:blog-8413638223026049990.post-60316031839341933052014-10-08T15:02:11.888-04:002014-10-08T15:02:11.888-04:00Thanks a lot !Thanks a lot !Ali Farooqihttps://www.blogger.com/profile/06728614856092776688noreply@blogger.comtag:blogger.com,1999:blog-8413638223026049990.post-81135520312053291882014-08-26T08:14:03.936-04:002014-08-26T08:14:03.936-04:00Thank you its helpfullThank you its helpfullAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-8413638223026049990.post-50730411420764711152014-04-17T17:00:35.314-04:002014-04-17T17:00:35.314-04:00Thank you! You saved me from tearing off the rest ...Thank you! You saved me from tearing off the rest of my hair. <br />Peace!Arif Baighttps://www.blogger.com/profile/17259032030873298233noreply@blogger.comtag:blogger.com,1999:blog-8413638223026049990.post-14897569288637472152014-04-17T16:54:30.444-04:002014-04-17T16:54:30.444-04:00Thanks!Thanks!Mark Iannuccihttps://www.blogger.com/profile/08487763024483591085noreply@blogger.comtag:blogger.com,1999:blog-8413638223026049990.post-68023963646768214312014-04-17T16:50:42.339-04:002014-04-17T16:50:42.339-04:00This may work when the available values for the pa...This may work when the available values for the parameter are static. But if the available values in the calling report are from a query, doesn't work. Any idea on how to that?Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-8413638223026049990.post-38649028534751009912014-03-18T12:21:52.686-04:002014-03-18T12:21:52.686-04:00Thank you for this!Thank you for this!Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-8413638223026049990.post-52395826923013376782013-12-17T20:36:49.555-05:002013-12-17T20:36:49.555-05:00This comment has been removed by a blog administrator.Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-8413638223026049990.post-26118454327047476302013-12-05T10:53:00.302-05:002013-12-05T10:53:00.302-05:00Thanks a lot for this post. I was struggling with ...Thanks a lot for this post. I was struggling with a similar issue with DT_STR datatype and your post said it all.Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-8413638223026049990.post-73948487990032356052013-09-23T03:30:16.092-04:002013-09-23T03:30:16.092-04:00Its greatly working...Its greatly working...Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-8413638223026049990.post-49349647258183877582013-09-20T13:33:08.335-04:002013-09-20T13:33:08.335-04:00In cases where all else fails (and it nearly did i...In cases where all else fails (and it nearly did in my case) manipulate the series data properties to make 0 values a null string - =IIf(Count(Fields!data.Value)>0,Count(Fields!Data.Value),"")netmarcoshttps://www.blogger.com/profile/00089676150265778216noreply@blogger.comtag:blogger.com,1999:blog-8413638223026049990.post-28811990269048158652013-07-12T15:45:17.370-04:002013-07-12T15:45:17.370-04:00Thanks so much. I was having the same issue with ...Thanks so much. I was having the same issue with trying to null a date true condition. I didn't run into this solution anywhere else.Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-8413638223026049990.post-75009987186706853512013-07-10T11:43:22.247-04:002013-07-10T11:43:22.247-04:00I'm glad you took the time to create the post....I'm glad you took the time to create the post. It helped me in my work. So thank you ;)Anonymoushttps://www.blogger.com/profile/06756882110504989453noreply@blogger.comtag:blogger.com,1999:blog-8413638223026049990.post-47694098975830307872013-07-09T23:14:11.544-04:002013-07-09T23:14:11.544-04:00Thank you! Yes, that was a mistake. I have correc...Thank you! Yes, that was a mistake. I have corrected it.<br />I am glad people are still reading these posts 6 years later... :)Bob Pearsonhttps://www.blogger.com/profile/16528166535649336177noreply@blogger.comtag:blogger.com,1999:blog-8413638223026049990.post-60547088486061980502013-07-09T05:54:57.484-04:002013-07-09T05:54:57.484-04:00I know this is a very late comment, but I believe ...I know this is a very late comment, but I believe there is a small mistake in your query:<br /><br />Select LabelID,<br />LabelText<br />From LabelText (NOLOCK)<br />Where LanguageID = @Language<br /><br /> union<br /><br /> Select LabelID,<br /> LabelText<br /> from LabelText lt (NOLOCK)<br /> Where LanguageID = 1<br /> and Not Exists ( Select 1<br /> From LabelText z (NOLOCK)<br /> Where LanguageID = @LanguageID<br /> and z.LabelID = lt.LabelID)<br /><br />The very last "Where"-clause should be: Where LanguageID = @Language and z.LabelID = lt.LabelID<br /><br />In other words, the parameter on which you compare should be @Language instead of @LanguageID.Anonymoushttps://www.blogger.com/profile/06756882110504989453noreply@blogger.comtag:blogger.com,1999:blog-8413638223026049990.post-3825061782682054332013-04-12T15:14:13.073-04:002013-04-12T15:14:13.073-04:00Awesome information.. thanks a lot! :DAwesome information.. thanks a lot! :Dlibinhttps://www.blogger.com/profile/09847239582391440256noreply@blogger.comtag:blogger.com,1999:blog-8413638223026049990.post-21559065738714316772013-03-20T19:11:59.798-04:002013-03-20T19:11:59.798-04:00I am using java and SSRS and I am trying to get dr...I am using java and SSRS and I am trying to get drill down reports. <br />I do get the report results but when clicking +/- in report result, I get an error( I rsReportParameterValueNotSet). <br /><br />I am setting up the parameter value initially in order to get the report result.My code is below for parameter setting<br /><br />ParameterValue[] parameters = new ParameterValue[1];<br />parameters[0] = new ParameterValue();<br /> parameters[0].setName("country");<br /> parameters[0].setValue(india);Anonymousnoreply@blogger.com