Search results for query: *

hi, Thanks for your answers. Am not going to use Crystal Report. Am just using the Date Report of the VS 6.0. The printer came with no cd driver. And i don't know where to find it. I have a long way to go. Please help WaZda

Hello, This is my very first time am doing an application for a sales point. Am having a hard time printing the datareport to the "Epson TM-U220" printer that they got. Could someone please help me with some piece of codes. Do i need to set the paper size? Please how do i go about this. Thank...

I've finally got it. what i did to get it work was to bind the dataset to the report, before i start writting the codes to initiate the parameter fields value on the report. Then after all that i load it in the viewer. Thank u. WaZda

Hi, I have some database field i've dragged and dropped on my Crystal report. I programatically create a dataset and bind it to the report. This works perfectly. Now i have some other parameter fields placed on the report that am trying to send data into, but this is not working. When i comment...

Hi, There is something i had to add to the report but it's not working. I've put some other "Parameter Fields" on the report. Data send there are not from the database. I had it working fine when i was not yet binding the report to a dataset. Now that the dataset is bound to the report, the data...

Hi Bluejay07, I've just got it working. I guess the main issue was to get the schema of the fields on the crystal report to be exactly the same as in the query. For those who might have the same problem here is the solution. Bluejay07's code is working good and is for stored procedure. here is...

Hi Bluejay07, thank u for your help. Tell me, do u think the Stored Procedure is a must to get this worked? I've done what u've described expect that i didn't use a stored procedure and what i get as an output, is all the records in the tables. so i mean even if i create a new dataset...

ok Bluejay07, I've been trying some much things that am now getting a lil bit mixed up. Could u please give me a simple way to put some parameter/textbox or whatever on a crystal report and then programmatically get a dataset and then bind it to the report to have the fields displayed on the...

HI Bluejay07, i think my issue is quiet a lil bit different from yours. unless i didn't really understand your approach. The parameters i have on my report are the different fields to be displayed. for example i have like three parameters (Name, Address, Job) placed on the report and then my...

Hello, I am using VS 2005 and SQL Server 2000 (the sql version shouldn't be an issue here anyway). I've having the same problem. I have a datareader or dataset I want to loop through the dataset and display each row of information on the report. My problem is that when I do the loop, the...

Hi Qamgine, Thank you very much for your help. i tried to understand your code but i just couldn't. and it is because i did make myself clear enough. So i'll try explaining better this time, here is the scenario: I have 3 files: Form1, Form2 and CrytalReport1.rpt(which is the crystal report...

In other words, this is what am trying to do: I have put a textbox on the report, now I want to create a parameter in the report then make the textbox in the report equal to the parameter value then sent the parameter value by code. WaZda

2005] Write to Crystal Report Hi everybody and i wish u all a happy new year. Am working on a project whereby i have to send some informations to a crystal report. Am using Visual Studio 2005. I would like to do some query to the SQL server then do some manipulations with the data and then send...

It's an alternative. I know i could do it like this in vb6. But in vb.net the code does work. To u know how to translate this in vb.net? crystalReport.ParameterFields.GetItemByName("ParameterName").AddCurrentValue("ValueToPass") WaZda

Hi everybody and i wish u all a happy new year. Am working on a project whereby i have to send some informations to a crystal report. Am using Visual Studio 2005. I would like to do some query to the SQL server then do some manipulations with the data and then send some of the data manipulated...

thanks a lot Stella740pl (Programmer), ur code rocks as well.

AndyKr (Programmer), by the way, was my SQL statement correct? if not could you please give me the sql statement version of the above code?

hi AndyKr (Programmer), really don't know how to thank u. u really helped me. the code ROCKSSSSSSSSSSSSSSSSSSSSSSSSSS. Thanks a lot man. Really appreciate it

Hi foxpro users, i need an select statement in which which should give me informations on a particular date. i would like to test a date column(date_limit) to see if the month of that date minus 3 month = the system month part of the current date. select * from table where (datepart('m'...

the insert insert into works fine. When i change the memo field to "character" the insert into syntax works fine. The memo is the problem.