aashis khanal :: aashis binod khanal

Recent Twitter Updates
  • Uh oh. it looks like Twitter is unavailable at the moment.
  • Follow me on
Recent Comments
  • i tried with " $creport->FormulaSyntax = 0; $creport-&g... more
  • Howdy! This article couldn’t be written any better! Going th... more
  • This is a topic that is close to my heart... Many thanks! Wh... more
  • Good post.. I had to read it twice to comprehend it all thou... more
  • Hey There. I found your blog using msn. This is an extremely... more
  • Generate Pdf from PHP Running Crystal Report, .NET Web Service

    Posted by Aashis on November 10th, 2011 at 9:10 pm
    Hi all After long time. I had previously discussed how we can generate pdfs running crystal report from php you can find the link in this link :: http://aashiskhanal.com/2011/06/generate-pdf-from-php-running-crystal-report-passing-parameter-to-the-crystal-report-from-php/ It has a draw back .. to run this in a server we need to have a crystal report client installed itself in the host machine. May be in future SAP or Microsoft come up with some runtime dll libraries. Next best and ...
    Read More
  • Upload files to SharePoint Document library from PHP

    Posted by Aashis on July 8th, 2011 at 4:31 pm
    It was very fun to work with the dotnet all the time. Deal with the restrictions microsoft provides is always fun :) . It is actually a very simple to upload your document from PHP to Microsoft Sharepoint environment. First we need to write an dotnet class (program) that upload files to sharepoint. The .NET Method should receive two parameters, 1. Source File path. 2. Destination URL to sharepoint. My .NET class looks like. using System.Collections.Generic; using Microsoft.SharePo...
    Read More

    Posted by Aashis on June 30th, 2011 at 8:59 pm
    Run your web application in your local or anywhere else. .. sometime you may face No Input File Specified. It took me like an hour or two to track down solution. There could be few causes. 1. If your file name (extension) is wrong rather than it is supposed to be. The solution for this problem is simple just make sure extension is correct. 2. Your project folder doesn't have proper read write mode. Solution to this problem is quite tricky. Right click your folder. Select ...
    Read More

    Posted by Aashis on June 29th, 2011 at 3:38 pm
    KOOL PHP is great in implementation. But it support only MySQL and old version of MSSQL driver called dblib.dll I like the old dblib driver for MSSQL, which is sometimes also called as mssql driver. This driver has a binding property before executing stored procedure, it has a seek function which moves pointer to our desired row with in the database result set. There are many other good features also and is stable. But I don't know somehow its support has been stopped nobody supports and ...
    Read More
  • Generate Pdf from PHP Running Crystal Report, Passing parameter to the crystal report from php

    Posted by Aashis on June 3rd, 2011 at 3:25 pm
    Here is the class I wrote to process my crystal report and generate it as pdf file. This function accepts 3 parameters. $resportName (Name of the crystal report). $pdfName (Name of the pdf file to be generated). $dbViewName (Name of my db view, on which based $reportName (crystal report ) is generated). /*============================================ * Generates PDF file from RPT format =============================================*/ function createReport($reportName,$...
    Read More
  • Crystal Reports ActiveX Designer Description: Access denied (Solution)

    Posted by Aashis on June 3rd, 2011 at 3:14 pm
    Some time you will get this error... It was driving me nuts, crazy situation........... I don't what's going. I went through many sites found that its because my folder where I was trying to put my generated pdf files into was on readonly mode. I was so relieved wow .. lets change the folder permission, did right click on the folder set permission to readwrite. Happy. Run the application.. damn... getting the same error message. Crystal Reports ActiveX Designer Description: Access denied ...
    Read More
  • SQL Generic/Dynamic Update function

    Posted by Aashis on June 3rd, 2011 at 1:53 pm
    This function is similar to my previous dynamic stored procedure for Insert SQL statement CREATE PROCEDURE [dbo].[proc_formUpdate] @tableName nvarchar(50), @columnsAndValues nvarchar(MAX), @whereConditions NVARCHAR(MAX), @delimit nvarchar(3), @equalsign nvarchar(3) AS BEGIN DECLARE @SQL VARCHAR(MAX) declare @strlength int DECLARE @updateList nvarchar(MAX),@conditions nvarchar(MAX) SELECT @updateList = dbo.fn_processUpdateStr(@columnsAndValues,@delimit,@equalsign) SELECT @cond...
    Read More
  • Easy Steps to Becoming a Millionaire

    Posted by Aashis on May 20th, 2011 at 2:34 pm
    Who wouldn't want to be worth a million dollars? Many of us dream of achieving this goal, more often than not for the sake of the freedom financial stability would bring. So how can we get there? The answers are actually much easier than you might expect. Here are several easy steps to get you into the millionaires' club. (With a little discipline and the help of some powerful savings vehicles, anyone can hit this mark.) 1. Only Marry Once According to "The Millionaire Next Door" by Thomas J...
    Read More
  • Facebook Shortcuts

    Posted by Aashis on May 20th, 2011 at 2:12 pm
    Facebook has a whole ton of keyboard shortcuts. If you're using Google Chrome, you can press Alt+1 for your news feed, Alt+2 for your profile page, Alt+3 for your friend requests, Alt+4 to see all your messages and Alt+5 to read your notifications. Alt+? does a search, and Alt+M lets you write a new message. If you're using Firefox, try Shift+Alt, then the number. Internet Explorer users will need to hit Enter after each shortcut, while Mac users will need to hold down Control+Option instead ...
    Read More
  • Dynamic Stored procedure for insert

    Posted by Aashis on May 13th, 2011 at 1:45 pm
    How we can create a dynamic/generic sq insert statement. Example below shows how we execute stored procedure using micorsoft sqlsrv library. /*============================================== * Executes stored procedure * @params: stored procedure name, variables=data array ===============================================*/ public function executeProc($conn,$sp_name,$paramArray) { try { $sp_stmt = "EXEC " . $sp_name . " "; $paramString = ""; $stmt = sqlsrv_prepare( $conn, $sp_stmt, arr...
    Read More
Upcoming Events
There are no upcoming events at this time.
August 2017
« Nov