Search results for query: *

I have this record selection formula, but when I check it, it gives me an error message. I am giving the users a multiple selection option. (if {?month} in [1,2,3,4,5,6,7,8,9,10,11,12] then Month ({WMS_MBP_PERMITS.DATE_OF_ISSUE}) in [{?month}] else if {?month} <= 0 then True ) The error...

Hi all, I have a parameter in my report and users can select multiple values. Can someone explain to me how I need to assign the values to the table field in the record selection? Thanks

Someone this morning suggested to me that i should use dataget control and display a certain number of records that way it will increase the the time for the selected resulted to be displayed.I took his suggestion and spent a fair amount of time and move from data grid to data set and the...

Hi I have a created a simple ASP page that return a row of 7K records using a data grid control and created a link for whomever to download the code as a CSV file. Everything works fine but for the result to be displayed on the data grid control is slow and it takes a lot longer to open a...

Here is my question: I have a code that work fine with access database and I want to use this code to work with oracle database. I have tried to change the connection string, command object and data reader but I do not seem to have luck yet. Can someone take a look at it and help me to fix this...

I am using this code to create a csv file and for some hidden reason I am not able to see my out put . I named my csv file filename="products.csv". can someone advise me what is wrong with this code.I do not get any error message but there is not result either. thanks <%@ import...

Hi all, Can somone advise me what i need to do to eliminate this error msg. thanks Description: An error occurred during the compilation of a resource required to service this request. Please review the following specific error details and modify your source code appropriately. Compiler...

It is a program created by the third party for our bidding process.what is does is when i run it create a file we use for our online bidding.I was hoping to write a simple script to copy this file from server and run it and generate those files

I did just use that but I do not seem to have a luck with it.It works fine when i use other executable files like notepad.exe , However For this GEN.EXE file to be executed I do need to to make a double click on it for me to get the result.I am not sure how i am able to do that inside the...

I have a .EXE file that i would like to run in visual basic.I did try to use shell script but it does not give me the result i am expecting to get. I need to double click for the exe file to be executed and i do not really know if i can do this inside the visula basic code. Private Sub...

now it works fine thank you johnwm. My next question is after I run this sub routine i would like to invoke an excutable file "Gen.exe" inorder for me to create the final out put. I am just wondering if i just add the executable file before the End Sub.Thank you guys for the help Private Sub...

sorry when I past it, it takes off the highlighted part.. Copy "J:\IO\qebsfnam\pass2ebs pass2ebs.txt" Rem Open "J:\IO\qebsfnam\pass2ebs" For Input As #1 If Dir(pass2ebs.txt")<>"" then Open "pass2ebs.txt" For Input As #1 Else Message = "File not found

I am trying to copy the file I need from the server in this case the location of my server is J:\IO\qebsfnam\pass2ebs and convert this file to pass2ebs.txt and test it if this file exit or not. Can someone take a look at this code and advise me where i made a mistake.I highlighted part of...

What I am looking or hoping for is a simple routine/program to manipulate line text. For this particular text file, the intent is to add a period 4 digits before a "/" and skip adding a period if it already exists. The text file could be very large so it is impractical to consider adding a...

I am trying to use this query to create a view and use it in crystal report. However, this query is considerably slow. I am wondering if there is a way to make this query run faster. Thanks SELECT DISTINCT G.CSECNUM,E.IPLINENO, LL.LETTING, E.EIITEM, I.IDESCR, P.CONTID...

Hi, I have a report which has one group and about 25 records in the detail section from one field. Is there anyway to break the report when it reaches the 5th record and to start a new column. Thanks Example Group A Field A 1 2 3 4 5 6 7 8 9 10 . . . Change to Group A A A A...

create a formula and add the rows Row1 + Row2 + Row3 and place the formula in the report under total1

Thank you, I got it working

Hi, Can you help me out on how to find the Grand total of this formula. if GroupName ({table_name.field_name}) = 'A' then (67.7 * Count ({table_name.field_name}, {table_name.field_name}))/100 else if GroupName ({table_name.field_name}) = 'B' then (37.8 * Count ({table_name.field_name}...

Hi, The Problem is I want to display the data from the subreport on the main report. Thanks