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

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

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

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

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

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

I have four summaries in the Report Footer that work fine. They're all Sums of various Report Fields. (WAGES_GROSS, WAGES_CONTR, WAGES_LOANP, WAGES_ARERS) However, if I add a condition in the Record Selection that tests one of the above mentioned Report Fields, (if WAGES_GROSS > 0), the other...

I have a little mystery. My Group Footer is divided into GF#1a and GF#1b. GF1a is suppressed. In GF1b, I have a simple formula... WhilePrintingRecords; Numbervar SumAccrual; Numbervar SumAccrual is populated in another formula that resides in GF2 When I run the report, this formula is empty...

I have a simple UPDATE statement against a table that unfortunately has an UPDATE trigger that forbids updating more than one 1 value at a time. When running the UPDATE, this error is returned... Server: Msg 512, Level 16, State 1, Procedure RSAS_TEST_UPR00400_UPDATE, Line 1 Subquery returned...

My report summarizes many records per EmployeeID. Certain fields are simply Summarized while others a calculation is performed via a Formula in the Group Footer. Details @SumHours_ALL Details @SumHours_ALL Details... @SumHours_ALL Group Footer #3 @CalculateDays @SumDays Details...

I have a report that is used exclusively to create a .csv file via File/Export. In the Report Footer, there are Summarys of some key fields. When the report is exported, the Report Footer is first Hidden because it's not required in the .csv file. However, we would like the Report Footer to be...

I have a simple stored procedure joining three tables. It has a couple DECLARE statements and a typical amount of WHERE conditions. DECLARE @ChekMonth nchar(6), @ChekYear nchar(4) DECLARE @p char(1) Set @p = '%' set @ChekMonth = 'NOV' Set @ChekYear = '2007' SELECT ... FROM UPR0Table UPR0...