Advertisement

10.01.2007 at 03:30PM PDT, ID: 22865168
[x]
Attachment Details

Reporting Services, access dataset from RDL custom code module

Asked by CraigYellick in SQL Server 2005

Tags: code, dataset, custom, services, reporting

Using Reporting Services in SQL Server 2005, is it possible to access the report's dataset(s) from within a function implemented in the report's custom code module?

The custom code module I'm talking about is the one you see when you select Report - Report Properties from the VS 2005 Report Designer, in the Code tab.  I'd like to be able to perform lookups into the report's datasets within the body of a function in this code module.

For example:

   function LookupStoreName(ZipCode as string) as String
      '// ... code to access dataset, do some logic, return a value
   end function

To save you some trouble: yes I know that I could call a SQL Server function in a dataset definition. I need this functionality to be callable from a textbox value expression and not as a Fields!XXX.value or Parameters!XXX.value reference.  It needs to function independent of the report's main dataset.

-- CraigStart Free Trial
[+][-]10.03.2007 at 08:56AM PDT, ID: 20007677

View this solution now by starting your 7-day free trial. Setting up your free trial is quick, easy, and secure. We will return you to this solution, unlocked, when you're done.

 

About this solution

Zone: SQL Server 2005
Tags: code, dataset, custom, services, reporting
Sign Up Now!
Solution Provided By: PFrog
Participating Experts: 3
Solution Grade: A
 
 
[+][-]10.03.2007 at 09:56AM PDT, ID: 20008146

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
 
Loading Advertisement...
20080716-EE-VQP-32 / EE_QW_1_20070628