robert fuschetto

that worked! Thanks all! 😀

..will try...

MARTIN...QUESTION! I tried to dumb thecode down as much as possible to illustrate the error I get when I your code in. Note the fex runs fine. I just can no longer access the GUI! This code is sort of just a few pieces stripped down to where it really makes no sense..but to illustrate a point: -*APP HOLD foccache -*TABLE FILE TBLMSTR_CALENDARPERIOD -*PRINT -* TBLMSTR_CALENDARPERIOD.TBLMSTR_CALENDARPERIOD.FISCALYEAR -* TBLMSTR_CALENDARPERIOD.TBLMSTR_CALENDARPERIOD.PERIOD -*WHERE TBLMSTR_CALENDARPERIOD.TBLMSTR_CALENDARPERIOD.ROLLINGMONTHS EQ -4; -*ON TABLE HOLD AS HOLDFYPERIOD -*END -*-RUN -* -*-READFILE HOLDFYPERIOD -*-DEFAULTH &FISCALYEAR = '' -*-DEFAULTH &PERIOD = '' -*FUTURE BUDGET JOIN INNER TBLMSTR_BUDGETEDUNITSBYMONTHSUMMARIZED.TBLMSTR_BUDGETEDUNITSBYMONTHSUMMARIZED.RPTBANBR IN tblmstr_budgetedunitsbymonthsummarized TO UNIQUE TBLMSTR_BANBRBANAMEXREF.TBLMSTR_BANBRBANAMEXREF.RPTBANBR IN tblmstr_banbrbanamexref TAG J0 AS J0 END TABLE FILE TBLMSTR_BUDGETEDUNITSBYMONTHSUMMARIZED BY LOWEST TBLMSTR_BUDGETEDUNITSBYMONTHSUMMARIZED.TBLMSTR_BUDGETEDUNITSBYMONTHSUMMARIZED.RPTBANBR WHERE ( TBLMSTR_BUDGETEDUNITSBYMONTHSUMMARIZED.TBLMSTR_BUDGETEDUNITSBYMONTHSUMMARIZED.FISCALYEAR EQ &FISCALYEAR.(FIND TBLMSTR_BUDGETEDUNITSBYMONTHSUMMARIZED.TBLMSTR_BUDGETEDUNITSBYMONTHSUMMARIZED.FISCALYEAR,TBLMSTR_BUDGETEDUNITSBYMONTHSUMMARIZED.TBLMSTR_BUDGETEDUNITSBYMONTHSUMMARIZED.FISCALYEAR IN TBLMSTR_BUDGETEDUNITSBYMONTHSUMMARIZED|FORMAT=I11).FISCALYEAR:. ); ON TABLE SET PAGE-NUM NOLEAD ON TABLE SET ASNAMES ON ON TABLE NOTOTAL ON TABLE HOLD AS HOLD_FUTUREBUDGET FORMAT ALPHA ON TABLE SET HTMLCSS ON ON TABLE SET STYLE * INCLUDE = IBFS:/EDA/EDASERVE/_EDAHOME/ETC/warm.sty, $ ENDSTYLE END -* ACTUALS JOIN INNER TBLMSTR_UNITSWRVUSSMRY.TBLMSTR_UNITSWRVUSSMRY.RPTBANBR IN tblmstr_unitswrvussmry TO UNIQUE TBLMSTR_BANBRBANAMEXREF.TBLMSTR_BANBRBANAMEXREF.IDXBANBR IN tblmstr_banbrbanamexref TAG J1 AS J1 END TABLE FILE TBLMSTR_UNITSWRVUSSMRY BY LOWEST TBLMSTR_UNITSWRVUSSMRY.TBLMSTR_UNITSWRVUSSMRY.RPTBANBR ON TABLE SET PAGE-NUM NOLEAD ON TABLE SET ASNAMES ON ON TABLE NOTOTAL ON TABLE PCHOLD FORMAT HTML ON TABLE SET HTMLEMBEDIMG ON ON TABLE SET HTMLCSS ON ON TABLE SET STYLE * INCLUDE = IBFS:/EDA/EDASERVE/_EDAHOME/ETC/warm.sty, $ ENDSTYLE END The code runs fine. I can access the GUI. Note the code to substitute FISCALYEAR is commented out this so it prompts me for a FISCALYEAR. If I run this: APP HOLD foccache TABLE FILE TBLMSTR_CALENDARPERIOD PRINT TBLMSTR_CALENDARPERIOD.TBLMSTR_CALENDARPERIOD.FISCALYEAR TBLMSTR_CALENDARPERIOD.TBLMSTR_CALENDARPERIOD.PERIOD WHERE TBLMSTR_CALENDARPERIOD.TBLMSTR_CALENDARPERIOD.ROLLINGMONTHS EQ -4; ON TABLE HOLD AS HOLDFYPERIOD END -RUN -READFILE HOLDFYPERIOD -DEFAULTH &FISCALYEAR = '' -DEFAULTH &PERIOD = '' -*FUTURE BUDGET JOIN INNER TBLMSTR_BUDGETEDUNITSBYMONTHSUMMARIZED.TBLMSTR_BUDGETEDUNITSBYMONTHSUMMARIZED.RPTBANBR IN tblmstr_budgetedunitsbymonthsummarized TO UNIQUE TBLMSTR_BANBRBANAMEXREF.TBLMSTR_BANBRBANAMEXREF.RPTBANBR IN tblmstr_banbrbanamexref TAG J0 AS J0 END TABLE FILE TBLMSTR_BUDGETEDUNITSBYMONTHSUMMARIZED BY LOWEST TBLMSTR_BUDGETEDUNITSBYMONTHSUMMARIZED.TBLMSTR_BUDGETEDUNITSBYMONTHSUMMARIZED.RPTBANBR WHERE ( TBLMSTR_BUDGETEDUNITSBYMONTHSUMMARIZED.TBLMSTR_BUDGETEDUNITSBYMONTHSUMMARIZED.FISCALYEAR EQ &FISCALYEAR.(FIND TBLMSTR_BUDGETEDUNITSBYMONTHSUMMARIZED.TBLMSTR_BUDGETEDUNITSBYMONTHSUMMARIZED.FISCALYEAR,TBLMSTR_BUDGETEDUNITSBYMONTHSUMMARIZED.TBLMSTR_BUDGETEDUNITSBYMONTHSUMMARIZED.FISCALYEAR IN TBLMSTR_BUDGETEDUNITSBYMONTHSUMMARIZED|FORMAT=I11).FISCALYEAR:. ); ON TABLE SET PAGE-NUM NOLEAD ON TABLE SET ASNAMES ON ON TABLE NOTOTAL ON TABLE HOLD AS HOLD_FUTUREBUDGET FORMAT ALPHA ON TABLE SET HTMLCSS ON ON TABLE SET STYLE * INCLUDE = IBFS:/EDA/EDASERVE/_EDAHOME/ETC/warm.sty, $ ENDSTYLE END -* ACTUALS JOIN INNER TBLMSTR_UNITSWRVUSSMRY.TBLMSTR_UNITSWRVUSSMRY.RPTBANBR IN tblmstr_unitswrvussmry TO UNIQUE TBLMSTR_BANBRBANAMEXREF.TBLMSTR_BANBRBANAMEXREF.IDXBANBR IN tblmstr_banbrbanamexref TAG J1 AS J1 END TABLE FILE TBLMSTR_UNITSWRVUSSMRY BY LOWEST TBLMSTR_UNITSWRVUSSMRY.TBLMSTR_UNITSWRVUSSMRY.RPTBANBR ON TABLE SET PAGE-NUM NOLEAD ON TABLE SET ASNAMES ON ON TABLE NOTOTAL ON TABLE PCHOLD FORMAT HTML ON TABLE SET HTMLEMBEDIMG ON ON TABLE SET HTMLCSS ON ON TABLE SET STYLE * INCLUDE = IBFS:/EDA/EDASERVE/_EDAHOME/ETC/warm.sty, $ ENDSTYLE END It still runs fine. it no longer prompts for FISCALYEAR but rather is using the value form the first query. YEA! But the issue is that I can't get into the GUI anymore. I double click the fex and am met with this: THE GUI no longer allows me to open and view REPORTS after the first JOIN, In other words, I can see the GUI'ized report for setting the variables. I can see the GUI-ized report for the FUTURE BUDGET...but every REPORT thereafter you get that error...NO GUI Just code. Note in this example I only show one report thereafter: ACTUALS. As soon as I put the comments back..all is good! Any ideas,,,

THANKS!

Instead of prompting for FISCALYEAR and PERIOD (&FISCALYEAR / &PERIOD) I want to derive &FISCALYEAR / &PERIOD for the user then use in subsequent WHERE conditions . How can I execute the code below to get the desired values without displaying the query results and then set &FISCALYEAR to the resultant TBLMSTR_CALENDARPERIOD.TBLMSTR_CALENDARPERIOD.FISCALYEAR and the same for &PERIOD. TABLE FILE TBLMSTR_CALENDARPERIOD PRINT TBLMSTR_CALENDARPERIOD.TBLMSTR_CALENDARPERIOD.FISCALYEAR TBLMSTR_CALENDARPERIOD.TBLMSTR_CALENDARPERIOD.PERIOD WHERE TBLMSTR_CALENDARPERIOD.TBLMSTR_CALENDARPERIOD.ROLLINGMONTHS EQ -4; ON TABLE SET PAGE-NUM NOLEAD ON TABLE SET ASNAMES ON ON TABLE NOTOTAL END

Well it seems to work and the column name won't change. Thaks for the list!

Thank you. I am back. I never noticed the Error Details. Thanks. It shows this: The field was added to the SQl table and the masterfile refreshed. Here are properties: Like I said, it seems to work on our reports....

We added a column to a the end of a sql table. I refreshed the meta data. The new column appears but is shown red. Why would that be? All reporting seems fine.

Thanks at this point we are a bit far removed from DS having fallen back to App Studio. However, we are looking to upgrade to the latest release soon and give DS another shot. Hopefully this time things work as fluently as the demos we have seen...LOL

We copy the path from SharePoint then go to the HTML page. We add the URL under Requests & Data Sources. We add a hyperlink control to the HTML Page. Then tie them all together under Tasks and Animations, Anchor20 was the Hyperlink Control. URL/ Request90 was the URL to the SharePoint File. I am not sure this is what you are after but if you need more detail let me know.

We use hyperlinks to a SharePoint site. I am not a huge fan nor a SharePoint expert but when EDGE rolled out the ability to link to spreadsheets on local shares no longer worked...and IS refused us disk space so we dumped them on SharePoint and hyperlink to them.

this continues to be a PITA...anyone on a 9.0 or later version? Has this issue been resolved in some fashion by IBI? I looked up the exact edge version we are on and downloaded and installed the driver. It seems like I need to do this several times a month. About 1 in 5 times it does not work...then one day it magically does...never been able to figure out why.

has this been fixed for the latest version? Chaining was a big issue for us the last time we upgraded...a reason we did not embrace DS at the time.

Good Moring Erin, I am wondering how your defined link works. When you drag that defined column to a report and the report is run, does it 'light up' like hyperlink? If it does then this is what we are looking for. It then would seem we need to get the syntax correctly integrated with the link stored in our column. Perhaps that is where the <a hxref' comes in etc? We just thought since we could copy/paste the link as is from our table column, into a browser, it would work as such.

This was set up for Ben to play with: SQL Table: Master File: Focus Report off new master file: We want the Document Link column above to be a clickable hyperlink on a Focus Report. Does the column type on the SQL table need to be something specific and the master file rebuilt? Does the master file need to have a property set. Is this done within and App Studio Report fex?