Solved

Problem: Report only come out once in my application

Posted on 1998-08-28
2
143 Views
Last Modified: 2010-04-04
When starting the Report which is made with ReportSmith V2.5.1 in my application, It is OK for the first time, but It dose not come out if I start the report again and again in my application. There is no error message.

The details is as follows:
1) Application
There is a report control named Report1 and a starting report button in my Delphi application. Before starting the report, there are some report parameters to be setup as follows:
Report1.InitialValues.Add(S1);
Report1.InitialValues.Add(S2);
Report1.InitialValues.Add(S3);
Report1.Preview := True;
Report1.run;
 
2)Report
There are several report variables S1, S2, S3 in the report. These variables are SQL clause. Such as FROM,WHERE,ORDER BY etc.

Without these report variables (SQL is fixed), the report can be started as many times as you want in the application.

With these report variables, the ReportSminth Run_Time Viewer can be started repeatedly, but the report come out only once, and no more come out again even though you close the report and keep clicking the starting report button in the application unless you quit the application and start it again.

Thanks and Regards
0
Comment
Question by:liuzifang
2 Comments
 
LVL 1

Accepted Solution

by:
Marcius earned 100 total points
ID: 1337959
Try forcing the report InitialValues to clear before adding new values. You may be adding more values than the query is expecting and causing the error.
0
 

Author Comment

by:liuzifang
ID: 1337960
Marcius,
Thank you very much for your reply. I have solved this problem by clearing the report InitialValues before adding new values that is your sulotion to this problem.

Best regards.

Liu ZiFang  
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

The uses clause is one of those things that just tends to grow and grow. Most of the time this is in the main form, as it's from this form that all others are called. If you have a big application (including many forms), the uses clause in the in…
Introduction I have seen many questions in this Delphi topic area where queries in threads are needed or suggested. I know bumped into a similar need. This article will address some of the concepts when dealing with a multithreaded delphi database…
Hi friends,  in this video  I'll show you how new windows 10 user can learn the using of windows 10. Thank you.
Both in life and business – not all partnerships are created equal. As the demand for cloud services increases, so do the number of self-proclaimed cloud partners. Asking the right questions up front in the partnership, will enable both parties …

912 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

16 Experts available now in Live!

Get 1:1 Help Now