October 8, 2010 at 4:52 am
hi, I read in magazine this = 'Access the embedded code of a report by clicking Report/Report Properties in the BIDS menu (you need to have selected either the Data or Layout tabs for this menu option to be available)'
I try to find this option, this dialog of code and didn't found.
someone can help me please ?
October 8, 2010 at 6:41 am
hi..
In right side panel u should right click on
reports->add new report->select the database
which u want..
after that a table will be displayed
and tabs will also be displayed..
hope u got it...
October 8, 2010 at 6:50 am
kln2020 (10/8/2010)
hi, I read in magazine this = 'Access the embedded code of a report by clicking Report/Report Properties in the BIDS menu (you need to have selected either the Data or Layout tabs for this menu option to be available)'I try to find this option, this dialog of code and didn't found.
someone can help me please ?
What exactly are you looking for? The SQL Code which creates the dataset or the RDL code (the XML code that defines the report)? Or are you looking for the custom code which may have been written for you by someone else to perform some customization on the data, design or whatnot? This third bit is what it seems the magazine was referring to.
-Luke.
EDIT: Also, what version are you using and how are you editing the report? using BIDS, Visual Studio etc?
October 8, 2010 at 7:20 am
kln2020 (10/8/2010)
hi, I read in magazine this = 'Access the embedded code of a report by clicking Report/Report Properties in the BIDS menu (you need to have selected either the Data or Layout tabs for this menu option to be available)'I try to find this option, this dialog of code and didn't found.
someone can help me please ?
This refers to .Net code that can be embedded into a report. In VS 2008, you have to have a report open on the design surface. With the Design tab selected, go to the top menu and choose Report>>Report Properties, and then choose Code. Any embedded code will be here.
Personally I have one bit of embedded code in all of my reports:
Public Function DivideBy(ByVal Exp1, ByVal Exp2)
If Microsoft.VisualBasic.IsNumeric(Exp1) And Microsoft.VisualBasic.IsNumeric(Exp2) Then
If Exp2 = 0 Then
DivideBy = 0
Else: DivideBy = Exp1/Exp2
End If
Else
DivideBy = "N/A"
End If
End Function
This function allows me to do division without checking first for a zero or a numeric value. It is accessed in the expression builder as
=code.DivideBy(Fields!FieldName.Value, Fields!DifferentFieldName.value)
FYI the code above is a modification of someone else's work that I found here on SSC.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply