validate and update report schema

Visual Basic

    Sponsored Links


  • 1. Returning data from subreports.
    We have a requirement to show physical stock and on order stock totals on the same line in a stock report. This involves two outer joins, one to the stock table and one to the purchase order table. Just putting all the data on the one report is then multiplying the stock value by the number of purchase orders and the purchase order value by the number of batches of stock.... My solution to this would be to paint the purchase order details as a sub-report, but I need to get the total level and value back out of that sub-report. Is there a method for doing this? Regards, Iain
  • 2. Array formaula question
    I have a simple formula to hide page headers: PageNumber=TotalPageCount-14 or PageNumber=TotalPageCount-13 . . . PageNumber=TotalPageCount-1 How can i write this in one line?? Basically an ARRAY saying TotalPageCount-[1-14] I cant seem to get the context correct Thx in advance for any help
  • 3. sending CR report via email in VB.NET
    I need to send certain CR reports to predefined group of users via email from a VB.NET app via either SMTP or Outlook client. Any help is greatly appreciated. Bill
  • 4. Looping thru field objects
    Hi all, I'm working with VB 6 (SP6) and CR 9. I need a VB algorithm to loop through all the field objects on the detail section of a report. I need to look only at database fields, not text or line objects. I then need to access the name of the Access database field the field object is bound to. (I'm using an Access 2002 DB). I tried a number of For.Each loops going through various collection but can' t seem to make it work. Can someone put me on the right path or point me to some readable documentation? The CR Developer's Help file isn't helping much. Thanks Jonathan

validate and update report schema

Postby Sally C » Fri, 04 Feb 2005 06:16:32 GMT

Yesterday I accidentally discovered that it is possible to set a report's
datasource to a DataSet with DataTable of the wrong schema. i.e. If the
DataTable's name is as expected, and if all the fields used in formula
fields are present, then no exception is thrown -- even if ordinary fields
that are used are not present in the DataTable. It seems that non-formula
fields are not "mandatory".

Once a report instance's data source is set (assuming no exception thrown),
I could then save the report as a file. When I open this new report file, it
shows the schema as the (wrong) one I've bound it to. The ordinary fields
that were present (but not part of the new schema) have disappeared, and
extra fields that were not used (but are part of the new schema) now appear.

Considering that stored procedures are used to fill the datasets, and they
may change. How do I get my reports to validate that the given DataSet's
schema and the expected schema match exactly when its datasource is set, so
that I would know when and which reports to update?

Thanks in advance.


Similar Threads:

1.Validate XML Fragments Against an XML Schema in VB

2.validating if a file is a true valid xml file that fits a certain schema

I need to make sure that a file saved in a particular place is a valid xml 
file that fits a certain schema. Where would I get started doing this? The 
original file would have been created and saved with a dataset.

3.Validating XML File Schema

I have a XML Schema, and a XML file.
How can I validate that the XML file implements the XML Schema meaning that
it is build correctly
Thanks ahead


4.XML serialization, Validating xml against schema

5.Word 2003 : Unable to validate schema node having data type "Integ

1. Map valid XML schema(XSD) containg nodes of Data type "Integer".
2. Load it into Word and place it on document
3. It will not validate the schme as it contain nodes having data type 
  but if u change the data type to "String". It validate the schema 

6. Validate table via form before update macro or vba

7. How to Manually update a Data Schema

8. Best practice on local database Schema update

Return to Visual Basic


Who is online

Users browsing this forum: No registered users and 35 guest