ALSO, my fault, forgot to add that I have 2 subreports on this report that also need to show top n, would I do the same thing for the sub reports as I did for the main.
SORRY, I thought I was adding to the original.
Ok, have the parameter created...
Under report->group sort->topN->where N = 10000, where do I put the formula
if {?topN} <> 0 then
{?topN} else
10000
does that go at the group I want to sort on or where????
Crystal XI - Business Objects XI R 2
I have a report that has multiple parameters, I want to add a parameter so that a person can tell it to pull the top # or all of a certain group, what would be the easiest way to do this???
I have and excel document that has 2 worksheets, I want to be able to Protect the document so it's read only AND be able to track any changes to the history sheet which users can always see. Is this possible, I'm wanting to use this so that if changes are made by allowed users, all users can...
Crystal XI
I have the following stored procedure which I am using as a datasource, this works great for someone if they want to manually run this. I want to be able to schedule this thru the BOE system and have it automatically emailed out to certain recipients, I want the report to pull based...
Crystal XI
Have a report as follows:
Grp 1, DatabaseName
Grp 2, Table Name ACount ACost
Details are suppressed, what I need to be able to do is the following:
CASTLE
TICKET 25 3200.00
CAR 16 3185.00
HOTEL 13 3030.00...
I have done a search on a drive and it returns several hundred files with the specified details
File Name Director Size Mod Date Acc Date
I need to be able to print the results of this, any ideas???
I'm sorry, need a bit further clarification, when I join the two tables, on what field do I link and what type of link do I use, THEN, where does the function above go, in a formula??
I have to link together two tables, one is a tickets table with a ticket number, date, total cost etc..., the other is an airseg table with a ticket number, depart date, depart time etc...
I need to link the two together via the ticket number, however, there may be multiple of the same ticket...
I have a crosstab as follows in the report footer:
mickey mouse 0 0 0 1 2 3 6
donald duck 1 2 1 0 0 0 4
goofy 0 0 0 0 2 0 2
I want to be able to suppress anything less than 3.
I am VERY new to this. I have SQL 2000, there is a stored procedure that was previously created that I need to be able to run, I made some minor changes to it such as I want it to SPECIFY a date to look out but am not sure I have done that right either.
Below is the code, like I said I really...
Currently using Crystal XI, I have a data file that I need to export with some specific settings, not sure if Crystal can do this.
I need to export in a pipe delimited format, also need to specify field lengths, specific formatting.
Example
Field 3 represents a rate ($),
$13.00 needs to...
Sorry, not trying to be dense here but...
1. So join the tables
2. Do I put
TABLE1.Field 1 Table2.Field2
or should I set up individual formulas for each field?? If you know where I could find any good examples of this that would be a huge help.
Sorry, thought I gave version in Subject Line, it's Crystal XI.
So, for the 1st report I need to join to tables with a left outer on all fields or just one???
What do you mean by "Note that Left Outer fails when you also do a selection for the second table"
Thanks.
I have the following situation:
Table A
Table B
Table B includes ALL fields in Table A PLUS there are approx 20 custom fields added based on a DTS process that runs.
What I am wanting to do is create some validation/exception reports to show...
1. SHOW Ticket # where...
I am trying to import a txt file and append into a table and I keep getting the following error, any help would be appreciated. Access 2003
You entered an expression that has an invalid reference to the property |.
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.