Viewing 15 posts - 46 through 60 (of 80 total)
That didn't work for me, but please share if you get it working.
Thanks,
-Megan
September 28, 2006 at 2:40 pm
For the parameter, use something like the following stored proc:
CREATE PROCEDURE dbo.rptGetTeam AS
SELECT TeamID, TeamDescription
FROM TEAM
UNION
SELECT 0, 'All Teams'
GO
Then, for the report data source, use something like the following...
September 8, 2006 at 11:11 am
I'm not sure I'm understanding you either, but what I would do is make each parameter also have an option for "Select All" (see previous posts on how to add...
September 8, 2006 at 8:56 am
I have not implemented SP and RS yet, but I had this linked saved for later:
http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/webrssp2.mspx
Don't know if it will help or not.
Seems like you would use the url:
July 31, 2006 at 3:07 pm
I have had the same issue and unfortunately, have not found a solution.
-Megan
July 31, 2006 at 3:02 pm
I think you can just set the source to:
=10.10+20.20--10
If not, you may need to use the convert function to convert each "string" "number" to a decimal.|
i.e. convert(decimal(5,2), 10.10)+convert(decimal(5,2),20.20)...
I could...
May 30, 2006 at 3:59 pm
Thanks everybody, for your comments!
I downloaded the trial versions of both ERwin and ERStudio yesterday.
I agree that ERStudio has a better feel and it is just easier to use...
May 18, 2006 at 8:52 am
Raj -
I don't know if I explained "my" method very well, but you don't have to allow nulls, you just have to default the parameters to "All" and default...
May 5, 2006 at 8:53 am
You can default all of the filters to return all records, and then if you select one of the parameters, it will filter by that one.
So, for the unit no...
May 4, 2006 at 8:56 am
Basically, I just want to "rank" or give a row number per sort.
I rank into some info on rank and ended up removing all of the cursor stuff and replacing...
February 27, 2006 at 2:44 pm
What about this statement?
/* fetch the next row and insert into the cursor */
Fetch Next from myCursor into
@nLogSaleUID,
@cLogSaleName,
@cSpeciesName,
@cSortName,
@nOrder,
@cCustomerName,
@cDestinationName,
@dBidMBF,
@mTLC,
@grossMBF,
@netMBF,
@Winner,
@Rank
I'll...
February 27, 2006 at 1:48 pm
Ahh, lucky duck, Dave, I'm still stuck with 2000.
February 23, 2006 at 1:31 pm
I don't think you can actually. I think that RS 2005 is licensed via SQL server 2005, so you have to have a licensed version of SQL 2005 in order...
February 23, 2006 at 9:08 am
Thanks Steve.
January 22, 2006 at 10:39 am
Thanks guys.
Unfortunately, in my case, it's not as simple as city, state, and I would like the user to be able to select any parameter and by selecting that...
January 20, 2006 at 9:25 am
Viewing 15 posts - 46 through 60 (of 80 total)