sql server - Is it possible to use XML dataset in SSRS report designer -

-

is possible use xml dataset in ssrs report designer ? need fetch large dataset like,

master row   - details1   - details2   - ... detailsn

i created query returns me xml data using for xml raw not able use in query designer when adding new report.

please note not using xml data source, trying add xml dataset using select query.. havn't tried stored procedure not sure if work well...

in other words, possible add xml dataset (not datasource) ssrs reports

if need xml looking treeview might this:

declare @xml xml= '<root>   <level content="level a">     <detail content="detail aa">       <item content="item aaa" />     </detail>     <detail content="detail ab">       <item content="item aba" />       <item content="item abb" />       <item content="item abc" />     </detail>     <detail content="detail ac">       <item content="item aca" />       <item content="item acb" />     </detail>   </level>   <level content="level b">     <detail content="detail ba">       <item content="item baa" />     </detail>     <detail content="detail bb">       <item content="item bba" />       <item content="item bbb" />       <item content="item bbc" />     </detail>     <detail content="detail bc">       <item content="item bca" />       <item content="item bcb" />     </detail>   </level> </root>';   select  case the.node.value('fn:local-name(.)','varchar(max)')         when 'level' ''         when 'detail' replicate(' ',4)         when 'item' replicate(' ',8)         else ''         end + the.node.value('@content','varchar(max)') @xml.nodes('root//*') the(node)

the result

level     detail aa         item aaa     detail ab         item aba         item abb         item abc     detail ac         item aca         item acb level b     detail ba         item baa     detail bb         item bba         item bbb         item bbc     detail bc         item bca         item bcb

Comments

Post a Comment

Popular posts from this blog

Hatching array of circles in AutoCAD using c# -

-
i beginner in autocad plugins .i have created array of circle using following code. now, have hatch circles in array .how that??how hatch circles @ once? moreover, how can return hatch method , use hatch objects.sorry language.thanks in advance. [assembly: commandclass(typeof(beamsection.class1))] namespace beamsection { public class class1 { //class1 obj = new class1(); [commandmethod("beamatsupport")] public void addlightweightpolyline() { // current document , database document acdoc = application.documentmanager.mdiactivedocument; database accurdb = acdoc.database; promptpointresult ppr = acdoc.editor.getpoint("\nselect starting point "); var ucs = acdoc.editor.currentusercoordinatesystem; point3d startingpt = ppr.value.transformby(ucs); list<double> radius = new list<double>(); radius.add(0.5); ...
Read more

ios - UITEXTFIELD InputView Uipicker not working in swift -

-
hello trying pop uipickerview view programmatically when user clicks on textfield. have tried doesn't doing anything. isn't working. nothing happening when click textfield class userprofiletableviewcontroller: uitableviewcontroller,uitextfielddelegate,uipickerviewdelegate,uipickerviewdatasource { var itempicker: uipickerview! = uipickerview() @iboutlet weak var gendertxtfield: uitextfield! var gender = ["male","female"] override func viewdidload() { super.viewdidload() gendertxtfield.delegate = self itempicker!.delegate = self itempicker!.datasource = self itempicker!.backgroundcolor = uicolor.blackcolor() self.gendertxtfield.inputview = itempicker } func numberofcomponentsinpickerview(pickerview: uipickerview) -> int{ return 1 } // returns # of rows in each component.. func pickerview(pickerview: uipickerview, numberofrowsincomponent component:...
Read more