Recent content by Jimdeb03

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"...