Customising Date Picker

O Great Beings of MSDN,

After much fruitless search I am requesting help on whether there's any way to disable some of the dates in SSRS date picker control.

I have a date parameter in which I want users only be able to select the Fridays. I could show a drop down list of Fridays but that doesn't look too flash, especially when the list has about 2K Fridays.

Any help would be appreciated.

The parameter controls on the standard toolbar cannot be customized. If this is a must have requirement, you need to implement a custom application front end and use the ASP.NET Report Viewer (which is what the Report Manager uses).|||

Thanks Teo,

I think I will have to give up on this one as we already have a custom report protal on which all the RS reports and other reports are displayed. Having another application fire up to collect parameters is not an option for me so that's a bit of bugger.

Hope microsoft can utilise the dataset section in order to provide this in the next service pack. Ie, it would be so much easier if we could have the option of having a list of dates defined in a data set and hence when connected to the datetime parameter, it could use this list to limit the date picker dates that could be chosen by user (having dates that were not in the dataset disabled).

Fortunately the data for this particular report for my company is valid since June 2006 so have implemented the datetime as a drop down list for now (only showing fridays dates after 2006) without the datepicker so the list of Fridays isn't too big just yet.

Totally unsatisfactory from my point of view but that's the best that I could come up with.

Custom Semi-Transparent bar charts?

I know that SSRS 2005 has a built-in semi-transparent color chart palette, but I'd like to define my own custom color semi-transparent palette.

Brian Welker's blog (https://blogs.msdn.com/bwelcker/archive/2005/05/20/420349.aspx) has a terrific post on how to create your own custom color palette, but it generates solid colors. How can it be tweaked to create semi-transparent colors? Is there another function that needs to be created to define the transparency of the color palette?

Thanks in advance,

Pete

Sorry, semi-transparency cannot be achieved by defining your own custom color palette.

There are CustomReportItem-based chart add ins available for RS from third parties (such as Dundas and ChartFX) which will enable that kind of functionality in RS 2005.

-- Robert

|||

Bummer.

Can images be used in charts? (I doubt it, but thought I'd inquire.)

Thanks,
Pete

|||

Yes, you can use an image as a background image for the chart plotarea (select the chart and look for the BackgroundImage property in the VS properties window).

-- Robert

|||

I should have made my followup question clearer. I meant to ask if images can be used in the actual charting of values, for example to use an image of coins for bar charts whereby the bars on the chart are actually a "stack" of the coins. Or to use an image that gets "stretched" on the bars of a bargraph.

--Pete

|||

I believe the plug-in from Dundas ("Dundas Charts for Reporting Services") supports this, but you would need to check with them. It is not supported out of the box with the built-in charts.

-- Robert

|||

Transparency is more than possible with ANY system palette or custom palette.
The trick (work-around whatever) lies in modifying the 'alpha' component of the colour for each series in the chart AFTER they have had their colour assigned to them.

ie. i used the code

//set the transparency of the series
if(_abstractChart.Options.Transparency > 0) {
//get the transparency as a percentage
double transPerc = _abstractChart.Options.Transparency / 100.00;
//Alpha value 255 is opaque, 0 is transparent. set the transparency as a % of 255
int alphaValue = (int) (255 * (1-transPerc));
_chart.ApplyPaletteColors();
foreach(Series series in _chart.Series) {
series.Color = Color.FromArgb(alphaValue, series.Color.R, series.Color.G, series.Color.B);
}
}

where
-abstractChart.Options.Transparency is the integer value (between 0 and 100 inclusive) denoting the transparent %.
-_chart is a Dundas.Charting.WebControl.Chart

in my C# application, a percentage value is retrieved from the user from an aspx form. I subtract the tranparent component of the alpha value from the max (255) to get the Opacity, which is what i set in the colour. Giving the user 101 grades of tranparency (no pun intended).

HOWEVER, i actually have a problem. Though this method works fine for bar chart, radar, area line charts, it DOES NOT work for pie charts. The semi-transparent palette works for pie charts, but this method does not.

Perhaps someone with more knowledge of the dundas system could use my solution in the right place to achieve transparency for pie charts?

please?

I thought maybe using this method in Customize, PrePaint or PostPaint event would work. Havent had the chance to try it yet.
Cheers

|||

Okay, i figured it out.
A bar chart has one series object in the Dundas.Charting.WebControl.Chart.Series[] of the chart for every bar, so setting the colour of the series would apply to the bar which that series plots.
A pie chart has one series object for the whole chart, and the slices are individual datapoints within that series.
The solution quite simply is to add another level to the loop which iterates through every datapoint of the current series.
If processing time is a concern there should be a check present for whether the second loop is necessary (so far i have only found it necessary within PIE charts)
if(abstractChart.Options.Transparency > 0) {
//get the transparency as a percentage
double transPerc = abstractChart.Options.Transparency / 100.00;
//Alpha value 255 is opaque, 0 is transparent. set the transparency as a % of 255
int alphaValue = (int) (255 * (1-transPerc));
chart.ApplyPaletteColors();
foreach(Series series in chart.Series) {
if(abstractChart.GetChartType != ChartType.Pie) {
series.Color = Color.FromArgb(alphaValue, series.Color.R, series.Color.G, series.Color.B);
}
else{
foreach(DataPoint dp in series.Points) {
dp.Color = Color.FromArgb(alphaValue, dp.Color.R, dp.Color.G, dp.Color.B);
}
}
}
}
Where
-abstractChart.Options.Transparency is the integer value (between 0 and 100 inclusive) denoting the transparent %.
-_chart is a Dundas.Charting.WebControl.Chart
-abstractChart.ChartType is an identifier for the type of chart we are plotting (Abstract Chart is one of MY classes, as is ChartType)

By the way, this code is called after the chart object has been created, but before returning from the method which created the chart object.
IE.
public Dundas.Charting.WebControl.Chart MakeChart(){
Dundas.Charting.WebControl.Chart chart = new Dundas.Charting.WebControl.Chart();
..
..
..
..
<transparency code>
..
..
..
return chart;
}
any questions?
LiLbUg@.ozemate.com

|||

just an out of topic question: sorry because i need an answer really fast hope you understand....

Hi everyone,

I just inquiring if the 'My subscription' toolbar at the upper right portion of the report manager can be removed? or shall we say hide... If possible, how to remove please help...

Another question is when you click the show details button, the option to delete and move appears but it is initially disabled...is there a way also to hide the move button?

thank you very much...hope to have any response or advice as soon as possible...thanks

|||

Hello Thor:

Interesting... I'm a little confused, though. Is your code affecting the Dundas charting component or are you suggesting a way to create charting transparency in reporting services without the need for a third party add-in like Dundas (or ChartFX)?

Thanks,

Pete

|||

hey pete

yeh, not sure what you mean, theres alot of syllables in some of those words.
To try to answer your question; i'm using dundas, and the code i supplied directly changes the colour value for datapoint objects/series objects inside a DUNDAS chart. IE i assign a new colour for each datapoint/series in the code, in this case the new colour is the same as the old one (which is assigned from the palette) except the alpha value has been changed.
effectively, any palette can therefore have transparency applied to it, retaining the oiginal colours of the palette.
SO... i think the answer to your question is that this code NEEDS dundas and i affect the instance of the dundas charting component to create transparency.
but technically this should work for any charting tool that allows you to modify the colour of the datapoints in a series after they have been assigned a colour and before they are drawn.
ps. last time i ran my app. it changed the colour for the whole pie chart to the colour of the first datapoint. i think this code would have to be in the PrePaint event (its worked there before).
ill post again when i know for sure.

...Edit...
just read the top post again, and realised you're not using dundas. for some reason i thought this was all about dundas.
anyways, this should work for that charting thing you use IF you can change the colours of the series / datapoints at the right time. Might take some experimenting to figure out where, or even if you can do it.

sql

Custom Renderer in SharePoint integrated mode

We have been successful in creating a custom Excel Renderer that works very well on a server configured for SSRS Native mode. However we have another server that is configured to work in SSRS integrated mode that we can not get this custom renderer to work properly. The steps we follow are:

After the report results are displayed we select Actions -> Export -> Excel Custom . So I can see the name of our custom rendering type. After a very short amount of time (no more than a second or 2) I get a frame that says: an unexpected error has occurred. Here is the URL of the web site:

http://sharepointserver/sites/BI/Reports/Reserved.ReportViewerWebPart.axd?ReportSession=2jqe4e45sm0sze553avovv55&ControlID=5c4fbb59def64efdac050393cd3fb338&Culture=1033&UICulture=1033&ReportStack=1&OpType=Export&FileName=edi001&ContentDisposition=OnlyHtmlInline&Format=CUSTOM_RENDERER

Is there anything that has to be done differently to get a custom renderer to work in SharePoint integrated mode?

Note: here is the article we followed to initially create the renderer that will work in SSRS native mode:

http://msdn.microsoft.com/msdnmag/issues/05/02/CustomRenderers/

Any help would be appreciated, thanks.

I have had the same problem, and have not found any hints yet on how to get a custom renderer to work. I check the supported/unsupported feature list for Integrated SSRS, and there is no mention there that the feature is not available, so am holding out hope that it is something simple.

-cg

Custom PDF export...

Group...
I have a requirement to add a custom button to an ASPX 'View PDF'. When the
user clicks this button a specific SSRS report will be returned (Open/Save)
as a pdf. I need to be able to do this without using the MS Sample Report
Viewer control (which has the 'Select a format, Export' option just like in
Report Manager).
From what I have read there may be a call that can be made to the RS Web
Service, is this true and if so, is this the only way to accomplish a PDF
export.
Thanks in advance everyone.I have same case as yours, and I am using web service call to accomplish
this. I dont know if there is another way but using RS web service is quite
easy. If you need further information or sample code drop a message.
Regards
"Terry Mulvany" <terry.mulvany@.rouseservices.com> wrote in message
news:eHXMZx92EHA.1452@.TK2MSFTNGP11.phx.gbl...
> Group...
> I have a requirement to add a custom button to an ASPX 'View PDF'. When
the
> user clicks this button a specific SSRS report will be returned
(Open/Save)
> as a pdf. I need to be able to do this without using the MS Sample Report
> Viewer control (which has the 'Select a format, Export' option just like
in
> Report Manager).
> From what I have read there may be a call that can be made to the RS Web
> Service, is this true and if so, is this the only way to accomplish a PDF
> export.
> Thanks in advance everyone.
>|||Do you have a sample link handy?
Thanks so much.
"saglamtimur" <bsaglamtimur@.mayanet.com.tr> wrote in message
news:ul5ho$92EHA.2540@.TK2MSFTNGP09.phx.gbl...
>I have same case as yours, and I am using web service call to accomplish
> this. I dont know if there is another way but using RS web service is
> quite
> easy. If you need further information or sample code drop a message.
> Regards
>
> "Terry Mulvany" <terry.mulvany@.rouseservices.com> wrote in message
> news:eHXMZx92EHA.1452@.TK2MSFTNGP11.phx.gbl...
>> Group...
>> I have a requirement to add a custom button to an ASPX 'View PDF'. When
> the
>> user clicks this button a specific SSRS report will be returned
> (Open/Save)
>> as a pdf. I need to be able to do this without using the MS Sample Report
>> Viewer control (which has the 'Select a format, Export' option just like
> in
>> Report Manager).
>> From what I have read there may be a call that can be made to the RS Web
>> Service, is this true and if so, is this the only way to accomplish a PDF
>> export.
>> Thanks in advance everyone.
>>
>|||My custemer can chose which format to download. I have a sub that accepts
mime type, so I can pass render format to sub, and use one sub for all
formats.
First you must add web referance to ReportService.
Here is the code;
Private Sub renderdoc(ByVal mime As String)
Dim mime_type As String
Dim filename As String
Select Case mime
Case "pdf"
mime_type = "application/pdf"
filename = "fiyatlistesi.pdf"
Case "Excel"
mime_type = "application/x-msexcel"
filename = "fiyatlistesi.xls"
Case "xml"
mime_type = "application/xml"
filename = "fiyatlistesi.xml"
Case Else
mime_type = "application/pdf"
filename = "fiyatlistesi.pdf"
End Select
Dim report As Byte() = Nothing
Dim rs As localhost.ReportingService = New
localhost.ReportingService
'login details comes here
rs.Credentials = New
System.Net.NetworkCredential("raport_user_name_here", "password_here")
rs.PreAuthenticate = True
'report path here, I have a report named fiyat.rdl
Dim reportPath As String = "/rapor/fiyat"
Dim format As String = mime
Dim devInfo As String = _
"<DeviceInfo>" + _
"<Toolbar>False</Toolbar>" + _
"<Parameters>False</Parameters>" + _
"<DocMap>True</DocMap>" + _
"<Zoom>100</Zoom>" + _
"</DeviceInfo>"
Dim historyID As String = Nothing
'I have 3 report parameters, I define them here
Dim parameters(2) As localhost.ParameterValue
Dim paramValue As localhost.ParameterValue = New
localhost.ParameterValue
'First param name is cari_isim (ok its in Turkish)
paramValue.Name = "cari_isim"
paramValue.Value = textbox1.text
parameters(0) = paramValue
'second here
paramValue = New localhost.ParameterValue
paramValue.Name = "fiyatgrup"
paramValue.Value = textbox2.text
parameters(1) = paramValue
'third here
paramValue = New localhost.ParameterValue
paramValue.Name = "urunler"
paramValue.Value = dropdownlist1.selecteditem.value
parameters(2) = paramValue
Dim credentials() As localhost.DataSourceCredentials = Nothing
Dim showHideToggle As String = Nothing
Dim encoding As String
Dim mimeType As String
Dim warnings() As localhost.Warning = Nothing
Dim reportHistoryParameters() As localhost.ParameterValue = Nothing
Dim streamIDs() As String = Nothing
Dim sh As localhost.SessionHeader = New localhost.SessionHeader
rs.SessionHeaderValue = sh
Try
report = rs.Render(reportPath, format, historyID, _
devInfo, parameters, credentials, _
showHideToggle, encoding, mimeType, _
reportHistoryParameters, warnings, _
streamIDs)
sh.SessionId = rs.SessionHeaderValue.SessionId
Response.Clear()
HttpContext.Current.Response.ClearHeaders()
HttpContext.Current.Response.ClearContent()
HttpContext.Current.Response.ContentType = mime_type
HttpContext.Current.Response.AddHeader("Content-disposition",
"attachment; filename=" + filename + "")
HttpContext.Current.Response.BinaryWrite(report)
HttpContext.Current.Response.Flush()
HttpContext.Current.Response.End()
Catch ex As Exception
If ex.Message <> "Thread was being aborted." Then
HttpContext.Current.Response.ClearHeaders()
HttpContext.Current.Response.ClearContent()
HttpContext.Current.Response.ContentType = "text/html"
HttpContext.Current.Response.Write( _
"&

---

Error" & _
ex.Message & "

---

")
HttpContext.Current.Response.End()
End If
End Try
End Sub
Hope works for you.
Regards
"Terry Mulvany" <terry.mulvany@.rouseservices.com> wrote in message
news:#yYGGv#2EHA.1264@.TK2MSFTNGP12.phx.gbl...
> Do you have a sample link handy?
> Thanks so much.
> "saglamtimur" <bsaglamtimur@.mayanet.com.tr> wrote in message
> news:ul5ho$92EHA.2540@.TK2MSFTNGP09.phx.gbl...
> >I have same case as yours, and I am using web service call to accomplish
> > this. I dont know if there is another way but using RS web service is
> > quite
> > easy. If you need further information or sample code drop a message.
> >
> > Regards
> >
> >
> >
> > "Terry Mulvany" <terry.mulvany@.rouseservices.com> wrote in message
> > news:eHXMZx92EHA.1452@.TK2MSFTNGP11.phx.gbl...
> >> Group...
> >> I have a requirement to add a custom button to an ASPX 'View PDF'. When
> > the
> >> user clicks this button a specific SSRS report will be returned
> > (Open/Save)
> >> as a pdf. I need to be able to do this without using the MS Sample
Report
> >> Viewer control (which has the 'Select a format, Export' option just
like
> > in
> >> Report Manager).
> >>
> >> From what I have read there may be a call that can be made to the RS
Web
> >> Service, is this true and if so, is this the only way to accomplish a
PDF
> >> export.
> >>
> >> Thanks in advance everyone.
> >>
> >>
> >
> >
>|||In the URL for the report you can specify the Render property for whatever
output you wish. The following (part) URLs demonstrate this. I have a number
of buttons on my asps, that allow the user to output directly to XL, PDF or
the standard RS report page, by using the following::
NOTE: I use javascript to create the link and then open a new results window
at this point::
function GET_RS(aFormat)
{
var sReportName="myReport1";
if(aFormat=="EXCEL"){sReportName="ReportRS1XL";GET_HELP('XL')}
if(aFormat=="PDF"){sReportName="ReportRS1";GET_HELP('PD')}
HLINK = HLINK + "http://myServer/ReportServer"
HLINK = HLINK + "?%2fBaanReports%2f"+sReportName HLINK = HLINK +
"&rs%3aClearSession=true"
HLINK = HLINK + "&rs%3aCommand=Render"
HLINK = HLINK + "&rs%3aFormat=" + aFormat
.....
....
}
This blows through the standard RS page, where the user then has to select
the output format and click the Export link.
Hope this helps
Tony
"Terry Mulvany" wrote:
> Group...
> I have a requirement to add a custom button to an ASPX 'View PDF'. When the
> user clicks this button a specific SSRS report will be returned (Open/Save)
> as a pdf. I need to be able to do this without using the MS Sample Report
> Viewer control (which has the 'Select a format, Export' option just like in
> Report Manager).
> From what I have read there may be a call that can be made to the RS Web
> Service, is this true and if so, is this the only way to accomplish a PDF
> export.
> Thanks in advance everyone.
>
>

Custom FormsAuthentication by means of a proxy...

I need to understand how to go about and implementing a custom SSO in SSRS. The scenario is that I have a custom J2EE application that handles authentication and I need to make SSRS to use it. I've done quite a bit of reading but is still unclear about possible ways to do it.

One way could be to place a proxy that uses webservices (SOAP) to call on RS. When user accesses the page, it would check the session for the SR token and if it is not present it would check with the authentication server if the user is logged on and if he is, it would log him on to the RS and store the generated token in his session. Otherwise it would simply pass on the token to the RS. Is this the correct way of thinking? Are there any other possible ways to do it? Would it be possible to generate a correct cookie from SOAP-reply and set it for the user so that he then could automagically access the RS withouth the proxy?

As I understand, one could also implement IAthentication (?) interface (the one with the logon-method) that could call on the authenticationserver. This would enable direct display of the reports without a proxy, but the code would have to be written in .NET (so far I failed to find a single code-sample that would work in a fresh install of development tools for RS2005 and that includes msdn). Any comments on that?

Thanks in advance!
Nobody knows anything?

custom formatting codes

I need to create formatting that is a bit different from the standard formatting codes in SSRS. Specifically, I need to have the percent sign come right after the number (SSRS inserts a space), whereas with currency fields I need to inster a space between the $ and the number (SSRS has no space). Is there any way to do this with custom formatting codes, or will I need to go through and add the percent and dollar sign in manually to each field so that the space can either be removed or inserted?

just use "#,###%" and "$ #,###" in the formatting condition of textboxes

PS when you put % in the specified manner SSRS multiply the result by 100 so you may require to divide your final result by 100. Just depends.

Priyank

|||Priyank, thanks! This works, but there's one problem. I can't seem to get the decimals if they are zero. In other words $5.00 just displays as $5. I tried using "$#,###.##" but that has the same problem... Any way to get the zeros to show?
|||

$ #,###.#0

|||Great, that did the trick! Thanks!
|||Ok, one more related question - how would I within this code specify using parens for negative values instead of a minus sign? I tried playing around with adding parens to the code, but now luck...
|||

I believe you need to use the following as your formatting code, where $ #,###.#0 is what you were using successfully for positive numbers:

Code Snippet

$ #,###.#0;($ #,###.#0);Zero

(replace Zero above with whatever you want the value 0 to look like)

... see http://msdn2.microsoft.com/en-us/library/0c899ak8(VS.80).aspx

>L<

|||Thanks so much!

I'll try that out.

custom formatting codes

I need to create formatting that is a bit different from the standard formatting codes in SSRS. Specifically, I need to have the percent sign come right after the number (SSRS inserts a space), whereas with currency fields I need to inster a space between the $ and the number (SSRS has no space). Is there any way to do this with custom formatting codes, or will I need to go through and add the percent and dollar sign in manually to each field so that the space can either be removed or inserted?

just use "#,###%" and "$ #,###" in the formatting condition of textboxes

PS when you put % in the specified manner SSRS multiply the result by 100 so you may require to divide your final result by 100. Just depends.

Priyank

|||Priyank, thanks! This works, but there's one problem. I can't seem to get the decimals if they are zero. In other words $5.00 just displays as $5. I tried using "$#,###.##" but that has the same problem... Any way to get the zeros to show?
|||

$ #,###.#0

|||Great, that did the trick! Thanks!
|||Ok, one more related question - how would I within this code specify using parens for negative values instead of a minus sign? I tried playing around with adding parens to the code, but now luck...
|||

I believe you need to use the following as your formatting code, where $ #,###.#0 is what you were using successfully for positive numbers:

Code Snippet

$ #,###.#0;($ #,###.#0);Zero

(replace Zero above with whatever you want the value 0 to look like)

... see http://msdn2.microsoft.com/en-us/library/0c899ak8(VS.80).aspx

>L<

|||Thanks so much!

I'll try that out.

custom error page

Hello,
Is there a a way to catch general errors on ssrs and display a custom error page to the user?

The goal is that if a user try to access a report when the ssrs is down, He won't see the RS general error but a custom notice from me.

Thanks.

If you are using report manager (which is an ASP.NET web application), I guess you can do that by configuring your custom error page in web.config file available in Program Files\Microsoft SQL Server\MSSQL.X\Reporting Services\ReportManager folder. Set mode="on" for customErrors tag and define the custom error page as you do for any other ASP.NET web application.

Shyam

|||

More details on how to use custom error pages in a web application:

You can use defaultRedirect attribute of customErrors tag to tell the application to go to another custom web page by default if any error occurs. Also you can define error pages for specific types of errors like 401, 402 etc. and add them as error tags inside this customErrors tag. En example would look like this:

<customErrors mode="on" defaultRedirect="/error.html">
<error statusCode="403" redirect="/accessdenied.html" />
<error statusCode="404" redirect="/pagenotfound.html" />
</customErrors>

where error.html, accessdenied.html and pagenotfound.html are the files that you create and place in the appropriate folder on report manager virtual directory.

Shyam

|||Hi Sundar,

Thats exctly what I did after I read your previus post

Hope it will work fine. I now have to do some tasting.

Thanks for the solution!

custom error page

Hello,
Is there a a way to catch general errors on ssrs and display a custom
error page to the user?
The goal is that if a user try to access a report when the ssrs is
down, He won't see the RS general error but a custom notice from me.
Thanks.Absolutely possible as we have it implemented.
Absolutely no idea how it was achieved as I'm not a developer :(
Sorry
"nicknack" <roezohar@.gmail.com> wrote in message
news:1174999816.602638.279850@.y80g2000hsf.googlegroups.com...
> Hello,
> Is there a a way to catch general errors on ssrs and display a custom
> error page to the user?
> The goal is that if a user try to access a report when the ssrs is
> down, He won't see the RS general error but a custom notice from me.
> Thanks.
>

Custom Delivery Extension - SubscriptionID

I am attempting to implement a custom delivery extension for SSRS 2000. The custom delivery extension will deliver the report to a database(table). CreateSubscription WebMethod returns a SubscriptionID once a subscription is created. Is it possible to get this SubscriptionID at run-time i.e when the IDeliveryExtension.Deliver method is called? If so, how? I want to store the SubscriptionID with the report in the database. Thanks for your help.

Hi

I had the same question .

please help us.

Custom Delivery Extension - SubscriptionID

I am attempting to implement a custom delivery extension for SSRS 2000. The custom delivery extension will deliver the report to a database(table). CreateSubscription WebMethod returns a SubscriptionID once a subscription is created. Is it possible to get this SubscriptionID at run-time i.e when the IDeliveryExtension.Deliver method is called? If so, how? I want to store the SubscriptionID with the report in the database. Thanks for your help.

Hi

I had the same question .

please help us.

Custom Data Processing Extensions/Custom Data Providers

Hello!

I'm trying to understand the limitations that SSRS places on a developing reports involving multiple data sources and how I can possibly create a custom data provider for a report that will consolidate data from multiple data sources..

thanks in advance.

Doug.

If you want to see what is all involved in creating a Custom Data Processing extension, I used the FSI example that comes with the SQL Server install. It gives you a good idea of what needs to be involved.

I extended and added to it a great deal but the basis for what you need to do is in there. It's non-trivial, but very do-able.

|||

I'll look into that!

THanks!!!!

doug

|||

Instead of implementing a data processing extension, you should look at the T-SQL OPENROWSET command

http://msdn2.microsoft.com/en-us/library/ms190312.aspx

Or linking servers

http://msdn2.microsoft.com/en-us/library/ms188279.aspx

These give you the ability to consolidate multiple data sources and it is a lot easier than implementing your own data processing extension to do the same. The only caveat is that it requires SQL Server.

|||

We're using Oracle...so that kind of bites...

well, we've hit a snag in our development of our extension..

I cannot figure out why I get this exception when we try to generate a DataSet in our SSRS IDE:

A connection cannot be made to the database,
Set and test the connection string.
Additional Information:
The data extension FOCUS could not be loaded. Check the the configuration files RSReportDesigner.config(Microsoft.ReportingServices.Designer)

We added the following to the RSReportDesigner.config file:

<Extension Name="FOCUS" Type="PPD.Focus.FocusDPE.FocusDbConn, PPD.Focus.FocusDPE"/>

And the dll's complete with the proper namespaces are all in the proper directories:

C:\Program Files\Microsoft SQL Server\MSSQL.4\Reporting Services\ReportServer\bin\PPD.Focus.FocusDPE.dll
C:\Program Files\Microsoft Visual Studio 8\Common7\IDE\PrivateAssemblies\PPD.Focus.FocusDPE.dll

We've tried to step into the extension code using a techique outlined in MSDN without any luck. We've also attempted to write out errors the Event Viewer, but it doesn't even seem to get into the connection object,

Any Idea of where I'm going wrong?

thanks!

Doug

Custom Data Processing Extensions/Custom Data Providers

Hello!

I'm trying to understand the limitations that SSRS places on a developing reports involving multiple data sources and how I can possibly create a custom data provider for a report that will consolidate data from multiple data sources..

thanks in advance.

Doug.

If you want to see what is all involved in creating a Custom Data Processing extension, I used the FSI example that comes with the SQL Server install. It gives you a good idea of what needs to be involved.

I extended and added to it a great deal but the basis for what you need to do is in there. It's non-trivial, but very do-able.

|||

I'll look into that!

THanks!!!!

doug

|||

Instead of implementing a data processing extension, you should look at the T-SQL OPENROWSET command

http://msdn2.microsoft.com/en-us/library/ms190312.aspx

Or linking servers

http://msdn2.microsoft.com/en-us/library/ms188279.aspx

These give you the ability to consolidate multiple data sources and it is a lot easier than implementing your own data processing extension to do the same. The only caveat is that it requires SQL Server.

|||

We're using Oracle...so that kind of bites...

well, we've hit a snag in our development of our extension..

I cannot figure out why I get this exception when we try to generate a DataSet in our SSRS IDE:

A connection cannot be made to the database,
Set and test the connection string.
Additional Information:
The data extension FOCUS could not be loaded. Check the the configuration files RSReportDesigner.config(Microsoft.ReportingServices.Designer)

We added the following to the RSReportDesigner.config file:

<Extension Name="FOCUS" Type="PPD.Focus.FocusDPE.FocusDbConn, PPD.Focus.FocusDPE"/>

And the dll's complete with the proper namespaces are all in the proper directories:

C:\Program Files\Microsoft SQL Server\MSSQL.4\Reporting Services\ReportServer\bin\PPD.Focus.FocusDPE.dll
C:\Program Files\Microsoft Visual Studio 8\Common7\IDE\PrivateAssemblies\PPD.Focus.FocusDPE.dll

We've tried to step into the extension code using a techique outlined in MSDN without any luck. We've also attempted to write out errors the Event Viewer, but it doesn't even seem to get into the connection object,

Any Idea of where I'm going wrong?

thanks!

Doug

Custom Auth / SSRS 2005 / ASP.NET

Hi,
I've implemented the custom authentication provider as prescribed by MSDN
documentation. Everything is working pretty much as expected, however, I
want to programatically retreive information about the report (such as the
datasources, parameters, etc.)
I extended a class for RSExecutionService and can get an authentication
cookie back etc. However, if I want to use the
rs.GetDataSourceContents(dataSource) method, I get a response saying the
object is moved.
The request failed with the error message:
--
<html><head><title>Object moved</title></head><body>
<h2>Object moved to <a
href="http://links.10026.com/?link=/ReportServer/logon.aspx?ReturnUrl=%2fReportServer%2fReportService.asmx">here</a>.</h2>
</body></html>
Ideas on how to get around this?
Thanks,
ChrisNevermind... Should read the word "Proxy" closer... and think before
coding...
solved, works like a charm. Man I love inheritance.
"Chris Taylor" <ctaylor7480@.newsgroups.nospam> wrote in message
news:upSzMR4IGHA.3984@.TK2MSFTNGP14.phx.gbl...
> Hi,
> I've implemented the custom authentication provider as prescribed by MSDN
> documentation. Everything is working pretty much as expected, however, I
> want to programatically retreive information about the report (such as the
> datasources, parameters, etc.)
> I extended a class for RSExecutionService and can get an authentication
> cookie back etc. However, if I want to use the
> rs.GetDataSourceContents(dataSource) method, I get a response saying the
> object is moved.
> The request failed with the error message:
> --
> <html><head><title>Object moved</title></head><body>
> <h2>Object moved to <a
> href="http://links.10026.com/?link=/ReportServer/logon.aspx?ReturnUrl=%2fReportServer%2fReportService.asmx">here</a>.</h2>
> </body></html>
> Ideas on how to get around this?
> Thanks,
> Chris
>

Custom Assembly Error

I have a SQL Server 2000 database that has a table with a text field whose
contents are in RTF format. My goal is to display this text in SSRS
reports. I have created a custom assembly to convert rtf formated text into
plain text.
Imports System.Windows.Forms
Public Class RichTextServices
Public Shared Function ConvertToPlainText(ByVal RTFText As String) As String
Dim m_rtb = New RichTextBox
m_rtb.Rtf = RTFText
Return m_rtb.Text
End Function
End Class
The assembly works great in preview mode. However, when I run the report
from my browser I get an error in the field containing the converted text.
I have copied my DLL to "C:\Program Files\Microsoft SQL
Server\MSSQL\Reporting Services\ReportServer\bin".
I have also added the attached code group to the "rssrvpolicy.config" and
"rsmgrpolicy.config" files. It still does not work.
What am I missing? Any suggestions would be greatly appreciated.
PS - If anyone knows a better way to handle RTF in SSRS that would also be
great to know. Especially if you can actually display the text with the
original formatting.
<CodeGroup
class="UnionCodeGroup"
version="1"
PermissionSetName="FullTrust"
Name="MyCodeGroup"
Description="Code group for my data processing extension">
<IMembershipCondition
class="UrlMembershipCondition"
version="1"
Url="C:\Program Files\Microsoft SQL Server\MSSQL\Reporting
Services\ReportServer\bin\myAssembly.dll"
/>
</CodeGroup>Hello Guess,
It seems the issue is caused by RichTextBox which is a com object. I wonder
if you also deploy the interop com assembly to the following folder:
C:\Program Files\Microsoft SQL Server\MSSQL\Reporting
Services\ReportServer\bin
Also, I suggest that you refer to the following article to deploy your
custom assembly in reporting service.
Deploying a Custom Assembly
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/RSPROG/htm/
rsp_prog_rdl_8mue.asp
Have a great day!
Best Regards,
Peter Yang
MCSE2000, MCSA, MCDBA
Microsoft Partner Online Support
Get Secure! - www.microsoft.com/security
=====================================================When responding to posts, please "Reply to Group" via
your newsreader so that others may learn and benefit
from your issue.
=====================================================This posting is provided "AS IS" with no warranties, and confers no rights.
| Reply-To: "Guess Nospam" <guess@.nospam.ha>
| From: "Guess Nospam" <guess@.nospam.ha>
| Subject: Custom Assembly Error
| Date: Mon, 25 Oct 2004 16:33:58 -0700
| Lines: 62
| X-Priority: 3
| X-MSMail-Priority: Normal
| X-Newsreader: Microsoft Outlook Express 6.00.2800.1409
| X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1409
| Message-ID: <O2KcisuuEHA.3376@.TK2MSFTNGP12.phx.gbl>
| Newsgroups: microsoft.public.sqlserver.reportingsvcs
| NNTP-Posting-Host: ftp.city.vancouver.bc.ca 199.175.219.1
| Path:
cpmsftngxa10.phx.gbl!TK2MSFTFEED01.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTNGP12

Custom assembilies in the Dundas Controls

Hi,

Currently I am using SSRS 2005 and the Dundas Map and Chart controls.

I have been doing extensive customization with these controls thru custom assembilies / DLL's written in C#.

For the upcoming integration of the controls into SSRS 2008, will the same amount of extensibility be available?

Thanks!

Do I need to provide an example of this?

Would that help my post get a response?

Thanks!

|||

(bump)

Could someone let me know about this?

I wouldn't mind posting something to make a case for it.

Thanks,

-Don

|||

Can someone please respond to this?

Thanks,

-Don

|||

Don, could you provide an example of what properties you have customized, what kind of functionality is performed within your customizations?

-- Robert

|||

Hi Robert,

I use all the Dundas controls, but I have currently only customized two, Chart and Map.

With either of them I am creating a C# dll and linking to it via the "Custom Assemblies" tab.

For the Chart control, I create pareto lines, create shaded areas based on data and insert simple graphics for navigation/drill thru's to other reports.

The bulk of my customization has been done with the map control.

For one of my clients (a large real estate developer) I created ESRI compliant shapefiles that represent each home in a subdivision. These are loaded based on user selections, showing the status of sales or any metric the user chooses.

I recently have started reporting sales and marketing data using the map control and the US maps included with it. I'm also using shapes representing zipcode areas to show geographic locations of customers, etc etc.

With both the map and chart control, one of the most if not the most powerful feature IMO is the ability for me to get a reference to the actual graphics object and draw directly into it using C# and GDI+. Also, Dundas exposing the render cycle in many stages allows me a ton of flexibility in my control over the render process.

While I completely welcome your team integrating the Dundas controls into SSRS (the dialogs for the chart control in 2000 & 2005 were much better than the Dundas dialogs IMO), it would be really awesome if you could either improve on the extensibility via .dll's as I have previously mentioned or leave the existing functionality there with no changes.

I know I probably one of a few folks that are using the controls in this way but I feel confident that if the extensibility were to remain in the controls for SSRS 2008/Katmai that you would quickly have a die hard group of new users taking advantage of this.

Every client I have showed the custom map stuff to has been extremely surprised the ease that it can be customized (new shapes/shapefiles etc). It has been a dealmaker. The maps have been so effective it's lead to many clients of mine purchasing the Dundas suite simply for the map control (and these are clients that do not normally purchase 3rd party controls).

Please feel free to contact me directly if you feel any of this needs more explanation, I would be happy to go over it and provide any examples that you may need.

Thanks!

-Don

|||

We appreciate the feedback and take it into account.

At this point however it is a bit too early to make definitive statements if it is going to fit in SSRS 2008.

-- Robert

|||

Hi Robert,

Does this mean that the Dundas Map & Chart may not make it into SSRS 2008?

Thanks!

-Don

Custom assembilies in the Dundas Controls

Hi,

Currently I am using SSRS 2005 and the Dundas Map and Chart controls.

I have been doing extensive customization with these controls thru custom assembilies / DLL's written in C#.

For the upcoming integration of the controls into SSRS 2008, will the same amount of extensibility be available?

Thanks!

Do I need to provide an example of this?

Would that help my post get a response?

Thanks!

|||

(bump)

Could someone let me know about this?

I wouldn't mind posting something to make a case for it.

Thanks,

-Don

|||

Can someone please respond to this?

Thanks,

-Don

|||

Don, could you provide an example of what properties you have customized, what kind of functionality is performed within your customizations?

-- Robert

|||

Hi Robert,

I use all the Dundas controls, but I have currently only customized two, Chart and Map.

With either of them I am creating a C# dll and linking to it via the "Custom Assemblies" tab.

For the Chart control, I create pareto lines, create shaded areas based on data and insert simple graphics for navigation/drill thru's to other reports.

The bulk of my customization has been done with the map control.

For one of my clients (a large real estate developer) I created ESRI compliant shapefiles that represent each home in a subdivision. These are loaded based on user selections, showing the status of sales or any metric the user chooses.

I recently have started reporting sales and marketing data using the map control and the US maps included with it. I'm also using shapes representing zipcode areas to show geographic locations of customers, etc etc.

With both the map and chart control, one of the most if not the most powerful feature IMO is the ability for me to get a reference to the actual graphics object and draw directly into it using C# and GDI+. Also, Dundas exposing the render cycle in many stages allows me a ton of flexibility in my control over the render process.

While I completely welcome your team integrating the Dundas controls into SSRS (the dialogs for the chart control in 2000 & 2005 were much better than the Dundas dialogs IMO), it would be really awesome if you could either improve on the extensibility via .dll's as I have previously mentioned or leave the existing functionality there with no changes.

I know I probably one of a few folks that are using the controls in this way but I feel confident that if the extensibility were to remain in the controls for SSRS 2008/Katmai that you would quickly have a die hard group of new users taking advantage of this.

Every client I have showed the custom map stuff to has been extremely surprised the ease that it can be customized (new shapes/shapefiles etc). It has been a dealmaker. The maps have been so effective it's lead to many clients of mine purchasing the Dundas suite simply for the map control (and these are clients that do not normally purchase 3rd party controls).

Please feel free to contact me directly if you feel any of this needs more explanation, I would be happy to go over it and provide any examples that you may need.

Thanks!

-Don

|||

We appreciate the feedback and take it into account.

At this point however it is a bit too early to make definitive statements if it is going to fit in SSRS 2008.

-- Robert

|||

Hi Robert,

Does this mean that the Dundas Map & Chart may not make it into SSRS 2008?

Thanks!

-Don

Custom assembilies in the Dundas Controls

Hi,

Currently I am using SSRS 2005 and the Dundas Map and Chart controls.

I have been doing extensive customization with these controls thru custom assembilies / DLL's written in C#.

For the upcoming integration of the controls into SSRS 2008, will the same amount of extensibility be available?

Thanks!

Do I need to provide an example of this?

Would that help my post get a response?

Thanks!

|||

(bump)

Could someone let me know about this?

I wouldn't mind posting something to make a case for it.

Thanks,

-Don

|||

Can someone please respond to this?

Thanks,

-Don

|||

Don, could you provide an example of what properties you have customized, what kind of functionality is performed within your customizations?

-- Robert

|||

Hi Robert,

I use all the Dundas controls, but I have currently only customized two, Chart and Map.

With either of them I am creating a C# dll and linking to it via the "Custom Assemblies" tab.

For the Chart control, I create pareto lines, create shaded areas based on data and insert simple graphics for navigation/drill thru's to other reports.

The bulk of my customization has been done with the map control.

For one of my clients (a large real estate developer) I created ESRI compliant shapefiles that represent each home in a subdivision. These are loaded based on user selections, showing the status of sales or any metric the user chooses.

I recently have started reporting sales and marketing data using the map control and the US maps included with it. I'm also using shapes representing zipcode areas to show geographic locations of customers, etc etc.

With both the map and chart control, one of the most if not the most powerful feature IMO is the ability for me to get a reference to the actual graphics object and draw directly into it using C# and GDI+. Also, Dundas exposing the render cycle in many stages allows me a ton of flexibility in my control over the render process.

While I completely welcome your team integrating the Dundas controls into SSRS (the dialogs for the chart control in 2000 & 2005 were much better than the Dundas dialogs IMO), it would be really awesome if you could either improve on the extensibility via .dll's as I have previously mentioned or leave the existing functionality there with no changes.

I know I probably one of a few folks that are using the controls in this way but I feel confident that if the extensibility were to remain in the controls for SSRS 2008/Katmai that you would quickly have a die hard group of new users taking advantage of this.

Every client I have showed the custom map stuff to has been extremely surprised the ease that it can be customized (new shapes/shapefiles etc). It has been a dealmaker. The maps have been so effective it's lead to many clients of mine purchasing the Dundas suite simply for the map control (and these are clients that do not normally purchase 3rd party controls).

Please feel free to contact me directly if you feel any of this needs more explanation, I would be happy to go over it and provide any examples that you may need.

Thanks!

-Don

|||

We appreciate the feedback and take it into account.

At this point however it is a bit too early to make definitive statements if it is going to fit in SSRS 2008.

-- Robert

|||

Hi Robert,

Does this mean that the Dundas Map & Chart may not make it into SSRS 2008?

Thanks!

-Don

Custom assembilies in the Dundas Controls

Hi,

Currently I am using SSRS 2005 and the Dundas Map and Chart controls.

I have been doing extensive customization with these controls thru custom assembilies / DLL's written in C#.

For the upcoming integration of the controls into SSRS 2008, will the same amount of extensibility be available?

Thanks!

Do I need to provide an example of this?

Would that help my post get a response?

Thanks!

|||

(bump)

Could someone let me know about this?

I wouldn't mind posting something to make a case for it.

Thanks,

-Don

|||

Can someone please respond to this?

Thanks,

-Don

|||

Don, could you provide an example of what properties you have customized, what kind of functionality is performed within your customizations?

-- Robert

|||

Hi Robert,

I use all the Dundas controls, but I have currently only customized two, Chart and Map.

With either of them I am creating a C# dll and linking to it via the "Custom Assemblies" tab.

For the Chart control, I create pareto lines, create shaded areas based on data and insert simple graphics for navigation/drill thru's to other reports.

The bulk of my customization has been done with the map control.

For one of my clients (a large real estate developer) I created ESRI compliant shapefiles that represent each home in a subdivision. These are loaded based on user selections, showing the status of sales or any metric the user chooses.

I recently have started reporting sales and marketing data using the map control and the US maps included with it. I'm also using shapes representing zipcode areas to show geographic locations of customers, etc etc.

With both the map and chart control, one of the most if not the most powerful feature IMO is the ability for me to get a reference to the actual graphics object and draw directly into it using C# and GDI+. Also, Dundas exposing the render cycle in many stages allows me a ton of flexibility in my control over the render process.

While I completely welcome your team integrating the Dundas controls into SSRS (the dialogs for the chart control in 2000 & 2005 were much better than the Dundas dialogs IMO), it would be really awesome if you could either improve on the extensibility via .dll's as I have previously mentioned or leave the existing functionality there with no changes.

I know I probably one of a few folks that are using the controls in this way but I feel confident that if the extensibility were to remain in the controls for SSRS 2008/Katmai that you would quickly have a die hard group of new users taking advantage of this.

Every client I have showed the custom map stuff to has been extremely surprised the ease that it can be customized (new shapes/shapefiles etc). It has been a dealmaker. The maps have been so effective it's lead to many clients of mine purchasing the Dundas suite simply for the map control (and these are clients that do not normally purchase 3rd party controls).

Please feel free to contact me directly if you feel any of this needs more explanation, I would be happy to go over it and provide any examples that you may need.

Thanks!

-Don

|||

We appreciate the feedback and take it into account.

At this point however it is a bit too early to make definitive statements if it is going to fit in SSRS 2008.

-- Robert

|||

Hi Robert,

Does this mean that the Dundas Map & Chart may not make it into SSRS 2008?

Thanks!

-Don

Custom assembilies in the Dundas Controls

Hi,

Currently I am using SSRS 2005 and the Dundas Map and Chart controls.

I have been doing extensive customization with these controls thru custom assembilies / DLL's written in C#.

For the upcoming integration of the controls into SSRS 2008, will the same amount of extensibility be available?

Thanks!

Do I need to provide an example of this?

Would that help my post get a response?

Thanks!

|||

(bump)

Could someone let me know about this?

I wouldn't mind posting something to make a case for it.

Thanks,

-Don

|||

Can someone please respond to this?

Thanks,

-Don

|||

Don, could you provide an example of what properties you have customized, what kind of functionality is performed within your customizations?

-- Robert

|||

Hi Robert,

I use all the Dundas controls, but I have currently only customized two, Chart and Map.

With either of them I am creating a C# dll and linking to it via the "Custom Assemblies" tab.

For the Chart control, I create pareto lines, create shaded areas based on data and insert simple graphics for navigation/drill thru's to other reports.

The bulk of my customization has been done with the map control.

For one of my clients (a large real estate developer) I created ESRI compliant shapefiles that represent each home in a subdivision. These are loaded based on user selections, showing the status of sales or any metric the user chooses.

I recently have started reporting sales and marketing data using the map control and the US maps included with it. I'm also using shapes representing zipcode areas to show geographic locations of customers, etc etc.

With both the map and chart control, one of the most if not the most powerful feature IMO is the ability for me to get a reference to the actual graphics object and draw directly into it using C# and GDI+. Also, Dundas exposing the render cycle in many stages allows me a ton of flexibility in my control over the render process.

While I completely welcome your team integrating the Dundas controls into SSRS (the dialogs for the chart control in 2000 & 2005 were much better than the Dundas dialogs IMO), it would be really awesome if you could either improve on the extensibility via .dll's as I have previously mentioned or leave the existing functionality there with no changes.

I know I probably one of a few folks that are using the controls in this way but I feel confident that if the extensibility were to remain in the controls for SSRS 2008/Katmai that you would quickly have a die hard group of new users taking advantage of this.

Every client I have showed the custom map stuff to has been extremely surprised the ease that it can be customized (new shapes/shapefiles etc). It has been a dealmaker. The maps have been so effective it's lead to many clients of mine purchasing the Dundas suite simply for the map control (and these are clients that do not normally purchase 3rd party controls).

Please feel free to contact me directly if you feel any of this needs more explanation, I would be happy to go over it and provide any examples that you may need.

Thanks!

-Don

|||

We appreciate the feedback and take it into account.

At this point however it is a bit too early to make definitive statements if it is going to fit in SSRS 2008.

-- Robert

|||

Hi Robert,

Does this mean that the Dundas Map & Chart may not make it into SSRS 2008?

Thanks!

-Don