wher to find my +column tab and layout tab in design mode

General discussions

Moderators: Bob Cergol, Data Access, Cintac

wher to find my +column tab and layout tab in design mode

Postby sunilyoganna » Fri Jul 02, 2010 10:36 am

Hi all

i am using Dynamic AI personal Edition but i cant find my +Columns and lay out tab in my design window
please help me out i am new to Dynamic Ai an in my auto preview section i am not able see the SQL Radio button please help me out.

Thanks and Regard's
SunilYoganna
sunilyoganna
 
Posts: 8
Joined: Fri Jul 02, 2010 10:22 am

Re: wher to find my +column tab and layout tab in design mod

Postby Carsten Sørensen » Fri Jul 02, 2010 2:42 pm

Hi,

The +Columns should be available on the list tab (in older versions you are right that they had an own tab).

The Layout tab - available on IE only for the time being - is hidden if "Form (floating layout)" - is selected on the General tab. If you are using IE and "Drill-down to" is set to "Form" then the Layout tab should appear.

The SQL option (to be able to see generated SQL) is available in the Server and Enterprise editions only.

Best regards,
Carsten
User avatar
Carsten Sørensen
Certified Dynamic AI Professional
 
Posts: 304
Joined: Thu Aug 16, 2007 1:25 pm
Location: Copenhagen

Re: wher to find my +column tab and layout tab in design mod

Postby sunilyoganna » Wed Jul 07, 2010 10:27 am

Thanks Carsteon,

for your information and i have one more question regardin connecting of Excel Data Base
i have Excel File By Name Book2.Xls
When I test the connection it Througing Exception Could not found Book2.Xls
i am using personal Edition please find me a Solution

Thanks & Regar'd
Sunil Yoganna
sunilyoganna
 
Posts: 8
Joined: Fri Jul 02, 2010 10:22 am

Re: wher to find my +column tab and layout tab in design mod

Postby Carsten Sørensen » Wed Jul 07, 2010 11:30 am

You need to specify the full path to the Excel file. E.g.: C:\yourdata\Book2.xls then it should work.

regards
Carsten
User avatar
Carsten Sørensen
Certified Dynamic AI Professional
 
Posts: 304
Joined: Thu Aug 16, 2007 1:25 pm
Location: Copenhagen

Re: wher to find my +column tab and layout tab in design mod

Postby sunilyoganna » Wed Jul 07, 2010 5:44 pm

thanks Carsten,

if the is given correct it shows connection is successfull but when i browse through the table it shows no data found what i have to do know carsten.

Thanks Regard's
Sunil Yoganna
sunilyoganna
 
Posts: 8
Joined: Fri Jul 02, 2010 10:22 am

Re: wher to find my +column tab and layout tab in design mod

Postby Carsten Sørensen » Wed Jul 07, 2010 10:04 pm

Sorry I misunderstood your question!

You need to define named Data-ranges in the Excel Sheet - that Dynamic AI can use as Data-sources, i.e. The range must have column headers and each row in the table will be 1 record in Dynamic AI. The ranges should then appear as a table source in Dynamic AI database explorer.

Be aware that you sometimes are not allowed to have the sheet open at the same time as using the file from Dynamic AI.

Best regards,
Carsten
User avatar
Carsten Sørensen
Certified Dynamic AI Professional
 
Posts: 304
Joined: Thu Aug 16, 2007 1:25 pm
Location: Copenhagen

Re: wher to find my +column tab and layout tab in design mod

Postby sunilyoganna » Thu Jul 08, 2010 6:02 am

Hi Carsten,
Thanks for your usefull inormation my problem got solved and now only proble is when i browse the table Excel Sheet name is also coming only when i use .xlsx format i.e when i select Excel Spread sheet 2007 if i use .xls it works fine. What i have to do to avoid Excel sheet name, because when i click on the Exel Sheet name it showing Syntax error in FROM clause

Thanks and Regard's

Sunil Yoganna
sunilyoganna
 
Posts: 8
Joined: Fri Jul 02, 2010 10:22 am

Re: wher to find my +column tab and layout tab in design mod

Postby Carsten Sørensen » Thu Jul 08, 2010 12:25 pm

Hi Sunil,

I'm not sure I understand exactly - but usually we define "reports" - eventually just a simple table report to place the relevant data-ranges in the Report menu for browsing, report creation, investigations, Automated Intelligence etc. I.e. It might be that the database explorer will expose some ranges (the ones that you see as sheet names) that are not suited for use as a data-source...

Don't know whether you have already seen this but there are some documentation available at:

viewtopic.php?f=8&t=114

viewtopic.php?f=8&t=113

Best regards,
Carsten
User avatar
Carsten Sørensen
Certified Dynamic AI Professional
 
Posts: 304
Joined: Thu Aug 16, 2007 1:25 pm
Location: Copenhagen

Re: wher to find my +column tab and layout tab in design mod

Postby sunilyoganna » Thu Jul 08, 2010 12:40 pm

Thank you Carsten,
sunilyoganna
 
Posts: 8
Joined: Fri Jul 02, 2010 10:22 am


Return to General discussions

cron