You searched for the word(s): userid:742080

More Search Options

RSS Available

• Re: SQL Annotation in XSD Schemas: non-relational XML to SQL Server

  Thanks for the reply, Samu! That's an interesting approach and I'm bookmarking this for future reference. =) Unfortunately, I got fed up before I got a reply and changed my approach. Rather than utilize the technique that I outlined in the OP, I decided instead to use OpenXML as outlined in this article: http://www.perfectxml.com/articles/xml/importxmlsql.asp My original approach is also outlined there. Basically, I just forced the XML flat rather than inserting it relationally and this seems

  Posted to XML and XmlDataSource Control (Forum) by pontupo on 11/12/2007

• SQL Annotation in XSD Schemas: non-relational XML to SQL Server

  So here's the deal, I have an XML data set that needs to be imported into SQL Server. I can't modify the form of the XML and unfortunately any relational information in the XML is contained in its structure rather than in foreign keys. Here's the XSD schema that I've written for the data: < xs:schema targetNamespace= "ns:usage-data-schema" elementFormDefault= "qualified" xmlns= "http://www.w3.org/2001/XMLSchema" xmlns:xs= "http://www.w3.org/2001

  Posted to XML and XmlDataSource Control (Forum) by pontupo on 11/7/2007

• Re: Crystal report error - Load report failed.

  Hmm, and you're sure that you installed the appropriate merge modules for your installation from here: http://support.businessobjects.com/downloads/merge_modules.asp onto the distribution box using a valid serial number? Just to be clear also, the error you're receiving is one that indicates that the file wasn't found or was it that the file was found but couldn't be loaded?

  Posted to Crystal Reports (Forum) by pontupo on 10/5/2007

• Re: Crystal report error - Load report failed.

  The issues are the same in VS 2005. Read the white paper (or the most recent version of it) that is linked a couple of posts up. In short: on your dev box, you have VS2005 installed as well as the .NET framework and the necessary Crystal Reports run-time libraries. You need to install the CR merge-modules on your distribution machine so that it will work there, assuming your issue is similar to the OP. Pont

  Posted to Crystal Reports (Forum) by pontupo on 10/5/2007

• Re: Accessing Dynamic Parameters in VB.NET

  That was my plan of attack, whoopes. I think that's the only way to do it properly. The only reason that I don't like this is that half the reason I created the Crystal Reportal (as I've taken to calling it) was to allow my power users to create their own Crystal Reports that could just be dropped into the portal and have them show up right away. This restriction in the flow of information (basically that the CrystalReportViewer won't pull dynamic parameter data at run time and allow

  Posted to Crystal Reports (Forum) by pontupo on 10/5/2007

• Re: Send a Crystal Report as an email attachment

  Simple answer: no, which is really irritating. Long answer: Yes, you can, but it will require some finagling. I've done it two ways: 1) Export to HTML, then parse the resulting HTML file into a String object and then assign that String to the body of a System.Net.Mail email. There are other email libraries that you can use, but this is the one that I chose. 2) Once my colleagues saw that they could have email reports, they decided to ask for the next natural extension: emails that are readable

  Posted to Crystal Reports (Forum) by pontupo on 10/4/2007

• Re: Windows/Temp folder filling

  Still looking for some help on this, unfortunately. Nothing I do seems to release the object at the right time. Any suggestions?

  Posted to Crystal Reports (Forum) by pontupo on 10/3/2007

• Re: Passing a variable from a form to Crystal

  There are a couple of different ways that you could approach this problem, but I'll give you the simplest scenario and you can extend it if you need: 1) Create a Parameter Field in Crystal. For the sake of simplicity, let's just say that you want to search the LastName field of a table of people with a String provided by the user. So, create a String parameter field in Crystal and don't provide any default values. 2) Create a form in ASP and add a text field to that form and a Submit

  Posted to Crystal Reports (Forum) by pontupo on 10/3/2007

• Re: keep losing my reports

  I tell you.... implementing the distribution of Crystal Reports is a serious pain in the.... well, you know what. Those kind of problems never end and each new thing you want to do takes a couple of days to sort out. I will say though.... once you get it up and running, it sure is nice and people love it =)

  Posted to Crystal Reports (Forum) by pontupo on 10/3/2007

• Re: keep losing my reports

  I'm sure cross-posting is frowned upon, but here's a link to another thread where you should be able to sort out your images and javascript: http://forums.asp.net/p/1136363/1818372.aspx#1818372 There's a post in that thread where I link to some articles/threads that got me through the same trouble when I hit it. Glad you're making progress!! Pont

  Posted to Crystal Reports (Forum) by pontupo on 10/2/2007