DataManagement

STORED PROCEDURE

Hi All i search to make procedure in strsql please can anybody help me and search code open text file from the procedure and put data on  it   Software/Hardware used: AS/400 sql400 DB2

The most-watched IT questions this week: Oct. 20, 2009

Here are the 5 most watched questions on ITKE: There's some great discussions going on ranging from SQL to diagnosing app crashes. Go answer a question now and take your shot at winning a TV, or check out the rest of the top 10 on the Community Blog: 1.ORA-31672 in oracle 11g tops the list, with...

Crystal Reports Cannot query View

I cannot query result from my custom Database View created from TOAD SQL, anyone knows why? I have granted access for the user.

Last 2 weeks Trends via Crystal Reports

I’m trying to pull data, from MySql Database through ODBC, for last two weeks & then trend them together Software/Hardware used: Crystal Reports 11.5

Most popular blog posts this week

10. Removing old hardware after a P2V conversion Eric Siebert shares a long-held best practice regarding old server management. 9. The challenge of managing risk when IT budgets tighten Linda Tucci explains the challenges of a down economy -- and offers some tips on coming out ahead. 8. Ellison...

Implementing a DBMS for a company

I would like to know the basic steps I should take in implementing a DBMS for my company? Software/Hardware used: WINTEL microcomputers and Microsoft Office for word processing and finanical applications

Dropping a DB2 Stored Procedure

In my DB2 stored procs I always first drop the procedure and then do a create statement.  Is there any way I could say something like...if exists (select * from sysroutines where routine_name = 'procname') then drop procedure procname;  ?   I tried this, but the proc doesn't like the IF...

Tree View Control

i am trying 2 make and explorer using the tree view control in my project using VB 6, SQL Server 2000 and crystal reports. in the looping statements i had inculed the details and all. i need 2 display the results in the Grid Box when click the nodes in the Tree control. please provide the code for...

Transfer Data from one database to other.

Hi all, How to transfer datas from one database which has completelly different structure to other datebase with different structure? How to map these database? Is there any tool which does this? If so please suggest some free tool. Please help. Thank you all in advance.

Differences between Crystal 11 and 2008

What are the differences between Crystal Rpts 11 and 2008. If upgrading to 2008 are there other patches to upgrade or will all existing reports upgrade to 2008 without problems?

object slected out of alignment in cross hair

when i copy and paste the object is not in the cross hair Software/Hardware used: autodesk architecture

The most-watched IT questions this week: Oct. 13, 2009

Here are the 10 most watched questions on ITKE: There’s some great discussions going on ranging from going green to how to create a new network. Go answer a question now and take your shot at winning a TV, or check out the rest of the top 10 on the Community Blog: 1. Going green: Are you feeling...

Like to do SAP

i am a computer systems engineer,currently doing networking,user support and web administration,how will SAP certification be good for my career?

Evaluating HP, Dell, IBM Solutions for small VMware deployment

Gday All, Currently doing some research for a solution to consolidate our 6 or so servers using VMware. We are looking to implement HA, DRS and VMotion. Our budget for the hardware is about $30K AUD and we currently have 10 users. We have the following server roles to consolidate and they are...

Question about Crystal Reports

I am storing my database in the APP_DATA Folder of my application. I added crystal report to my application. I mentioned .SQLEXPRESS as my server. In database drop down i see only these databases -Master, Model, msdb, tempdb My dabase's name is "Database.mdf" . Why i am not able to see it ? My...

AutoCAD - auto open dialog box when editing text

what is the command to make Autocad 2000 open the dialog box when you double clike on text to be edited. Software/Hardware used: Autocad 2000

Updating a View

I have a view that's missing data and needs to be updated. I'm not sure how to update a view - any help would be greatly appreciated. The database name is: ABCD_Dbase The view that needs to be updated is: dbo.vGoLPgcfos Thanks in advance. ~DJ  

export crystal report to flat file in fixed length with headers and footers

Hi; I need to produce a flat file in fixed length format as output of Crystal Reports version 8.5. The issue I am having is that the file has a batch header and trailer record which must be placed in the header and footer sections of the report. I also have multiple subreports within the details...

The most-watched IT questions this week: Oct. 6, 2009

Once again, we’ve compiled the 10 most watched questions on ITKE, and found some great discussions on topics ranging from virtualization to disaster recovery to disaster recovery. Go answer a question now and you could win a TV, or check out the rest of the top 10 on the Community Blog: 1. How...

Crystal Report

hi, i want to use crystal report in asp.net website using push model. i am facing problem in creation of crystal report object. Regards kalpa pachori [   Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load BindReport()   End Sub   Sub BindReport()...