Custom Report Item: Textbox

Hi all,
If it is possible, how I can extend the Textbox item with a DataSet
property. In order to display a field from multiple rows, with a separator ?
Example:
a dataset with 10 rows (and 1 field "Name")
and I want to display in the Textbox
"Name1, Name2, Name3, Name4, Name5, Name6, Name7, Name8, Name9, Name10"
ThanksI'm sure this is possible, just to give you a point in one possible
direction...
From a Database side of things, you could pivot the data in your SQL
statement. SQL Server 2005 has new SQL commands called PIVOT and UNPIVOT...
Once your rows values are pivotted to columns in a single row, then you
could specify them easily enough in the text box.
Hope that helps.
Dan.
"gbouzebra" <gbouzebra@.discussions.microsoft.com> wrote in message
news:D8959BBA-3778-4129-9E3F-AB4443A58C5F@.microsoft.com...
> Hi all,
> If it is possible, how I can extend the Textbox item with a DataSet
> property. In order to display a field from multiple rows, with a separator
> ?
> Example:
> a dataset with 10 rows (and 1 field "Name")
> and I want to display in the Textbox
> "Name1, Name2, Name3, Name4, Name5, Name6, Name7, Name8, Name9, Name10"
> Thanks

custom report item test justification.

Dear all,
i need to extend the functionality of the textbox in reporting services to
implement text justification align.
i made a research and found the concept of "custom report items" but it's
implmented as image i also see the sample of polygonCL in SDK extention
samples
i am asking if there are a way to take all the functionality of textbox and
on just extend the required functionality' or develop a new textbox and
render it as image?
thanksWhat do you mean by text justification?
If you mean you want to center, right align, or left align - those are
already availiable. Just click on the text box and clikc one of the
Justifications.
I dont think this is the problem you are facing. What, exactly, is the
issue? and what is it your tryingto accomplish?|||thanks a lot for your replaying
i mean by text justification is the text width is the same for all line
inside textbox
if you look at word u will see right, left, center and justify align
i need to use a justify align for textbox
by the way i am using RS 2005
thanks
"sorcerdon@.gmail.com" wrote:
> What do you mean by text justification?
> If you mean you want to center, right align, or left align - those are
> already availiable. Just click on the text box and clikc one of the
> Justifications.
> I dont think this is the problem you are facing. What, exactly, is the
> issue? and what is it your tryingto accomplish?
>

Custom Report Item example not rendering right?

I'm trying to work with the custom report item example (PolygonsCRI.dll) from the latest SQL Server 2005 downloads. I've followed all of the instructions on how to deploy the report. The report is now available on my Report Server, and I can load the Polygons.sln report and view it in the designer. However, whenever I preview the report in the designer or view the report on the server, the polygon report items just show up as big blank spots - there's no image there and no indication of an error. The chart on the report renders just fine, though.

Does anybody have any ideas on what could be causing this?

Thanks,

Glenn Burnsider

There is a typo in the PolygonsCRI.vb and .cs file. The class name should be "PolygonsCRI", not "PolygonsCCustomReportItem". Change the class name to "PolygonsCRI", redeploy, and the chart should be visible now.

Custom Report Item example not rendering right?

I'm trying to work with the custom report item example (PolygonsCRI.dll) from the latest SQL Server 2005 downloads. I've followed all of the instructions on how to deploy the report. The report is now available on my Report Server, and I can load the Polygons.sln report and view it in the designer. However, whenever I preview the report in the designer or view the report on the server, the polygon report items just show up as big blank spots - there's no image there and no indication of an error. The chart on the report renders just fine, though.

Does anybody have any ideas on what could be causing this?

Thanks,

Glenn Burnsider

There is a typo in the PolygonsCRI.vb and .cs file. The class name should be "PolygonsCRI", not "PolygonsCCustomReportItem". Change the class name to "PolygonsCRI", redeploy, and the chart should be visible now.

Custom Report Item and Parameters in c#, how do I get them

Hi,

We are developing a custom report item but we cannot find a way to get the report parameters. In Vb examples there is mentioning of globals but these do not seem to be present in the c# enviroment.

Could anyone give a solution on how to get to the report parameter collection in run-time.

Thanks,

Arwin van der Laan

This may help you:

ReportViewer1.ServerReport.GetParameters();

|||

Greg,

Thanks for the help but it does not do the job as far as i can see.

Maybe this makes my question more clearly.

During the process event of the runtime part of the custom report item we need to hold a report wide string for state purposes, beside that one we need to get the user_id which we will add to the parameters requesting the report.

Arwin

|||

Whether your code is written in C# or VB should have no bearing on this.

I've written a couple of custom report items. I am not sure whether you are writing a "custom report item" exactly, from what you are saying here, or a "custom report logic DLL (assembly)" for use in processing.

If the latter, can you check this thread http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1755679&SiteID=1, which I think may help you?

If the former, can you talk a bit about your report item's API, and what you're trying to do/what's not working for you?

>L<

|||

Lisa,

Thanks for your answere, I looked into the thread you referenced but I still can get what I want.

Below there is a sample of what we want to do, in het process event we want to get hold of the report parameters and some kind of report string variable so multiple report items can use it.

Code Snippet

public class ReportItemBasic : ICustomReportItem

{

private CustomReportItem m_CustomReportItem;

private Microsoft.ReportingServices.ReportRendering.Image m_BasicImage;

private Microsoft.ReportingServices.ReportRendering.ImageMapAreasCollection m_ImageMap;

protected static string propertyClass = "Basic";

public CustomReportItem CustomItem

{

set

{

m_CustomReportItem = value;

}

}

public ReportItem RenderItem

{

get

{

if (m_BasicImage == null)

{

}

Process();

}

// Get report parameters and extract user id and application autorisation

// string id_User = ...

// global:appAut = ........

return m_BasicImage;

}

Besides the fact that reporting services is a new area for us is that I am just started with c# (former delphi & vb).

Arwin

|||

Ah! The thread I sent you to will not help you because you really *are* using a custom report item, not doing custom report processing (I really wasn't sure before and very few people are doing the former <s>).

>> I am just started with c# (former delphi & vb)

It really is important to realize that you should be able to do this in whatever language you want, and that should include delphi.net <g>, but FWIW I think they test most everything of this nature in c# first <g>.

First, where is the vb sample that you are working from and trying to emulate? I think there was a custom report item in RS 2000 but it changed a lot so it's important to make sure you're not using an old sample, regardless of language.

Now, I have two mostly-separate things to tell you <s>:

1. I think the best way to do what you want to do is to use a custom property to hold the report parameters item you want.

I assume that you have been working from either the Polygons CRI sample or maybe the article by Teo Lachev in MSDN that is based on the Polygons sample? That's how I got started. You will see that the Polygons item has a custom property like this:

<CustomProperty>
<Name>polyPI</Name>
<Value>=Parameters!DPI.Value</Value>
</CustomProperty>

... so clearly it is one way to get access to the parameters. You will see other custom properties that are expressions basd on data elements in the report.

2. What you said about "so multiple report items can use it" happens to touch on a subject very near and dear to my heart with regard to custom report items. <s> I have posted something about what I have been working on here http://spacefold.com/articles/XMLRSDocs.aspx, but what you can't see in what I've written so far is the design choices that I made as a result of what a custom report item can and cannot do.

We can take this conversation off-line or off-forum if you like and I can be more specific. Basically as you'll see in what I've written already it is quite important in my scenario that one custom report item have some bearing on the rest of the report but it is not something that was envisioned by MS. In fact, I thought originally that I wanted to work solely on the Report level rather than using a customreportitem at all for what I wanted to do -- but this turned out to have its own difficulties. I haven't had a chance to write about this yet.

>L<

|||

Lisa,

This was what I was looking for, thanks.

As far as the concept "so multiple report items can use it" is concerned, yes I am interested in the design choices and your point of view regarding custom report items.

Where do you propose to take the discussion off-forum? By e-mail or on spacefold.com?

Arwin

|||

You can contact me there (spacefold) and we'll continue e-mali as needed.

Either way, you can explain your reason to have one report item touch the lives of other ones -- I think mine is pretty clear in the docs for the utility I'm writing <s> -- and, I'll tell you what I know about the limitations that might affect you.

I do want to continue to write more stuff about this publicly, and if you are free to comment on it publicly, I would prefer to do that. I think that it will turn out to be generally helpful. I am sure that you and I are not the only people who have thought about this approach. But if we need to bring the discussion to e-mail I would certainly not divulge any details of your project in anything I write publicly. OK?

>L<

Custom Report Item and embedded images

Hi,

I would like to integrate an embedded image into a custom report item. However, I can't find a property which gives access to the embedded images collection. What would be the right approach to load an embedded image within the process method?

Kind regards

Benno

Found a workaround - I will store images as own custom properties.|||

Hello,

Could you tell me how to create a custom report item that modifys the RDL file.

Thanks!!

SQLNew

Custom Report Item

Hello all,

Could any one point me to some documents on building custom report items.

Thanks!!

SqlNew

A good place to start would be the BOL (Books Online).

Here is the starting point for Custom Report Items: http://msdn2.microsoft.com/en-us/library/ms345231.aspx

Custom Report Item

Hello.
I need to write a CRI which will update a attribute in the RDL file.
Can anyone point me in the right direction.
This is my view I
will have a textbox and a button on the CRI.
While building a report through BI , the report author adds CRI.
enter a value in the text box and click ok.
Then the text in the textbox needs to be added to the RDL file.
Thanks!!
RadhikaHello,
Does any one have ideas.
Thanks!!
"Radhika" wrote:
> Hello.
> I need to write a CRI which will update a attribute in the RDL file.
> Can anyone point me in the right direction.
> This is my view I
> will have a textbox and a button on the CRI.
> While building a report through BI , the report author adds CRI.
> enter a value in the text box and click ok.
> Then the text in the textbox needs to be added to the RDL file.
>
> Thanks!!
> Radhika

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 Grouping

Can someone please point me in the direction of how to create a custom grouping for an attribute? I have an 'age' attribute of an item that tracks how old it is. Let's assume this age is always between 1 and 30 days. Regardless of the distribution of the ages, I'd like to have specific ranges defined according to our business' tracking rules: 1 - 3 days, 4 - 10 days, 11 - 20 days and 21 - 30 days.

The DiscretizationMethods available will not produce these types of grouping ranges for me. What am I missing?

Thanks!

Kirun

You might have to create a two level hierarchy in the age dimension with your custom groups as the first level.

Custom Control Flow Item Issue

I've been using Konesan's FileWatcher control-flow item successfully in design-mode on my PC, which runs the package on a remote server.

I have installed the Konesan's FileWatcher on the remote SQLServer machine. I then imported the package to the server (Files System folder). I then select the package, right-click 'Run Package', then Execute, and receive the error:

"Error: The task 'File Watcher Task' cannot run on this edition of Integration Services. It requires a higher level edition"

..in the 'Package Execution Progeress' dialog. All other validation seem to be ok.

(Note, I'm executing the above steps using SQLServer Mgt Studio from my PC ; I'm not doing it from the SQLServer machine itself...not sure if this matters or not.)

The SSIS version installed on the server is 9.0.3054. It shouldn't be an "SSIS version issue", as it is the same SQLServer that I used (successfully) from my PC in design mode...

Thanks,

Allen

SSIS is not likely installed on the server. Grab the installation media and verify that SSIS is installed. Better yet, look at the services on the server and see if there's a SQL Server Integration Service.|||

When you execute from SQL Server Mgt Studio, actually it runs from your system and not on server. Hence you will need SSIS installed on your box to run it locally.

This should give you some more insight

http://blogs.msdn.com/michen/archive/2006/08/11/package-exec-location.aspx

Thanks

|||Via MSSMS, I logged directly into "Integration Services", and then successfully "Import(ed) Package", so it must be installed; ObjectExpolorer shows "DEVSQL06 (Integration Services 9.0.3054...). I don't have physical access to the machine, but am having somebody checking anyway.

|||Yep, see the post above. Sorry, I missed the part about you executing the package via SSMS. *You* don't have SSIS installed on your local machine.

If you were to create an Agent job on the server that pointed to the package, it would likely work fine.|||Karunakaran - Thanks..that definitely shed some light on the topic! I thought it was being run on the server via RPC, with status messages being returned back...

I do not have any SSIS Service on my machine, so will install it. (I do have SQLServer express, but am not using it).

However, just as a test, I removed the 'FileWatcher' control, then re-imported the package to the server, and it is now running (validation's all completed, and it has "Start"ed), and I see my recordcount increasing, so it is working. How is this possible if I don't have SSIS installed?

|||Because some components need to have a full version of SSIS installed. Just try it!

It's kind of a mess the way it's setup.|||

Only some components? I was under the impression to run a SSIS package you need to have full SSIS installed.

Time to dig up and see what all component will run without full SSIS installation. Is there any document on this?

Thanks

|||
Phil

Installation of SSIS on my PC did the trick; the Konesan FileWatcher task now works!

Karunakaran

Prior to installation of SSIS (when running my package with the Konesan FileWatcher removed), the package seems to have worked just fine with the following ControlFlow items:

For Loop Container
Execute T-SQL Task
Data Flow Task
File System Task

Your help is MUCH appreciated!!!

Rgds,
Allen

Custom Control Flow Item Issue

I've been using Konesan's FileWatcher control-flow item successfully in design-mode on my PC, which runs the package on a remote server.

I have installed the Konesan's FileWatcher on the remote SQLServer machine. I then imported the package to the server (Files System folder). I then select the package, right-click 'Run Package', then Execute, and receive the error:

"Error: The task 'File Watcher Task' cannot run on this edition of Integration Services. It requires a higher level edition"

..in the 'Package Execution Progeress' dialog. All other validation seem to be ok.

(Note, I'm executing the above steps using SQLServer Mgt Studio from my PC ; I'm not doing it from the SQLServer machine itself...not sure if this matters or not.)

The SSIS version installed on the server is 9.0.3054. It shouldn't be an "SSIS version issue", as it is the same SQLServer that I used (successfully) from my PC in design mode...

Thanks,

Allen

SSIS is not likely installed on the server. Grab the installation media and verify that SSIS is installed. Better yet, look at the services on the server and see if there's a SQL Server Integration Service.|||

When you execute from SQL Server Mgt Studio, actually it runs from your system and not on server. Hence you will need SSIS installed on your box to run it locally.

This should give you some more insight

http://blogs.msdn.com/michen/archive/2006/08/11/package-exec-location.aspx

Thanks

|||Via MSSMS, I logged directly into "Integration Services", and then successfully "Import(ed) Package", so it must be installed; ObjectExpolorer shows "DEVSQL06 (Integration Services 9.0.3054...). I don't have physical access to the machine, but am having somebody checking anyway.

|||Yep, see the post above. Sorry, I missed the part about you executing the package via SSMS. *You* don't have SSIS installed on your local machine.

If you were to create an Agent job on the server that pointed to the package, it would likely work fine.|||Karunakaran - Thanks..that definitely shed some light on the topic! I thought it was being run on the server via RPC, with status messages being returned back...

I do not have any SSIS Service on my machine, so will install it. (I do have SQLServer express, but am not using it).

However, just as a test, I removed the 'FileWatcher' control, then re-imported the package to the server, and it is now running (validation's all completed, and it has "Start"ed), and I see my recordcount increasing, so it is working. How is this possible if I don't have SSIS installed?

|||Because some components need to have a full version of SSIS installed. Just try it!

It's kind of a mess the way it's setup.|||

Only some components? I was under the impression to run a SSIS package you need to have full SSIS installed.

Time to dig up and see what all component will run without full SSIS installation. Is there any document on this?

Thanks

|||
Phil

Installation of SSIS on my PC did the trick; the Konesan FileWatcher task now works!

Karunakaran

Prior to installation of SSIS (when running my package with the Konesan FileWatcher removed), the package seems to have worked just fine with the following ControlFlow items:

For Loop Container
Execute T-SQL Task
Data Flow Task
File System Task

Your help is MUCH appreciated!!!

Rgds,
Allen