Search results for query: *

I am using ReportViewer in local mode. Can I set more than one data source in the DataSetName property (in a table)?

Yes, there will be around 20-30 subreports. The reason for having so many is because the users want the options to hide and show subreports. Redesigning the report is not in the scope.

I have a localreport (RDLC) has about 12 subreports. Within each subreports, there could be 2-5 more subreports. It is taking the ReportViewer too long to load the report because for every subreport, the SubreportProcessingEventHandler (SubreportProcessing event) is triggered to get data from...

I have a localreport (RDLC) has about 12 subreports. Within each subreports, there could be 2-5 more subreports. It is taking the ReportViewer too long to load the report because for every subreport, the SubreportProcessingEventHandler (SubreportProcessing event) is triggered to get data from...

Thanks for the tip. It led me the right solution. <asp:TemplateField HeaderText="Department" > <ItemTemplate> <asp:Label ID="lblDepartment" runat="server" Text='<%# Bind("Department") %>'></asp:Label> </ItemTemplate> <EditItemTemplate> <asp:HiddenField ID="hfDepartment" runat="server"...

How do you handle the ArgumentOutOfRangeException thrown from a DropDownList within a gridview? I have a editable field containing a DropDownList. The list is bind to a data source. Basically, the error is thrown because the item no longer exists in the list. When this exception occurs, I just...

I have two boolean variables called ExtractSuccess and LoadSuccess defined with package level scope. I want to be able to assign a value to the variables in the Data Flow tab. Is this possible? If so, is it also possible to retrieve the OLE DB Source and OLE DB Destination task execution result...

I have three environment: development, test, and production. I am using Subversion and I want to be able to use Ant to build the latest version of my project in source control and deploy to the test environment. Any suggestions or how I can do this would help me get started. Thanks.

What is the syntax to query a table from Oracle? I have tried Google, but had no luck. Anyways, here's some information on my database. I'm trying to write the query in MS SQL Server 2000. The Oracle database is 8i. The linked server name is LOANIMG. Database name is RPT. The schema is...

Nevermind, I was calling the same table I was trying to update in the function.

Oh yeah, I am getting the following error: ORA-04091: table LSAPP.VARIABLE_BACKLOG is mutating, trigger/function may not see it ORA-06512: at "LSAPP.GET_LAST_CUTOFF_DATE", line 23

I have a lookup table that I want to update with the following query: UPDATE VARIABLE_BACKLOG SET LASTCUTOFF = Get_Last_Cutoff_Date(WORKTYPE, SYSDATE), NEXTCUTOFF = Get_Next_Cutoff_Date(WORKTYPE, SYSDATE), CAPTURETIME = SYSDATE Get_Last_Cutoff_Date and Get_Next_Cutoff_Date are custom...

Thank you. I recoded to reflect your last example and it worked. Thanks so much for everyone's help.

Thanks karluk for trying to help. Unfortunately, because I using Oracle 8i, CASE statement is not supported in PL/SQL. That is the reason why I am trying to use the execute immediate method.

Actually, I did those steps before I posted. Running the SQL in an editor works fine, it bugs out when I try to set it up using PL/SQL. I took pieces of it out in the PL/SQL code, but that didn't help either. Here's is my table schema that I am trying to fill: CREATE TABLE LSAPP_WORKFLOWSTATUS...

I wasn't able to find much help from my google searches. Any help is appreciated.

That is because I am trying to round a percentage to 6 decimal places. I removed the ROUND(..., 6) but it didn't help. Oh, thanks for indenting.

Anyone know what is wrong with this code? DECLARE v_deptexclude VARCHAR2(30) := 'Direct Retail Lending%'; v_queuetype VARCHAR2(10) := 'new'; v_catgnew VARCHAR2(10) := 'NEW'; v_catgbacklog VARCHAR2(10) := 'BACKLOG'; v_stepname1 VARCHAR2(10) := 'Complete'; v_stepname2 VARCHAR2(10) :=...

Yeah, CASE isn't supported inside PL/SQL in Oracle 8.

I am trying to compile this procedure in Oracle 8i: CREATE OR REPLACE PROCEDURE Sp_Update_LSAPP_WORKFLOWSTATUS IS BEGIN DELETE FROM LSAPP_WORKFLOWSTATUS; -- INSERT INTO LSAPP_WORKFLOWSTATUS SELECT DEPARTMENT, DEPTINITIAL, SUM(CASE WHEN CATG = 'BACKLOG' THEN 1 ELSE 0 END) AS WOB_BACKLOG...