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: *

  1. fmrock

    Group by Week Issue

    How do you use this DateDiff(Day, 0, DateAdd(Day, -5, YourDateColumnHere)) / 7 to display a date?
  2. fmrock

    Group by Week Issue

    Is there anyway of doing it without changing the SET DATEFIRST? In Oracle I can do something like this SELECT next_day(trunc(sysdate)-7,'Thursday') dtWeek FROM DUAL;
  3. fmrock

    Group by Week Issue

    I am trying to create a query that groups data by week. However the week should be Saturday to Friday. Any ideas how I should convert my date to Friday and then I can group/sum my data based on that date. Thanks .
  4. fmrock

    Help with Grid View

    No errors but If i choose a different version of the report and it runs through the code again. The datatable has the correct values, but the gridview does not get them. If I leave these commented out, the values switch. //dResult =...
  5. fmrock

    Help with Grid View

    I have a page that has drop down list and a user control The user control generate graphs and data grids for web enabled reports. protected void Page_Load(object sender, EventArgs e) { uc_report.sChartType = ddlChartType.SelectedValue; } Inside my UC i...
  6. fmrock

    Package Update Help

    We are moving one of our database's to a new server. This new server is SQL 2008 64bit, and the old was 2005 64bit. Here is the error I am getting when I try to execute the package from Mgt Studio. [Destination 1 - DDRAbbreviations [147]] Error: SSIS Error Code...
  7. fmrock

    Cross tab header color

    Is it possible to color the header row of a cross tab a color. I know you can set the background of the text in the header, but the color does not extend to the borders. Is it possible to get the whole header cell colored? Thanks,
  8. fmrock

    Crosstab help with suppress

    This works... GridRowColumnValue("@Year") = replace(totext(year({SPNAME;1.EndDate}),0),",","") AND GridRowColumnValue("SPNAME;1.Month_Name") > month({SPNAME;1.EndDate})
  9. fmrock

    Crosstab help with suppress

    I figured out this will supress the whole row GridRowColumnValue("@Year") = "2012" I want to suppress 2012 and everything after March....
  10. fmrock

    Crosstab help with suppress

    Hey Everyone, I have a cross tab that has Jan-Dec as the column headers and years as the rows. However, my data comes back with Jan 2011-Mar-2012. But Apr-Dec 2012 still show zeros. I do not want to suppress zeros, because I could have real zero values in my data. I only want to suppress...
  11. fmrock

    Crystal Reports Server - Only allow reports to run off hours?

    I have a set of crystal reports that are hitting a production database, and they seem to be causing some performance issues to that production system. Is there way in Crystal Reports Server 2008 to limit a report so it can only be run during off hours? say 6pm-6am?
  12. fmrock

    parenthesis help

    Fee_Effective to_date("MEDMNGCARE_FEE"."MNGEFFECTIVE",'j') Fee_Expiration to_date("MEDMNGCARE_FEE"."MNGEXPIRATION",'j') The where clause Crystal is writing is not allowing the left join to work. WHERE to_date("MEDINSCONTRACT"."CEFFECTIVE",'j')<TO_DATE ('13-03-2012 00:00:00'...
  13. fmrock

    parenthesis help

    {MEDMNGCARE_FEE.MNGPRCODE} is just a field in the database and I am left joining to that table. I also use different statements based on a parameter. ( If UCASE({?CPT Status})= "FUTURE" Then ({%Fee_Effective} > datadate) AND ((isnull({%Fee_Expiration})) OR ({%Fee_Expiration} > datadate))...
  14. fmrock

    parenthesis help

    Is there any trick to getting the parenthesis in your select expert match in the SQL that crystal generates. I am using this in my select expert, but the SQL that crystal comes up the parens are way off and not using my left join. (({%Fee_Effective} < datadate) AND ((isnull({%Fee_Expiration}))...
  15. fmrock

    Query Help ...Performance Question

    That is exactly what I did. My asp.net does seem a bit quicker. I have that other function fn_ParseDelimitedStrings(@sLOB,',') L ON (Q.Location_Code=convert(int, L.Value)) My app is passing in a location number or set of location numbers. <Items>...
  16. fmrock

    Query Help ...Performance Question

    I just had to add logic for the all. Declare @SiteType VarChar(3), @SiteState VarChar(2) Select @SiteType = 'ECI', @SiteState = 'IL' SELECT DISTINCT CPCODE FROM MEDGROUP G JOIN MEDLOCATIONS L ON G.CPCODE = L.LOCCPCODE WHERE...
  17. fmrock

    Query Help ...Performance Question

    I have the following stored procedure... CREATE PROCEDURE [dbo].[Quicksilver_Get_Charges_Pmts_Adj_Amt] ( @sSiteType varchar(5) ,@sState varchar(5) ,@sStartMonth varchar(6) ,@sEndMonth varchar(6) ,@sLOB varchar(50) ) AS BEGIN -- SET NOCOUNT ON added to prevent extra result sets...
  18. fmrock

    Crystal + Oracle 10g pulling up a list of tables

    Commands run at an acceptable speed. Its loading the tree view in Crystal that is so slow.
  19. fmrock

    Date Parameter Question

    I have a report that contains several different date fields. I would like to get the user the ability to choose which date field the date parameter selects from. What would be the best way to do this? Thanks,
  20. fmrock

    Crystal + Oracle 10g pulling up a list of tables

    Oh and this is just pulling up the list of tables in the Crystal tree of tables, not even running a command.

Part and Inventory Search

Back
Top