Need R&R MsSQL Guru Help Fast!!!
Posted: Fri Jun 02, 2006 1:29 pm
Hi all,__I have a bunch of reports that I am trying to convert from XBase to SQL. I have them converted, but I am having a problem trying to use a parameter screen I developed before R&R had their Parameter options. My customers do not want anything to change, therefore I am trying to see if it is possible to use these reports. I am sure there has to be someone out there that has faced this issue in the past.____In Xbase, I related a parameter table in my report by creating a calculated field with the value of 1, then relate by record number. In SQL, this does not work. I have since added a field called ri_id to my parameter table with the value of 1 and then added the same field to each of my tables I need to relate. I so far have gotten one of the reports to work this way. Unfortunately, I can^t seem to get any others to work, but I have had almost no time to give to these reports and now they are due in 3 days.____If there is anyone out there who can give some time over the next three days to help, please email me your fee and email address, and I^ll get back to you. Thank you in advance,__Lynn____email: CoggCal@aol.com