Recent content by AndersonCJA

Thank you IanWaterman for the reply. I learned a lot yesterday and have it all working perfectly today. This can be done using Crystal reports. The query is using 3 different data sources. I did this using 11.0.0.1282 and using an ODBC connection. I signed on to the Datasource 02 - and...

I Have a Crystal Report that provides a correct listing. I Created a second report displaying the same type of information, but from another Data Source. The only problem is that the Key field is sorting in order in one report, then in order within the second report, and the person who uses the...

thread766-1767434 Able to link to Synonyms, using SAP Business Objects Crystal Reports 2013 Support Pack 1 Version 14.1.1.1036. This is how: Open Crystal. Click on File: Click on Options: Click on Database tab: Only these three are checked: Tables, Views, Synonyms Click on OK: Click on File...

If you want to print the record when {WORK_ORDER.PRINTED_DATE} is null you could try, ( isnull({WORK_ORDER.PRINTED_DATE}) or Date({WORK_ORDER.PRINTED_DATE}) = date(0,0,0) )

I'm not sure I understand so I apologize if my reply is not helpful. How are you currently pulling data for the current date? Are you asking how to print work orders on a specific date that is not the current date? If so, you could try Date({WORK_ORDER.PRINTED_DATE}) = Date(2016,07,27)

I looked at a report this morning to see if I could find other details to share that might help. I found that the linking is different from what I suggested/remembered. In my main report, the account number Key field is converted to a string in a formula field. That Formula field is linked to...

Hello, I have run into similar difficulties using different odbc connections. What has worked for me is to use a sub report for the other database connection. And, create a formula field in both the main report and the sub report and use the formula field to link from the main report to the...

hiffy, Thank you for your reply. Your blog post is informative and I will revisit my report commands and update them accordingly. At the moment, all seems great with the current set up, with a test database with less than 1k records. Thank you for the eye opener.

Hi briangiffin!! I am happy to get your response. To answer your question, it is a long form. It provides data from the data base while providing parameters for information that is different for almost every case. I looked into the option of doing this in Excel, but there seems to be a lot...

This little bug is really bugging me. Have any of you created a crystal report with over 65 parameters? I can reduce the number of parameters by 20 or so by specifying, 'allow multiple values' within some of the parameters, but I still have over 65 parameters. With using the - 'Allow...

To resolve the issue, the sql was created using the Non synonym table and tested in another database tool. Once it was working correctly, using notepad, the non synonym table name was changed to the synonym name. That query was then copied into a CMD field in the Crystal report.

In the Details Section Expert, check the box to format with multiple columns

Hello, is there anyone out there who has experienced this problem or might have a solution? The report has 110 parameters. The set parameter order screen only displays 65 of the parameters. It is difficult to sort the bottom 30 because parameters the cursor selection can not be seen once it...

I want to be able to select database location on an existing report where the Synonym is replacing another data source. Or, just create a simple report using the Synonym. However, the DBO schema is not visible. Using Crystal Reports XI version 11.0.0.1282 on Windows 7 Professional, and sql...

This is resolved. The fourth line was corrected by changing it to: ParamValue= (1) from, ParamValue= 1 <% myvariable ="init" if ParamValue= 1 then myvariable = "ABC" %>