Search results for query: *

Hey All, I havent spent too much time trying this on my own yet, but i'm assuming i will run into trouble perhaps someone here would be able to help me out.. here's how my data relates: contract contractID portfolioid transactions transid contractid transtype transactiontypes transtype...

I've built a reporter utility using VB6 and CR8.5. In it I've implemented a quasi Banker's Rounding algorithm that changes a numeric value to a text value, then looks at the 1000ths digit. ie 2.4350 -> "2.4350" -> "5" I then do my calculations based on that digit and and...

hey guys, i've got a bit of a problem here.. dunno if i've maybe overlooked something in my code.. hopefully you can help. my report works fine on its own. it gives me the the totals i'd expect. i've since added it as a subreport in one of our main reports.. for some strange reason it blows...

Hey guys, thought I'd make a post here before I called it a day. Hopefully someone can point me in the right direction. I'll try to provide as much info as possible. I can query the db for my desired results with this: SELECT sum (vwReportA.QTY)'QTY', vwReportA.Event...

i'll give this a shot here.. its the end of the week and i'm not functioning on all cylinders here.. hope you guys can help. my table structure is: tblMain_Schedule: schTime (DATETIME), Site (VARCHAR), Event (VARCHAR) tblMain_TransTickets: Site (VARCHAR), Event (VARCHAR), Date (DATETIME)...

Does anyone know of a way to perform bankers rounding using sql server 7? any resources would be appreciated.. thanks mike

hello, i have a subreport with the following formula: whileprintingrecords; shared currencyvar total := 17.10; in my main report i have this (After the subreport): whileprintingrecords; shared currencyvar total; i'm getting 0.00 displayed on the main report. any suggestions? mike

Hey guys, I've been working on a legacy ticketing system, and added CR reporting to it. Everything was fine and dandy until the client through a loop at us which brings us to the information that I currently have. I have the following information from 3 different tables: TransID CurrencyType...

Hello, I've designed a few reports using CR 8.5, and have been mainly working on a local server. The time came this morning to test the reports with VB 6 on the main test server. This server has a different name, and the database has a different name, although it has the same structure...

Hello, Has anyone experienced crystal automatically adding empty report headers / footers when reimporting a sub report? i've noticed that everytime i reimport i get a new (one of each) empty header/footer. is there any solution? have i overlooked anything?/ thanks mike

Hello.. another newbie question here.. i've been having probs displaying a subreport within a main report. the first time i did it, everything 'seemed' to work just fine, but now i get the outline of the box on my main form with no data.. if i double click the box i get the preview of the...

hello folks.. dew to downsizing, i have to now deal with some crystal reporting. i have a question that will help me out considerably.. just thought i'd post here before i go and buy a book... i have this structure: tblMain_TransTickets ==================== NumOfPeople : Number Category ...