Search results for query: *

I solved the origonal problem by creating a hidden column containing the dimension. Thanks anyways cdekoning. Further input still welcome.

cdekoning That's not too bad but it presents another problem in that it's defeating the purpose of a measure. And by making what should be a dimension a measure causes the totals in the sum row and columns to go exponential. It will cause it to do this <Variable>*<Measure>*<Number of records...

I am trying to multiply a Dimension <DailyRateForEmp> by a Measure <Hour> in a crosstab body. All I get though is a #COMPUTATION or a #IERR. The Measure works fine by itself and both are definately numeric. The formula =Sum(<Hour>*<DailyRateForEmp>/8) works correctly in the Total columns to...

Thanks a lot Maiden. I had forgotten about this thread as I have no profile for e-mail notication set up. Trust Microsoft to put the bug in the ointment. I guess I'll go the FreeHand route. Does that mean that BO 5.1.2 has full SQL support in the FreeHand pane?

I have a problem when accessing Stored Procedures on an SQL Server 2000 database. When it pulls up the parameters box to specify the parameters that you will be passing to the PROC, it always has one extra at the start name RETURN_VALUE. I can't complete until I specify a parameter for this but...

Thanks for the quick reply Bob. I have Shared, Secured and Personal type connections in Designer (All using the one user dsn), but none of them show up in the wizard.

I have a problem whereby when I select the new report wizard and select Stored Procedures, it tells me I can't use them because I have no connections. I have a connection to an SQL Server 2000 Database set up in Designer. Where am I going wrong?