Search results for query: *

Here is the ASP code that lets you pass parameters to you report: Set Session("ParamCollection") = Session("oRpt").Parameterfields Set Param1 = Session("ParamCollection").Item(1) Call Param1.SetCurrentValue (CStr(FromDate), 12) Set Param2 =...

In ASP code, you would pass the username and password to &quot;LogOnServer&quot; method as follows: Set Session(&quot;oApp&quot;) = Server.CreateObject(&quot;Crystal.CRPE.Application&quot;) Session(&quot;oApp&quot;).LogOnServer &quot;pdsodbc.dll&quot;, &quot;<DSN>&quot;, &quot;<Database...

Can you write more details, please? <p>Ossama Gharib<br><a href=mailto:ogharib@link.com.eg>ogharib@link.com.eg</a><br><a href=http://www.linkdev.com>Welcome to Link Development</a><br>

Why do not you create formula to be so? It is very easy, just divide that number by 100 to get the 2 decimal places you want. The formula would be as follows: 00123450 / 100 Does this answer your question, or were I not able to understand your question? I hope that would help. :-) <p>Ossama...

Can you write more details about your problem? It is not clear from your question! <p>Ossama Gharib<br><a href=mailto:ogharib@link.com.eg>ogharib@link.com.eg</a><br><a href=http://www.linkdev.com>Welcome to Link Development</a><br>

First of all, you have to define your need. After that, you can choose the method of reach your goal. Using Running Totals is a straight forward procedure, but you have to make sure: When to Evaluate and when to Reset. For default, you evaluate for each record. Sometimes, you need to evaluate...

I think you do contact your database administrator to limit the access for any person you do not want to view certain tables. As for the meaning names for the columns, it can be done from the database, that is, create a meaningful names for the columns when creating the database. For sure, the...

You only display the columns (or database fields) that you want in your report and change the column names displayed in the report. For example, a database field (column) with name &quot;States&quot; and the records would be displayed in the report as follows: States AZ CL and so on...

Just using the &quot;Format Formula&quot; (x+2) from the &quot;Format Section&quot; under the pulldown menu: Insert -> Section. Click on the button (x+2) beside the Suppress (No Drill-Down) for the section that displays the records, normally, Details section and write the following code...

If I got what you meant by your question, when you select a Label (I assume you mean a Text Object), you could use the pulldown menu Format -> Object Size and Position to do what you want. Similarly, you could have access to the same feature by using the context menu (right-click mouse menu)...

You can use a very simple way to accomplish what is needed. Just use the DateValue function. As a simple example, do two formulas as follows (you can use one formula only, it depends on your needs): The first formula would create a StringVar variable and store the date with the format...

If I understand you correctly, you want the people who are not assigned to any state to be grouped at the end of the report. To be more precise, those people would be displayed in the last group in the report? Please write more details. I hope I would help.

As far as I know, the main sections in any report (Report Header, Page Header, Details, Report Footer, and Page Footer) have fixed locations in the report. As for any Group, it would be located between the Page Header and the Report Footer. You can not remove a group from that fixed location...

MalcolmW is right. Thank you, MalcolmW. Sorry nickdaniels for my indirect way in representing the problem.

What I understood now is that you are not the only one who worked with that report. The first report had the database fields insert in the report with meaningful names as you assumed. Let us say that the table used has name &quot;Statistics&quot; and that person who worked with the report before...

I did the same thing: created two different reports based on the same database. In both reports, the database field (what I assumed that the word &quot;item&quot; in your question means), in my example, on a table named &quot;Banks&quot;. I used the same database field &quot;Bank_id&quot; and...

You must use 3 formulas to achieve your goal: one formula for initialization, another formula for evaluation, and a third formula for display. You have no problem with the display formula: WhilePrintingRecords; Shared CurrencyVar PeriodDifference; The problem is with the formula that...

It is simple to do what you want. Just use the &quot;Format Formula Editor&quot;. You can found it when you open the &quot;Section&quot; part under the pull-down menu &quot;Insert&quot; -> &quot;Section&quot;. Go to the section you have the records displayed in, normally, the...

You can do this by write a formula in the Format Editor under object format and suppress section. Enter the formula that you want in order to suppress the label when the formula returns true. Click to the &quot;X+2&quot; button and write: cust_no >= 100 and the same formula for the actual value...

What I did to solve such problem is to suppress all sections in the subreport. That would make the subreport &quot;suppressed&quot; in the main report. Now, you can pass any variable in the subreport and pass it to the main report using the &quot;Shared&quot; type, for example: Create a formula...