Hi Code fixesers,
I am trying to get the first and last record in a group.
E.g Group Records
X 4300
X 100
X 3000
My answer should be 4300 after processing per group.
Please Help.
SLM2004
When you say that the tables are unlinked, do you mean they have no fields which are related (eg Account_No appears on 2 or more of the tables)?
If the tables cannot be linked then I would suggest you follow synapse's suggestion of subreports. This would require a main report and 4...
Hi Mark
What about doing this. In your grouping editor dialog, set the sort order to "In specified order". Then put them in the order High, Medium, Low. Then on the "Others" tab set to discard all others...
That might also work.
Hi Peter
Is it not possible to have some code running which actaully creates a TABLE with all the data you need (as opposed to a view or sp)? Eg some VB code which creates a table and populates it with the data you need.
Apologies! DTS stands for data tranfer service (or something similar) and allows you to transfer data between similar or different databases. Basically all I want to do is get some Sybase data into Oracle but on a regular and automatic basis.
Thanks
Hi all
Is there a function similar to DTS in MS SQL server in Oracle? I have a requirement to get data from a Sybase database into an Oracle database on a regular basis in order to be able to report on it using Crystal. Ideally I would like to have all the required data in a single database...
Hi all
We used to use Crystal 6 (which requires that you print the reports onto dinosaur-leather parchment) to export our report to a text file automatically (via another program). Then this exported document is read into another application (app B). Now that we have upgraded to V9, we are...
Thanks Ken! Just for others' sake, the setting you mentioned is under file, options reporting tab where you will see an option called "Update connected repository objects when loading reports".
Hi all
As I understand it, the repository data is stored in a database. If you make a change to an item in the repository, every report that uses that repository item will be affected.
Is this all correct?
Then my next question is, what would happen if you created a report with a few...
What about having a shared variable on the subreport which evaluates to True when the subreport in question is empty. Then use this to suppress Eg the page footer (if there is one) IN THE SUBREPORT, as well as on the main report. It may well be a case of the page footer or report footer on the...
I have a feeling that should you put in any criteria on the right hand table in a left out join (eg Table1 left outer join Table2 and then in eg your records selection criteria specify that table2.name like "*THIS*") you can have a problem. I don't know whether this is a bug or if I...
Hi all
I have posted an FAQ (faq149-4496) which details a method for preventing virtual pages in cross tabs. I hope some of you might find it useful.
Cheers
Hi
We have all had to deal with the ANNOYING problem with virtual pages when doing a cross tab. Virtual pages are created when the number of columns in your crosstab becomes so many that it spills over horizontally to form Virtual pages. These pages have no page numbers and are not counted...
Thanks Ido. I was kinda hoping to avoid creating a new table but it seems it may be the best route to take. Now as a related question, what is the best way to create this table. I am thinking that we have a table for days with a days column and a month_grp column, so that we can have 1 to 31...
Hi. I have posted this in the crystal formulas section too! Sorry to those that lurk in both sections. I would like to group by the day of the month such that EVERY day of the month is shown regardless of whether there is data for this day or not.
Firstly, this report is run for a whole...
Is there something specific about this record that you could use to select it from all others - thereby making this record the only one on the report before you export to PDF? You could use a parameter field to prompt the user for input so that the report would be dynamic and could be reused...
Hi. I would like to group by the day of the month such that EVERY day of the month is shown regardless of whether there is data for this day or not.
Firstly, this report is run for a whole month only. (ie only Jan or only Feb etc) I have data reported for samples that are logged in on...
Tom, Crystal uses sections and evaluates things differently in these sections. The report header(RH) appears only at the top of the first page of the report and is the partner section to the report footer (RF) which appears on the bottom of the last page. Page Header (PH) appears at the top of...
Madawc, that is an interesting suggestion. Unfortunately, I can't do that because I need this repeated ONCE on EACH page, so I can't put it in the RH since this will only appear on the first page and I don't want to put it into a details or group section since this will appear more than once...
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.