Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: goitz
  • Order by date
  1. goitz

    Cursor Already Exisits Error

    I totally agree with SQLSister using a cursor to do this will kill your performance especially if your doing this every time on a insert. I would insert all your records into a temp table to do your work then insert into the main table as a final step.
  2. goitz

    SQL Server Job Step report success/failure using T-SQL

    I am trying to use a job node to decide the order of steps based on criteria. if datepart(dw,getdate()) = 1 return job Success else return failure this way i can add a step if its sunday and skip it every other day.
  3. goitz

    Dashboard creation

    Does anyone know how to add a pagelet to a report. I want to create a dashboard that can run a report within the main page without refreshing the entire report.
  4. goitz

    Migration ReportNet to Cognos8

    The migration does take a large chunk of time as its not as easy as they make it sound. The of the biggest pains is report rebuilding some syntax does not port through properly as well as we have been experiencing prompt problems. The upgrade is definitly worth it but take the time you planned...
  5. goitz

    Alternative to Cognos script in ReporNet

    I have been working on converting Impromptu reports to ReportNet for the last few weeks. What i have found is there is no great way to accomplish this task for very detailed Impromptu reports. We have had a consultant from cognos here and still we have virtually rewrite all the reports. If there...
  6. goitz

    Using If Then Else With Parameters In Filters

    I just had this issue yesterday. ((?Time_Zone?='East') and ([DWH Production Rogers].[Eastern Standard Time]between ?start_date? and ?end_date?)) or ((?Time_Zone?='Central') and ([DWH Production Rogers].[Central Standard Time]between ?start_date? and ?end_date?)) or ... The thing to...
  7. goitz

    Sorting Aggregated columns

    I want to sort based on a users prompt. I am able to do it without a problem for columns that are not aggregated. I would like some solutions based on sorting aggregated columns if any exist. currently im trying to get a child tabular model to do the aggregation but I am running into a cross...

Part and Inventory Search

Back
Top