I'm still kind of new to Crystal, so I'm not 100% sure of your terminology, but I've verified (by printing the value of the parameter on the subreport) that the value is, in fact, making it to the subreport. Here's the subreports record selection formula...
Folks;
I've got a main report with multiple subreports. The subreports are passed an id as a parameter. When I check the preview (in Crystal) it works fine. When I run it through VB6, the 2nd and 3rd subreports work fine, the 1st and 4th don't find any data.
I've verified the parameters my...
Oh, wise ones...
When running a Crystal report (8.5) with several unavoidable subreports I'm getting the error "This field name is not known." Unfortunately, there is no other descriptive information in the error. Everything I've seen from a Google search says the problem is with my selection...
MrBill;
Unfortunately, subreport 1 contains a detail-type listing showing multiple records which are actually TOTALS by master account of the details listed in the main report by sub-account. Yep. The boss wants the totals FIRST!
Quite a pain for an old Cobol dinosaur.
Thanks for the...
Hi, wiegelman;
This may be kind of out there, totally off-base and DEFINITELY inefficient, but how about creating a subreport that runs before the detail that does exactly the same thing as the main report (but only for the "current" customer.) Using a shared variable, when it returns, check...
Thanks for the speedy response.
I still need the 2nd subreport to print after the 1st one, though. How would that work?
Unfortunately, because of the way the boss wants the report to work, the subreports seem to be a necessary evil.
Thanks again.
MikeTheDinosaur
Folks;
Is it possible to supress two subreports based on a total calculated in the 2nd subreport? I have to be able to conditionally supress the detail items (subreport 1) and the summary and analysis data (subreport 2) based on net profitability that's not calculated until the end of...
When a group footer is being printed, is ther a way to "know" a value in the next record that's going to print?
I need to increment a value and conditionally turn off a group header based on a value in the next record.
Using CR 8.5 and MS-SQL.
Thanks in advance.
[thumbsup]
MikeTheDinosaur
Folks;
In case anyone's interested, I figured out my solution.
To refresh you memory: my group header has a bitmap (about 3.5 in. high) which underlays following sections. My group break is by machine. I must print no more than 10 detail lines (products, in this case) over the bitmap...
Folks;
Is is possible to append a uniquely-valued field to a data set? What I'd really like to do is add a serialized (1, 2, 3, 4, etc.) or even randomized field as the last field in my result data set using an SQL stored procedure.
I'd like my result to be:
MachA ProdX 1
MachA ProdY...
Thanks for the quick response. Unfortunately, what I need to do is force a group break, not necessarily a page break.
Will the same kind of thing work?
Sorry if these are lame-o questions. I'm still kind of new to CR formulas.
Thanks again.
Mike [bigears]
Folks;
I need to be able to force a group break in CR 8.5 if I detect a certain condition in the data. Unfortunately I also need to have the already defined group break in place, too.
The condition I need to detect, is: if ten detail lines have printed, I want to perform the group break. If...
I guess I was trying to avoid drawing the whole thing out. Here it is. I've drawn a bitmap that I'm going to use as an underlay. I'm going to write data on top of it. The paper I'm using is perfed into thirds. The bitmap fits three times on a cut-sheet page.
If my data is this:
MachA...
Thanks for both of your suggestions. Things are VERY close. My remaining problem is, there are three of my forms to a page. The group is only printing one time per page.
I know this is probably very simple, but the solution continues to elude me.
Thanks again for your help.
- Mike
Manu;
Just a couple of days ago, I had the same problem. You've probably already thought of this, but all I had to do was make sure the parameter field itself existed on the report somewhere (in my case, I just dragged it to a suppressed section).
Hope that helps.
Mike
Hi, folks;
I've got what I think is an unusual problem with printing a "special" form in CR 8.5. I'm trying to print a route card for vending machine techs that list the products in the machine on the card by underlaying a bmp under my data. Works like a charm except for the fact...
Thanks. I suspected as much. Your answer now makes this a Crystal reports problem, I guess. I'm trying to print a "route card" for vending machines that need filling. The machine info need to print once with as many as five products printing on the card. I guess I should go to the...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.