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...
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...
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...
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...
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...
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...
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.
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...
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...
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...
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?
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...
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!
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)...
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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.