Forum Replies Created

Viewing 12 posts - 1,171 through 1,183 (of 1,183 total)

  • RE: need help with self join query

    Sorry about the spacing! Extra spaces got removed from my post ?????

    ______________________________________________________________________

    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. Selburg
  • RE: need help with self join query

    Thomas,

    This isn't the most efficient, but it works...

    ----------------------------

    SELECT

    ID,

    Number,

    Name,

    Date

    FROM

    CLASS

    WHERE

    Number NOT IN

    ...

    ______________________________________________________________________

    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. Selburg
  • RE: Where does the ActiveX print control come from?

    I'm not 100% sure, but I believe it's microsoft

    ______________________________________________________________________

    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. Selburg
  • RE: None of the Submit Buttons working in Report Manager

    Drew,

    Is this a fresh install of RS or one that's been up for a while?

    Have you recently moved or restored the RS Database?

     

    ______________________________________________________________________

    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. Selburg
  • RE: Can''''t create or edit Subscriptions

    Issue resolved after a great loss of hair.

    Solution, as provided online was to re-install the ASP.NET files by running "aspnet_regiis.exe -c" THIS DID NOT WORK.

    After stumbling around, I tried "aspnet_regiis...

    ______________________________________________________________________

    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. Selburg
  • RE: PLEASE HELP - Extra columns in Excel reports with SP2

    Hello,

    This is only an observation that may assist you. From my experience, the extra columns appear when you have more than one table in your report, and the widths and...

    ______________________________________________________________________

    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. Selburg
  • RE: Barcode Font not printing from the Web interface

    The font is installed on the webserver! That's the weird part. And you can "export" the file into Excel and print it fine, you just can't print from the web...

    ______________________________________________________________________

    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. Selburg
  • RE: Update records ''''prior'''' to ....

    TABLE SCRIPT

    -------------------------------------------------------------------------------------

    CREATE TABLE [dbo].[tblRTPs] (

     [RtpID] [int] IDENTITY (1, 1) NOT NULL ,

     [PersonID] [int] NOT NULL ,

     [WeekID] [int] NOT NULL ,

     [PointsEarned] [int] NOT NULL

    ) ON [PRIMARY]

    GO

    -------------------------------------------------------------------------------------

    MY WORKING SP

    -------------------------------------------------------------------------------------

    SET QUOTED_IDENTIFIER ON

    GO

    SET...

    ______________________________________________________________________

    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. Selburg
  • RE: SELECT from a table WHERE fields are LIKE results from another table

    Perfect Farrell! I knew there was a simple way. Thank you!

    ______________________________________________________________________

    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. Selburg
  • RE: Duplicate records using join and distinct

    Thanks to ALL for your replies. In the end I went with the function, and it works great!

    ______________________________________________________________________

    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. Selburg
  • RE: Duplicate records using join and distinct

    Francis,

    That worked for what I needed. Just for curiosity though, is there an easy way to get the multiple entries in one field?

    So if ....

    Customer_Contact_ID    Customer    Location   Region                ...

    ______________________________________________________________________

    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. Selburg
  • RE: Deploying with RS.exe through firewall - port issue?

    Port 80 is default and 443 is for HTTPS.

    ______________________________________________________________________

    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. Selburg

Viewing 12 posts - 1,171 through 1,183 (of 1,183 total)