Custom report item

How would one go about setting the height of a custom report item programmatically?

I have a custom report item that renders back an image of indeterminate height. I cannot simply set RenderItem.Sizing = Image.Sizings.AutoSize; As the image is being rendered back at 300 dpi and will require being set to FitProportional. Therefore I need to set the height to a scale height. I've tried setting CRI.Height to a ReportSize value, but it tells me that I cannot because of the current state of the item.

I have also tried setting the Width and Height of the Microsoft.ReportingServices.ReportRendering.Image to the needed values, but that appears to be completely ignored when the report is generated.

Custom report item

How would one go about setting the height of a custom report item programmatically?

I have a custom report item that renders back an image of indeterminate height. I cannot simply set RenderItem.Sizing = Image.Sizings.AutoSize; As the image is being rendered back at 300 dpi and will require being set to FitProportional. Therefore I need to set the height to a scale height. I've tried setting CRI.Height to a ReportSize value, but it tells me that I cannot because of the current state of the item.

I have also tried setting the Width and Height of the Microsoft.ReportingServices.ReportRendering.Image to the needed values, but that appears to be completely ignored when the report is generated.

Custom Data Pre-Processing

Is there anyway I can send report properties to a custom
assembly which does all the work and passes back a dataset
that I can then bind to a report?
I've got to do some extensive pre-processing of the data,
which I couldnt really do with sql query alone, but I'd
still like to take advantage of all the other benefits of
sql reporting services.
Thanks in advance,
Weston WeemsYes, I think you can do this by writing a "Data Processing Extension" to
Reporting Services. There are examples and documentation in RS books on
line...
--
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Weston Weems" <anonymous@.discussions.microsoft.com> wrote in message
news:05fd01c4f426$138c6880$a301280a@.phx.gbl...
> Is there anyway I can send report properties to a custom
> assembly which does all the work and passes back a dataset
> that I can then bind to a report?
> I've got to do some extensive pre-processing of the data,
> which I couldnt really do with sql query alone, but I'd
> still like to take advantage of all the other benefits of
> sql reporting services.
> Thanks in advance,
> Weston Weems

Custom Code

I've created a function in the code tab but when I go back to the text box
that is going to call the custom code through the expression... i type code.
and my function isn't there... anybody else see this?Hi,
"Code" or "Report" is a global object pertaining to Reporting Services.
User defined functions wont be visible since it is not a user created class.
Amarnath
"gdjoshua" wrote:
> I've created a function in the code tab but when I go back to the text box
> that is going to call the custom code through the expression... i type code.
> and my function isn't there... anybody else see this?

custom assembly cant read app.config file.

i added an app.config to my custom assembly but when i try
to read keys from it i get Nothing back.
my config file looks like this:
<?xml version="1.0" encoding="utf-8" ?>
<configuration>
<appSettings>
<add key="SERVER" value="j4b-web-srv6" />
<add key="DATABASE" value="GUIDEWEBLIVE" />
<add key="USER" value="sa" />
<add key="PASSWORD" value="sqldoor5" />
</appSettings>
<system.diagnostics>
<sources>
<!-- Th
<--snip-->
then i call it like so:
sServer = System.Configuration.ConfigurationManager.AppSettings("SERVER")
the config file is renamed to FundTrackHelper.dll.configHi,
Did you get any error msg when trying to read the config file?
Any resources accessed throught custom assemblie of the report has to be
given proper permission in the assmblie and in the reports server config
policy file. Did you do that before accessing file?
in the assemblie you have to do something like this..
FileIOPermission FIOPermRead = new
FileIOPermission(FileIOPermissionAccess.Read, strPath);
FIOPermRead.Assert();
let me know if this helps
~Bava
"taz" wrote:
> i added an app.config to my custom assembly but when i try
> to read keys from it i get Nothing back.
> my config file looks like this:
> <?xml version="1.0" encoding="utf-8" ?>
> <configuration>
> <appSettings>
> <add key="SERVER" value="j4b-web-srv6" />
> <add key="DATABASE" value="GUIDEWEBLIVE" />
> <add key="USER" value="sa" />
> <add key="PASSWORD" value="sqldoor5" />
> </appSettings>
> <system.diagnostics>
> <sources>
> <!-- Th
> <--snip-->
> then i call it like so:
> sServer = System.Configuration.ConfigurationManager.AppSettings("SERVER")
> the config file is renamed to FundTrackHelper.dll.config
>|||hi,
i didnt get any error msg, it just returns "Nothing".
i did not give it any permissions so i guess thats
what i was missing. i'll give it a try and let u know -
thanks a lot !
t.
"Bava Mani" wrote:
> Hi,
> Did you get any error msg when trying to read the config file?
> Any resources accessed throught custom assemblie of the report has to be
> given proper permission in the assmblie and in the reports server config
> policy file. Did you do that before accessing file?
> in the assemblie you have to do something like this..
> FileIOPermission FIOPermRead = new
> FileIOPermission(FileIOPermissionAccess.Read, strPath);
> FIOPermRead.Assert();
> let me know if this helps
> ~Bava
> "taz" wrote:
> >
> > i added an app.config to my custom assembly but when i try
> > to read keys from it i get Nothing back.
> >
> > my config file looks like this:
> >
> > <?xml version="1.0" encoding="utf-8" ?>
> > <configuration>
> >
> > <appSettings>
> > <add key="SERVER" value="j4b-web-srv6" />
> > <add key="DATABASE" value="GUIDEWEBLIVE" />
> > <add key="USER" value="sa" />
> > <add key="PASSWORD" value="sqldoor5" />
> > </appSettings>
> >
> > <system.diagnostics>
> > <sources>
> > <!-- Th
> >
> > <--snip-->
> >
> > then i call it like so:
> >
> > sServer = System.Configuration.ConfigurationManager.AppSettings("SERVER")
> >
> > the config file is renamed to FundTrackHelper.dll.config
> >