customization of browser setting in reporting services 2000

Hi
I want to know how can i customize browser setting in Reporting
services 2000.I wish to show name of my report on browser.I don`t want
to show it as Report parameter.It should be text , just name of the
report.How is this feasible? can it be done by changing report
container, if yes than how?
Quick reply will be highly appreciated.You can try editing the file Report.aspx with a javascript that adds the
name of the report.
Try following the code in this thread:
http://groups.google.com/group/microsoft.public.sqlserver.reportingsvcs/browse_thread/thread/39e5747688f51268/d0a6a49f6891dfd4?lnk=gst&q=javascript+title&rnum=2#d0a6a49f6891dfd4
Kaisa M. Lindahl Lervik
"vishal" <vishal_9feb@.yahoo.co.in> wrote in message
news:1155185261.353691.32120@.i42g2000cwa.googlegroups.com...
> Hi
> I want to know how can i customize browser setting in Reporting
> services 2000.I wish to show name of my report on browser.I don`t want
> to show it as Report parameter.It should be text , just name of the
> report.How is this feasible? can it be done by changing report
> container, if yes than how?
>
> Quick reply will be highly appreciated.
>

Customization at runtime

I have a report which i am using in vb6.

it has following
itemid, itemname,price

but i want to give user choice to change this order at runtime,
according to him like
itemname,itemid,price or it can be any combination.

Ideas will be appreciated.
Thanks in AdvanceHi,
yes you could but not Only using CR but VB + SQL manupulating to suit u r requirement

the SQL which brings u data has to be
select Itemid as Filed1, itemname as Filed2 , price as Filed3

ie u let the user decided the orer he wants (in VB he decides through a ordering using selecting from a Left Listbox to right Listbox)

the according to that u Generate the SQL

select Itemid as Filed1, itemname as Filed2 , price as Filed3
Or
select itemname as Filed1, Itemid as Filed2 , price as Filed3
Or
......(u can simply do this depending on the use selection)

but in crystal Report use a 'Field Definitions Only' in (Database Expert --> create new connection ) then create a .ttx file with 3 field of type String with name Filed1, Filed2, Filed3 then place them in report in order

in VB set the DS value got from SQL to this report the

Note : the Order is Truely dynamic in SQL but user feels like the rpt is, but u have created only one Rpt.

Hope u got it
FaFa|||Thanks it worked.

Do you have any idea about letting user to place fields at specified position.

Thanks in Advancesql

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

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