I will be heavily using custom assemblies to generate queries for my reports. I have been able to call static members of my C# .NET classes, and am now starting with instance members. However, some of my classes have paramaterized constructors and initializers that I need to call before accessing the methods. How do I make a plain function call in my RDL? If this were ASP I'd just write <%call namespace.class.foo()%>, but I don't see the equivalent in RDL.

Thanks,
Daniel Williams

I'm not very familiar w/ C# but I know you can edit the XML of the RDL file, you might be able to accomplish this there...

To view the XML code of the RDL file simply open the report project, in the solutions explorer right click on the RDL file you wish to edit, and select View Code from the pop up menu.

Question:

Why not just write the query in SQL?

Hope this helps!

--
Ben Sullins
Sql Developer - Our Vacation Store

Thanks for the input BSullins. The reason I need to use real custom assemblies (not just static members) is because I have a ton of existing code which encompasses the business logic of our system. This logic is too complex for simple SQL, so I would like to re-use the existing classes that I have in C# and VB.NET
If I can code to RDL as easily as I do with ASP, then the Reporting Services will be tremendously useful to my company. (BTW: I do edit the RDL directly, as this is often the fastest way to edit the reports.)

Thanks,
Daniel Williams