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: j0em0mma
  • Order by date
  1. j0em0mma

    server control in an ascx not getting theme on ascx LoadControl

    I have a styleSheetTheme Web App defined in the web.config and I have 3rd party component library that is registered in the GAC. It gives proper code complete in design mode in html side. When I add this to a normal page in html and run the page, the skin I have defined for this control is...
  2. j0em0mma

    why is _objId undefined in this statement?: var _objId = self.id;

    Welcome to amateur hour, starring me. I was sending a parameter to my 'new object' call named 'id.' turns out that the 'id' I thought I was getting (the variable name stored in the window object associative array) was actually the one I was passing as a parameter. This raises a question...
  3. j0em0mma

    why is _objId undefined in this statement?: var _objId = self.id;

    I have debugged this and verified that self.id evaluates to a scalar string that represents the name of the variable I assigned this object to...
  4. j0em0mma

    Dynamically reference user object, like document['myObject']?

    I have two variables and I have assigned to each an instance of the same user defined object. Based on if/then, I want to get a reference to either variable by name. Is there something like: document['myObjectInstancesVariableName'] available? eval is not an option...
  5. j0em0mma

    Unable to cast object of type 'ASP.xsd_master' to type 'xSD'.

    I got this error randomly once every few days for awhile. Once I stopped debugging, it would run again fine. Over the past few days, the project would only rebuild if I deleted the temporary files in the following directory: C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\Temporary ASP.NET...
  6. j0em0mma

    Why does this format string turn "0" Blank?

    SOLVED =Format(Fields!Units_Distributed_in_Date_Range.Value,"###,###,##0")
  7. j0em0mma

    Why does this format string turn "0" Blank?

    I have the following format string applied to a Report Column: =Format(Fields!Units_Distributed_in_Date_Range.Value,"###,###,###") For any value other than zero (actually zero, not a NULL value) this works, but a zero is displayed as blank. If I change this line to this...
  8. j0em0mma

    Can I make each instance of a Group start on new page?

    I am not sure if this is the proper forum, please forgive me and direct me if it is not. I have a straight forward Order/Order Item report that needs to have each of the main grouping elements (Order) start on a new page. I am limited to using Visual Studio's Report designer. Is this possible...
  9. j0em0mma

    How to connect rdlc Report Parameters to Stored Proc Parameters

    So, this doesn't really address using Report Parameters added while creating the report. If anyone is interested, I will figure this out and post it, though I don't need it now.
  10. j0em0mma

    How to connect rdlc Report Parameters to Stored Proc Parameters

    So this is how it's done: 1) in Visual Studio 2005, choose Menu->Data->Add New Data Source. Choose Database, then enter the appropriate connection string. Then enter an appropriate name for the data source. Once the database objects are listed, choose the desired stored procedure, plus the...
  11. j0em0mma

    How to connect rdlc Report Parameters to Stored Proc Parameters

    I have a stored procedure accepting from and to date as parameters to an Group By Select. I have added this as a datasource and even have the report designed and showing up fine except... I cannot find an example of passing parameters from a control (say, DateTimePicker) on the WindowsForm that...
  12. j0em0mma

    Where are my zero Counts?!

    Well, I'll be dipped in something or other :). I could swear that I'd gotten this to work with out the join to an inner select before. In my original question, the sample code with the Right Outer JOIN works until you apply the where clause. After looking at your solution, it makes sense why...
  13. j0em0mma

    Where are my zero Counts?!

    Don't smack that head too hard, it'll stick that way :) "Make tbl_orders base table, then join from there" Isn't that what the second code sample from my original post is doing?
  14. j0em0mma

    Where are my zero Counts?!

    I have done this a bil... let's just say many times. Given the following SQL: SELECT dbo.tbl_Items.ItemName AS [Item Name], dbo.tbl_Items.ItemDescription AS [Item Description], COUNT(Distinct(dbo.tbl_Orders.OrderID)) AS [Orders Distributed] FROM dbo.tbl_Items LEFT OUTER JOIN...
  15. j0em0mma

    Having trouble with Stored Proc syntax

    Thank you both very much! 4 quotes did it. Also, I did not need to run exec on the stored procedure, just inside it. Man, T-SQL error messages don't help much!
  16. j0em0mma

    Having trouble with Stored Proc syntax

    Thank you very much for your help guys, never had to get into T-SQL like this, so it's a bit new for me. I have altered the Stored Procedure to the following: ALTER PROCEDURE [dbo].[sp_GetOrdersDistributed] -- Add the parameters for the stored procedure here @FromDate varchar(50)...
  17. j0em0mma

    Having trouble with Stored Proc syntax

    oops, did not see your post SQLDenis, trying it now
  18. j0em0mma

    Having trouble with Stored Proc syntax

    k, did that: set ANSI_NULLS ON set QUOTED_IDENTIFIER ON go -- ============================================= -- Author: ##### ###### -- Create date: 2/24/2006 -- Description: Return Parameterized Orders Report -- ============================================= ALTER PROCEDURE...

Part and Inventory Search

Back
Top