Recent content by ajr1705

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