Thanks, Vladimir. It was the extra space which was causing the problem. It is working fine now.

Any reply, please. Thanks.

<t>I have created a report that retrieves data from a mySQL database. Everything is working fine, but the problem is that I am prompted to enter the user name and password each time I generate the report in ViewerFx. I have tried unchecking the 'Prompt User Name and Password' checkbox in the Edit co...

I solved it myself. I realised that I had to mention the data band name and then sum all three bands, like this:

{Sum(DataBand5, F_Claims.RowAmount)+Sum(DataBand3, O_Claims.RowAmount)+Sum(DataBand2, T_Claims.RowAmount)}

Thanks.

<t>I have 3 data bands with their individual footers. I have a amount column in all 3 data bands and I am using the Sum function in each footer to get the total amount for each band. However, I want a grand total to come at the end of the report which is the sum of all 3 data bands total amounts put...

Thanks it worked, Vladimir. However, I had to enclose the dates between single quotes like this if I used / or - as the separator: http://localhost/QuickStart/stimulsoft/index.php?stimulsoft_client_key=DesignerFx&stimulsoft_report_key=mySQLRpt2.mrt&DateBegin='2011/03/01'&DateEnd='2011/05...

<t>Dear Jan<br/> <br/> Thanks for the prompt reply. I am not using any code. The report is directly generated through the hyperlink.<br/> <br/> I have attached the mrt file and a small sql file. Can you please instruct me on how to show the records between 2 visit dates? In other words, I want to se...

<r>Hi.<br/> <br/> I am trying to pass dates as parameters to my mySQL report. After going through the forums, I have taken these steps:<br/> <br/> 1. In the SQL query, we have to prefix an @ in the parameter. I have done this and this is my query:<br/> <br/> Select * from visit_master, company_maste...

Its finally working! Thanks Vladimir for the excellent support.

I will be buying this product soon. The product is excellent and it is matched by a similar quality of support.

Regards,

Rahul

Dear Vladimir,

I have attached the log file. Please have a look.

Thanks.