Datasource Error

I'm getting this message when I try to enter an SQL statement for a new
report:
"There is an error in the query. MinimumCapacity must be non-negative."
My SQL statement is:
"CALL GET_INSTALLMENTS_HEADER(?,?)"
I've tried using both IBM DB2 Provider and HiT Softwares OLEDB/400 provider
and get the same error.
Any ideas?
Thanks in advance,
MikeI am going against Sybase using OLEDB so although it is not the same
database as you are going against it is using an OLEDB provider. I do not
use the syntax you are using. I use the following syntax:
pr_test ?, ?
If you already have report parameters created then go to the parameters tab
of the dataset (click on the ...) and map the query parameter to the report
parameter. If in the generic query designer I have found I have to leave the
command type as text rather than setting it to stored procedure.
--
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Mike" <MichaelLopez@.inds.com> wrote in message
news:O7%23%233%23mxEHA.3212@.TK2MSFTNGP09.phx.gbl...
> I'm getting this message when I try to enter an SQL statement for a new
> report:
> "There is an error in the query. MinimumCapacity must be
non-negative."
> My SQL statement is:
> "CALL GET_INSTALLMENTS_HEADER(?,?)"
> I've tried using both IBM DB2 Provider and HiT Softwares OLEDB/400
provider
> and get the same error.
> Any ideas?
> Thanks in advance,
> Mike
>|||Hi, Bruce. Thanks for responding.
That's how I did it, though I discovered it through empirical means.
We've used Crystal Reports for some time, and it's not a bad product at all.
But we always had to jump through hoops to gain access to an IBM AS/400
(iSeries) machine, and forget about accessing stored procedures on the 400.
We never could natively. Yesterday was my first attempt at accessing the
same system using RS and got it to work in about an hour.
That's a good sign. My next step is to figure out how to emulate CR's "Group
Tree" functionality.
Good chance this group will be hearing from me soon.
Thanks again,
Mike
"Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
news:OGgUbenxEHA.824@.TK2MSFTNGP11.phx.gbl...
>I am going against Sybase using OLEDB so although it is not the same
> database as you are going against it is using an OLEDB provider. I do not
> use the syntax you are using. I use the following syntax:
> pr_test ?, ?
> If you already have report parameters created then go to the parameters
> tab
> of the dataset (click on the ...) and map the query parameter to the
> report
> parameter. If in the generic query designer I have found I have to leave
> the
> command type as text rather than setting it to stored procedure.
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "Mike" <MichaelLopez@.inds.com> wrote in message
> news:O7%23%233%23mxEHA.3212@.TK2MSFTNGP09.phx.gbl...
>> I'm getting this message when I try to enter an SQL statement for a new
>> report:
>> "There is an error in the query. MinimumCapacity must be
> non-negative."
>> My SQL statement is:
>> "CALL GET_INSTALLMENTS_HEADER(?,?)"
>> I've tried using both IBM DB2 Provider and HiT Softwares OLEDB/400
> provider
>> and get the same error.
>> Any ideas?
>> Thanks in advance,
>> Mike
>>
>sql

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--

Dataset CommandType: TableDirect (Error)

In Visual Studio Report Designer data tab, whenever I try to create a new
dataset with the CommandType "TableDirect" I get the following message:
"An error has occurred while setting the Command Type property of the data
extension command. CommandType.TableDirect is not supported by the .Net
SqlClient Data Provider."
when I click OK to the dataset. I wonder why Visual Studio.NET would contain
a CommandType that is not supported. Any ideas what is causing this?
MalikSee
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/cpref/html/frlrfSystemDataCommandTypeClassTopic.asp
for details.
--
Ravi Mumulla (Microsoft)
SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"Abdul Malik Said" <diplacusis@.hotmNOSPAMail.com> wrote in message
news:uiM%23UDybEHA.1000@.TK2MSFTNGP12.phx.gbl...
> In Visual Studio Report Designer data tab, whenever I try to create a new
> dataset with the CommandType "TableDirect" I get the following message:
> "An error has occurred while setting the Command Type property of the data
> extension command. CommandType.TableDirect is not supported by the .Net
> SqlClient Data Provider."
> when I click OK to the dataset. I wonder why Visual Studio.NET would
contain
> a CommandType that is not supported. Any ideas what is causing this?
> Malik
>sql

DataReader Source can not configurate

when I configurate the datareader source using the ODBC connection manager. it show the follow error message:
"Error at Data Flow Task[DataReader Source [562]]: Cannot acquire a managed connection from the run-time connection manager"
this ODBC is connect to IBM DB2.

Can anyone help on this?

Frank,

see this thread:

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=379235&SiteID=1

Thanks.

Datagrid Delete

Hi I'm having a problem deleting rows from my datagrid. Basically I hit delete and a message box pops up and asks if Im sure I want to delete so I hit yes and then I get the following error -->Could not find stored procedure 'delete from SECTION_TBL where SECT_ID = @.SECT_ID'.

Is it my code thats wrong or is our test sql server that is the problem?

1<%@. Page Language="VB" EnableEventValidation="True" MasterPageFile="~/MasterPage.master" Title="Untitled Page" %>2<%@. import namespace="System" %>3<%@. import namespace="System.Data" %>4<%@. import namespace="System.Data.SqlClient" %>56<script language="VB" runat="server">78Dim sectionAs String9 Dim myconnectionAs SqlConnection10Dim mydaAs SqlDataAdapter11Dim dsAs DataSet1213Sub Page_Load(ByVal SourceAs Object,ByVal EAs EventArgs)14 BindData()15End Sub1617 Sub BindData()1819Dim strConnAs String ="server=fileserver; uid=xxx; pwd=xxx; database=NEW_CMS"20Dim sqlAs String ="Select * from SECTION_TBL"21 myconnection =New SqlConnection(strConn)22 myda =New SqlDataAdapter(sql, myconnection)23 ds =New DataSet24 myda.Fill(ds,"SECTION_TBL")25 sectList.DataSource = ds26 sectList.DataBind()2728End Sub2930 Private Sub sectList_ItemDataBound(ByVal senderAs Object,ByVal eAs DataGridItemEventArgs)Handles sectList.ItemDataBound3132Dim lAs LinkButton3334If e.Item.ItemType = ListItemType.ItemOr e.Item.ItemType = ListItemType.AlternatingItemThen35 l =CType(e.Item.Cells(0).FindControl("cmdDel"), LinkButton)36 l.Attributes.Add("onclick","return getconfirm();")37End If3839 End Sub4041 Sub sectList_DeleteCommand(ByVal sAs Object,ByVal eAs DataGridCommandEventArgs)4243Dim ConnectionStrAs String = ConfigurationManager.AppSettings("ConnStr")44Dim connAs SqlConnection45Dim cmdAs SqlCommand46Dim IdAs Integer4748 Id =CInt(e.Item.Cells(0).Text)49 conn =New SqlConnection("server=fileserver; uid=xxx; pwd=xxx; database=NEW_CMS")50 cmd =New SqlCommand("delete from SECTION_TBL where SECT_ID = @.SECT_ID", conn)51 cmd.CommandType = CommandType.StoredProcedure52 cmd.Parameters.Add("@.SECT_ID", SqlDbType.Int).Value = Id5354 cmd.Connection.Open()55 cmd.ExecuteNonQuery()56 cmd.Connection.Close()5758 DataBind()5960End Sub61626364</script>6566<asp:Content ID="Content1" ContentPlaceHolderID="ContentPlaceHolder1" Runat="Server">6768<script language="javascript">6970function getconfirm()71{72if (confirm("Do you want to delete record?")==true)73return true;74else75return false;76}7778</script>7980<table cellpadding="2" cellspacing="2" width="760">81<tr>82<td>Sections</td>83</tr>84<tr>85<td>8687<asp:DataGrid OnDeleteCommand="sectList_DeleteCommand" ID="sectList" runat="server" DataKeyField="SECT_ID" AutoGenerateColumns="False">8889<Columns>9091<asp:BoundColumn DataField="SECT_ID" Visible="False" />9293<asp:HyperLinkColumn HeaderText="SECTION NAME" DataTextField="SECT_NAME" DataNavigateUrlField="SECT_ID" DataNavigateUrlFormatString="manageSection.aspx?SECT_ID={0}" />9495<asp:TemplateColumn>96<ItemTemplate>97<asp:LinkButton id="cmdDel" runat="server" Text="Delete" CommandName="Delete" CausesValidation="false" />98</ItemTemplate>99</asp:TemplateColumn>100101</Columns>102103</asp:DataGrid>104105</td>106</tr>107<tr>108<td></td>109</tr>110</table>111112</asp:Content>

Thanks in advance.

on line 51 you should use

CommandType.Text

|||

Brilliant - This works great

Thank you.

Datagram message

My app was working fine (no change in the last couple of years) until
recently.
Here is an example of my XML -
<root
xmlns:updg="urn:schemas-microsoft-com:xml-updategram"><updg:sync><updg:before><ProbePart
VFPID="28724"/></updg:before><updg:after><ProbePart
ReconSell="5520"/></updg:after></updg:sync></root>
which results in the Response -
<H3>ERROR: 400.100 Bad Request</H3><b>HResult:</b>
0x80004005<br><b>Source:</b> Microsoft SQL isapi
extension<br><b>Description:</b> Query not specified<br>
Not sure where to look for resolution - any pointers would be appreciated.
Could you please provide some more information? Like what your setup is and
a simple complete repro?
Thanks
Michael
"howard" <howard@.discussions.microsoft.com> wrote in message
news:1B14174A-7CC0-4B78-BB8E-15EC906834BE@.microsoft.com...
> My app was working fine (no change in the last couple of years) until
> recently.
> Here is an example of my XML -
> <root
> xmlns:updg="urn:schemas-microsoft-com:xml-updategram"><updg:sync><updg:before><ProbePart
> VFPID="28724"/></updg:before><updg:after><ProbePart
> ReconSell="5520"/></updg:after></updg:sync></root>
> which results in the Response -
> <H3>ERROR: 400.100 Bad Request</H3><b>HResult:</b>
> 0x80004005<br><b>Source:</b> Microsoft SQL isapi
> extension<br><b>Description:</b> Query not specified<br>
> Not sure where to look for resolution - any pointers would be appreciated.
>
>

Datafields in report header

Hi.

I want some information stored in the database to be shown on the top of each page in my report. But in the report designer I get an error message if I try to drop a table in the header, and if I try to assign the value of a textbox in the header to e.g. "First(Fields!sometable.Value)", I get a runtime-error in the preview that says "... Fields cannot be used in page headers or footers".

How can I do this?

Regards, Tomsi

Hi Tomsi,

you can not place a databound field in the page header directly. Instead, you can place it in the body of the report and make it hidden.

you can refer to this hidden field content using the similar syntax

=ReportItems!txt_1.Value

and display in a text box placed in the header.

Rgds,

Ramesh

|||

Nice workaround. Thanks.

But why doesn't Reporting Services support this feature / when will it come? Workarounds like this will in the long run make the reports complex and messy. I'm converting reports from Crystal Reports, and my customer will obviously dislike this "missing" feature in RS.

The ideal solution would be have a databound table in the header...

Tomsi

|||I tried this on some of the reports we have been creating and it works great on the first page but in the rest of the report the cells in the header are unable to reference the cells in the body. We are using 2005.|||

Another option is to add a (hidden) report parameter at the beginning of your list of report parameters with a query-based default value (the field you want to show in the report header). If your query returns multiple rows, you will need to perform aggregations (e.g. Max(...)) directly in the query so that the first row contains the value you want to use for the parameter value.
Then, in the report header reference the parameter value.

-- Robert

|||

I'm experiencing the same issue, were you able to resolve the problem? It works fine on page 1, but not on subsequent pages.

Alternatively, I was able to use the Parameters!parameter.value consistently in the header, but when I used Parameters!parameter.label, the value would disappear from the header when I changed any parameter that affected a report filter without requerying.

|||

The secret of this is, to embed the data in a table header. Have the table header repeat on every page, and refer to the table header cell in the text field of the page header.

unfortuantely the only way I've been able hide the data, in the table header, and not be noticeable, is take make the font really small, and make the text, and row black. Hope this helps.

M

|||

Another way to do this is to have the Data you want displayed in the header to be retrieved into Report paramaters.

Then the parameters can be put in the Page Header.

Set up a Paramater for each piece of Data you require and retrieve into the Paramaters setting the default values with the values you want displayed.

It works fine. It would be much better if we could ust put Data bound fields into the Page Header.

Dave

|||

I created a report (rs2005) with a hidden header row in the table that repeats on each page. When I view the report it looks fine, but when I export to a PDF the ReportItem data is missing from the header.

Header before exporting to PDF:

Title: This Should be Easier Date: 5/19/06

Header after exporting to PDF:

Title: Date:

Is there any way to fix this?

|||

This could quite possibly be the biggest pain in Reporting Services, compared to other reporting tools. It is quite probable that anyone doing reports is doing so in a corporate environment where key data values must be displayed in the header. When report details relating to these key data values span more than one page, the RS engine should be able to handle this and continue to display the data associated with these values in the header. In addition, it should be able to handle changes in this data and apply appropriate page breaks.

I have tried all these so called "work arounds" and they only work about 80% of the time. I am slowly, (or quickly, and can't admit it) coming to the conclusion that RS is not yet ready for Prime-Time corporate reporting. I agree with the previous post that these only make development in RS much more difficult and hoaky work-arounds make for difficult to maintain and basically not very functional reports.

I have some complicated reports that use subreports, datalists, and intrictate formating of textboxes and images which need to span multiple pages and print nicely in PDF. Unfortunately, the reference to a textbox or reference to hidden row in a table just does not always work.

IS THERE ANYONE out there that has found a simple, consistant and non-cumbersome way of doing this.

AND for Microsoft RS development team...when are you going to provide an actual solution to this issue? It was a problem in RS2000 and continues in RS2005.

|||You hit the nail right on the head there buddy. This task is so basic it seems ridiculous to have to resort to these tricks. I hope they get this fixed cause it's ugly.

Frank|||

I have a few clients who love SRS but almost dropped it because of this.

We have found ways around it by using a table and putting a subreports into table headers so we could control if they displayed on first page only or all pages or not at all. Or for simpler solutions by using parameters to store the data that is required in the header.

Either way it's a huge pain in the ^$% for what should be a simple task.

I would also like to plead to the PM of this project to fix this in the next release or a patch it's a necessary feature if you plan to compete with other reporting tools.

Dave

|||

I tried putting the value into a parameter field, but we are setting the datasource of the report at runtime. It works fine in the development environment, but when I deploy the app (even locally) I get this error:

The 'prmFOFCode' parameter is missing a value|||

I used Oracle Reports for years and must admit, SSRS is a pretty disappointing enterprise reporting tool. No data fields in headers, no multi axis charts ... and the list goes on. Nice designer and clicky windows but presenting information is just a pain in the neck. Hope the SSRS team will get their act together and provide some basic corporate features.

|||i agree with that, microsoft need to improve its reporting services by keeping corporate business in mind

Datafields in report header

Hi.

I want some information stored in the database to be shown on the top of each page in my report. But in the report designer I get an error message if I try to drop a table in the header, and if I try to assign the value of a textbox in the header to e.g. "First(Fields!sometable.Value)", I get a runtime-error in the preview that says "... Fields cannot be used in page headers or footers".

How can I do this?

Regards, Tomsi

Hi Tomsi,

you can not place a databound field in the page header directly. Instead, you can place it in the body of the report and make it hidden.

you can refer to this hidden field content using the similar syntax

=ReportItems!txt_1.Value

and display in a text box placed in the header.

Rgds,

Ramesh

|||

Nice workaround. Thanks.

But why doesn't Reporting Services support this feature / when will it come? Workarounds like this will in the long run make the reports complex and messy. I'm converting reports from Crystal Reports, and my customer will obviously dislike this "missing" feature in RS.

The ideal solution would be have a databound table in the header...

Tomsi

|||I tried this on some of the reports we have been creating and it works great on the first page but in the rest of the report the cells in the header are unable to reference the cells in the body. We are using 2005.|||

Another option is to add a (hidden) report parameter at the beginning of your list of report parameters with a query-based default value (the field you want to show in the report header). If your query returns multiple rows, you will need to perform aggregations (e.g. Max(...)) directly in the query so that the first row contains the value you want to use for the parameter value.
Then, in the report header reference the parameter value.

-- Robert

|||

I'm experiencing the same issue, were you able to resolve the problem? It works fine on page 1, but not on subsequent pages.

Alternatively, I was able to use the Parameters!parameter.value consistently in the header, but when I used Parameters!parameter.label, the value would disappear from the header when I changed any parameter that affected a report filter without requerying.

|||

The secret of this is, to embed the data in a table header. Have the table header repeat on every page, and refer to the table header cell in the text field of the page header.

unfortuantely the only way I've been able hide the data, in the table header, and not be noticeable, is take make the font really small, and make the text, and row black. Hope this helps.

M

|||

Another way to do this is to have the Data you want displayed in the header to be retrieved into Report paramaters.

Then the parameters can be put in the Page Header.

Set up a Paramater for each piece of Data you require and retrieve into the Paramaters setting the default values with the values you want displayed.

It works fine. It would be much better if we could ust put Data bound fields into the Page Header.

Dave

|||

I created a report (rs2005) with a hidden header row in the table that repeats on each page. When I view the report it looks fine, but when I export to a PDF the ReportItem data is missing from the header.

Header before exporting to PDF:

Title: This Should be Easier Date: 5/19/06

Header after exporting to PDF:

Title: Date:

Is there any way to fix this?

|||

This could quite possibly be the biggest pain in Reporting Services, compared to other reporting tools. It is quite probable that anyone doing reports is doing so in a corporate environment where key data values must be displayed in the header. When report details relating to these key data values span more than one page, the RS engine should be able to handle this and continue to display the data associated with these values in the header. In addition, it should be able to handle changes in this data and apply appropriate page breaks.

I have tried all these so called "work arounds" and they only work about 80% of the time. I am slowly, (or quickly, and can't admit it) coming to the conclusion that RS is not yet ready for Prime-Time corporate reporting. I agree with the previous post that these only make development in RS much more difficult and hoaky work-arounds make for difficult to maintain and basically not very functional reports.

I have some complicated reports that use subreports, datalists, and intrictate formating of textboxes and images which need to span multiple pages and print nicely in PDF. Unfortunately, the reference to a textbox or reference to hidden row in a table just does not always work.

IS THERE ANYONE out there that has found a simple, consistant and non-cumbersome way of doing this.

AND for Microsoft RS development team...when are you going to provide an actual solution to this issue? It was a problem in RS2000 and continues in RS2005.

|||You hit the nail right on the head there buddy. This task is so basic it seems ridiculous to have to resort to these tricks. I hope they get this fixed cause it's ugly.

Frank|||

I have a few clients who love SRS but almost dropped it because of this.

We have found ways around it by using a table and putting a subreports into table headers so we could control if they displayed on first page only or all pages or not at all. Or for simpler solutions by using parameters to store the data that is required in the header.

Either way it's a huge pain in the ^$% for what should be a simple task.

I would also like to plead to the PM of this project to fix this in the next release or a patch it's a necessary feature if you plan to compete with other reporting tools.

Dave

|||

I tried putting the value into a parameter field, but we are setting the datasource of the report at runtime. It works fine in the development environment, but when I deploy the app (even locally) I get this error:

The 'prmFOFCode' parameter is missing a value|||

I used Oracle Reports for years and must admit, SSRS is a pretty disappointing enterprise reporting tool. No data fields in headers, no multi axis charts ... and the list goes on. Nice designer and clicky windows but presenting information is just a pain in the neck. Hope the SSRS team will get their act together and provide some basic corporate features.

|||i agree with that, microsoft need to improve its reporting services by keeping corporate business in mind

Datafields in report header

Hi.

I want some information stored in the database to be shown on the top of each page in my report. But in the report designer I get an error message if I try to drop a table in the header, and if I try to assign the value of a textbox in the header to e.g. "First(Fields!sometable.Value)", I get a runtime-error in the preview that says "... Fields cannot be used in page headers or footers".

How can I do this?

Regards, Tomsi

Hi Tomsi,

you can not place a databound field in the page header directly. Instead, you can place it in the body of the report and make it hidden.

you can refer to this hidden field content using the similar syntax

=ReportItems!txt_1.Value

and display in a text box placed in the header.

Rgds,

Ramesh

|||

Nice workaround. Thanks.

But why doesn't Reporting Services support this feature / when will it come? Workarounds like this will in the long run make the reports complex and messy. I'm converting reports from Crystal Reports, and my customer will obviously dislike this "missing" feature in RS.

The ideal solution would be have a databound table in the header...

Tomsi

|||I tried this on some of the reports we have been creating and it works great on the first page but in the rest of the report the cells in the header are unable to reference the cells in the body. We are using 2005.|||

Another option is to add a (hidden) report parameter at the beginning of your list of report parameters with a query-based default value (the field you want to show in the report header). If your query returns multiple rows, you will need to perform aggregations (e.g. Max(...)) directly in the query so that the first row contains the value you want to use for the parameter value.
Then, in the report header reference the parameter value.

-- Robert

|||

I'm experiencing the same issue, were you able to resolve the problem? It works fine on page 1, but not on subsequent pages.

Alternatively, I was able to use the Parameters!parameter.value consistently in the header, but when I used Parameters!parameter.label, the value would disappear from the header when I changed any parameter that affected a report filter without requerying.

|||

The secret of this is, to embed the data in a table header. Have the table header repeat on every page, and refer to the table header cell in the text field of the page header.

unfortuantely the only way I've been able hide the data, in the table header, and not be noticeable, is take make the font really small, and make the text, and row black. Hope this helps.

M

|||

Another way to do this is to have the Data you want displayed in the header to be retrieved into Report paramaters.

Then the parameters can be put in the Page Header.

Set up a Paramater for each piece of Data you require and retrieve into the Paramaters setting the default values with the values you want displayed.

It works fine. It would be much better if we could ust put Data bound fields into the Page Header.

Dave

|||

I created a report (rs2005) with a hidden header row in the table that repeats on each page. When I view the report it looks fine, but when I export to a PDF the ReportItem data is missing from the header.

Header before exporting to PDF:

Title: This Should be Easier Date: 5/19/06

Header after exporting to PDF:

Title: Date:

Is there any way to fix this?

|||

This could quite possibly be the biggest pain in Reporting Services, compared to other reporting tools. It is quite probable that anyone doing reports is doing so in a corporate environment where key data values must be displayed in the header. When report details relating to these key data values span more than one page, the RS engine should be able to handle this and continue to display the data associated with these values in the header. In addition, it should be able to handle changes in this data and apply appropriate page breaks.

I have tried all these so called "work arounds" and they only work about 80% of the time. I am slowly, (or quickly, and can't admit it) coming to the conclusion that RS is not yet ready for Prime-Time corporate reporting. I agree with the previous post that these only make development in RS much more difficult and hoaky work-arounds make for difficult to maintain and basically not very functional reports.

I have some complicated reports that use subreports, datalists, and intrictate formating of textboxes and images which need to span multiple pages and print nicely in PDF. Unfortunately, the reference to a textbox or reference to hidden row in a table just does not always work.

IS THERE ANYONE out there that has found a simple, consistant and non-cumbersome way of doing this.

AND for Microsoft RS development team...when are you going to provide an actual solution to this issue? It was a problem in RS2000 and continues in RS2005.

|||You hit the nail right on the head there buddy. This task is so basic it seems ridiculous to have to resort to these tricks. I hope they get this fixed cause it's ugly.

Frank|||

I have a few clients who love SRS but almost dropped it because of this.

We have found ways around it by using a table and putting a subreports into table headers so we could control if they displayed on first page only or all pages or not at all. Or for simpler solutions by using parameters to store the data that is required in the header.

Either way it's a huge pain in the ^$% for what should be a simple task.

I would also like to plead to the PM of this project to fix this in the next release or a patch it's a necessary feature if you plan to compete with other reporting tools.

Dave

|||

I tried putting the value into a parameter field, but we are setting the datasource of the report at runtime. It works fine in the development environment, but when I deploy the app (even locally) I get this error:

The 'prmFOFCode' parameter is missing a value|||

I used Oracle Reports for years and must admit, SSRS is a pretty disappointing enterprise reporting tool. No data fields in headers, no multi axis charts ... and the list goes on. Nice designer and clicky windows but presenting information is just a pain in the neck. Hope the SSRS team will get their act together and provide some basic corporate features.

|||i agree with that, microsoft need to improve its reporting services by keeping corporate business in mind

Datafields in report header

Hi.

I want some information stored in the database to be shown on the top of each page in my report. But in the report designer I get an error message if I try to drop a table in the header, and if I try to assign the value of a textbox in the header to e.g. "First(Fields!sometable.Value)", I get a runtime-error in the preview that says "... Fields cannot be used in page headers or footers".

How can I do this?

Regards, Tomsi

Hi Tomsi,

you can not place a databound field in the page header directly. Instead, you can place it in the body of the report and make it hidden.

you can refer to this hidden field content using the similar syntax

=ReportItems!txt_1.Value

and display in a text box placed in the header.

Rgds,

Ramesh

|||

Nice workaround. Thanks.

But why doesn't Reporting Services support this feature / when will it come? Workarounds like this will in the long run make the reports complex and messy. I'm converting reports from Crystal Reports, and my customer will obviously dislike this "missing" feature in RS.

The ideal solution would be have a databound table in the header...

Tomsi

|||I tried this on some of the reports we have been creating and it works great on the first page but in the rest of the report the cells in the header are unable to reference the cells in the body. We are using 2005.|||

Another option is to add a (hidden) report parameter at the beginning of your list of report parameters with a query-based default value (the field you want to show in the report header). If your query returns multiple rows, you will need to perform aggregations (e.g. Max(...)) directly in the query so that the first row contains the value you want to use for the parameter value.
Then, in the report header reference the parameter value.

-- Robert

|||

I'm experiencing the same issue, were you able to resolve the problem? It works fine on page 1, but not on subsequent pages.

Alternatively, I was able to use the Parameters!parameter.value consistently in the header, but when I used Parameters!parameter.label, the value would disappear from the header when I changed any parameter that affected a report filter without requerying.

|||

The secret of this is, to embed the data in a table header. Have the table header repeat on every page, and refer to the table header cell in the text field of the page header.

unfortuantely the only way I've been able hide the data, in the table header, and not be noticeable, is take make the font really small, and make the text, and row black. Hope this helps.

M

|||

Another way to do this is to have the Data you want displayed in the header to be retrieved into Report paramaters.

Then the parameters can be put in the Page Header.

Set up a Paramater for each piece of Data you require and retrieve into the Paramaters setting the default values with the values you want displayed.

It works fine. It would be much better if we could ust put Data bound fields into the Page Header.

Dave

|||

I created a report (rs2005) with a hidden header row in the table that repeats on each page. When I view the report it looks fine, but when I export to a PDF the ReportItem data is missing from the header.

Header before exporting to PDF:

Title: This Should be Easier Date: 5/19/06

Header after exporting to PDF:

Title: Date:

Is there any way to fix this?

|||

This could quite possibly be the biggest pain in Reporting Services, compared to other reporting tools. It is quite probable that anyone doing reports is doing so in a corporate environment where key data values must be displayed in the header. When report details relating to these key data values span more than one page, the RS engine should be able to handle this and continue to display the data associated with these values in the header. In addition, it should be able to handle changes in this data and apply appropriate page breaks.

I have tried all these so called "work arounds" and they only work about 80% of the time. I am slowly, (or quickly, and can't admit it) coming to the conclusion that RS is not yet ready for Prime-Time corporate reporting. I agree with the previous post that these only make development in RS much more difficult and hoaky work-arounds make for difficult to maintain and basically not very functional reports.

I have some complicated reports that use subreports, datalists, and intrictate formating of textboxes and images which need to span multiple pages and print nicely in PDF. Unfortunately, the reference to a textbox or reference to hidden row in a table just does not always work.

IS THERE ANYONE out there that has found a simple, consistant and non-cumbersome way of doing this.

AND for Microsoft RS development team...when are you going to provide an actual solution to this issue? It was a problem in RS2000 and continues in RS2005.

|||You hit the nail right on the head there buddy. This task is so basic it seems ridiculous to have to resort to these tricks. I hope they get this fixed cause it's ugly.

Frank|||

I have a few clients who love SRS but almost dropped it because of this.

We have found ways around it by using a table and putting a subreports into table headers so we could control if they displayed on first page only or all pages or not at all. Or for simpler solutions by using parameters to store the data that is required in the header.

Either way it's a huge pain in the ^$% for what should be a simple task.

I would also like to plead to the PM of this project to fix this in the next release or a patch it's a necessary feature if you plan to compete with other reporting tools.

Dave

|||

I tried putting the value into a parameter field, but we are setting the datasource of the report at runtime. It works fine in the development environment, but when I deploy the app (even locally) I get this error:

The 'prmFOFCode' parameter is missing a value|||

I used Oracle Reports for years and must admit, SSRS is a pretty disappointing enterprise reporting tool. No data fields in headers, no multi axis charts ... and the list goes on. Nice designer and clicky windows but presenting information is just a pain in the neck. Hope the SSRS team will get their act together and provide some basic corporate features.

|||i agree with that, microsoft need to improve its reporting services by keeping corporate business in mind

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--

Databases not available through QA for some users

Hey All Gurus,
Why on a large environment with many users, when you attach to QA the
systyem says on a pop up message that several databases are not avail
for viewing. These users are members and logins have the correct
permissions. This happens also when you hit f8 from inside of QA then
the databases do not show in the object browser list? The really wierd
this is you can query these unlisted objects?
does anyone know why this would happen
Bill
*** Sent via Developersdex http://www.examnotes.net ***if the databases are not ready to accept client connection (i.e. still in
recovery phase), they're not accessible.
-oj
"Bill Orova" <nospam@.devdex.com> wrote in message
news:OP4zvC$VFHA.2796@.TK2MSFTNGP09.phx.gbl...
>
> Hey All Gurus,
> Why on a large environment with many users, when you attach to QA the
> systyem says on a pop up message that several databases are not avail
> for viewing. These users are members and logins have the correct
> permissions. This happens also when you hit f8 from inside of QA then
> the databases do not show in the object browser list? The really wierd
> this is you can query these unlisted objects?
> does anyone know why this would happen
> Bill
> *** Sent via Developersdex http://www.examnotes.net ***

DATABASEPROPERTYEX is not a recognized function name?

Hi, I just made a report with the wizard when I swith to preview I got that
message and I cant see my report.
Thanks in advance
--
LUIS ESTEBAN VALENCIA
MICROSOFT DCE 3.
MIEMBRO ACTIVO DE ALIANZADEV
http://spaces.msn.com/members/extremed/You are accessing a SQL Server 7.0 or older, correct? Just install SP1 of RS
2000 on report server and report designer machines and it will work.
The workaround for RS 2000 _without_ SP1 is as follows: Go to the "Data
Options" tab of the "Dataset" dialog in report designer. On the Data Options
tab you will see that all settings contain "Auto" (and report server would
therefore try to auto-detect the collation settings from the database
server). Replace the Auto-settings with the following settings (e.g. if your
SQL 7.0 database collation is "SQL_Latin1_General_CP1_CI_AS"):
Collation = Latin1_General
Case sensitivity = false
Kanatype sensitivity = false
Width sensitivity = false
Accent sensitivity = true
-- Robert
This posting is provided "AS IS" with no warranties, and confers no rights.
"Luis Esteban Valencia" <luisvalen@.haceb.com> wrote in message
news:uCrElYQGFHA.4088@.TK2MSFTNGP09.phx.gbl...
> Hi, I just made a report with the wizard when I swith to preview I got
> that
> message and I cant see my report.
> Thanks in advance
> --
> LUIS ESTEBAN VALENCIA
> MICROSOFT DCE 3.
> MIEMBRO ACTIVO DE ALIANZADEV
> http://spaces.msn.com/members/extremed/
>

database Vendor Code: 1843

Im getting above error code when tried to preview the report. The full message as below:
Failed to retrieve data from the database.
Details: ORA-01843: not a valid month
[database Vendor Code: 1843]There is date format error when sending SQL statement or you set month
more than 12 in input argument.|||ORA-01843: not a valid month
Cause: A date specified an invalid month. Valid months are: January-December, for format code MONTH, and Jan-Dec, for format code MON.
Action: Enter a valid month value in the correct format.