please help before I kill myself over this problem...

have a report that takes 1 parameter on a report server.

Trying to call the report using the reportviewer control

All I want to do is set the report parameter in code.

Dim rp = New Microsoft.Reporting.WinForms.ReportParameter

rp.Name = "InvoiceNumber"

rp.Values.Add("0618050")

Me.ReportViewer1.ServerReport.SetParameters(rp)

Me.ReportViewer1.ShowParameterPrompts = False

ReportViewer1.RefreshReport()

This always fails. I can't figure out how to add the report parameter to the control. PLEASE save me.

I haven't done this myself, but I did see an sample in the help files. Here's a snippet:

// Create the sales order number report parameter
ReportParameter salesOrderNumber = new ReportParameter();
salesOrderNumber.Name = "SalesOrderNumber";
salesOrderNumber.Values.Add("SO43661");

// Set the report parameters for the report
reportViewer1.ServerReport.SetParameters(
new ReportParameter[] { salesOrderNumber });

// Refresh the report
reportViewer1.RefreshReport();

I found this in my local reporting services help under 'Integrating Reporting Services Into Applications'-> 'Integrating Reporting Services Using the Report Viewer Control'.

I hope this helps- please don't kill yourself over microsoft code!!!!

|||what would this be in vb.net?|||

here is what I get in vb.net

Dim salesOrderNumber As ReportParameter = New ReportParameter()

salesOrderNumber.Name = "InvoiceNumber"

salesOrderNumber.Values.Add("0618050")

' Set the report parameters for the report

dim reportparameters() as ReportViewer1.ServerReport.SetParameters(new salesOrderNumber)

except where "new" is I get an error saying that "array bounds cannot appear in type specifiers"

Please help : A call to SQL Server Reconciler failed. Try to resynchronize.

Hi all,

While i am doing new substription wizad, I encounter following error: Do I miss something?

A call to SQL Server Reconciler failed. Try to resynchronize.

A call to SQL Server Reconciler failed. Try to resynchronize.
HRESULT 0x80004005 (29006)

The schema script 'C:\Program Files\Microsoft SQL Server\MSSQL\ReplData\unc\compuntername_SQLMOBILE_SQLMOBILE\20060321224198\CustomerData_2.sch' could not be propagated to the subscriber.
HRESULT 0x80070005 (0)

The merge process was unable to deliver the snapshot to the Subscriber. If using Web synchronization, the merge process may have been unable to create or write to the message file. When troubleshooting, restart the synchronization with verbose history logging and specify an output file to which to write.
HRESULT 0x80045017 (0)

I am using

IIS 5.1

SQL 2005 (Upgrade from SQL 2000 SP4)

Visual Studio 2005

Thank you very much

Tony

try generating a new snapshot on the server and also make sure you are not out of memory on your mobile device when performing the replication.

Darren

|||

HI ,

How can I create another snapshot agin. I am not getting the oiption to select a nre one when running the wizard. I am not able to delete the previous snap shot also.

-Please advise

sql

Please help : A call to SQL Server Reconciler failed. Try to resynchronize.

Hi all,

While i am doing new substription wizad, I encounter following error: Do I miss something?

A call to SQL Server Reconciler failed. Try to resynchronize.

A call to SQL Server Reconciler failed. Try to resynchronize.
HRESULT 0x80004005 (29006)

The schema script 'C:\Program Files\Microsoft SQL Server\MSSQL\ReplData\unc\compuntername_SQLMOBILE_SQLMOBILE\20060321224198\CustomerData_2.sch' could not be propagated to the subscriber.
HRESULT 0x80070005 (0)

The merge process was unable to deliver the snapshot to the Subscriber. If using Web synchronization, the merge process may have been unable to create or write to the message file. When troubleshooting, restart the synchronization with verbose history logging and specify an output file to which to write.
HRESULT 0x80045017 (0)

I am using

IIS 5.1

SQL 2005 (Upgrade from SQL 2000 SP4)

Visual Studio 2005

Thank you very much

Tony

try generating a new snapshot on the server and also make sure you are not out of memory on your mobile device when performing the replication.

Darren

|||

HI ,

How can I create another snapshot agin. I am not getting the oiption to select a nre one when running the wizard. I am not able to delete the previous snap shot also.

-Please advise

PL/SQL RPC call from Sql Server linked server (OraOLEDB)

I'ma having trouble calling a remote pl/sql proc from SQL server 2000 using
a
linked server provider=OraOLEDB.Oracle
Here's the call:
EXEC PS..TESTDTA.esp_F0101Z2_EDSP_set
'C',
'MCHAMBERS',
'23577',
'107399',
2000.0
This is the proc, straight forward...
CREATE PROCEDURE TESTDTA.esp_F0101Z2_EDSP_set (
flag in varchar2,
p_szedus in nchar,
p_szedbt in nchar,
p_szedtn nchar,
p_szedln number
)
AS
BEGIN
UPDATE TESTDTA.F0101Z2 SET
SZEDSP = flag
WHERE
szedus = p_szedus AND
szedbt = p_szedbt AND
szedtn = p_szedtn AND
szedln = p_szedln;
END;
Linked Server Properties:
Collation Compatible = true
Data Access = true
RPC = true
RPC Out = true
Use Remote Collation = true
Provider Properties:
AllowInProcess = 1
DisallowAdhocAccess = 0
DynamicParameters = 1
IndexAsAccessPath = 0
LevelZeroOnly = 0
NestedQueries = 0
NonTransactedUpdates = 0"Alien2_51" <dan.billow.remove@.monacocoach.removeme.com> wrote in message
news:A0EB9CA3-F18A-4777-8F5B-46CE8F1856B4@.microsoft.com...
> I'ma having trouble calling a remote pl/sql proc from SQL server 2000
> using a
> linked server provider=OraOLEDB.Oracle
> Here's the call:
> EXEC PS..TESTDTA.esp_F0101Z2_EDSP_set
> 'C',
> 'MCHAMBERS',
> '23577',
> '107399',
> 2000.0
>
> This is the proc, straight forward...
> CREATE PROCEDURE TESTDTA.esp_F0101Z2_EDSP_set (
> flag in varchar2,
> p_szedus in nchar,
> p_szedbt in nchar,
> p_szedtn nchar,
> p_szedln number
> )
> AS
> BEGIN
> UPDATE TESTDTA.F0101Z2 SET
> SZEDSP = flag
> WHERE
> szedus = p_szedus AND
> szedbt = p_szedbt AND
> szedtn = p_szedtn AND
> szedln = p_szedln;
> END;
>
In SQL 2000 you have to use OPENQUERY and jump through hoops:
http://groups.google.com/group/micr.../>
ce8a?hl=en&
SQL 2005 makes this much easier a couple of enhancements to the EXEC
statement, you can specify a linked server to run remotely, and you can pass
parameters in and out of a dynamic SQL query.
--Oracle SQL---
CREATE OR REPLACE PROCEDURE scott.esp_F0101Z2_EDSP_set (
flag in varchar2,
p_szedus in nchar,
p_szedbt in nchar,
p_szedtn nchar,
p_szedln number,
p_result out varchar2
)
AS
BEGIN
p_result := 'it worked';
END;
--end Oracle SQL---
EXEC sp_addlinkedserver @.server = 'ORACLE',
@.srvproduct='Oracle',
@.provider='OraOLEDB.Oracle',
@.datasrc='//localhost/xe'
EXEC sp_serveroption @.server='ORACLE', @.optname='rpc out', @.optvalue='true'
EXEC sp_addlinkedsrvlogin 'ORACLE', 'false', NULL, 'Scott', 'tiger'
GO
EXEC (
'
BEGIN
SCOTT.esp_F0101Z2_EDSP_set(
:p_flag,
:p_szedus,
:p_szedbt,
:p_szedtn,
:p_szedln,
:p_result);
END;
',
'C',
'MCHAMBERS',
'23577',
'107399',
2000.0,
@.result output
) at ORACLE
print @.result