Search results for query: *

we currently analysing multiple systems ie. SQL, Oracle databases and also ACCESS. We are mapping the tables and fields to ligicaldata model ( Entities/Attributes) to finally come a with Physical Data Model. Thus i need to get this data so thati map this information inline with the data i have...

Thanks Remou, what i need is to export the data into excel to analyse it what be possible

I need analyse database information i.e. table name, filed name, properties etc. Is there an easy to export this information using and specific tool? I know we can use the documenter within access but I have many tables and when I export the info to excel it does not export the table name...

lbass, what can i say your just a ...... genius, every time i ask a question you just seem to now what the asnwer is or what i am asking you. thanks my man

Hi, I need to do the following. current data extarcted like this... a 1 01/01/06 no a 2 02/01/06 yes a 3 03/01/06 no a 4 04/01/06 yes I would like the data to be shown like this for 'yes' records only a (02/01/06,04/01/06) I think you can use the WhileReadingRecords to do...

I am trying to create some address label, how can I get it repeat 7 down and 2 across, any ideas. Thanks cr 8.5

I am trying to write a formula so that it searches through Multiple fields to find values in address fields. I want use the formula to extract only these that meet the selection. E.g. Fields are say add1, add2, add3 etc I want to search for the string "GAHANA" or "ENGLAND", this could be in...

I get this error after installing Cr 8.5.. Any suggestion on a fix ODBC error: [DataDirect][ODBC Oracle Driver]The Keywords LEFT OUTER JOIN were not found in an outer join escape sequence Thanks

I get this error after installing Cr 8.5.. Any suggestion on a fix ODBC error: [DataDirect][ODBC Oracle Driver]The Keywords LEFT OUTER JOIN were not found in an outer join escape sequence

Hi I have lot of grouping in my report and I need to force the report to sort the data at the lowest group, how can I force it sort at that group. E.g Gooup @ a,b,c,d,e... I need it sort it at e and ignore d, but I need the grouping at the order to get the correct data. Thank you

Thanks Ibass

Ibass, this is what I tought , but if your reports parameter or groupings are based on fileds on the larger table is it better to start with the larger table. Do you know any document I can look at on this with differebt examples of linking. Thanks

Apologies for not making my self clear. My question is if Table 1 has 1000 records Table 2 has 10000 records Table 3 has 10000 records And they are related by key then which table should be the left most. What I am asking does it make a difference on how fast the report will run (optimization)...

Hi Simple question, when linking multiple tables which table should be the primary table. E.g. . Header, Detail, Detail1 Provided all the above tables are linked by key is it best to start with Detail or Header Thanks

Ok Sorry people no reply required. Its done

Hi I have the following:- Two Parameter fields for limiting records shown on the report. i.e. startamt and finamt I have limited this on the group by Sum ({dbsfield}, {group field }) in {? startamt } to {? finamt } But if I enter the range for example -500 to 0, it returns value which are...

Thanks for all the help guys, you guys are real stars. Thanks again

Boss sorry for the late reply. Thanks for the help.

Is there a formula I can use to remove all spaces. I have used the trim command but I want all spaces removed thus from with the text. E.g " AA xx" required data "AAXX"

Boss man, I have done the following as suggested by you grouped on name,postcode and also formula( name&Poscode). name&Poscode i am ristricted the data on group count (formula( name&Poscode),formula( name&Poscode))=1 this gives me all new customers but when the post code is differnt or...