Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. Lion3000

    We have multiple subreports with one parameter hardcoded for each one

    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 =...
  2. Lion3000

    Crystal - web reporting & Sql Server userid/password

    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...
  3. Lion3000

    How to divide a certain date record without affecting others.

    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>
  4. Lion3000

    Scaling fields

    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...
  5. Lion3000

    We have multiple subreports with one parameter hardcoded for each one

    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>
  6. Lion3000

    What problems are there with Running Totals?

    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...
  7. Lion3000

    How to identify underlying table and column names

    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...
  8. Lion3000

    How to identify underlying table and column names

    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...
  9. Lion3000

    I Need help with stopping at Nth record

    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...
  10. Lion3000

    Adjusting Label/Column widths and heights

    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)...
  11. Lion3000

    Changing text to date format

    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...
  12. Lion3000

    Grouping Order

    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.
  13. Lion3000

    Grouping Order

    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...
  14. Lion3000

    How to identify underlying table and column names

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

    How to identify underlying table and column names

    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...
  16. Lion3000

    How to identify underlying table and column names

    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...
  17. Lion3000

    Sharing variables and resetting value

    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...
  18. Lion3000

    print limited number of records in one page

    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...
  19. Lion3000

    How conditionally printing a label using Data Report (VB6.0)

    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...
  20. Lion3000

    Suppressing a subreport

    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...

Part and Inventory Search

Back
Top