Crystal Report ~ Period date in report

Just add formula field containing :

//{@DateRange}

WhilePrintingRecords;
DateVar date1;
DateVar date2;
date1:=Minimum (Date Field Here);
date2:=Maximum (Date Field Here);
"Report For Period: " + totext(date1) + " To " + totext(date2)

Share My Smart JUMP via Ubuntu 8.04 server

The following will explain how to share your Internet connection:

Note: Type all the following commands in a root terminal, DO NOT use sudo.

1. Start by setting up ppp dial up for smart axesstel MV140B:

# lsusb

Bus 005 Device 001: ID 0000:0000
Bus 004 Device 003: ID 1726:1000 < this is our axesstel mv140b modem
Bus 004 Device 001: ID 0000:0000
Bus 003 Device 001: ID 0000:0000
Bus 002 Device 001: ID 0000:0000
Bus 001 Device 001: ID 0000:0000

Then set up the usbserial for this modem

#modprobe usbserial vendor=0x1726 product=0x1000

Setup pppconf as needed by filling account for your smart modem



2. Then configure the NAT as follows:

# iptables -t nat -A POSTROUTING -o ppp0 -j MASQUERADE

where ppp0 is the internet connection is coming from

# echo 1 > /proc/sys/net/ipv4/ip_forward

3. Install dnsmasq and ipmasq using apt-get:

# apt-get install dnsmasq ipmasq

4. Restart dnsmasq:

# /etc/init.d/dnsmasq restart

5. Reconfigure ipmasq to start after networking has been started:

# dpkg-reconfigure ipmasq

6. Repeat steps 1 and 2.

7. Add the line "net.ipv4.ip_forward = 1" to /etc/sysctl.conf

# gedit /etc/sysctl.conf

8. Reboot. (Optional)

From client PC you have to set your gateway and DNS server to the server IP

: this article will be edited for more detailed step, i just wrote it for me to not to forget the setting