By Edhy Rijo - 6/25/2010
When using SF we have the BindingField which is based on the BusinessObject property of the control, sometimes I have controls which I would like to bind to a new form's property and no business object, so I can reference this property instead of the control itself.
In this case if I use a SF control, can still use its BindingField property with not BusinessObject? or should I just add a regular property and assign the control value in the GET/SET?
|
By Ivan George Borges - 6/25/2010
Hey Edhy.Never tried this and now I have to leave to a very important meeting. My fiance would kill me if I didn't attend this one.  But what I usually do is to set the control value or text according to what I need, let's say the form's property value.
|
By Edhy Rijo - 6/25/2010
Ivan George Borges (06/25/2010)
Never tried this and now I have to leave to a very important meeting. My fiance would kill me if I didn't attend this one.
Fiance? Meeting? Do I smell wedding soon???? 
I am basically using a regular form property as below, but wanted to know if there was a trick available when using SF controls instead.
Private Property AutoGenerateLotNumberQty As Integer
Get
Return Me.txtAutoGenerateLotNumberQty.Value
End Get
Set(ByVal value As Integer)
Me.txtAutoGenerateLotNumberQty.Value = value
End Set
End Property
|
By Charles R Hankey - 6/25/2010
Deja vu all over again
http://forum.strataframe.net/FindPost25190.aspx
Not sure if this is the answer but you and I were asking this question a while ago.
|
By Edhy Rijo - 6/25/2010
Charles R Hankey (06/25/2010)
Deja vu all over again
Thanks Charles,
Well, sort of. Using basic properties with Get/Set does the trick in this case, but thanks for the reminder since I may have to implement something like what is described in that thread to fill up PDF form.
BTW, what tool are you using to fill up the PDF file?
|
By Charles R Hankey - 6/25/2010
I realized after I send the link that the only part that was really relevant to your question was where Trent said single form properties could be handled easily with the control binding.
For PDF forms I'm using iTextsharper and it really is nice. I use it for filling out forms, putting on stamps, watermarks etc and for joining multple pdfs into one document. I plan to use PDF forms a lot now that I can handle them programmatically.
I've pretty well decided to go with DevExpress XtraReports over Sharpshooter. The interface is really nicely integrated into VS IDE and the creation of new reports very fast and just feels natural. I used RSS but just never warmed up to the logic of the whole thing. Did you ever find time to test it?
|
By Edhy Rijo - 6/25/2010
Charles R Hankey (06/25/2010)
For PDF forms I'm using iTextsharper and it really is nice. I use it for filling out forms, putting on stamps, watermarks etc and for joining multple pdfs into one document. I plan to use PDF forms a lot now that I can handle them programmatically.
A while back in VFP I used the PDFToolkit which was pretty nice to work with. To fill the form, I used to have a table with a field for each field in the PDF file, of course, first I had setup the PDF form with all needed fields names. In my case I only worked with a single form with several pages, but thinking ahead now, I may need to fill several forms and that approach was not that easy with that many fields in the table. What approach are you using to fill the PDF form?
I've pretty well decided to go with DevExpress XtraReports over Sharpshooter. The interface is really nicely integrated into VS IDE and the creation of new reports very fast and just feels natural. I used RSS but just never warmed up to the logic of the whole thing. Did you ever find time to test it?
Nope, but it is in the list of things to review, for now I did not renew my RSS subscription, they promised that many things will change specially the designer, but it is taking too long, so far they had made changes to the documentation. Don't get me wrong RSS is very, very powerful, just not that user friendly. I have been able to create some reports which would have been very difficult to do with the VFP report engine
|
By Charles R Hankey - 6/25/2010
I let me RSS subscription lapse as well. Xtrareports - even if you buy it separately from their big bundle of everything with source and priority support for $1300 is $350 and includes client side report designer and works with WPF, Silverlight, ASP and Winforms as far as I can tell . It really looks like the report tool VS should have had built in.
|
By Russell Scott Brown - 6/25/2010
That is interesting that you like XtraReports. I have been trying to decide between Telerik and DevExpress but I think I will go with DevExpress too if for no other reasons than you gave I know I can find at least one other person on the forum who uses it.
Thanks
|
By Edhy Rijo - 6/25/2010
Hi Charles,
Any comment on the PDF stuff Above?
|
By Ivan George Borges - 6/25/2010
Fiance? Meeting? Do I smell wedding soon???? Yep, you got it. 
|
By Edhy Rijo - 6/26/2010
Well, welcome to the club 
Congratulations in advance wishing you and wife to be the best!!!!
|
By Bill Cunnien - 6/26/2010
Russell Scott Brown (06/25/2010)
...I have been trying to decide between Telerik and DevExpress but I think I will go with DevExpress too if for no other reasons than you gave I know I can find at least one other person on the forum who uses it...
I've been using DevEx XtraReports for several years...even before SF. It has been quite enjoyable to use.
Bill
|
By Charles R Hankey - 6/26/2010
Hi Bill -
What strategy are you using for the data? It seems at first glance that using the BBS approach and creating the properties for child tables etc is not really necessary. I am tempted to use standard datasets, filled from parameterized SQL views and just by-passing SF for reporting data needs. If I go that route am I going to be missing something I'll wish I had?
Second question : do you have the whole dxExperience subscription or a separate XtraReports suite? Does this include WPF and Silverlight?
It looks like no further license is needed to give the end-user report design functionality. Is this the case?
( see what you started - I'm sure I'm going to have a lot of questions going forward. )
TIA
Charles
|
By Ger Cannoll - 6/26/2010
Hi Charles. I have been trying to decide which Report Writer to go for and have narrowed it down to either Activereports or Xtrareports.I was tending towards Activereports as , without additional licenses or expense, you can include a run time report designer for the end user. You seem to be suggesting that that can also be done with Xtrarports....did I pick this up correctly. Also , would be interested if anybody has seen any feature by feature comaprison of the two. ActiveReports seems to be more expensive .
|
By Ivan George Borges - 6/27/2010
Edhy Rijo (06/26/2010)
Well, welcome to the club Congratulations in advance wishing you and wife to be the best!!!! Thanks a lot Edhy! 
|
By Peter Jones - 6/27/2010
Congratulations Ivan.Regarding reporting, we have been using DevExpress Controls for about as long as we have been using Strataframe, but were using Crystal Reports (the version that came with visual studio) for our reporting, mainly due to previous experience with it. We had intended to examine xtraReports when we had a bit of time. Recently we upgraded to Visual Studio 2010, only to find that Crystal reports is only available as a seperate download currently in beta and without a client distributable. Furthermore in the Terminal Services environment we are targeting it is no longer free. This led us to quickly convert to XrtaReports, and have been very happy with the results. There is nothing we have found that Crystal Reports could do that XrtaReports can't. Where we were stuck on how to achive what we wanted, the support from Devexpress was excellent. We found that the best way to handle things was to create a bo mapped to a view. We use the same view to create a dataset for the XtraReports designer, then we use the following to get the data from the bo into the report Private Sub AssignBOToReport(ByRef myReport As DevExpress.XtraReports.UI.XtraReport, ByRef bo As MicroFour.StrataFrame.Business.BusinessLayer)If bo.CurrentDataTable.Rows.Count >= 1 ThenDim ds As New DataSetds.Tables.Add(bo.CurrentDataTable) myReport.DataSource = ds myReport.DataMember = bo.CurrentDataTable.TableName ElsemyReport.DataSource = NothingmyReport.DataMember = ""End IfEnd Sub The key point here is that xtraReports is very fussy in that if a report is designed from a dataset, then that is what it expect to get its data from. Cheers, Peter
|
By Ivan George Borges - 6/27/2010
Thanks Peter!
|
By Terry Bottorff - 6/28/2010
Peter, what do you use to design your report? What I mean is how are you able to drag and drop fields on your report?I've not used XtraReport but I am thinking about switching. TIA.
|
By Edhy Rijo - 6/28/2010
Hi Terry,
I have not test it yet, but I looked at some of their online videos, and they look very impressive and the quality of the videos are the best I have seen for an online video.
http://www.devexpress.com/Products/NET/Reporting/QuickStart.xml
|
By Terry Bottorff - 6/28/2010
I'll go view those and see if they answer my question. Thanks.
|
By Charles R Hankey - 6/28/2010
Hi Peter -
This answers a lot of my questions. I like the idea of using a dataset and creating the tables from SF BOs. Are you setting your relationships for child table in the dataset itself and if so do you need to turn off any parent/child metadata in the BOs so they don't interfere?
In any case, I am convinced now that Xtrareports is the direction I'm going in in the future. I finally decided the RSS interface was more counter-intuitive than I have time for 
|
By Terry Bottorff - 6/28/2010
I agree. I just don't like their interface either.
|
By Peter Jones - 6/28/2010
Hi Guys,
"What I mean is how are you able to drag and drop fields on your report?"
Yep. You end up with a tool bar item called XtraReports and in there is a field from which you drag and drop. BTW - this field list can extended via creating calculated fields within XtraReports. I've had no need (yet) to create custom fields in the BO.
"Are you setting your relationships for child table in the dataset itself"
Yes. The proc contains all the data that the report needs
"and if so do you need to turn off any parent/child metadata in the BOs so they don't interfere?"
Charles, I'm not sure what you mean by this. Perhaps you are referring to the DDT which we don't use.
The one thing that I really like about XtraReports is that all custom code (e.g. special sub totals, special formatting) can be written in VB.Net (our language) or C#. Very easy to leaverage those skills for reporting whereas in Crystal Reports we had to use a rather clunky scripting language. Plus form controls (such as Charts) can simply be dropped on a report.
On the down side because we use VB.Net we can't ship report updates by loading a contol file, i.e. in Crystal Reports we could change a report and simple copy the .rpt file to a customer. Now we have compile our reporting project and copy the entire exe to the customer. We thought this would be a real pain but it has proven to be a problem. If we had gone down the XtraReports scripting path, rather than VB.Net for custom code, then we could have copied a designer file in the same manner as we did with Crystal Reports.
And finally - we all know that the support from the SF guys is great - they always seem to go the extra mile. Well - DevExpress support is also excellent.
Cheers, Peter
|
By Charles R Hankey - 6/28/2010
Thanks Peter
Just to clarify my question about related tables :
In the SF example and in using RSS, we would create a business object with a BBS, and have a child table's BO as a custom property of the parent.
I seems to me that using XtraReports, I would want to creae datasets that defined the relationship between tables and then simply fill the tables - either directly from sprocs on the back end or using the datatable of a BO.
My thought was defining parent/child relationships between BOs, as we would when we normally use BOs, might get in the way when the BO was used simply as a data source for a data table in a dataset that itself defined a relationship..
Have you found any reason to use SF BOs in the reporting module or do you just pull data from the backend into your datasets?
|
By Terry Bottorff - 6/28/2010
Peter, if I have a View in my database that selects the records from two tables exactly like I want them to print. What would be the steps I would use to print them using XtraReport? I'm just looking for an outline of the steps used to create the report and say put a button on a form to print the data. I use Visual Basic.
If this requires a huge reply then just tell me so and I will understand that this is too lengthy to attack all at once.
TIA.
|
By Peter Jones - 6/28/2010
Hi Guys,
"I would want to creae datasets that defined the relationship between tables and then simply fill the tables - either directly from sprocs on the back end or using the datatable of a BO."
The "defined relationships" are simply as choose the do so in the view. For instance the following view is used for a report:
CREATE View vw_Rpt0002HPCProdSummary
AS
SELECT tblSTAStations.STAStnType, tblBTCBatch.BTCBatch,
tblCMPCompany_1.CMPRegName + '/' + tblCMPCompany_2.CMPRegName AS AbattoirSupplier, tblSZGSizeGroup.SZGSequ, tblHGRHideGrades.HGRSequ,
tblSZRSizeRanges.SZRSize, 1 AS HideCount, tblHPCHidePiece.HPCDateTime, tblHPCHidePiece.HPCHidePart, tblHPCHidePiece.HPCWght,
tblHPCHidePiece.HPCWghtSize, tblHPCHidePiece.HPCArea, tblHPCHidePiece.HPCAreaSize, tblHPCHidePiece.HPCSubst, tblHPCHidePiece.HPCSubstSize,
tblSTAStations.STAName + '/' + tblSTRStationTerm.STRName AS Station, tblSTAStations.STAID, tblSTRStationTerm.STRID, tblHGRHideGrades.HGRName,
tblBTCBatch.BTCType, tblHPCHidePiece.HPC_CMPIDOperator, tblHPCHidePiece.HPC_CMPIDAbattoir, tblHPCHidePiece.HPC_CMPIDSupplier,
tblHPCHidePiece.HPC_CMPIDGrower, tblHPCHidePiece.HPC_CMPIDTannery, tblCMPCompany.CMPRegName AS OperatorName,
tblCMPCompany_1.CMPRegName AS AbattoirName, tblCMPCompany_2.CMPRegName AS SupplierName, tblCMPCompany_3.CMPRegName AS GrowerName,
tblCMPCompany_4.CMPRegName AS TanneryName, tblSZGSizeGroup.SZGName, tblSZRSizeRanges.SZRRangeDesc, tblINIInvItems.INIID,
tblINIInvItems.INISequ, tblINIInvItems.INIProdCode + '/' + tblINIInvItems.ININame AS INIDescription, tblHPCHidePiece.HPCID AS PKID, 0 AS CtrlShowSuppliers,
0 AS CtrlShowBatches, 0 AS CtrlShowStations, tblINIInvItems.INI_SPCID, tblSZRSizeRanges.SZRMax, dbo.GetEnumNameSizeTypes(tblSTAStations.STAStnType) As StationTypeName
FROM tblHPCHidePiece INNER JOIN
tblHGRHideGrades ON tblHPCHidePiece.HPC_HGRID = tblHGRHideGrades.HGRID INNER JOIN
tblSZRSizeRanges ON tblHPCHidePiece.HPC_SZRIDWght = tblSZRSizeRanges.SZRID INNER JOIN
tblSZGSizeGroup ON tblSZRSizeRanges.SZR_SZGID = tblSZGSizeGroup.SZGID INNER JOIN
tblSTRStationTerm ON tblHPCHidePiece.HPC_STRID = tblSTRStationTerm.STRID INNER JOIN
tblSTAStations ON tblSTRStationTerm.STR_STAID = tblSTAStations.STAID INNER JOIN
tblCMPCompany ON tblHPCHidePiece.HPC_CMPIDOperator = tblCMPCompany.CMPID INNER JOIN
tblCMPCompany AS tblCMPCompany_1 ON tblHPCHidePiece.HPC_CMPIDAbattoir = tblCMPCompany_1.CMPID INNER JOIN
tblCMPCompany AS tblCMPCompany_2 ON tblHPCHidePiece.HPC_CMPIDSupplier = tblCMPCompany_2.CMPID INNER JOIN
tblCMPCompany AS tblCMPCompany_3 ON tblHPCHidePiece.HPC_CMPIDGrower = tblCMPCompany_3.CMPID INNER JOIN
tblCMPCompany AS tblCMPCompany_4 ON tblHPCHidePiece.HPC_CMPIDTannery = tblCMPCompany_4.CMPID INNER JOIN
tblBTCBatch ON tblHPCHidePiece.HPC_BTCID = tblBTCBatch.BTCID INNER JOIN
tblPUNPackingUnit ON tblHPCHidePiece.HPC_PUNID = tblPUNPackingUnit.PUNID INNER JOIN
tblINIInvItems ON tblPUNPackingUnit.PUN_INIID = tblINIInvItems.INIID
It has lots of relationships. The actual stored procedure that the report executes to gather the data is a lot more complex but presents the same data as the view:
CREATE Procedure [dbo].[stp_Rpt0002HPCProdSummary]
@CMPIDTannery As Uniqueidentifier = Null,
@CMPIDOperator As Uniqueidentifier = Null,
@CMPIDAbattoir As Uniqueidentifier= Null,
@CMPIDSupplier As Uniqueidentifier = Null,
@CMPIDGrower As Uniqueidentifier = Null,
@SPCID As Uniqueidentifier = Null,
@STRID As Uniqueidentifier = Null,
@STRType As Integer = Null,
@INIID As Uniqueidentifier = Null,
@HGRID As Uniqueidentifier = Null,
@AbLotNo As nvarChar(500) = Null,
@Batches As nvarChar(500) = Null,
@Contract As nvarChar(500) = Null,
@ToDate As DateTime,
@FromDate As DateTime,
@FromKillDate As DateTime = Null,
@ToKillDate As DateTime = Null,
@CtrlShowSuppliers As Integer = 1,
@CtrlShowBatches As Integer = 1,
@CtrlShowStations As Integer = 1
AS
Declare @StartOfBatchTO As Integer
Declare @FirstBatch As nvarChar(500)
Declare @LastBatch As nvarChar(500)
Declare @LengthOfBatch As Integer
Declare @BatchSelectType As Integer
Declare @StartOfAbLotNoTO As Integer
Declare @FirstAbLotNo As nvarChar(500)
Declare @LastAbLotNo As nvarChar(500)
Declare @LengthOfAbLotNo As Integer
Declare @AbLotNoType As Integer
Declare @myCtrlShowSuppliers As Integer
Declare @myCtrlShowBatches As Integer
Declare @myCtrlShowStations As Integer
-- Make sure the hide/unhide controls are sensible
Set @myCtrlShowSuppliers = @CtrlShowSuppliers
Set @myCtrlShowBatches = @CtrlShowBatches
Set @myCtrlShowStations = @CtrlShowStations
-- Configure selection criteria for those controls that can multiple, comma delimitered, entries
Set @BatchSelectType = 0
Set @AbLotNoType = 0
If @Batches Is Not NULL
Begin
Set @BatchSelectType = 1
Set @LengthOfBatch = Len(@Batches)
Set @StartOfBatchTO = CHARINDEX(' TO ',@Batches)
-- Found TO so lets extract the From/To values
IF @StartOfBatchTO > 0
Begin
Set @BatchSelectType = 2
Set @FirstBatch = Left(@Batches, (@StartOfBatchTO - 1))
Set @LastBatch = Right(@Batches, (@LengthOfBatch - @StartOfBatchTO) - 3)
End
End
If @AbLotNo Is Not NULL
Begin
Set @AbLotNoType = 1
Set @LengthOfAbLotNo = Len(@AbLotNo)
Set @StartOfAbLotNoTO = CHARINDEX(' TO ',@AbLotNo)
-- Found TO so lets extract the From/To values
IF @StartOfAbLotNoTO > 0
Begin
Set @AbLotNoType = 2
Set @FirstAbLotNo = Left(@AbLotNo, (@StartOfAbLotNoTO - 1))
Set @LastAbLotNo = Right(@AbLotNo, (@LengthOfAbLotNo - @StartOfAbLotNoTO) - 3)
End
End
-- Read Committed assumes the database is has READ_COMMITTED_SNAPSHOT set to ON.
Set Transaction Isolation Level Read Committed
Begin Tran
--SELECT TOP (100) PERCENT tblSTAStations.STAStnType, tblBTCBatch.BTCBatch,
SELECT TOP (100) PERCENT tblSTAStations.STAStnType,
CASE @myCtrlShowBatches
WHEN 1 THEN tblBTCBatch.BTCBatch
WHEN 0 THEN '**'
END AS BTCBatch,
tblCMPCompany_1.CMPRegName + '/' + tblCMPCompany_2.CMPRegName AS AbattoirSupplier, tblSZGSizeGroup.SZGSequ, tblHGRHideGrades.HGRSequ,
tblSZRSizeRanges.SZRSize, 1 AS HideCount, tblHPCHidePiece.HPCDateTime, tblHPCHidePiece.HPCHidePart, tblHPCHidePiece.HPCWght,
tblHPCHidePiece.HPCWghtSize, tblHPCHidePiece.HPCArea, tblHPCHidePiece.HPCAreaSize, tblHPCHidePiece.HPCSubst, tblHPCHidePiece.HPCSubstSize,
Case @CtrlShowStations
WHEN 1 Then tblSTAStations.STAName + '/' + tblSTRStationTerm.STRName
WHEN 0 Then '**'
END AS Station,
tblSTAStations.STAID, tblSTRStationTerm.STRID, tblHGRHideGrades.HGRName,
tblBTCBatch.BTCType, tblHPCHidePiece.HPC_CMPIDOperator, tblHPCHidePiece.HPC_CMPIDAbattoir, tblHPCHidePiece.HPC_CMPIDSupplier,
tblHPCHidePiece.HPC_CMPIDGrower, tblHPCHidePiece.HPC_CMPIDTannery, tblCMPCompany.CMPRegName AS OperatorName,
tblCMPCompany_1.CMPRegName AS AbattoirName, tblCMPCompany_2.CMPRegName AS SupplierName, tblCMPCompany_3.CMPRegName AS GrowerName,
tblCMPCompany_4.CMPRegName AS TanneryName, tblSZGSizeGroup.SZGName, tblSZRSizeRanges.SZRRangeDesc, tblINIInvItems.INIID,
tblINIInvItems.INISequ, tblINIInvItems.INIProdCode + '/' + tblINIInvItems.ININame AS INIDescription, tblHPCHidePiece.HPCID AS PKID,
@myCtrlShowSuppliers As CtrlShowSuppliers, @myCtrlShowBatches As CtrlShowBatches, @myCtrlShowStations As CtrlShowStations,
tblINIInvItems.INI_SPCID, tblSZRSizeRanges.SZRMax, dbo.GetEnumNameStationTypes(tblSTAStations.STAStnType) As StationTypeName
FROM tblHPCHidePiece INNER JOIN
tblHGRHideGrades ON tblHPCHidePiece.HPC_HGRID = tblHGRHideGrades.HGRID INNER JOIN
tblSZRSizeRanges ON tblHPCHidePiece.HPC_SZRIDWght = tblSZRSizeRanges.SZRID INNER JOIN
tblSZGSizeGroup ON tblSZRSizeRanges.SZR_SZGID = tblSZGSizeGroup.SZGID INNER JOIN
tblSTRStationTerm ON tblHPCHidePiece.HPC_STRID = tblSTRStationTerm.STRID INNER JOIN
tblSTAStations ON tblSTRStationTerm.STR_STAID = tblSTAStations.STAID INNER JOIN
tblCMPCompany ON tblHPCHidePiece.HPC_CMPIDOperator = tblCMPCompany.CMPID INNER JOIN
tblCMPCompany AS tblCMPCompany_1 ON tblHPCHidePiece.HPC_CMPIDAbattoir = tblCMPCompany_1.CMPID INNER JOIN
tblCMPCompany AS tblCMPCompany_2 ON tblHPCHidePiece.HPC_CMPIDSupplier = tblCMPCompany_2.CMPID INNER JOIN
tblCMPCompany AS tblCMPCompany_3 ON tblHPCHidePiece.HPC_CMPIDGrower = tblCMPCompany_3.CMPID INNER JOIN
tblCMPCompany AS tblCMPCompany_4 ON tblHPCHidePiece.HPC_CMPIDTannery = tblCMPCompany_4.CMPID INNER JOIN
tblBTCBatch ON tblHPCHidePiece.HPC_BTCID = tblBTCBatch.BTCID INNER JOIN
tblPUNPackingUnit ON tblHPCHidePiece.HPC_PUNID = tblPUNPackingUnit.PUNID INNER JOIN
tblINIInvItems ON tblPUNPackingUnit.PUN_INIID = tblINIInvItems.INIID
-- NOTE - it may well be wrong to exclude Regrade Ins (ERPProdType 4)
WHERE tblHPCHidePiece.HPCDateTime BETWEEN @FromDate AND @ToDate
AND
tblHPCHidePiece.HPCERPProdType <> 3
AND
tblHPCHidePiece.HPCERPProdType <> 4
AND
tblHPCHidePiece.HPCERPProdType <= 6
AND
((@CMPIDTannery Is Null) OR (tblHPCHidePiece.HPC_CMPIDTannery = @CMPIDTannery))
AND
((@CMPIDOperator Is Null) OR (tblHPCHidePiece.HPC_CMPIDOperator = @CMPIDOperator))
AND
((@CMPIDAbattoir Is Null) OR (tblHPCHidePiece.HPC_CMPIDAbattoir = @CMPIDAbattoir))
AND
((@CMPIDSupplier Is Null) OR (tblHPCHidePiece.HPC_CMPIDSupplier = @CMPIDSupplier))
AND
((@CMPIDGrower Is Null) OR (tblHPCHidePiece.HPC_CMPIDGrower = @CMPIDGrower))
AND
((@HGRID Is Null) OR (tblHPCHidePiece.HPC_HGRID = @HGRID))
AND
((@STRID Is Null) OR (tblHPCHidePiece.HPC_STRID = @STRID))
AND
((@FromKillDate Is Null Or @ToKillDate Is Null) OR (tblHPCHidePiece.HPCAbKillDate Between @FromKillDate AND @ToKillDate))
AND
((@SPCID Is Null) OR (tblINIInvItems.INI_SPCID = @SPCID))
AND
((@INIID Is Null) OR (tblINIInvItems.INIID = @INIID))
AND
((@STRType Is Null) OR (tblSTAStations.STAStnType = @STRType))
AND
((@BatchSelectType = 0)
OR
(@BatchSelectType = 1 AND CHARINDEX(tblBTCBatch.BTCBatch + ',',@Batches) > 0)
OR
(@BatchSelectType = 2 AND tblBTCBatch.BTCBatch Between @FirstBatch And @LastBatch))
AND
((@Contract Is Null) OR (tblBTCBatch.BTCContract = @Contract))
AND
((@AbLotNoType = 0)
OR
(@AbLotNoType = 1 AND CHARINDEX(tblHPCHidePiece.HPCAbLotNo + ',',@AbLotNo) > 0)
OR
(@AbLotNoType = 2 AND tblHPCHidePiece.HPCAbLotNo Between @FirstAbLotNo And @LastAbLotNo))
Option (Recompile)
Commit Tran
Keep in mind the view is only there so we can generate a BO. In terms of defining a XtraReport it isn't needed because in its designer it is using a standard Visual Studio Data Source which can be created via many means including a stored procedure. We use a SF BO because we can use our existing DAL code to populate it, i.e. from our perspective 'no extra coding'.
"might get in the way when the BO was used simply as a data source"
Agreed.
"Have you found any reason to use SF BOs in the reporting module "
Yes. Please see above - we can leverage our existing DAL code that is why we use SF BO's.
"I want them to print. What would be the steps I would use to print them using XtraReport?"
1) Create a Data Source that uses the view.
2) Assign the Data Source to your report. DexExpress has something it calls (hmm, I forget what its called!). Anyway its a small > symbol in a box - it opens up special facilities for the control (report, form, tab, etc..). For a report one of the things it exposes is the data source for the report. Just click on the Data Source pull down list and you can see all your data souces - simply select the one you want.
3) Under XtraReport on the toolbar you will find Group and Sort. Here you enter the what groupings you want and any special sorting. As you select groups they are automatically created in the body of the report. Each group must have a header but a footer is optional. Note: all sorting must be carried out within the report itself. You cannot rely on data being processed in the correct order just because it was sorted correctly in the stored procedure. This cause me a bit of grief for a time...
4) Drop the fields you want into the group and detail section. For instance assume your view contains Order and Line Items. Just drop the Order fields into the group header and the Line Item details into the report Details.
That's basically it.
"put a button on a form to print the data. I use Visual Basic"
Ah, we don't do this. We have a specific reporting module with its own menu however doing this is pretty straight forward. I know this from asking questions of DevExpress and they regularly include a sample project with their reply. Check out http://www.devexpress.com/Support/Center/default.aspx. You can download a fully functional version of DevXpress on a 60 day trial basis to check out these samples. This is from one of the samples they sent me:
Button on a form to open a report. XtraReport1 is XtraReport in the project.
Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
Dim r As New XtraReport1
r.ShowPreviewDialog()
End Sub
The code in the report was as follows. It explained how I could custom sort pivot grid columns in the report. I only show this just to demonstrate everything in the report is VB.Net.
Public Class XtraReport1
Private Sub XrPivotGrid3_CustomFieldSort(ByVal sender As System.Object, ByVal e As DevExpress.XtraPivotGrid.PivotGridCustomFieldSortEventArgs) Handles XrPivotGrid3.CustomFieldSort
Dim val1 As String = DataSet11.Tables(0).Rows(e.ListSourceRowIndex1)("ColA").ToString()
Dim val2 As String = DataSet11.Tables(0).Rows(e.ListSourceRowIndex2)("ColA").ToString()
Dim result As Integer = String.Compare(val1, val2)
If (result > 0) Then
e.Result = 1
ElseIf (result < 0) Then
e.Result = -1
Else
e.Result = 0
End If
e.Handled = True
'e.ListSourceRowIndex1
End Sub
Private Sub XtraReport1_BeforePrint(ByVal sender As System.Object, ByVal e As System.Drawing.Printing.PrintEventArgs) Handles MyBase.BeforePrint
DataSet11.Tables(0).Rows.Add(New Object() {"A", "Z", 1})
DataSet11.Tables(0).Rows.Add(New Object() {"B", "Y", 1})
DataSet11.Tables(0).Rows.Add(New Object() {"C", "X", 1})
End Sub
End Class
Hope this helps.
Cheers, Peter
Cheers, Peter
|
By Terry Bottorff - 6/29/2010
Wow. Peter that is one Great Answer. Thank you. It will take me some time to digest all of that but that will certainly get me started. Thanks again for all of the time you put into helping others.
|
By Charles R Hankey - 6/29/2010
Peter thanks so much.
I think I asked my question in-artfully ...
I meant in creating a parent-child report or parent-child-child-grandchild etc rather than the denormalization of a view. So for multiple companies, to show both their employees and their orders and the details of those orders :
Company ( detail band ) has two children - employees and orders
employees ( first child detail )
orders ( second child detail )
lineitems ( child detail of orders )
etc.
Do you use 4 BO s in this case to load your datasets? And assuming that there are parent child relationships defined in your BOs, does that get in the way or is it not a problem as long as the instance BOs do not have a parent BO set?
My assumption was in the case above, no matter how I got the tables in the dataset filled, the relationships in order to create a parent child report would be set in the dataset, no?
|
By Peter Jones - 6/29/2010
Hi Charles,
In that simple example I would have a single, denormalised, view:
Company Employee Order OrderLineItem
C1 E1 O1 OL1
C1 E1 O1 OL2
C1 E1 O1 OL3
C1 E1 O2 OL1
C1 E2 O3 OL1
C1 E2 O4 OL1
C1 E2 O4 OL2
C2 E1 O5 OL1
C2 E1 O5 OL2
The report group levels would be:
Company (GroupHeader1)
Employee (GroupHeader2)
Order (GroupHeader3)
Order Line Items (Detail Band)
Order (GroupFooter3)
Employee (GroupFooter2)
Company (GroupFooter1)
So, just a single BO based on a denormalised view
A more complex approach would to use SubReports, e.g. your Order may have a range of other attributes in addition to Order Line Items that you may want to show. In this case you may have:
Company (GroupHeader1)
Employee (GroupHeader2)
Order (GroupHeader3)
Order Line Items (Detail Band)
Order (GroupFooter3)
Order Sub Report1
Employee (GroupFooter2)
Company (GroupFooter1)
In this case Order Sub Report1 would have its own BO.
"I meant in creating a parent-child report or parent-child-child-grandchild etc rather than the denormalization of a view."
Denormalised view (see above)
"Do you use 4 BO s in this case to load your datasets?"
No. See above
"And assuming that there are parent child relationships defined in your BOs, does that get in the way or is it not a problem as long as the instance BOs do not have a parent BO set?"
No relationships. See above.
"My assumption was in the case above, no matter how I got the tables in the dataset filled, the relationships in order to create a parent child report would be set in the dataset, no?"
No. There is no need for any relationships to be defined. Just get the data into a flat file format and sort and group as needed within the report. For instance, you will see that Employee E1 took Orders for 2 different Companies therefore the same view could also be used to generate a report along the lines of:
Employee(GroupHeader1)
Company (GroupHeader2)
Order (GroupHeader3)
Order Line Items (Detail Band)
Order (GroupFooter3)
Company (GroupFooter2)
Employee (GroupFooter1)
All sorting and grouping is performed in the XtraReport.
I think the essential point is that Parent > Child > Grand Child relationships fall into place using the report Grouping hierarchy.
Cheers, Peter
|
By Ivan George Borges - 6/29/2010
Really awesome, Peter!
|
By Peter Jones - 6/29/2010
Oops, all the indentation was lost in the post. It should have looked something like this:
Company...Employee...Order...OrderLineItem
C1..E1..O1..OL1
C1..E1..O1..OL2
C1..E1..O1..OL3
C1..E1..O2..OL1
C1..E2..O3..OL1
C1..E2..O4..OL1
C1..E2..O4..OL2
C2..E1..O5..OL1
C2..E1..O5..OL2
Company (GroupHeader1)
..Employee (GroupHeader2)
....Order (GroupHeader3)
......Order Line Items (Detail Band)
....Order (GroupFooter3)
..Employee (GroupFooter2)
Company (GroupFooter1)
Company (GroupHeader1)
..Employee (GroupHeader2)
....Order (GroupHeader3)
......Order Line Items (Detail Band)
....Order (GroupFooter3)
....Order Sub Report1
..Employee (GroupFooter2)
Company (GroupFooter1)
|
By Peter Jones - 6/29/2010
Oops, all the indentation was lost in the post. It should have looked something like this:
Company...Employee...Order...OrderLineItem
C1..E1..O1..OL1
C1..E1..O1..OL2
C1..E1..O1..OL3
C1..E1..O2..OL1
C1..E2..O3..OL1
C1..E2..O4..OL1
C1..E2..O4..OL2
C2..E1..O5..OL1
C2..E1..O5..OL2
Company (GroupHeader1)
..Employee (GroupHeader2)
....Order (GroupHeader3)
......Order Line Items (Detail Band)
....Order (GroupFooter3)
..Employee (GroupFooter2)
Company (GroupFooter1)
Company (GroupHeader1)
..Employee (GroupHeader2)
....Order (GroupHeader3)
......Order Line Items (Detail Band)
....Order (GroupFooter3)
....Order Sub Report1
..Employee (GroupFooter2)
Company (GroupFooter1)
|
By Charles R Hankey - 12/13/2010
I've been working a bit more with Xtrareports now, so i wanted to share some observations and this thread seems a good place to tack it on, as Peter was so helpful.
First, there is a 42 minute video of a DevExpress Webinar ( god I love that company ) that was very helpful for me getting two very basic things worked out : having preview data available at design time when the datasource is a parameterized sproc and how to hook up the params through the interface. tv.devexpress.com/#XtraReportsWebinar1Key concept is to drop a sqldataadapter on the Xtrareport design surface and use that to generate the dataset ( in my case off a sproc ) The sda lets you set default values for params which will be used at design time in preview mode. A sqltableadapter won't. (sqldataadapter is not in the toolbox by default so you have to right-click the data tab, pick Choose Items and add it ) The video explaiins everything else very clearly. ( the part I messed with a bit was trying to drag and drop fields from the datasource treeview onto the report - I needed to find the Fieldlist on the Xtrareports menu and D and D from there. That is also where you create calculated fields) One other comment re Peter's post - there is a third alternative to denormalized tables and subreports - detail bands. As Peter is a long-time xtrareports user he probably started designing before DevExpress added child detail bands to the product. They are now recommended over sub reports when the goal is just to have multiple child bands. Old Foxpro developers will particularly appreciate how easy all this is, especially since we didn't get multiple detail bands out of the box until late ( too late ) in vfp 9 Anyway, my experience of DevExpress so far has been extremely positive and I love the XtraReports !!
|
By Edhy Rijo - 12/13/2010
Hi Charles,
Thanks for posting the link to the video, very interesting. I was wondering how to get the data to preview with SF BO, but guess is not possible for now. I kind of like the SP approach, even though that will require an stored procedure for each report, but is either that or no having preview available.
Using the method explained in the video, you also need to grab the connection string at runtime to avoid having to hard code it.
|
By Charles R Hankey - 12/13/2010
You can build a sql select statement into the sqldataadapter rather than point it to a sproc and you'll get the same result, I believe.
I am hosting the form that launches the report inside a SF app, so I think I can grab the connection from the application. The connection string at design time is a different matter.
I'll keep posting as I work through this, but I'll probably post in User Contrib Samples for easy access. I'm pretty convinced this is the way to go with SF apps. I don't see any plus side to using SF business objects for reporting but am willing to listen to arguments in their favor. Just don't see where the creating a propertyinside reporting bos for child stuff is near as fast as creating datasets from a sqldataadapter.
Makes sense for CRUD of course, but for just grabbing data for reporting seems overbloated.
|
By Terry Bottorff - 6/28/2011
Charles Hankey I noticed you were using iText for PDF's. Are you still using it? Do you program in C# or VB? If you use VB where did you find your examples or did you just convert the C# from their site? If you are still using it do you have forms where you fill fields from a database table?Thank you for your time and effort.
|
|