DataType Money

Please i need to display the money column in DataBase in an asp.net page but i get something like this 786.0000 how can i format it so that i get something like 786.00

Thanx

That kind of formatting is best done at the application level.|||

You could use the ToString("c") to display as currency on your page.

Double TotalCost = 786.0000;

lblCost.Text = TotalCost.ToString("c");

Your label should now be set to $786.00

|||

If you are binding it, you can use <%# Bind("YourColumnName","{0:c}") %> and will display $786.00
If you dont want to display the currency, repace c with your own format like #0.00 at it should display 786.00

DataType change

I recieve a text file with a field that has a text format of 20010910. I import this data into sql server 7.0 utilizing the import wizard. (The wizard will not convert the data to datetime format) I need to know how to convert this data into date format of 2001/09/10. How do I do this in sql.

Thank You,
David A. FullertonYou can add a string column to your table and CONVERT in a post-importing execution or use Visual Basic CDATE in Transformation tab in DTS just before click OK in usual IMPORT... dialog|||CDATE will not work in this example. However, I agree with Cesar's recommendations. In this case, since using vbscript will be more complicated than using cdate you can try the following after the data is loaded:

select convert(varchar(10), cast('20010920' as datetime), 111)|||Thank You That worked..Have a great day!|||Happy to help and good luck.

Dataset or SqlCommand or SQLXML

I am in a dilemma(rather "trilemma"!!!).
I have a Microsoft SQL 2000 Server and I want to retrieve data from the
server in XML format. Can do it without even utilizing the special XML
capabilites of SQL 2000 server.
I mean I can very well use:
1. Store the data retieved from the DB in a dataset and use WriteXML()
function.
2. Use SQLExecuteReader() function of SqlCommand class
Is their some advantage/need(may be performance issues etc.) to use SqlXml
managed classes for *only* conversion of data retrieved from SQL server to
XML format?
Also in case we dont have SQL 2000 server (suppose an earlier version or a
non-Microsoft DB) then too the aforelisted 2 methods for accessing XML data
would work...are'nt they?
Suggestions/comments invited.
-Aayush
What you say is partially correct - if you simply want to convert the
relational data to XML, you can do it using the WriteXml method of a
DataSet.
As regards your second option, I assume you mean the ExecuteXmlReader method
of SqlCommand - and this will only work with a FOR XML query against SQL
Server 2000 - so you couldn't use this approach with other data sources.
See http://www.microsoft.com/mspress/boo...#SampleChapter
for a comparison of using "standard" ADO.NET vs SqlXml classes. There are
quite a few advantages to using the SqlXml classes if your data is in SQL
Server 2000 - I guess it depends whether or not you need the additional
flexibility and functionality they offer.
Cheers,
Graeme
--
Graeme Malcolm
Principal Technologist
Content Master Ltd.
www.contentmaster.com
www.microsoft.com/mspress/books/6137.asp
"Aayush Puri" <aayush@.nospam.com> wrote in message
news:%23VXfr16TEHA.2716@.tk2msftngp13.phx.gbl...
I am in a dilemma(rather "trilemma"!!!).
I have a Microsoft SQL 2000 Server and I want to retrieve data from the
server in XML format. Can do it without even utilizing the special XML
capabilites of SQL 2000 server.
I mean I can very well use:
1. Store the data retieved from the DB in a dataset and use WriteXML()
function.
2. Use SQLExecuteReader() function of SqlCommand class
Is their some advantage/need(may be performance issues etc.) to use SqlXml
managed classes for *only* conversion of data retrieved from SQL server to
XML format?
Also in case we dont have SQL 2000 server (suppose an earlier version or a
non-Microsoft DB) then too the aforelisted 2 methods for accessing XML data
would work...are'nt they?
Suggestions/comments invited.
-Aayush

dataset in main report and subreport

This is a multi-part message in MIME format.
--=_NextPart_000_0009_01C6B485.898E4410
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
Hi,
We have a main report that calls a subreport. The subreport is being = passed the appropriate parameters.
The subreport works correctly in isolation in the preview mode. However, = when it is called
in a main report it stops working. I get the message
"Error: Subreport could not be shown."
The main report is NOT using a shared dataset, but subreport is. Initially the main report was using a shared dataset and the subreport = was working correctly.
However, since we need to create report columns on the fly (for ad-hoc = reports) so we have to generate the RDL at run-time and use = ReportExecutionService.LoadReportDefinition method to load RDLto report = server. This method requires RDL to use private data source/dataset.
Am I required to do some kind of special handling for these kind of = subreports?
Thanks
--=_NextPart_000_0009_01C6B485.898E4410
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
&
Hi,
We have a main report that calls a subreport. The subreport is = being passed the appropriate parameters.The subreport works correctly in = isolation in the preview mode. However, when it is calledin a main report it stops = working. I get the message"Error: Subreport could not be shown."The main = report is NOT using a shared dataset, but subreport is. Initially the main = report was using a shared dataset and the subreport was working correctly.

However, since we need to create report columns on the fly (for = ad-hoc reports) so we have to generate the RDL at run-time and use ReportExecutionService.LoadReportDefinition method to load RDLto report = server. This method requires RDL to use private data source/dataset.
Am I required to do some kind of special handling for these = kind of subreports?

Thanks

---

</FONT></FONT>
--=_NextPart_000_0009_01C6B485.898E4410--Hi spamme,
Thank you for using MSDN Managed Newsgroup Support.
From your description, my understanding of this issue is: You could not see
your subreport and you get the error "Error: Subreport could not be
shown.". If I misunderstood your concern, please feel free to let me know.
I would like to get the Report Error log file to troubleshot this issue. By
default, the log file is located at \Microsoft SQL Server\<SQL Server
Instance>\Reporting Services\LogFiles.
Please post the error in the log file so that I could provide further
assistance.
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
Get notification to my posts through email? Please refer to
http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notif
ications.
Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
where an initial response from the community or a Microsoft Support
Engineer within 1 business day is acceptable. Please note that each follow
up response may take approximately 2 business days as the support
professional working with you may need further investigation to reach the
most efficient resolution. The offering is not appropriate for situations
that require urgent, real-time or phone-based interactions or complex
project analysis and dump analysis issues. Issues of this nature are best
handled working with a dedicated Microsoft Support Engineer by contacting
Microsoft Customer Support Services (CSS) at
http://msdn.microsoft.com/subscriptions/support/default.aspx.
==================================================(This posting is provided "AS IS", with no warranties, and confers no
rights.)|||This is a multi-part message in MIME format.
--=_NextPart_000_0007_01C6B59D.95D1DED0
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
Hi Wei,
Here are the errors from report server log file: (the two always came =together)
We changed to have both main report and subreport use private data =sources, but we were still getting same error.
w3wp!webserver!1!08/01/2006-16:46:18:: i INFO: Processed report. =Report=3D'/', Stream=3D''
w3wp!library!1!08/01/2006-16:49:36:: i INFO: Call to CreateDataSource( ='MyReport', '/Data Sources', dataSourceDefinition )
w3wp!library!1!08/01/2006-16:49:36:: i INFO: Call to CreateReport( ='BudgetAdHoc', '/EventReports', def)
w3wp!library!1!08/01/2006-16:49:36:: i INFO: Call to =SetReportDefinition( '/EventReports/BudgetAdHoc', def )
w3wp!library!1!08/01/2006-16:49:39:: e ERROR: Throwing =Microsoft.ReportingServices.Diagnostics.Utilities.ItemNotFoundException: =The item '/GenericSubreportEventDetails' cannot be found., ;
Info: =Microsoft.ReportingServices.Diagnostics.Utilities.ItemNotFoundException: =The item '/GenericSubreportEventDetails' cannot be found.
w3wp!processing!1!08/01/2006-16:49:39:: e ERROR: An error has occurred =while retrieving datasources for a sub-report. Details: The item ='/GenericSubreportEventDetails' cannot be found. Stack trace:
at =Microsoft.ReportingServices.Library.RSService.GetCompiledDefinition(Strin=g originalItemPath, String itemPath, ItemType& type, ReportSnapshot& =compiledDefinition, Guid& executionSnapshotID, String& properties, =String& description, Byte[]& secDesc, Guid& reportID, Int32& =execOptions)
at =Microsoft.ReportingServices.Library.RSService.ProcessingGetDataSources(Ca=talogItemContext reportContext, String subreportPath, =CatalogItemContext& subreportContext, GetReportChunk& =getCompiledDefinition, DataSourceInfoCollection& dataSources)
at =Microsoft.ReportingServices.ReportProcessing.ReportProcessing.CheckCreden=tials(Report report, DataSourceInfoCollection dataSources, =CatalogItemContext reportContext, SubReportDataSourcesCallback =subReportCallback, RuntimeDataSourceInfoCollection allDataSources, Int32 =subReportLevel, Boolean checkIfUsable, ServerDataSourceSettings =serverDatasourceSettings)
w3wp!library!1!08/01/2006-16:49:41:: i INFO: Call to RenderFirst( '' )
w3wp!library!1!8/1/2006-16:49:41:: e ERROR: Throwing =Microsoft.ReportingServices.Diagnostics.Utilities.ItemNotFoundException: =The item '/GenericSubreportEventDetails' cannot be found., ;
Info: =Microsoft.ReportingServices.Diagnostics.Utilities.ItemNotFoundException: =The item '/GenericSubreportEventDetails' cannot be found.
w3wp!processing!1!8/1/2006-16:49:41:: e ERROR: An error has occurred =while processing a sub-report. Details: The item ='/GenericSubreportEventDetails' cannot be found. Stack trace:
at =Microsoft.ReportingServices.Library.RSService.ProcessingGetSubreport(Cata=logItemContext reportContext, String subreportPath, CatalogItemContext& =subreportContext, String& description, GetReportChunk& =getCompiledDefinition, ParameterInfoCollection& parameters)
at =Microsoft.ReportingServices.ReportProcessing.ReportProcessing.RuntimeRICo=llection.RetrieveSubReport(SubReport subReport, ProcessingContext =processingContext, ProcessingErrorContext subReportErrorContext, Boolean =isProcessingPrefetch)
It is important to know that we use LoadReportDefinition to load RDL for =this kind of ad-hoc report (columns were created on the fly based on =user's selections). If I understand correctly, the LoadReportDefinition =method requires RDL use private data source. I believe the second error =(ItemNotFoundException) was actually caused by the first error (failed =to create the subreport item due to the error while retrieving data =sources).
Since the main report and sub report both use private data source, I =only see one data source was created from report server log. I expect to =see two data sources created, one for main report and one for sub =report. Can this be the reason, or something to do with data source =credential ?
Thanks
"Wei Lu [MSFT]" <weilu@.online.microsoft.com> wrote in message =news:ktCgbCRtGHA.2500@.TK2MSFTNGXA01.phx.gbl...
> Hi spamme,
> > Thank you for using MSDN Managed Newsgroup Support.
> > From your description, my understanding of this issue is: You could =not see > your subreport and you get the error "Error: Subreport could not be > shown.". If I misunderstood your concern, please feel free to let me =know.
> > I would like to get the Report Error log file to troubleshot this =issue. By > default, the log file is located at \Microsoft SQL Server\<SQL Server > Instance>\Reporting Services\LogFiles. > > Please post the error in the log file so that I could provide further > assistance.
> > Sincerely,
> > Wei Lu
> > Microsoft Online Community Support
> > ==3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D==3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
> > Get notification to my posts through email? Please refer to > =http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#no=
tif
> ications.
> > Note: The MSDN Managed Newsgroup support offering is for non-urgent =issues > where an initial response from the community or a Microsoft Support > Engineer within 1 business day is acceptable. Please note that each =follow > up response may take approximately 2 business days as the support > professional working with you may need further investigation to reach =the > most efficient resolution. The offering is not appropriate for =situations > that require urgent, real-time or phone-based interactions or complex > project analysis and dump analysis issues. Issues of this nature are =best > handled working with a dedicated Microsoft Support Engineer by =contacting > Microsoft Customer Support Services (CSS) at > http://msdn.microsoft.com/subscriptions/support/default.aspx.
> > ==3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D==3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
> (This posting is provided "AS IS", with no warranties, and confers no > rights.)
>
--=_NextPart_000_0007_01C6B59D.95D1DED0
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
&

---

Hi Wei,
Here are the errors from report server =log file: (the two always came together)
We changed to have both main report and =subreport use private data sources, but we were still getting same =error.
w3wp!webserver!1!08/01/2006-16:46:18:: i INFO: Processed =report. Report=3D'/', Stream=3D''w3wp!library!1!08/01/2006-16:49:36:: i =INFO: Call to CreateDataSource( 'MyReport', '/Data Sources', dataSourceDefinition )w3wp!library!1!08/01/2006-16:49:36:: i INFO: Call to CreateReport( 'BudgetAdHoc', '/EventReports', =def)w3wp!library!1!08/01/2006-16:49:36:: i INFO: Call to SetReportDefinition( '/EventReports/BudgetAdHoc', def )w3wp!library!1!08/01/2006-16:49:39:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.ItemNotFoundException: =The item '/GenericSubreportEventDetails' cannot be found., ; Info: Microsoft.ReportingServices.Diagnostics.Utilities.ItemNotFoundException: =The item '/GenericSubreportEventDetails' cannot be found.w3wp!processing!1!08/01/2006-16:49:39:: e ERROR: An error has =occurred while retrieving datasources for a sub-report. Details: The item '/GenericSubreportEventDetails' cannot be found. Stack =trace: at Microsoft.ReportingServices.Library.RSService.GetCompiledDefinition(Strin=g originalItemPath, String itemPath, ItemType& type, =ReportSnapshot& compiledDefinition, Guid& executionSnapshotID, String& =properties, String& description, Byte[]& secDesc, Guid& reportID, =Int32& execOptions) at Microsoft.ReportingServices.Library.RSService.ProcessingGetDataSources(Ca=talogItemContext reportContext, String subreportPath, CatalogItemContext& =subreportContext, GetReportChunk& getCompiledDefinition, DataSourceInfoCollection& =dataSources) at Microsoft.ReportingServices.ReportProcessing.ReportProcessing.CheckCreden=tials(Report report, DataSourceInfoCollection dataSources, CatalogItemContext =reportContext, SubReportDataSourcesCallback subReportCallback, =RuntimeDataSourceInfoCollection allDataSources, Int32 subReportLevel, Boolean checkIfUsable, ServerDataSourceSettings serverDatasourceSettings)w3wp!library!1!08/01/2006-16:49:41:: i =INFO: Call to RenderFirst( '' )w3wp!library!1!8/1/2006-16:49:41:: e ERROR: =Throwing Microsoft.ReportingServices.Diagnostics.Utilities.ItemNotFoundException: =The item '/GenericSubreportEventDetails' cannot be found., ; Info: Microsoft.ReportingServices.Diagnostics.Utilities.ItemNotFoundException: =The item '/GenericSubreportEventDetails' cannot be found.w3wp!processing!1!8/1/2006-16:49:41:: e ERROR: An error has =occurred while processing a sub-report. Details: The item ='/GenericSubreportEventDetails' cannot be found. Stack trace: at Microsoft.ReportingServices.Library.RSService.ProcessingGetSubreport(Cata=logItemContext reportContext, String subreportPath, CatalogItemContext& =subreportContext, String& description, GetReportChunk& getCompiledDefinition, ParameterInfoCollection& parameters) at Microsoft.ReportingServices.ReportProcessing.ReportProcessing.RuntimeRICo=llection.RetrieveSubReport(SubReport subReport, ProcessingContext processingContext, ProcessingErrorContext subReportErrorContext, Boolean isProcessingPrefetch)
It is important to know that we use LoadReportDefinition to load RDL for this kind of ad-hoc report (columns =were created on the fly based on user's selections). If I understand =correctly, the LoadReportDefinition method requires RDL use private data source. I =believe the second error (ItemNotFoundException) was actually caused by the =first error (failed to create the subreport item due to the error while =retrieving data sources).
Since the main report and sub report =both use private data source, I only see one data source was created =from report server log. I expect to see two data sources created, one for main =report and one for sub report. Can this be the reason, or something to do with =data source credential ?
Thanks
"Wei Lu [MSFT]" wrote in message news:ktCgbCRtGHA.2500@.TK2MSFTNGXA01.phx.gbl...> =Hi spamme,> > Thank you for using MSDN Managed Newsgroup Support.> > From your description, my understanding of =this issue is: You could not see > your subreport and you get the error ="Error: Subreport could not be > shown.". If I misunderstood your =concern, please feel free to let me know.> > I would like to get =the Report Error log file to troubleshot this issue. By > default, the log =file is located at \Microsoft SQL Server\ =Instance>\Reporting Services\LogFiles. > > Please post the error in the log =file so that I could provide further > assistance.> > Sincerely,> > Wei Lu> > Microsoft Online =Community Support> > =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D==3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=> > Get notification to my posts through email? Please refer to > =http://msdn.microsoft.com/subscriptions/managednewsgroups/defaul=t.aspx#notif> ications.> > Note: The MSDN =Managed Newsgroup support offering is for non-urgent issues > where an =initial response from the community or a Microsoft Support > Engineer =within 1 business day is acceptable. Please note that each follow > up =response may take approximately 2 business days as the support > =professional working with you may need further investigation to reach the > =most efficient resolution. The offering is not appropriate for situations => that require urgent, real-time or phone-based interactions or complex => project analysis and dump analysis issues. Issues of this nature are =best > handled working with a dedicated Microsoft Support Engineer by contacting > Microsoft Customer Support Services (CSS) at => .> > =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D==3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=> (This posting is provided "AS IS", with no warranties, and confers no > rights.)>

---

--=_NextPart_000_0007_01C6B59D.95D1DED0--|||Hi spamme,
Thank you for your response.
Would you please provide some sample code of how you use
LoadReportDefinition to load the RDL file? Is the RDL file in the local
file system?
Also, you may try to test whether other main report with the sub-report you
use have the same issue. Please let me know the result.
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
Get notification to my posts through email? Please refer to
http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notif
ications.
Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
where an initial response from the community or a Microsoft Support
Engineer within 1 business day is acceptable. Please note that each follow
up response may take approximately 2 business days as the support
professional working with you may need further investigation to reach the
most efficient resolution. The offering is not appropriate for situations
that require urgent, real-time or phone-based interactions or complex
project analysis and dump analysis issues. Issues of this nature are best
handled working with a dedicated Microsoft Support Engineer by contacting
Microsoft Customer Support Services (CSS) at
http://msdn.microsoft.com/subscriptions/support/default.aspx.
==================================================(This posting is provided "AS IS", with no warranties, and confers no
rights.)|||This is a multi-part message in MIME format.
--=_NextPart_000_0015_01C6BA07.8BE13F10
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
Wei,
Just want to provide a quick update on this issue. According to BOL =http://msdn2.microsoft.com/en-us/library/microsoft.wssux.reportingservice=
swebservice.rsexecutionservice2005.reportexecutionservice.loadreportdefin=ition.aspx, Subreports and data source references with relative paths are not =supported using this method. However, absolute paths to catalog items =can be used
As soon as we changed to use absolute path, the problem was resolved
Thanks
"Wei Lu [MSFT]" <weilu@.online.microsoft.com> wrote in message =news:vzBRjwftGHA.2504@.TK2MSFTNGXA01.phx.gbl...
> Hi spamme,
> > Thank you for your response.
> > Would you please provide some sample code of how you use > LoadReportDefinition to load the RDL file? Is the RDL file in the =local > file system?
> > Also, you may try to test whether other main report with the =sub-report you > use have the same issue. Please let me know the result.
> > Sincerely,
> > Wei Lu
> > Microsoft Online Community Support
> > ==3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D==3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
> > Get notification to my posts through email? Please refer to > =http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#no=
tif
> ications.
> > Note: The MSDN Managed Newsgroup support offering is for non-urgent =issues > where an initial response from the community or a Microsoft Support > Engineer within 1 business day is acceptable. Please note that each =follow > up response may take approximately 2 business days as the support > professional working with you may need further investigation to reach =the > most efficient resolution. The offering is not appropriate for =situations > that require urgent, real-time or phone-based interactions or complex > project analysis and dump analysis issues. Issues of this nature are =best > handled working with a dedicated Microsoft Support Engineer by =contacting > Microsoft Customer Support Services (CSS) at > http://msdn.microsoft.com/subscriptions/support/default.aspx.
> > ==3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D==3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
> (This posting is provided "AS IS", with no warranties, and confers no > rights.)
>
--=_NextPart_000_0015_01C6BA07.8BE13F10
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
&

---

Wei,
Just want to provide a quick update =on this issue. According to BOL http://msdn2.microsoft.com/en-us/library/microsoft.wssux.reporti=ngserviceswebservice.rsexecutionservice2005.reportexecutionservice.loadre=portdefinition.aspx,
Subreports and data source references =with relative paths are not supported using this method. However, absolute =paths to catalog items can be used
As soon as we changed to use absolute =path, the problem was resolved
Thanks
"Wei Lu [MSFT]" wrote in message news:vzBRjwftGHA.2504@.TK2MSFTNGXA01.phx.gbl...> =Hi spamme,> > Thank you for your response.> > =Would you please provide some sample code of how you use > =LoadReportDefinition to load the RDL file? Is the RDL file in the local > file =system?> > Also, you may try to test whether other main report with the =sub-report you > use have the same issue. Please let me know the =result.> > Sincerely,> > Wei Lu> > Microsoft =Online Community Support> > =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D==3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=> > Get notification to my posts through email? Please refer to > =http://msdn.microsoft.com/subscriptions/managednewsgroups/defaul=t.aspx#notif> ications.> > Note: The MSDN =Managed Newsgroup support offering is for non-urgent issues > where an =initial response from the community or a Microsoft Support > Engineer =within 1 business day is acceptable. Please note that each follow > up =response may take approximately 2 business days as the support > =professional working with you may need further investigation to reach the > =most efficient resolution. The offering is not appropriate for situations => that require urgent, real-time or phone-based interactions or complex => project analysis and dump analysis issues. Issues of this nature are =best > handled working with a dedicated Microsoft Support Engineer by contacting > Microsoft Customer Support Services (CSS) at => .> > =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D==3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=> (This posting is provided "AS IS", with no warranties, and confers no > rights.)>

---

--=_NextPart_000_0015_01C6BA07.8BE13F10--

Datadriven Subscription - Web Archive Improper formatting

Hi All,

I have a data driven subscription with Web Archive rendering format.

(SQL Reporting Service 2000). When a user gets this email, the format is not alligned properly, even, lines are missing in the report.

What could be the problem, is this a known issue? if yes, any patches available?

Please help me.

Thanks,

Nagesh

There are no replies to this query since one week...

Is this a silly query or tough one...

DataConversion Problem

This is a multi-part message in MIME format.
--=_NextPart_000_0008_01C5F419.25A61BD0
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
SQL Server 2000, Win 2000 Access 97
I have an Access FrontEnd and BackEnd
The backend tables have been imported (Data Transformation Services) = into ab SQL Server Database.
Much of the data was not of the type required - e.g. nVarChar needed to = be VarChar
These transformations were carried out using SQL EnterpriseManager > = DesignTable
The Access Front End worked Fine.
PROBLEM
--
For security reasons one tables, Companies, was dropped.
Now after re-importing the table (Data Transformation Services)
and running a script (SQL Query Analyser)
[ example line of script > ALTER TABLE dbo.Companies Alter Column = CompanyName VarChar(50) ]
This reports success.
The datatypes are now reported to be as required (SQL EnterpriseManager = > Design Table)
Inspecting the data in the ACCESS 97 front end is fine
BUT - attempts to update the data give an ERROR
The import of the error is that the ACCESS front end is trying to update = a text field BUT the server is still telling the access Front end that = the datatype is nVarChar [NOT VarChar - as currently reported by SQL = Enterprise Manager]
NOTE - the Access Front End first deletes ALL the tableDefs then = recreates them with an ODBC connection to the Server
All the other tables (apart from Companies) are still updateable as they = were before.
Jim Bunton
--=_NextPart_000_0008_01C5F419.25A61BD0
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
&
SQL Server 2000, Win 2000 Access = 97

I have an Access FrontEnd and = BackEnd
The backend tables have been imported = (Data Transformation Services) into ab SQL Server Database.

Much of the data was not of the type = required - e.g. nVarChar needed to be VarChar

These transformations were carried out = using SQL EnterpriseManager > DesignTable

The Access Front End worked = Fine.

PROBLEM
--
For security reasons one tables, = Companies, was dropped.
Now after re-importing the table (Data Transformation Services)
and running a script (SQL Query Analyser)
[ example line of script > = ALTER TABLE dbo.Companies Alter Column CompanyName VarChar(50) ]This reports success.

The datatypes are now reported to be as = required (SQL EnterpriseManager > Design Table)

Inspecting the data in the ACCESS = 97 front end is fine

BUT - attempts to update = the data give an ERROR
The import of the error is that the = ACCESS front end is trying to update a text field BUT the server is still telling the = access Front end that the datatype is nVarChar [NOT VarChar - = as currently reported by SQL Enterprise Manager]
NOTE - the Access Front End first = deletes ALL the tableDefs then recreates them with an ODBC connection to the = Server
All the other tables (apart from = Companies) are still updateable as they were before.
Jim = Bunton
--=_NextPart_000_0008_01C5F419.25A61BD0--This is a multi-part message in MIME format.
--=_NextPart_000_002A_01C5F42C.B3E69A60
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
Jim
Do you have a last Service Pack installed on the SQL Server?
Looks strange. I just did some testing and it works just fine
Try to create a table first and then run DTS to update the table.
"Jim Bunton" <jBunton@.BlueYonder.co.uk> wrote in message =news:KWCif.17904$8G6.12386@.fe1.news.blueyonder.co.uk...
SQL Server 2000, Win 2000 Access 97
I have an Access FrontEnd and BackEnd
The backend tables have been imported (Data Transformation Services) =into ab SQL Server Database.
Much of the data was not of the type required - e.g. nVarChar needed =to be VarChar
These transformations were carried out using SQL EnterpriseManager > =DesignTable
The Access Front End worked Fine.
PROBLEM
--
For security reasons one tables, Companies, was dropped.
Now after re-importing the table (Data Transformation Services)
and running a script (SQL Query Analyser)
[ example line of script > ALTER TABLE dbo.Companies Alter Column =CompanyName VarChar(50) ]
This reports success.
The datatypes are now reported to be as required (SQL =EnterpriseManager > Design Table)
Inspecting the data in the ACCESS 97 front end is fine
BUT - attempts to update the data give an ERROR
The import of the error is that the ACCESS front end is trying to =update a text field BUT the server is still telling the access Front end =that the datatype is nVarChar [NOT VarChar - as currently reported by =SQL Enterprise Manager]
NOTE - the Access Front End first deletes ALL the tableDefs then =recreates them with an ODBC connection to the Server
All the other tables (apart from Companies) are still updateable as =they were before.
Jim Bunton
--=_NextPart_000_002A_01C5F42C.B3E69A60
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
&

---

Jim
Do you have a last Service Pack =installed on the SQL Server?
Looks strange. I just did some testing =and it works just fine
Try to create a table first and =then run DTS to update the table.
"Jim Bunton" = wrote in message news:KWCif.=17904$8G6.12386@.fe1.news.blueyonder.co.uk...
SQL Server 2000, Win 2000 Access =97

I have an Access FrontEnd and BackEnd
The backend tables have been imported =(Data Transformation Services) into ab SQL Server Database.

Much of the data was not of the type =required - e.g. nVarChar needed to be VarChar

These transformations were carried =out using SQL EnterpriseManager > DesignTable

The Access Front End worked =Fine.

PROBLEM
--
For security reasons one tables, =Companies, was dropped.
Now after re-importing the table =(Data Transformation Services)
and running a script (SQL Query Analyser)
[ example line of script > = ALTER TABLE dbo.Companies Alter Column CompanyName VarChar(50) ]This reports success.

The datatypes are now reported to be =as required (SQL EnterpriseManager > Design Table)

Inspecting the data in the =ACCESS 97 front end is fine

BUT - attempts to =update the data give an ERROR
The import of the error is that the =ACCESS front end is trying to update a text field BUT the server is still telling =the access Front end that the datatype is nVarChar [NOT =VarChar - as currently reported by SQL Enterprise Manager]
NOTE - the Access Front End first =deletes ALL the tableDefs then recreates them with an ODBC connection to the Server
All the other tables (apart from =Companies) are still updateable as they were before.
Jim Bunton

---

--=_NextPart_000_002A_01C5F42C.B3E69A60--|||This is a multi-part message in MIME format.
--=_NextPart_000_0009_01C5F42C.4FDF9BC0
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
Thanks for the reply Uri
DownLoaded Service Pack 3
Installed - works
DownLoaded Service Pack 3a (sql2kasp3.exe)
Setup.exe > begins to run - stops on ERROR 145 an error occurred in =the move data process
? Help ? !! Have done a reboot. still no joy
"Uri Dimant" <urid@.iscar.co.il> wrote in message =news:eeBjvvB9FHA.1032@.TK2MSFTNGP11.phx.gbl...
Jim
Do you have a last Service Pack installed on the SQL Server?
Looks strange. I just did some testing and it works just fine
Try to create a table first and then run DTS to update the table.
"Jim Bunton" <jBunton@.BlueYonder.co.uk> wrote in message =news:KWCif.17904$8G6.12386@.fe1.news.blueyonder.co.uk...
SQL Server 2000, Win 2000 Access 97
I have an Access FrontEnd and BackEnd
The backend tables have been imported (Data Transformation Services) =into ab SQL Server Database.
Much of the data was not of the type required - e.g. nVarChar needed =to be VarChar
These transformations were carried out using SQL EnterpriseManager > =DesignTable
The Access Front End worked Fine.
PROBLEM
--
For security reasons one tables, Companies, was dropped.
Now after re-importing the table (Data Transformation Services)
and running a script (SQL Query Analyser)
[ example line of script > ALTER TABLE dbo.Companies Alter Column =CompanyName VarChar(50) ]
This reports success.
The datatypes are now reported to be as required (SQL =EnterpriseManager > Design Table)
Inspecting the data in the ACCESS 97 front end is fine
BUT - attempts to update the data give an ERROR
The import of the error is that the ACCESS front end is trying to =update a text field BUT the server is still telling the access Front end =that the datatype is nVarChar [NOT VarChar - as currently reported by =SQL Enterprise Manager]
NOTE - the Access Front End first deletes ALL the tableDefs then =recreates them with an ODBC connection to the Server
All the other tables (apart from Companies) are still updateable as =they were before.
Jim Bunton
--=_NextPart_000_0009_01C5F42C.4FDF9BC0
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
&

---

Thanks for the reply Uri
DownLoaded Service Pack 3
Installed - works
DownLoaded Service Pack 3a (sql2kasp3.exe)
Setup.exe > =begins to run - stops on ERROR 145 an error occurred in the move data =process
? Help ? !! Have done a reboot. =still no joy
"Uri Dimant" wrote in =message news:eeBjvvB9FHA.1032=@.TK2MSFTNGP11.phx.gbl...
Jim

Do you have a last Service Pack =installed on the SQL Server?

Looks strange. I just did some =testing and it works just fine

Try to create a table first and =then run DTS to update the table.


"Jim Bunton" = wrote in message news:KWCif.=17904$8G6.12386@.fe1.news.blueyonder.co.uk...
SQL Server 2000, Win 2000 Access 97

I have an Access FrontEnd and BackEnd
The backend tables have been =imported (Data Transformation Services) into ab SQL Server Database.

Much of the data was not of the =type required - e.g. nVarChar needed to be VarChar

These transformations were carried =out using SQL EnterpriseManager > DesignTable

The Access Front End worked =Fine.

PROBLEM
--
For security reasons one tables, =Companies, was dropped.
Now after re-importing the table =(Data Transformation Services)
and running a script (SQL Query Analyser)
[ example line of script > = ALTER TABLE dbo.Companies Alter Column CompanyName VarChar(50) ]This reports = success.

The datatypes are now reported to =be as required (SQL EnterpriseManager > Design Table)

Inspecting the data in the =ACCESS 97 front end is fine

BUT - attempts to =update the data give an ERROR
The import of the error is that the =ACCESS front end is trying to update a text field BUT the server is still =telling the access Front end that the datatype is nVarChar =[NOT VarChar - as currently reported by SQL Enterprise =Manager]
NOTE - the Access Front End first =deletes ALL the tableDefs then recreates them with an ODBC connection to the Server
All the other tables (apart from =Companies) are still updateable as they were before.
Jim Bunton

---

--=_NextPart_000_0009_01C5F42C.4FDF9BC0--|||This is a multi-part message in MIME format.
--=_NextPart_000_001B_01C5F447.76A4E2E0
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
Creating table first then loading data works fine - ca now edit data
[update to SP 4 - to SP 3 Ok but SP 3a setup.exe > will not instal - stops wth err 145 'an error occurred =in the move data process']
"Uri Dimant" <urid@.iscar.co.il> wrote in message =news:eeBjvvB9FHA.1032@.TK2MSFTNGP11.phx.gbl...
Jim
Do you have a last Service Pack installed on the SQL Server?
Looks strange. I just did some testing and it works just fine
Try to create a table first and then run DTS to update the table.
"Jim Bunton" <jBunton@.BlueYonder.co.uk> wrote in message =news:KWCif.17904$8G6.12386@.fe1.news.blueyonder.co.uk...
SQL Server 2000, Win 2000 Access 97
I have an Access FrontEnd and BackEnd
The backend tables have been imported (Data Transformation Services) =into ab SQL Server Database.
Much of the data was not of the type required - e.g. nVarChar needed =to be VarChar
These transformations were carried out using SQL EnterpriseManager > =DesignTable
The Access Front End worked Fine.
PROBLEM
--
For security reasons one tables, Companies, was dropped.
Now after re-importing the table (Data Transformation Services)
and running a script (SQL Query Analyser)
[ example line of script > ALTER TABLE dbo.Companies Alter Column =CompanyName VarChar(50) ]
This reports success.
The datatypes are now reported to be as required (SQL =EnterpriseManager > Design Table)
Inspecting the data in the ACCESS 97 front end is fine
BUT - attempts to update the data give an ERROR
The import of the error is that the ACCESS front end is trying to =update a text field BUT the server is still telling the access Front end =that the datatype is nVarChar [NOT VarChar - as currently reported by =SQL Enterprise Manager]
NOTE - the Access Front End first deletes ALL the tableDefs then =recreates them with an ODBC connection to the Server
All the other tables (apart from Companies) are still updateable as =they were before.
Jim Bunton
--=_NextPart_000_001B_01C5F447.76A4E2E0
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
&

---

Creating table first then loading data =works fine - ca now edit data
[update to SP 4 - to SP 3 Ok but =SP 3a setup.exe > will not instal - =stops wth err 145 'an error occurred in the move data process']
"Uri Dimant" wrote in =message news:eeBjvvB9FHA.1032=@.TK2MSFTNGP11.phx.gbl...
Jim

Do you have a last Service Pack =installed on the SQL Server?

Looks strange. I just did some =testing and it works just fine

Try to create a table first and =then run DTS to update the table.


"Jim Bunton" = wrote in message news:KWCif.=17904$8G6.12386@.fe1.news.blueyonder.co.uk...
SQL Server 2000, Win 2000 Access 97

I have an Access FrontEnd and BackEnd
The backend tables have been =imported (Data Transformation Services) into ab SQL Server Database.

Much of the data was not of the =type required - e.g. nVarChar needed to be VarChar

These transformations were carried =out using SQL EnterpriseManager > DesignTable

The Access Front End worked =Fine.

PROBLEM
--
For security reasons one tables, =Companies, was dropped.
Now after re-importing the table =(Data Transformation Services)
and running a script (SQL Query Analyser)
[ example line of script > = ALTER TABLE dbo.Companies Alter Column CompanyName VarChar(50) ]This reports = success.

The datatypes are now reported to =be as required (SQL EnterpriseManager > Design Table)

Inspecting the data in the =ACCESS 97 front end is fine

BUT - attempts to =update the data give an ERROR
The import of the error is that the =ACCESS front end is trying to update a text field BUT the server is still =telling the access Front end that the datatype is nVarChar =[NOT VarChar - as currently reported by SQL Enterprise =Manager]
NOTE - the Access Front End first =deletes ALL the tableDefs then recreates them with an ODBC connection to the Server
All the other tables (apart from =Companies) are still updateable as they were before.
Jim Bunton

---

--=_NextPart_000_001B_01C5F447.76A4E2E0--

database written in Natural and bck data format

does anybody know, is there any possible way to connect to database written in Natural ?? After evaluating everyday backups on that database all i can see is BCK data format. im trying to create datawarehouse running on sql server 2000 and gather all operational data from the systems that are working in my firm. I just managed to get data originating from Interbase and these with dbf and txt format . unfortunatelly my problem with bck data format is still open.
As you can see im a beginner with that issue so if anybody could help i would be very gratefull.http://www.attunity.com/data_integration/adabas_xml.htm