Search results for query: *

I understand. Thanks so much for your time (and knowledge!)

In the main report, Group one is by Client ID, Group 2 is by Transaction Created Date with a change on Year. The subreport is in GF 2 and the linking formula date (transaction created date) is in GF1. The linking formula (invoice date) in the subreport is in the Report Header. In the record...

Based on your last post, I just realized I left out an important piece and maybe it's the reason why it is working with the date(year({table.field}) syntax. The date formulas are my secondary subreport link. The primary subreport link is on Client ID. Sorry about that - I hope I didn't waste...

Actually, I am linking the transaction created date in the main report to the invoice date in the subreport. So, I am not using identical fields between the two reports (although they really mean the same thing). When I use the date(year({table.field}), the year of the subreport invoice date...

It is Date/Time format in the main report which is using an Access table and the matching field in the sub is Date format using a table from a different database.

Odd - I changed it in both the main and the sub and I get an error, "a number is required here" in the main report.

If I want to change this formula to use it strictly for the year (dropping the month piece entirely), would I have to do something similar or could I just use: date(year({RHEADER.INVOICE_DATE}) I an using this formula as a subreport link...

Thanks!!

Version 10, W2k I've been asked to modify a report written by someone else and I was wondering if someone could tell me what the "01" variable in this formula represents: date(year({RHEADER.INVOICE_DATE}), month({RHEADER.CREATE_DATE}),01) Thanks!

No wonder I've never heard of it! Duh!! Thanks for your help.

IdoMillet, Thanks, that's the answer I was looking for! However, I wasn't even aware you could use a parameter to tell the report what export format you want to use. What else might I need to know to set the parameter up? Sorry - I must sound like I'm a real newbie!!

Pardon me for being "thick" but I don't understand the statement, {?My PDF or Excel parameter} = "Excel". I know how to conditionally supress but could you dummy down the syntax for me? Thanks!

I am using version 9 (9.2.2.693) and I can export my field headings by unchecking the "simplify page headers" option in the excel export dialogue box. However, I also get my report header. I can't do away with the report header because I need it for printing in PDF format. Is there any way to...

I am using version 9 and when I increase a font size on a text field, the placeholder does not increase vertically to accomodate the larger size. I enabled "can grow" but that only takes care of the increase horizontally. I have to manually drag the placeholder just a tad to make it large enough...

The subreport is in the group footer of the main report. It is linked by account number. I know they are inefficient and I know it will run for every group footer instance but in this case it couldn't be avoided. Subreports are available as a workaround when certain data can not be accessed in...

I am using Crystal 9. I have a report that contains one subreport. After the main report preview is complete, I try to save the report and I get a message that says all the data has not been generated for saving (something to this effect) and do I want to generate the data? I hit yes and it...

Ken - there are no subreports. And unfortunately there are thousands of reports here and that's why we haven't been able to nail down the contributing factors such as complexity, formula evaluation or formatting issues. However, I think it's safe to say that at the present time, we don't see a...

Thanks Ken. This group of report writers rarely uses the page x of Y feature. Deadlines for reports often result in many "quick and dirty" reports that don't contain a lot of formatting. So, the majority of the reports here are page 1 of 1+ They may not be pretty but the complexity...

This occurs on some reports and not others and we haven't isolated the factor that contributes to it but when some reports are done running in preview mode, you can navigate directly to the last page with the navigation buttons. On other reports you press the button to go directly to the last...

I recompiled and redistributed the report with no saved data. I logged into the client machine as administrator. It still did not work. The specific message I get when the setup starts is "Could not write to c:\winnt\system32\ctl3d32.dll because it is use by another application. Close all...