Hi friends,
i want to know something abt sql server installation and database properties as under.
1) how much disk space reqd by multiuser sqlserver 2000 db to install ?
2) is it possible to install sql 2K on Flash Drive ( gen connect at USB) ?
3) When v create a database user Enterprise Manager , which files created by database ?
4) If i Know datafiles name of a database e.g. pubs , and if v copied on cd and paste on other system which has sql 2K install , does those database works ?
5) is it possible to create database on flash drive ?
thanx in advance.Come on...are these trick questions?|||I suppose it could be done, but you would have to be very sure that you properly detach the database before someone goes and unplugs the USB drive. I think you would set yourself up for a heck of a lot more user errors than SQL Server errors this way.
Showing posts with label installation. Show all posts
Showing posts with label installation. Show all posts
Thursday, March 29, 2012
Thursday, March 22, 2012
Data Driven Subscriptions
Hello,
I have an installation of Reporting Services with SQL
Server 7.0 SP3. One of my reports is a data driven
subscription and it worked wonderfully.
Then, I applied Reporting Services Service Pack 1 and now
the data driven subscription does not work.
Any ideas?
Thanks,
DaveSorry, SQL Server 2000 SP3
>--Original Message--
>Hello,
>I have an installation of Reporting Services with SQL
>Server 7.0 SP3. One of my reports is a data driven
>subscription and it worked wonderfully.
>Then, I applied Reporting Services Service Pack 1 and now
>the data driven subscription does not work.
>Any ideas?
>Thanks,
>Dave
>.
>
I have an installation of Reporting Services with SQL
Server 7.0 SP3. One of my reports is a data driven
subscription and it worked wonderfully.
Then, I applied Reporting Services Service Pack 1 and now
the data driven subscription does not work.
Any ideas?
Thanks,
DaveSorry, SQL Server 2000 SP3
>--Original Message--
>Hello,
>I have an installation of Reporting Services with SQL
>Server 7.0 SP3. One of my reports is a data driven
>subscription and it worked wonderfully.
>Then, I applied Reporting Services Service Pack 1 and now
>the data driven subscription does not work.
>Any ideas?
>Thanks,
>Dave
>.
>
Friday, February 24, 2012
Daniel Reib, Please Help with installation error
On one particular server, when installing Reporting Services I keep getting
"Failure Compiling WMI registration file"
What is the problem and how can I resolve it.
Thank you.
--Hmm, not really sure what would cause this. Can you run setup, when it
fails, but before you cancel, run mofcomp on reportingservices.mof. Perhaps
this will give a more detailed error message.
--
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"Richard Cranium" <mgreco40@.hotmail.com> wrote in message
news:eeDqOZBnEHA.324@.TK2MSFTNGP11.phx.gbl...
> On one particular server, when installing Reporting Services I keep
getting
> "Failure Compiling WMI registration file"
> What is the problem and how can I resolve it.
> Thank you.
> --
>
>
"Failure Compiling WMI registration file"
What is the problem and how can I resolve it.
Thank you.
--Hmm, not really sure what would cause this. Can you run setup, when it
fails, but before you cancel, run mofcomp on reportingservices.mof. Perhaps
this will give a more detailed error message.
--
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"Richard Cranium" <mgreco40@.hotmail.com> wrote in message
news:eeDqOZBnEHA.324@.TK2MSFTNGP11.phx.gbl...
> On one particular server, when installing Reporting Services I keep
getting
> "Failure Compiling WMI registration file"
> What is the problem and how can I resolve it.
> Thank you.
> --
>
>
Damaged database
I in a real catastrophic scenario in a SQL2000
installation:
Due to a hardware failure:
I HAVE A SINGLE MDF, NOTHING ELSE .
The database originally was formed with this single mdf
and a single ldf, and its recovery model was simple.
I tried sp_attach_single_file_db as documented, but it
returned errors.
I tried to out smart the engine and create a database
with same name, and BORROW its log, but when attaching
with my lonely mdf, the engine returned a logical error
massage telling me that these two files doesn't belong .
Please can anyone help ?If that didn't work then you're in a bit of trouble but you can try this
**Make sure you have a copy of your MDF first and a backup of master**
Replace the filenames with your filename !!!
1) Make sure you have a copy of PowerDVD301_2_Data.MDF
2) Create a new database called fake (default file locations)
3) Stop SQL Service
4) Delete the fake_Data.MDF and copy PowerDVD301_2_Data.MDF
to where fake_Data.MDF used to be and rename the file to fake_Data.MDF
5) Start SQL Service
6) Database fake will appear as suspect in EM
7) Open Query Analyser and in master database run the following :
sp_configure 'allow updates',1
go
reconfigure with override
go
update sysdatabases set
status=-32768 where dbid=DB_ID('fake')
go
sp_configure 'allow updates',0
go
reconfigure with override
go
This will put the database in emergency recovery mode
8) Stop SQL Service
9) Delete the fake_Log.LDF file
10) Restart SQL Service
11) In QA run the following (with correct path for log)
dbcc rebuild_log('fake','h:\fake_log.ldf')
go
dbcc checkdb('fake') -- to check for errors
go
12) Now we need to rename the files, run the following (make sure
there are no connections to it) in Query Analyser
(At this stage you can actually access the database so you could use
DTS or bcp to move the data to another database .)
use master
go
sp_helpdb 'fake'
go
/* Make a note of the names of the files , you will need them
in the next bit of the script to replace datafilename and
logfilename - it might be that they have the right names */
sp_renamedb 'fake','PowerDVD301'
go
alter database PowerDVD301
MODIFY FILE(NAME='datafilename', NEWNAME = 'PowerDVD301_Data')
go
alter database PowerDVD301
MODIFY FILE(NAME='logfilename', NEWNAME = 'PowerDVD301_Log')
go
dbcc checkdb('PowerDVD301')
go
sp_dboption 'PowerDVD301','dbo use only','false'
go
use PowerDVD301
go
sp_updatestats
go
13) You should now have a working database. However the log file
will be small so it will be worth increasing its size
Unfortunately your files will be called fake_Data.MDF and
fake_Log.LDF but you can get round this by detaching the
database properly and then renaming the files and reattaching
it
14) Run the following in QA
sp_detach_db PowerDVD301
--now rename the files then reattach
sp_attach_db 'PowerDVD301','h:\dvd.mdf','h:\DVD.ldf'
--
HTH
Jasper Smith (SQL Server MVP)
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"ATS967" <anonymous@.discussions.microsoft.com> wrote in message
news:098d01c3a06f$83c18e20$a301280a@.phx.gbl...
I in a real catastrophic scenario in a SQL2000
installation:
Due to a hardware failure:
I HAVE A SINGLE MDF, NOTHING ELSE .
The database originally was formed with this single mdf
and a single ldf, and its recovery model was simple.
I tried sp_attach_single_file_db as documented, but it
returned errors.
I tried to out smart the engine and create a database
with same name, and BORROW its log, but when attaching
with my lonely mdf, the engine returned a logical error
massage telling me that these two files doesn't belong .
Please can anyone help ?
installation:
Due to a hardware failure:
I HAVE A SINGLE MDF, NOTHING ELSE .
The database originally was formed with this single mdf
and a single ldf, and its recovery model was simple.
I tried sp_attach_single_file_db as documented, but it
returned errors.
I tried to out smart the engine and create a database
with same name, and BORROW its log, but when attaching
with my lonely mdf, the engine returned a logical error
massage telling me that these two files doesn't belong .
Please can anyone help ?If that didn't work then you're in a bit of trouble but you can try this
**Make sure you have a copy of your MDF first and a backup of master**
Replace the filenames with your filename !!!
1) Make sure you have a copy of PowerDVD301_2_Data.MDF
2) Create a new database called fake (default file locations)
3) Stop SQL Service
4) Delete the fake_Data.MDF and copy PowerDVD301_2_Data.MDF
to where fake_Data.MDF used to be and rename the file to fake_Data.MDF
5) Start SQL Service
6) Database fake will appear as suspect in EM
7) Open Query Analyser and in master database run the following :
sp_configure 'allow updates',1
go
reconfigure with override
go
update sysdatabases set
status=-32768 where dbid=DB_ID('fake')
go
sp_configure 'allow updates',0
go
reconfigure with override
go
This will put the database in emergency recovery mode
8) Stop SQL Service
9) Delete the fake_Log.LDF file
10) Restart SQL Service
11) In QA run the following (with correct path for log)
dbcc rebuild_log('fake','h:\fake_log.ldf')
go
dbcc checkdb('fake') -- to check for errors
go
12) Now we need to rename the files, run the following (make sure
there are no connections to it) in Query Analyser
(At this stage you can actually access the database so you could use
DTS or bcp to move the data to another database .)
use master
go
sp_helpdb 'fake'
go
/* Make a note of the names of the files , you will need them
in the next bit of the script to replace datafilename and
logfilename - it might be that they have the right names */
sp_renamedb 'fake','PowerDVD301'
go
alter database PowerDVD301
MODIFY FILE(NAME='datafilename', NEWNAME = 'PowerDVD301_Data')
go
alter database PowerDVD301
MODIFY FILE(NAME='logfilename', NEWNAME = 'PowerDVD301_Log')
go
dbcc checkdb('PowerDVD301')
go
sp_dboption 'PowerDVD301','dbo use only','false'
go
use PowerDVD301
go
sp_updatestats
go
13) You should now have a working database. However the log file
will be small so it will be worth increasing its size
Unfortunately your files will be called fake_Data.MDF and
fake_Log.LDF but you can get round this by detaching the
database properly and then renaming the files and reattaching
it
14) Run the following in QA
sp_detach_db PowerDVD301
--now rename the files then reattach
sp_attach_db 'PowerDVD301','h:\dvd.mdf','h:\DVD.ldf'
--
HTH
Jasper Smith (SQL Server MVP)
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"ATS967" <anonymous@.discussions.microsoft.com> wrote in message
news:098d01c3a06f$83c18e20$a301280a@.phx.gbl...
I in a real catastrophic scenario in a SQL2000
installation:
Due to a hardware failure:
I HAVE A SINGLE MDF, NOTHING ELSE .
The database originally was formed with this single mdf
and a single ldf, and its recovery model was simple.
I tried sp_attach_single_file_db as documented, but it
returned errors.
I tried to out smart the engine and create a database
with same name, and BORROW its log, but when attaching
with my lonely mdf, the engine returned a logical error
massage telling me that these two files doesn't belong .
Please can anyone help ?
Tuesday, February 14, 2012
CustomReportItem Installation
Is there any documentation currently outlining how to make use of the CustomReportItem element or class? My thoughts on this are that it might act as a server control for an ASP.NET application. Is that correct?
I want to be able to add some richer user interactivity to a couple reports that I'm currently authoring (i.e. checkboxes, buttons to access web service functionality, etc...) and I think that I might be able to make use of this class to provide that functionality since RDL doesn't seem to give any support for scripting in HTML entities into the report.
Lastly, will support for installing custom report items be included in ReportServer Express?
Thanks.
Unfortunately, the CustomReportItem documentation did not make it in time for SQL 2005 release. We expect to have a white paper and sample out around the release time. It is much like an ASP.NET server control but it is specific to Reporting Services.The CustomReportItem is also limited in it's initial version to basically returning images. While you can build things like maps, graphs, or other visualizations, the interactive controls you are talking about are not really possible.
RDL doesn't enable embedded HTML because of the inability to render to other formats along with the fact that you would have to write code behind them anyway.
CustomReportItems are not supported in the RS in SQL Server Express.|||
Two months later….
Is there now any documentation, whitepaper or example describing how to make use of the CRI?
RS BOL contains some limited information at this point. Stay tuned for more information becoming available in the next months.
-- Robert|||BTW: besides the scenarios described by Brian Welcker, there are also a few additional scenarios where CRI can be used in RS 2005. I will post more information about this in a few weeks.
-- Robert|||
Thank you for your quick answer. I have already seen the example of Chris.
By using of this example I can add the control to the toolbox. However there are some problems with the installation of the Runtime control (Polygons).
I have done following:
- Both controls (Design and RTC) have been signed.
- Both of them are copied in the ReportServer/Bin directory and additionally in the c$\Program Files\Microsoft Visual Studio 8\Common7\IDE\PrivateAssemblies.
- After this did not work, I have appended the Public-Key Membership-Condition to the rssrvpolicy.config.
- Designer control is registered in the RSReportDesigner.config.
Unfortunately, it still does not work. When I try to drag the control to the report the VS dialog appears with the following message:
“The custom report type Polygons is not installed”
The question is: How to install the control properly?
My config files look as shown bellow:
rsreportserver.config
--
. . .
<Extensions>
<ReportItems>
<ReportItem Name="Polygons" Type="PolygonsCRI.PolygonsCRI, PolygonsCRI" />
</ReportItems>
<Delivery>
. . .
rssrvpolicy.config
<CodeGroup
class="UnionCodeGroup"
version="1"
PermissionSetName="FullTrust"
Name="Polygons"
Description="This code group grants FullTrust to DAENET assemblies. ">
<IMembershipCondition
class="StrongNameMembershipCondition"
version="1" PublicKeyBlob="00240000. . .BE06C0"
/>
</CodeGroup>
RSReportDesigner.config
. . .
<Extensions>
<ReportItemDesigner>
<ReportItem Name="Polygons" Type="PolygonsCRI.PolygonsCRI, PolygonsCRI" />
</ReportItemDesigner>
<ReportItems>
<ReportItem Name="Polygons" Type="PolygonsCRI.PolygonsDesigner, PolygonsDesigner" />
</ReportItems>
<Render>
. . . . . . 'devenv.exe' (Managed): Loaded 'C:\Program Files\Microsoft Visual Studio 8\Common7\IDE\PrivateAssemblies\PolygonsCRI.dll', Symbols loaded. 'devenv.exe' (Managed): Loaded 'C:\Program Files\Microsoft Visual Studio 8\Common7\IDE\PrivateAssemblies\Microsoft.ReportingServices.ProcessingCore.dll', Skipped loading symbols. Module is optimized and the debugger option 'Just My Code' is enabled. 'devenv.exe' (Managed): Loaded 'C:\Program Files\Microsoft Visual Studio 8\Common7\IDE\PrivateAssemblies\Microsoft.ReportingServices.QueryDesigners.dll', Skipped loading symbols. Module is optimized and the debugger option 'Just My Code' is enabled. 'devenv.exe' (Managed): Loaded 'C:\WINDOWS\assembly\GAC_MSIL\Microsoft.SqlServer.ManagedDTS\9.0.242.0__89845dcd8080cc91\Microsoft.SqlServer.ManagedDTS.dll', Skipped loading symbols. Module is optimized and the debugger option 'Just My Code' is enabled. 'devenv.exe' (Managed): Loaded 'C:\WINDOWS\assembly\GAC_MSIL\Microsoft.VSDesigner\8.0.0.0__b03f5f7f11d50a3a\Microsoft.VSDesigner.dll', Skipped loading symbols. Module is optimized and the debugger option 'Just My Code' is enabled. 'devenv.exe' (Managed): Loaded 'C:\WINDOWS\assembly\GAC_32\System.Data.OracleClient\2.0.0.0__b77a5c561934e089\System.Data.OracleClient.dll', Skipped loading symbols. Module is optimized and the debugger option 'Just My Code' is enabled. 'devenv.exe' (Managed): Loaded 'C:\WINDOWS\assembly\GAC_MSIL\System.Runtime.Serialization.Formatters.Soap\2.0.0.0__b03f5f7f11d50a3a\System.Runtime.Serialization.Formatters.Soap.dll', Skipped loading symbols. Module is optimized and the debugger option 'Just My Code' is enabled. 'devenv.exe' (Managed): Loaded 'C:\WINDOWS\assembly\GAC\Microsoft.VisualStudio.VSHelp80\8.0.0.0__b03f5f7f11d50a3a\Microsoft.VisualStudio.VSHelp80.dll', Skipped loading symbols. Module is optimized and the debugger option 'Just My Code' is enabled. 'devenv.exe' (Managed): Loaded 'C:\Program Files\Microsoft Visual Studio 8\Common7\IDE\PrivateAssemblies\PolygonsDesigner.dll', Symbols loaded.
Here is the list of loaded modules of the VS. As you can see (first and last entry) both componets are loaded.
. . .
Framevork Ver.: 2.0.50727.26
I get the behavior you're seeing when I omit the CustomReportItem attribute from the PolygonsDesigner class (or give it the wrong custom report item name, or have a typo in the CRI name in the designer config file).
|||Here is the Designer-code:
[LocalizedName("Polygons")]
[Editor(typeof(CustomEditor), typeof(ComponentEditor))]
[ToolboxBitmap(typeof(PolygonsDesigner),"Polygons.ico")]
[CustomReportItem("Polygons")]
public class PolygonsDesigner : CustomReportItemDesigner
PS. There ware no any changes in the original code.
|||Would a CustomReportItem be capable of providing the following functionality:Need a Text Box/Label that can support text in multiple styles like Bold and Italic. I have heard that someone is building a RTF TextBox for Reporting Services.
Client is building a service that builds Letters and prints them for mailing. Need blocks of text with different formats in the text.|||In RS 2005, you could build a CustomReportItem that takes the RTF information and generates an image out of it.
-- Robert|||
Sorry I was to fast,
I have found the information in this thread........
Hi,
has anyone example code to build a customReportItem? Or knows anyone a tutorial that descibes this scenario?
Thanks
Stefan
|||OK, once again,
Robert, Keith or anyone else. Do you have a code sample to integrate the rtf formated text in the report? As ReportItem
Thank you in advance
stefan
|||Now that it is March, do we have any more detailed documentation on how to build Custom Report Items?|||This is now fully documented in the SQL Server 2005 SP1 documentation and samples.|||Btw, the latest RS BOL documentation is also available as separate download: http://www.microsoft.com/downloads/details.aspx?FamilyId=BE6A2C5D-00DF-4220-B133-29C1E0B6585F&displaylang=en
-- Robert
CustomReportItem Installation
Is there any documentation currently outlining how to make use of the CustomReportItem element or class? My thoughts on this are that it might act as a server control for an ASP.NET application. Is that correct?
I want to be able to add some richer user interactivity to a couple reports that I'm currently authoring (i.e. checkboxes, buttons to access web service functionality, etc...) and I think that I might be able to make use of this class to provide that functionality since RDL doesn't seem to give any support for scripting in HTML entities into the report.
Lastly, will support for installing custom report items be included in ReportServer Express?
Thanks.
Unfortunately, the CustomReportItem documentation did not make it in time for SQL 2005 release. We expect to have a white paper and sample out around the release time. It is much like an ASP.NET server control but it is specific to Reporting Services.The CustomReportItem is also limited in it's initial version to basically returning images. While you can build things like maps, graphs, or other visualizations, the interactive controls you are talking about are not really possible.
RDL doesn't enable embedded HTML because of the inability to render to other formats along with the fact that you would have to write code behind them anyway.
CustomReportItems are not supported in the RS in SQL Server Express.|||
Two months later….
Is there now any documentation, whitepaper or example describing how to make use of the CRI?
RS BOL contains some limited information at this point. Stay tuned for more information becoming available in the next months.
-- Robert|||BTW: besides the scenarios described by Brian Welcker, there are also a few additional scenarios where CRI can be used in RS 2005. I will post more information about this in a few weeks.
-- Robert|||
Thank you for your quick answer. I have already seen the example of Chris.
By using of this example I can add the control to the toolbox. However there are some problems with the installation of the Runtime control (Polygons).
I have done following:
- Both controls (Design and RTC) have been signed.
- Both of them are copied in the ReportServer/Bin directory and additionally in the c$\Program Files\Microsoft Visual Studio 8\Common7\IDE\PrivateAssemblies.
- After this did not work, I have appended the Public-Key Membership-Condition to the rssrvpolicy.config.
- Designer control is registered in the RSReportDesigner.config.
Unfortunately, it still does not work. When I try to drag the control to the report the VS dialog appears with the following message:
“The custom report type Polygons is not installed”
The question is: How to install the control properly?
My config files look as shown bellow:
rsreportserver.config
--
. . .
<Extensions>
<ReportItems>
<ReportItem Name="Polygons" Type="PolygonsCRI.PolygonsCRI, PolygonsCRI" />
</ReportItems>
<Delivery>
. . .
rssrvpolicy.config
<CodeGroup
class="UnionCodeGroup"
version="1"
PermissionSetName="FullTrust"
Name="Polygons"
Description="This code group grants FullTrust to DAENET assemblies. ">
<IMembershipCondition
class="StrongNameMembershipCondition"
version="1" PublicKeyBlob="00240000. . .BE06C0"
/>
</CodeGroup>
RSReportDesigner.config
. . .
<Extensions>
<ReportItemDesigner>
<ReportItem Name="Polygons" Type="PolygonsCRI.PolygonsCRI, PolygonsCRI" />
</ReportItemDesigner>
<ReportItems>
<ReportItem Name="Polygons" Type="PolygonsCRI.PolygonsDesigner, PolygonsDesigner" />
</ReportItems>
<Render>
. . . . . . 'devenv.exe' (Managed): Loaded 'C:\Program Files\Microsoft Visual Studio 8\Common7\IDE\PrivateAssemblies\PolygonsCRI.dll', Symbols loaded. 'devenv.exe' (Managed): Loaded 'C:\Program Files\Microsoft Visual Studio 8\Common7\IDE\PrivateAssemblies\Microsoft.ReportingServices.ProcessingCore.dll', Skipped loading symbols. Module is optimized and the debugger option 'Just My Code' is enabled. 'devenv.exe' (Managed): Loaded 'C:\Program Files\Microsoft Visual Studio 8\Common7\IDE\PrivateAssemblies\Microsoft.ReportingServices.QueryDesigners.dll', Skipped loading symbols. Module is optimized and the debugger option 'Just My Code' is enabled. 'devenv.exe' (Managed): Loaded 'C:\WINDOWS\assembly\GAC_MSIL\Microsoft.SqlServer.ManagedDTS\9.0.242.0__89845dcd8080cc91\Microsoft.SqlServer.ManagedDTS.dll', Skipped loading symbols. Module is optimized and the debugger option 'Just My Code' is enabled. 'devenv.exe' (Managed): Loaded 'C:\WINDOWS\assembly\GAC_MSIL\Microsoft.VSDesigner\8.0.0.0__b03f5f7f11d50a3a\Microsoft.VSDesigner.dll', Skipped loading symbols. Module is optimized and the debugger option 'Just My Code' is enabled. 'devenv.exe' (Managed): Loaded 'C:\WINDOWS\assembly\GAC_32\System.Data.OracleClient\2.0.0.0__b77a5c561934e089\System.Data.OracleClient.dll', Skipped loading symbols. Module is optimized and the debugger option 'Just My Code' is enabled. 'devenv.exe' (Managed): Loaded 'C:\WINDOWS\assembly\GAC_MSIL\System.Runtime.Serialization.Formatters.Soap\2.0.0.0__b03f5f7f11d50a3a\System.Runtime.Serialization.Formatters.Soap.dll', Skipped loading symbols. Module is optimized and the debugger option 'Just My Code' is enabled. 'devenv.exe' (Managed): Loaded 'C:\WINDOWS\assembly\GAC\Microsoft.VisualStudio.VSHelp80\8.0.0.0__b03f5f7f11d50a3a\Microsoft.VisualStudio.VSHelp80.dll', Skipped loading symbols. Module is optimized and the debugger option 'Just My Code' is enabled. 'devenv.exe' (Managed): Loaded 'C:\Program Files\Microsoft Visual Studio 8\Common7\IDE\PrivateAssemblies\PolygonsDesigner.dll', Symbols loaded.
Here is the list of loaded modules of the VS. As you can see (first and last entry) both componets are loaded.
. . .
Framevork Ver.: 2.0.50727.26
I get the behavior you're seeing when I omit the CustomReportItem attribute from the PolygonsDesigner class (or give it the wrong custom report item name, or have a typo in the CRI name in the designer config file).
|||Here is the Designer-code:
[LocalizedName("Polygons")]
[Editor(typeof(CustomEditor), typeof(ComponentEditor))]
[ToolboxBitmap(typeof(PolygonsDesigner),"Polygons.ico")]
[CustomReportItem("Polygons")]
public class PolygonsDesigner : CustomReportItemDesigner
PS. There ware no any changes in the original code.
|||Would a CustomReportItem be capable of providing the following functionality:Need a Text Box/Label that can support text in multiple styles like Bold and Italic. I have heard that someone is building a RTF TextBox for Reporting Services.
Client is building a service that builds Letters and prints them for mailing. Need blocks of text with different formats in the text.|||In RS 2005, you could build a CustomReportItem that takes the RTF information and generates an image out of it.
-- Robert|||
Sorry I was to fast,
I have found the information in this thread........
Hi,
has anyone example code to build a customReportItem? Or knows anyone a tutorial that descibes this scenario?
Thanks
Stefan
|||OK, once again,
Robert, Keith or anyone else. Do you have a code sample to integrate the rtf formated text in the report? As ReportItem
Thank you in advance
stefan
|||Now that it is March, do we have any more detailed documentation on how to build Custom Report Items?|||This is now fully documented in the SQL Server 2005 SP1 documentation and samples.|||Btw, the latest RS BOL documentation is also available as separate download: http://www.microsoft.com/downloads/details.aspx?FamilyId=BE6A2C5D-00DF-4220-B133-29C1E0B6585F&displaylang=en
-- Robert
CustomReportItem Installation
Is there any documentation currently outlining how to make use of the CustomReportItem element or class? My thoughts on this are that it might act as a server control for an ASP.NET application. Is that correct?
I want to be able to add some richer user interactivity to a couple reports that I'm currently authoring (i.e. checkboxes, buttons to access web service functionality, etc...) and I think that I might be able to make use of this class to provide that functionality since RDL doesn't seem to give any support for scripting in HTML entities into the report.
Lastly, will support for installing custom report items be included in ReportServer Express?
Thanks.
Unfortunately, the CustomReportItem documentation did not make it in time for SQL 2005 release. We expect to have a white paper and sample out around the release time. It is much like an ASP.NET server control but it is specific to Reporting Services.The CustomReportItem is also limited in it's initial version to basically returning images. While you can build things like maps, graphs, or other visualizations, the interactive controls you are talking about are not really possible.
RDL doesn't enable embedded HTML because of the inability to render to other formats along with the fact that you would have to write code behind them anyway.
CustomReportItems are not supported in the RS in SQL Server Express.|||
Two months later….
Is there now any documentation, whitepaper or example describing how to make use of the CRI?
RS BOL contains some limited information at this point. Stay tuned for more information becoming available in the next months.
-- Robert|||BTW: besides the scenarios described by Brian Welcker, there are also a few additional scenarios where CRI can be used in RS 2005. I will post more information about this in a few weeks.
-- Robert|||
Thank you for your quick answer. I have already seen the example of Chris.
By using of this example I can add the control to the toolbox. However there are some problems with the installation of the Runtime control (Polygons).
I have done following:
- Both controls (Design and RTC) have been signed.
- Both of them are copied in the ReportServer/Bin directory and additionally in the c$\Program Files\Microsoft Visual Studio 8\Common7\IDE\PrivateAssemblies.
- After this did not work, I have appended the Public-Key Membership-Condition to the rssrvpolicy.config.
- Designer control is registered in the RSReportDesigner.config.
Unfortunately, it still does not work. When I try to drag the control to the report the VS dialog appears with the following message:
“The custom report type Polygons is not installed”
The question is: How to install the control properly?
My config files look as shown bellow:
rsreportserver.config
--
. . .
<Extensions>
<ReportItems>
<ReportItem Name="Polygons" Type="PolygonsCRI.PolygonsCRI, PolygonsCRI" />
</ReportItems>
<Delivery>
. . .
rssrvpolicy.config
<CodeGroup
class="UnionCodeGroup"
version="1"
PermissionSetName="FullTrust"
Name="Polygons"
Description="This code group grants FullTrust to DAENET assemblies. ">
<IMembershipCondition
class="StrongNameMembershipCondition"
version="1" PublicKeyBlob="00240000. . .BE06C0"
/>
</CodeGroup>
RSReportDesigner.config
. . .
<Extensions>
<ReportItemDesigner>
<ReportItem Name="Polygons" Type="PolygonsCRI.PolygonsCRI, PolygonsCRI" />
</ReportItemDesigner>
<ReportItems>
<ReportItem Name="Polygons" Type="PolygonsCRI.PolygonsDesigner, PolygonsDesigner" />
</ReportItems>
<Render>
. . . . . . 'devenv.exe' (Managed): Loaded 'C:\Program Files\Microsoft Visual Studio 8\Common7\IDE\PrivateAssemblies\PolygonsCRI.dll', Symbols loaded. 'devenv.exe' (Managed): Loaded 'C:\Program Files\Microsoft Visual Studio 8\Common7\IDE\PrivateAssemblies\Microsoft.ReportingServices.ProcessingCore.dll', Skipped loading symbols. Module is optimized and the debugger option 'Just My Code' is enabled. 'devenv.exe' (Managed): Loaded 'C:\Program Files\Microsoft Visual Studio 8\Common7\IDE\PrivateAssemblies\Microsoft.ReportingServices.QueryDesigners.dll', Skipped loading symbols. Module is optimized and the debugger option 'Just My Code' is enabled. 'devenv.exe' (Managed): Loaded 'C:\WINDOWS\assembly\GAC_MSIL\Microsoft.SqlServer.ManagedDTS\9.0.242.0__89845dcd8080cc91\Microsoft.SqlServer.ManagedDTS.dll', Skipped loading symbols. Module is optimized and the debugger option 'Just My Code' is enabled. 'devenv.exe' (Managed): Loaded 'C:\WINDOWS\assembly\GAC_MSIL\Microsoft.VSDesigner\8.0.0.0__b03f5f7f11d50a3a\Microsoft.VSDesigner.dll', Skipped loading symbols. Module is optimized and the debugger option 'Just My Code' is enabled. 'devenv.exe' (Managed): Loaded 'C:\WINDOWS\assembly\GAC_32\System.Data.OracleClient\2.0.0.0__b77a5c561934e089\System.Data.OracleClient.dll', Skipped loading symbols. Module is optimized and the debugger option 'Just My Code' is enabled. 'devenv.exe' (Managed): Loaded 'C:\WINDOWS\assembly\GAC_MSIL\System.Runtime.Serialization.Formatters.Soap\2.0.0.0__b03f5f7f11d50a3a\System.Runtime.Serialization.Formatters.Soap.dll', Skipped loading symbols. Module is optimized and the debugger option 'Just My Code' is enabled. 'devenv.exe' (Managed): Loaded 'C:\WINDOWS\assembly\GAC\Microsoft.VisualStudio.VSHelp80\8.0.0.0__b03f5f7f11d50a3a\Microsoft.VisualStudio.VSHelp80.dll', Skipped loading symbols. Module is optimized and the debugger option 'Just My Code' is enabled. 'devenv.exe' (Managed): Loaded 'C:\Program Files\Microsoft Visual Studio 8\Common7\IDE\PrivateAssemblies\PolygonsDesigner.dll', Symbols loaded.
Here is the list of loaded modules of the VS. As you can see (first and last entry) both componets are loaded.
. . .
Framevork Ver.: 2.0.50727.26
I get the behavior you're seeing when I omit the CustomReportItem attribute from the PolygonsDesigner class (or give it the wrong custom report item name, or have a typo in the CRI name in the designer config file).
|||Here is the Designer-code:
[LocalizedName("Polygons")]
[Editor(typeof(CustomEditor), typeof(ComponentEditor))]
[ToolboxBitmap(typeof(PolygonsDesigner),"Polygons.ico")]
[CustomReportItem("Polygons")]
public class PolygonsDesigner : CustomReportItemDesigner
PS. There ware no any changes in the original code.
|||Would a CustomReportItem be capable of providing the following functionality:Need a Text Box/Label that can support text in multiple styles like Bold and Italic. I have heard that someone is building a RTF TextBox for Reporting Services.
Client is building a service that builds Letters and prints them for mailing. Need blocks of text with different formats in the text.|||In RS 2005, you could build a CustomReportItem that takes the RTF information and generates an image out of it.
-- Robert|||
Sorry I was to fast,
I have found the information in this thread........
Hi,
has anyone example code to build a customReportItem? Or knows anyone a tutorial that descibes this scenario?
Thanks
Stefan
|||OK, once again,
Robert, Keith or anyone else. Do you have a code sample to integrate the rtf formated text in the report? As ReportItem
Thank you in advance
stefan
|||Now that it is March, do we have any more detailed documentation on how to build Custom Report Items?|||This is now fully documented in the SQL Server 2005 SP1 documentation and samples.|||Btw, the latest RS BOL documentation is also available as separate download: http://www.microsoft.com/downloads/details.aspx?FamilyId=BE6A2C5D-00DF-4220-B133-29C1E0B6585F&displaylang=en
-- Robert
Subscribe to:
Posts (Atom)