Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

Problem: Report only come out once in my application

Posted on 1998-08-28
2
Medium Priority
?
151 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 1

Accepted Solution

by:
Marcius earned 300 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

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

Question has a verified solution.

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

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…
Objective: - This article will help user in how to convert their numeric value become words. How to use 1. You can copy this code in your Unit as function 2. than you can perform your function by type this code The Code   (CODE) The Im…
In this video, Percona Solution Engineer Dimitri Vanoverbeke discusses why you want to use at least three nodes in a database cluster. To discuss how Percona Consulting can help with your design and architecture needs for your database and infras…
In this video, Percona Solutions Engineer Barrett Chambers discusses some of the basic syntax differences between MySQL and MongoDB. To learn more check out our webinar on MongoDB administration for MySQL DBA: https://www.percona.com/resources/we…
Suggested Courses

722 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