Search Results - CodeGuru Forums
CodeGuru Home VC++ / MFC / C++ .NET / C# Visual Basic VB Forums Developer.com

Search:

Type: Posts; User: Ned Pepper

Page 1 of 7 1 2 3 4

Search: Search took 0.01 seconds.

  1. Re: SQL Server 2005 query that uses the IIF with style date bool ?

    IIF function is not available in MsSql Server 2005. IIF was introduced in MsSql Server 2012 and newer, try using case statement. https://msdn.microsoft.com/en-us/library/hh213574.aspx
  2. Re: Show records for same date plus additional filter

    Hello,
    I am not sure what you mean by 'messed up'. It looks like you have the same record selection formula in the sub report as in the main report. I don't have access to your data, but from the...
  3. Re: Need help understanding an existing report

    Hello - Subreports do not necessarily have to be saved as separate report objects. If the report definition states there is a subreport, then there is a sub-report embedded within the report you are...
  4. Re: Calculate number of days between dates across months

    Not sure exactly what you are trying to get your report to do, but the DATEDIFF function will return the number of days between 2 dates. Combined with an input parameter, you should be able to write...
  5. Re: Need help understanding an existing report

    Hello Charlie - try exporting the report definition... File->Export->Export Report, and choose Report Definition. This will output all the formulas, commands and formatting options used in the...
  6. Re: Show records for same date plus additional filter

    By container report I mean the main report that will house (contain) the sub-report. You basically will use the same report that returns your exams as the sub-report, with different input...
  7. Re: How to to custom sorting based on row values?

    You can force a sort order using a formula like...

    if {TABLE.Products} = 'Television HD' then 'A'
    else
    if {TABLE.Products} = 'Home Theatre type 1' then 'B'
    else
    if {TABLE.Products} = 'Music...
  8. Replies
    1
    Views
    871

    Re: How to catching "data change events"

    You can find that a DML statement was executed on a table by querying ALL_TAB_MODIFICATIONS. That table will give you a count of inserts, updates and deletes. You could try turning on user session...
  9. Re: Show records for same date plus additional filter

    I would suggest you use a sub-report. The sub-report would be created from your existing report. You need a container report to house your existing report that has the exam parameter. When the...
  10. Re: Need to add a restriction to a current formula, but not quite sure how to do it!

    The error "A Boolean is required here" is returned because a formula is similar to a database field in that is must be of 1 and only 1 data type. The statement {ARTRNDETAIL.TrnMonth} =...
  11. Replies
    1
    Views
    527

    Re: Help with Report Form Manipulation

    Your report has several group header sections. The group header section with the text "TASKS" has a conditional suppression formula, and contains a sub-report. I would not recommend putting your...
  12. Re: How to go about adding new fields to a report when it's already crammed?

    The size of the report designer working area is controlled by the size of the paper you select in page setup. Crystal uses print drivers to control output format. One technique I have used...
  13. Replies
    2
    Views
    871

    Re: Documentation of Crystal_Reports

    One quick way to produce documentation is to select export report and under the export format, choose Report Definition (txt).
  14. Replies
    2
    Views
    1,039

    Re: Suppress section based on condition

    I think your problem is that you are attempting to suppress a footer sections based on the results of a formula within the footer section. If you examine your report output, and the underlying data...
  15. Replies
    6
    Views
    1,243

    Re: One Of Numeric Parameter?

    Hello - Difficult to trouble shoot your report here, but I would start by eliminating (comment out) any other parameters. I don't think you want to "Allow multiple values", as that turns your...
  16. Replies
    6
    Views
    1,243

    Re: One Of Numeric Parameter?

    If you have a string parameter named MyParameter, you can enter a comma separated list of numbers. Since the parameter is a string, you must convert your numeric field values to text to make the...
  17. Replies
    1
    Views
    814

    Re: two report design in the same page

    One suggestion is to, create two separate reports that return the results you show in each of the two grids. Then create a report to serve as a container that is formatted to use 2 columns. insert...
  18. Thread: Date Range

    by Ned Pepper
    Replies
    1
    Views
    1,149

    Re: Date Range

    You can use the recordnumber function to increment the date by 1 for each record returned, using something like

    {?ADATEPARAMETER} + recordnumber.

    This will only work if are displaying all...
  19. Re: Highlighting a date field within the next 5 days of that date.

    This isn't a Crystal issue, it is a date math issue. Your formula will highlight in purple any date the is greater than current date + 5 days, so Christmas 2099 would be highlighted.
    What you say...
  20. Replies
    3
    Views
    1,044

    Re: Crystal Report Division by zero error

    Hello,
    The values you are seeing are not related to the testing for a null and/or zero divisor. That test simply allows the division to take place. You will need to examine your data, and your...
  21. Replies
    3
    Views
    1,044

    Re: Crystal Report Division by zero error

    Hello,
    I suggest your testing on the divisors does not cover all possible values. In your first example you test for a null divisor, but not a zero value divisor. In the next 2 examples you test...
  22. Re: Display barcode as image within Crystal Report

    If possible, i suggest you do not store images of barcodes as images take up a lot of space and bandwidth. Instead, use the free Code 3 of 9 barcode font, and simply store the data you wish to...
  23. Re: Need Crystal Reports help - exception reporting

    Depending on the number of records in your table, Crystal may not be the best tool to use for this application. Under normal conditions, Crystal reads records in a continuous block, allowing you to...
  24. Re: New page after subreport finish printing

    It depends on where in your report you have placed the sub-reports. Assuming you placed the sub-reports in the details section, right click on details section in the gray area to the left of the...
  25. Re: Sort Group According to selection of group in crystal reports

    Not sure what your desired output is. The Group Sort Order formula will change the order of the data in the group, it will NOT change which data is selected to be grouped. In general, you need to...
Results 1 to 25 of 171
Page 1 of 7 1 2 3 4


Windows Mobile Development Center


Click Here to Expand Forum to Full Width

This a Codeguru.com survey!


HTML5 Development Center