|
|
Browse by Tags
- 5
- 8
- 9
- add
- adobe
- Alt-N
- antivirus
- apache
- apple
- backup exec
- bea
- boot
- Business Objects
- change
- citrix
- client
- code
- corel
- corporate
- create
- crystal
- Crystal Decisions
- Crystal Reports
- Crystal Reports 10
- database
- databases
- Dell
- disable
- disk
- drive
- dynamics
- Dynamics GP
- enterprise
- error
- filemaker
- firewall
- Flash Player
- FTP
- ghost
- hostname
- illustrator
- install
- installing
- last
- linux
- Linux Enterprise
- media
- memory
- Microsoft
- mode
- ms
- multiple
- mysql
- nic
- norton
- Nuance
- number
- oracle
- Oracle 10g
- os
- parameter
- partition
- path
- player
- precision
- raid
- report
- reports
- Sage
- select
- sendmail
- server
- service
- set
- single
- sles
- snmp
- solaris
- Solaris 10
- sql
- start
- Sun
- Sun Microsystems
- suse
- Suse Linux
- Suse Linux Enterprise
- sybase
- symantec
- tape
- telnet
- top
- uninstall
- upgrade
- user
- vb.net
- veritas
- virtual
- vpn
- weblogic
- windows
-
MySQL: how do i select last 10 rows in ascending order?
Hi, I am making a shout box, and I want it to display the last 10 messages posted in ascending order. I know how to display the last 10 in descending order but can't figure out how to do it in ascending order. Can you help me please? heres an example: if in the database there were 26 shouts which... -
Where are the voice training files?
I lost boot capability in my old c: drive and have to reinstall all my programs on the new c: I have access to the old c: via usb and would like to copy the voice training files to the new drive and avoid having to entirely retrain Dragon 10. Where are the files, and where do I put them to avoid the... -
I want an SQL query - select top 10 records except for the top 10 records.
have some theory, i think it should work, i havnt figure it out yet. I couldnt get my sql running. I just need a SQL statement that SELECT TOP 10 records FROM table WHERE records NOT (SELECT TOP 10 from table) its not working and it wont run as i expect it. select top 10 * employees from employees where... -
Using Crystal Fails on x64 Windows Server Standard
Hello guys, I have a solution (.Net Framework 2.0 Windows forms application) where I use Crystal Reports 10. It is running just fine on every x86 machine we have tested until now, using Crystal runtime deployment packages (MSM or MSI). I now installed a new Windows Server 2003 R2 Standard x64, with Visual... -
Error while creating a materialized view or refreshing any view.
Hi, I am getting a strage error while creating a materialized view on Oracle database. We were able to create or refresh view earlier to this and there were no problems at all. But now when I try to create a materialized view on the database I am getting error like ORA-04063: package body "SYS.DBMS_LOGSTDBY"... -
Crystal 10 - crystl32.ocx?
Hi all, Till recently I was using CR 7.0 to create reports and use crystl32.ocx control in VB to call the report. We've now upgraded to CR 10 but I can't find the control. How do I go about running reports from VB? Thanks! Adi -
Union Question
I am currently writing a report in Access by using a Union. I would like to be able to write this in Crystal, but I think Crystal uses a different format. In access I currently have it as: SELECT prod_PABUDGET.R_POSITION, prod_PABUDGET.DEPARTMENT, prod_PABUDGET.END_DATE, prod_PABUDGET.EFFECT_DATE, prod_PABUDGET... -
Multiple line IF statement in Crystal Reports
I need to create a multiple line IF statement using Crystal Report (formula editor). I am attempting to debug where a caculation error is happeneing. I need to do something like this: If amount > 0 then Amt_variable =: Amt_variable + 30 string_variable = : "added 30 to Amt" else Amt_variable... -
Distinct count without grouping?
I have a simple report (2 tables) that lists companies and their contacts. I'd like to add the number of total contacts (for that company) to each company line. I can do that by creating a group but then I no longer see the contacts, right? I'd like to end up with a report like this: Apple Computers... -
Oracle, databases, 10, decode using like statment
folks i have a decode statment that works fine select decode(assetnum,'AGV','FLEET','Other') from asset however i would like to use a like or starts with function ie AV% instead of 'AGV' ,how do i build this into this query? all help will do