Search results for query: *

a little late but here's what i've been doing: i get my data from a webservice pass my parameter to the report, the report calls the webservice to get the data, and passes those parameters to the webservice, which in turn gets my data from sql.. it was the easiest way without having to...

thanks synapse, i know you've helped me out before.. before i left i tossed the cross tab in a group based on contractid.. gets the info out that i want, but i'm re-writing an old report and people upstairs are stuck on having it display basically the same way.. is there a way to include...

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

thanks for the reply, its sales transactions that i am looking at so there will always be numeric non null data that i'm looking at. the strange thing is that i get the error only when i run the report through a citrix connection. if i open the report up in cr8.5 and run it on my machine...

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

great thanks for the help... i realised that i didn't change the default number and currency to carry four decimal places in the new report. mike

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

i figured out what was going on.. i rebuilt my report, this time with group on the server selected... strangely i got the correct total.. i've also noticed that when i have a formula in the select expert, it reverts back so that crystal does the grouping, even though i have it set to group on...

ok.. my QTY value in the query analyzer comes up as 25956 Butterfly General Admission Regular Adult but in cr it comes up as 25161 for the same grouping.. is there any reason that there would be a difference between the query run on the back end and the crystal? thanks mike

thanks.. sorry.. it was the end of the day.. using sql server 7, and cr 8.5. the like's are in there so the user can search based on wildcards. thanks again for the post, i'll try it asap..

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

might be a bit late but, couldn't you write a formula that starts out as '' and appends patients names to it, then summarize that field rather than the patientname field? mike

thanks swampBoogie.. this database has so many strange things in it that i've stopped trying to rationalize why they are there.. i guess when they wrote it they wanted to keep the date and time seperate.. i dunno why, because they have to be manually seperated anyway in the source code...

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

ya.. in vb6 .265 rounds to .26

it gets a little trickier.. i should also add this: .235 = .24 .255 = .26 and .245 = .24

sorry i wasn't more clear.. i don't function too well right before lunch :) .243 = .24 .245 = .24 .247 = .25

well in the data that i'm looking at i have: taxttoal: 0.24 the formula for getting this is: ((netprice / quantity)(percentage))(quantity) so ((3.5 / 1) (0.07))(1) = 0.245 When the data was inserted into the table (from VB), VB rounded it to 0.24 (using the Round() function). SQL Server...

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