Viewing 15 posts - 1,126 through 1,140 (of 1,183 total)
Type this in the jump to url field...
="http://sever99/folder1/page1.aspx?profitCenter=100&department=" & field!department.value
and that should do it.
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. SelburgAugust 9, 2006 at 4:34 pm
1. Use the query to get the available fiscal dates for your parameter.
2. Combine the other two queries into one
----------------
declare @startdate datetime, @enddate datetime
SELECT @startDate = FiscalStartDate, @endDate = FiscalEndDate
FROM...
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. SelburgAugust 2, 2006 at 5:51 pm
Wouldn't this work as well, and more efficient?
SELECT
a.ServerName
FROM
tableA a
LEFT JOIN tableb b...
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. SelburgJuly 27, 2006 at 5:55 pm
Just a comment ....
One other thing that I've noticed, and haven't found how to get around (and I doubt you can), is that the settings in the users Adobe Reader...
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. SelburgJuly 11, 2006 at 6:55 pm
My experience with Host Headers is this:
As long as the Report Server Address in your .config files, the address you use in VS for the RS match the host header...
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. SelburgJuly 11, 2006 at 6:19 pm
To address the wait time for the subscription to complete, make the following changes to the stored proc. This solution was devised by hughthomas -> http://www.sqlservercentral.com/forums/userinfo.aspx?id=86254
Add the following lines...
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. SelburgJuly 7, 2006 at 6:35 am
What are the datatypes of your fields (ID and name)?
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. SelburgJune 23, 2006 at 5:29 am
What is the error message you are getting?
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. SelburgJune 22, 2006 at 2:42 pm
Wouldn't this work?
.....AND (field in (@parameter) or @parameter like '%All%' )
?
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. SelburgJune 22, 2006 at 2:22 pm
I'll try to test this and get back to you asap.
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. SelburgJune 15, 2006 at 10:59 pm
I'm not positive, but I'm pretty sure it's not possible within one text box.
One possible solution is to use formula's to calculate the 'left' properties of your second and third...
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. SelburgJune 15, 2006 at 6:39 pm
The second agument of replace is the replacement text.
I think you want
REPLACE( REPLACE( thecolumname, CHAR( 13 ) , '' ) , CHAR( 10) , '' ) AS TheString
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. SelburgJune 15, 2006 at 11:14 am
This may be a stupid question, but do you have "Allow saving Password" selected?
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. SelburgJune 14, 2006 at 3:35 pm
Just a thought...
create a table with the parameters as fields.
have the report's parameters use the value from this table as defaults but not available values.
have the dataset that is used...
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. SelburgJune 14, 2006 at 3:33 pm
My understanding of your situation is that you have restored a backup and want to know where to see it?
If this is correct, it is restored 'over' the database that...
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. SelburgJune 13, 2006 at 5:53 pm
Viewing 15 posts - 1,126 through 1,140 (of 1,183 total)