Search results for query: *

I have an issue with rounding that I need some assistance. Let's say a typical report has many groups populated by a stored procedure from a database. Each group has a its own summary field of a database field Something like this -GH1 Groupby TrackID --GH2 ----GH3 -----Detail database field...

Thanks for the reply I discovered the problem and now the formulas and summaries are updating as expected. Was looking at the results incorrectly that lead to the confusion. Still, it's interesting or frustrating why any of the Execution Time functions don't work in Select Functions. What if...

I have a report with a simple Record Selection Formula that I want to control via a Parameter {?HideDowns}. IF {?HideDowns} THEN if {uspSELECT;1.TrackID} <> "xxx" then TRUE else FALSE ELSE true; This Selection formula works fine where the report will filter out 'xxx' (depending on...

How do you add Row Numbers to a Group? I have a list of x number of rows on a report and want to number them 1,2,3... I don't want to do a Distinct Count Summary of a field which only gives me the total. I need to add a simple counter that increments itself for each record depending on how...

I need to run a stored procedure from an aspx page but because it takes a long time to complete, it times out at MyDataAdapter.Fill. This sp doesn't return any recordset but the number of records affected would be nice. Protected Sub BtnProcessDT_Click(ByVal sender As Object, ByVal e As...

I’m trying to create a Web site to view our Crystal Reports but am coming up some issues during development. I discovered online that Release 2, not Release 1 is compatible with VS 2005 When I attempt to download Crystal Reports XI Release 2 via the Business Objects search results, I’m...

So in other words, there is no way to dynamically display any database connections on the report. Sometime the reports would get their data from a development db while other times live. Hard coding wouldn't be practical.

Is it possible to display any database information on the report? All I really need is to display on the report what's found under Database/Show SQL Query but virtually anything in Database Expert would be ok. Are there functions that make this possible? I'm using Crystal Reports XI 11.0.0.895...

OF COURSE! So what's needed is a function and/or sproc to do this little multiplication on each decimal field. SQLXML takes care of the actual import so the only recourse is to UPDATE the decimal fields after the fact. The saving grace is SQLXML imports into temporary tables before an UPDATE...

I'm importing data from an XML file into SQL Express using SQLXML 4.0 through a vb.net app. The numbers in the xml's are whole numbers, meaning no decimal places or points exist. However, the numbers do represent a number with 2 decimal places. So 59455 is actually 594.55 15500 is 155.00 I've...

I'm using SQLXML 3.0 with VB.net to upload xml files to SQL Express. One XML uploads to multiple SQL tables. One table has a trigger to update fields in one of the other tables. Unfortunately, the trigger won't fire. The trigger will fire with a simple T-SQL INSERT script but won't using...

How do you display a Console Window prorgramatically? I'm in Visual Basic 2005 Setting Application Type: to Console Application causes the console window to appear first when the program starts. I'd like the Console to appear after the Main form appears and to make it invisible through a...

This was pulled from the SQLXML 3.0 help. I'm using VS2005, SQLExpress and SQLXML 3.0 <ROOT> <Order OrderID="11" CustomerID="ALFKI"> <Product ProductID="11" ProductName="Chai" /> <Product ProductID="22" ProductName="Chang" /> </Order> <Order OrderID="22" CustomerID="ANATR">...

Thanks for the input. I too came to the same conclusion to separate the XML data into multiple tables depending on the number of Elements. You went a step further and put in a relationship between the two tables My plan is to dump the XML data into temporary tables and use a stored procedure...

If I edit the schema file to include the attribute name="Run" under the "Activity" element, TA_id remains empty. In the xml, the "Run" attribute is under the 'Header' element, not 'Activity'. <?xml version="1.0" encoding="utf-8"?> <xsd:schema xmlns:xsd="http://www.w3.org/2001/XMLSchema"...

I'm importing XML files into a SQLExpress DB using SQLXML and VB.net 2005. I have a simple *.xsd schema file that is pulling in all attributes from the <Activity> element. Schema file... <?xml version="1.0" encoding="utf-8"?> <xsd:schema xmlns:xsd="http://www.w3.org/2001/XMLSchema"...

I'm importing xml files into a database using SQLXML through C# into SQLExpress I have the data going in ok but the tables have Date fields I'd like to add with each record. This field is set to NOT NULL. Obviously, with this field set to NOT NULL, the import process fails because there is no...

We have a project in the works that involves a daily download of .xml files for our accounting program. These xml's are to be imported into a SQL database where all the necessary calculations and reports are to be generated. Once imported, the XML's are to be archived. There is no question...

Thanks for the reply. We're going ahead with SQLExpress and will work fine for our needs. If we bump up the 4GB limit, which won't happen for a while if at all, then we'll have to upgrade

We're in the process of adding another server for an upcoming programming project. We're anticipating SQLExpress on this box. We have SQL Server on another box for our accounting program The primary reason for going to SQLExpress is cost Yet I'm concerned if SQLExpress will perform as well as...