Search results for query: *

cis12232004 (TechnicalUser) 22 Nov 05 12:03 I have a standard solomon report that I am accessing using solomon 5.5. I want to amend this report using crystal 8.5 but herein lies my problem. Once I saved the report on my hard drive, I tried to access it using Crystal but whenever I tried to...

I have a standard solomon report that I am accessing using solomon 5.5. I want to amend this report using crystal 8.5 but herein lies my problem. Once I saved the report on my hard drive, I tried to access it using Crystal but whenever I tried to open the report I received the error message...

This is what is located in the Record selection: {vr_10630.RI_ID} = ToNumber ({@RI_ID}) and {vr_10630.StkItem} = 1.00 and {RptCompany.RI_ID} = ToNumber(RIPARAM( "RI_ID" )) The Group formula is blank. This scenario is repeated for both the report that printed blank and the one that printed...

I am using Crystal 8.5 to create a new report that can be accessed through Solomon 5.5 and I am using SQL database with an ODBC connection. The problem is the report prints sometimes and then other times a blank report prints. I copied out the SQL statement on a couple occassions and what I...

Thank you for your comments but my report is working as it should.

Thanks gentlemen but I finally figured it out. I generated the table using SQL, exported it to Crystal, made some adjustments and then put it in the solomon user folder for use. Worked like a charm.

LB, when I go into Report Expert and try to link to table to the existing report I keep getting an error and crystal report closes. Any ideas what could be causing this? I have used report expert to customize other reports without any problems. By the way, that is the reason I attempted to...

cis12232004 (TechnicalUser) 27 Sep 05 12:56 I am attempting to customize a report in crystal 8.5 but everytime I connect to the SQL7 DB and add the new table my report closes out. I tried to manually add the SQL statement to add the table and field as well but I got an error. I am not well...

I am attempting to customize a report in crystal 8.5 but everytime I connect to the SQL7 DB and add the new table my report closes out. I tried to manually add the SQL statement to add the table and field as well but I got an error. I am not well versed in how crystal responsds to SQL so can...

Jcfx, I thought I should use that because that is what the fields are made up of on the report and because it provided some commonality between the two reports. And, yes, your example portrays a good example of what I want these reports to do.

Fields for the @Inventory formula in the subreport report are: Transform({PurOrdDet.InvtId}, RIPARAM( "SegInvenMask" )) + " " + {Inventory.Descr} Fields for @Inventory formula in the main report are: Inventory Trim( Transform({vr_10630.InvtID}, RIPARAM( "SegInvenMask" ))) + " " +...

lbass, your patience in helping me resolve this issue is commendable. I did as you suggested and the information from the subreport is not showing at all. Question, eventhough the two fields have the same name, they are made up of different data, would that affect the outcome of the report...

LB, it's me AGAIN! I have been working on this report and there is still a problem with linking. The two reports have one field in common and both fields also have the same name @inventory. When I go to Edit/Subreport Links, I choose the @inventory as the field to link to and I am not...

In group footer 2, the main report should display the inventoryID and Description, Ending Balance, the Usage for the period, Unit Cost and Extended Cost, which it is now doing. In group footer 1, the subreport should display the inventoryID and Description, VendorID and Name, PO Number, PO...

Ok, the subreport is in the group header and the information for the main report is in the group footer. There is nothing in the details section and the totals are in the report footer. The result I am receiving is just a repetition of the subreport. I don't see any of the data from the main...

lbass, I apologise for all these questions but this is my first attempt at doing subreports and it is really challenging me. These are the steps I am taking to create the report: 1. Open the main report. 2. Insert the sub-report in the Group Footer section of the report. 3. Go to edit...

lbass, thank you so much for your suggestions and patience. I linked the reports as stated and now I have another problem. I have more data in the primary report than the linked report. Is there anyway I can get all the data from the main report to show that don't have any corresponding data...

I have a problem, I grouped the report as suggested, but what is happening is that no matter what section I put the subreport, it is still duplicating itself 20 times or more over and over again. Am I missing a step?

Okay, I tried the subreport and ran into a problem. I have inventory IDs on both reports and I want these to be together. Right now I have an inventory ID starting with 100 on page 1 and a similar item on a separate page. How can I bring like items together so that the report flows smoothly...

Will try that, thanks lupins46!