RS and user defined functions or custom code

Last Post 10 Mar 2005 07:05 AM by xfonhe. 1 Replies.
AddThis - Bookmarking and Sharing Button Printer Friendly
  •  
  •  
  •  
  •  
  •  
Sort:
PrevPrev NextNext
You are not authorized to post a reply.
Author Messages
GaryCa
New Member
New Member

--
13 Jan 2005 08:09 PM

I know there is a code window to write your own functions. You can also use custom assemblies (.net classes) by referencing it etc

but ...

I'm porting a report from MS Access to SSRS manually, ie not using any tools.

If I have a MS Access query like

Select myFunc(field1), field2, field3 from table1

how do I do the same thing in SSRS?

I need to type 'pure' T-SQL as the reports data-source. The code window is only applicable to fields/textboxes inside the report.

Do I have to :-

Select field1, field2, field3 from table1

and then inside the report designer, set the appropriate text box to

=code.myFunc(field1)

Is that possible? Can I pass parameters to embedded code? Do I reference the field as above?

If I was using a SQL Server 2000 view, I'd specify a UDF but I don't know if SSRS can reference SQL Server UDF's.



xfonhe
New Member
New Member

--
10 Mar 2005 07:05 AM
SRS natively includes a tool to directly import Access reports.... why are you not using it?
You are not authorized to post a reply.

Acceptable Use Policy