have you tried this :

set the InteractiveSize >>>>> Height property to 0cm:

this will work fine in excel as it will squeeze everything into one tab.... but i am not sure...

spj basically means "Sub-project"

thanks for the response.

okay so as explained above the formula currently reads like this

spj(16909)(a/3)+spj(16212)(a/3/3)+spj(16214)(a/3/3)+spj(16918)(a/3/3)+spj(16472)(a/3/3)+spj(16473)(a/3/3)+spj(16779)(a/3/3)

as you can see it contains a specific number after the bracket but this number is actually...

although that is a simpler way to do it ...we have tons of formulas that do different calculations.

"PRJ" stands for project. the number within the brackets is the project id...

thanks guys for the responses.

i have passed a 3rd parameter and i am working on the stored procs now.

will inform you as a i make progress.

Thanks Twin.

i have been working on something like your solution but i will make the tweeks to it now.

just one question though...

Will the financialYearID not conflict ?

Basically our requirements is to put both the stored procs in 1.

We have been ordered to do so....:w00t:

Not sure if this will help...

but from my experience i know that you will need to create a Split Function and then pass the value in the query.

i usually just...

hi thanks for the response.

i need to add time to my query.

what i am doing in the code is calculating the Sunday of every month.

all i would like to add...

hey thanks for the response

i will most definitely give that a shot.

thanks man for the response.

i just added the number of rows and it worked perfectly

thanks for the response.

but what i actually would like to do is show a report.

this report needs to be in a form of a pop up if possible but on...

i am not sure if this will help.

since your users are external, why not try to create a group on your domain with the relevant users and then try to...

hello all

thanks for all your assistance yesterday.

i have a new requirement :

i would like to split this string after the "+" symbol:

prj(9204)(a)+prj(9205)(a)+prj(9206)(a)+prj(9207)(a)+prj(9208)(a)+prj(9209)(a)+prj(9210)(a)+prj(9211(a)

if that is my string, then i want...

select distinct p.FormulaTypeID,p.FinancialYearID,p.VersionID,p.ProjectName,f.Formula

from tb_Projects p

inner join tb_FormulaTypes f on p.FormulaTypeID=p.FormulaTypeID

this is still not pulling the right results 🙁