I think the field heading is automatically created when the field is pulled onto the report. I don't know if you can break that link, however if you right...
This is one good use I've found for the Crystal For Eclipse plugin; it lets you change the data field being pointed to without having to delete & reinsert if...
Maybe a hyperlink to a report with subreports would work? From: crystalreportsusersgroup@yahoogroups.com [mailto:crystalreportsusersgroup@yahoogroups.com] On...
Seems like it's a matter of preference. To me, it's easier to just write a sql query than to figure out how to use Crystal formulas and all that stuff to do...
Yes, you are right that it is a matter of preference. I'm a programmer by trade, so learning the syntax for CR formulas wasn't too bad. (It still has way too...
At any one time, you can pull the sql from Crystal by clicking Database/Show sql Query, cut it and past it to any db editor/viewer (we use DBVisualizer). They...
I know, but I read somewhere that someone successfully did this by making it an On-demand subreport (similar to a hyperlink). I was wondering if anyone here...
Sorry, not here... ________________________________ From: crystalreportsusersgroup@yahoogroups.com [mailto:crystalreportsusersgroup@yahoogroups.com] On Behalf...
Can someone think of any possible way to accomplish the rpt that I described in my original post? Seems like it is impossible without being able to have...
I creating a report that contains several sections in it that come from different database tables. One section pulls lesson plan titles from a parent table and...
Thanks for reminding us what your problem is. Doing all this in CR is beyond my ability, but I'm not a CR power-user by any means. My only suggestion is to...
Greetings! A report I am working on has a formula that works, but I don't know why. Here it is: Sum ({charge_stats.charge_weight}) / Sum ({charge.numbercoils})...
Hi Janet, I think what you want to do is access the child tables using subreports. It is generally necessary to do this when multiple child tables each have...
The report has several different sections that are based on different data, so I can't create one view that will contain everything. That's the problem. Each...
I think the rule of "no subreport in a subreport" is valid even if you call it a "main report with a supreport in a main report". It might have something to do...
I created a parameter based crystal report (not very serious topic) with blobs that I use as a football pool at work. I would be willing to share this with...
Janet, This statement of yours triggered a memory: "For example, Lesson Plan 1 is associated with 3 Child A records and 4 Child B records. I don't know how I...
My sums behave the same way. That is the way I always understood it worked. For my purposes, that is a positive feature, not a problem. Thom Rose Controller ...
Yes, it's a positive feature, but it goes against my understanding of CR, which is already weak enough. I would like to understand why it works. I'm always...
I believe I tried this. The problem is that I couldn't get it to display as follows with Child A values listed first and then Child B values listed second: ...
"So if for instance your "method of instructions" is a string you can build a view with your Ktp's as variable that concats every method together with a ...
I won't be able to access the child tables using subreports if the lesson plan list is a subreport itself. You can't have subreports within subreports. So,...
Janet, I'm confused about what your data is, or where it comes from. Does "Ktp 1a" come from one of your Child lists? Let me see if I can state your goal in...
The lesson plan table is the parent table. Each lesson plan has one or more child ktp's. Each lesson plan also has one or more child methods of instruction....
Hi All, I am try to call a procedure with an array as a parameter.... If i pass pass a single parameter from crystal report to SQL procedure, its working...
Hi Sanjay , We had the same issue last month. Unfortunately, we had not found passing an array parameter to SP. So, we enforce the users to enter parameters...
The current report I am working on is connecting to an oracle database, and I am also running Crystal Server 2008 to an Oracle 10g db. When I try to publish...