Search:
Type: Posts; User: Ned Pepper
Search:
Search took 0.05 seconds.
-
February 20th, 2020, 12:49 PM
Crystal Reports must first connect to the database before it can process any data. Therefore, you cannot use a parameter to control which database CR uses. However, you could create a view, or...
-
As long as you can 100% rely on the text always being in the field at the same relative positions, then you can use the text as anchor points for extracting portions of the string:
formula1
...
-
This look like a job for sub-report. You can create a report with a group based on your invoice, so that you only have the first record returned in the group header (or footer if you like). Place a...
-
January 26th, 2018, 04:27 PM
This can be done using page headers. You need a long page header that is as long as your printed page. Place your "intentionally left blank" text box in the long page header. Use a conditional...
-
October 20th, 2017, 10:20 AM
It is difficult to understand your issue from the example. In general, you can insert a summary field into a report in either a group header/footer, or in the report header/footer. If you insert...
-
September 22nd, 2017, 09:59 AM
I think when you select a specific date, Crystal can "push down" the record selection formula to your database server. But, when you use the function to determine the date of interest, crystal...
-
September 12th, 2017, 10:21 AM
I don't think there is enough info here to really provide an answer. First - what is the "trouble" you are running into? is there an error message, or is the output just not what is expected?
...
-
July 14th, 2017, 09:48 AM
You could try HVR from https://www.hvr-software.com/. It is a change data capture/replication tool, but it also will compare databases row-by-row across different DBMS. They support Teradata, MySQL,...
-
You can insert multiple detail sections (right click in the gray area to the left of the Details section and choose Insert Section Below). A typical use of multiple detail sections is to allow for...
-
I don't think you are correctly describing the problem. Crystal reports allows for multiple sub-reports, but will not allow you to insert a sub-report into another sub-report.
If you want to...
-
June 16th, 2016, 10:34 AM
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
-
June 14th, 2016, 10:07 AM
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...
-
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...
-
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...
-
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...
-
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...
-
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...
-
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...
-
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...
-
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} =...
-
April 26th, 2016, 12:17 PM
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...
-
March 11th, 2016, 11:49 AM
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...
-
March 11th, 2016, 11:38 AM
One quick way to produce documentation is to select export report and under the export format, choose Report Definition (txt).
-
December 23rd, 2015, 10:59 AM
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...
-
December 23rd, 2015, 10:49 AM
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...
|
Click Here to Expand Forum to Full Width
|