[dba-VB] SCRUM: Passing variable to or from reports and forms

Hi Mike and SCRUM team,

The sample set of screenshots on how to make parameterized report is published here at CodePlex:

http://northwind.codeplex.com/WorkItem/View.aspx?WorkItemId=547

and also at dba-VB MS Live SkyDrive in HOW TOs section.

Thank you.

--
Shamil

-----Original Message-----
From: "Mike Mattys" <mmattys at rochester.rr.com>
To: "Discussion concerning Visual Basic and related programming issues."<dba-vb at databaseadvisors.com>
Date: Mon, 13 Apr 2009 10:05:15 -0400
Subject: Re: [dba-VB] SCRUM: Passing variable to or from reports and forms

> Hi SCRUM Team,
> 
> Looks like everyone is busy :)
> 
> I decided to temporarily remove the parameter from the view vw_Invoices
> that is the source of the Invoice Report and tried to run it. The error I've
> received is rather puzzling - it was probably there all along and waited 
> patiently.
> 
> This will probably make veteran .Net developer laugh ...
> The error is System.Data.ConstraintException
> I see the "Help" system in .Net has been further "enhanced" also :(
> 
> -
> Michael R Mattys
> MapPoint and Database Dev
> www.mattysconsulting.com
> -
> ----- Original Message ----- 
> From: "Mike Mattys" <mmattys at rochester.rr.com>
> To: "Salakhetdinov Shamil" <mcp2004 at mail.ru>; "Discussion concerning Visual 
> Basic and related programming issues." <dba-vb at databaseadvisors.com>
> Sent: Sunday, April 12, 2009 10:09 PM
> Subject: [dba-VB] SCRUM: Passing variable to or from reports and forms
> 
> 
> > Hi SCRUM Team,
> >
> > I have made the datasource and rdlc of the Invoice Report and bound it to
> > InvoiceReport.cs.
> >
> > If I understand correctly, I can
> >
> > -create a global static variable in Globals.cs or
> > -create a public property in the Orders form
> >
> > for the purpose of passing this variable as a parameter to the report.
> >
> > I could also use a stored procedure to delete and re-create Invoice 
> > Filter.
> >
> > What is the recommended method for passing variables locally vs ASP.Net?
> >
> > -
> > Michael R Mattys
> > MapPoint and Database Dev
> > www.mattysconsulting.com 
> 
> _______________________________________________
> dba-VB mailing list
> dba-VB at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/dba-vb
> http://www.databaseadvisors.com
>