Need some help linking parameters from amin to subreport.
The Main report takes 3 parameters
{?AccountNo}StringVar
{?ReportStart}DateVar
{?ReportStop}DateVar
The ReportStart & ReportStop Vars are just User inputs. They do not query against the DB, The AccoutNo does query the DB
I can Pass in...
I have the formula below in a SubReport. The SubReport is placed in the AccountNo GroupFooter of the main report. I am looking for the correct syntax to pass the main report AccountNo to the formula in the subreport??
IIf({tblAutoRaw.dtAction}={?ReportStart}AND[Mainreport.AccountNo =...
Here is what I have. One group named accounts.
What I am doing t is some calcualtions for each account and putting the results in the GF. No problem there. What I am having a problem with is this. The detail section suppressed, I just want a summary so the account calcualtions are placed in...
Having difficulty with 2 unbound controls on a form. One is a combo (cboCanister) populated by a query, the second is textBox (txtQTY) which allows direct user input.
First problem is the textbox. After the user enters the value and exits the box, the onExit Event fires and sends an Id from a...
I am missing something while trying to pass a shared var from a subreport to the main report and don't know what it is I am overlooking. Here is the setup
Main report has 2 groups account(character) and dmsid(character)
The linkage between the sub and main is
{tblConsultants.szdmsid} =...
I seem to be having trrouble creating a subtotal in CR 8.5
Here is the scenario
I have one group
I have one formula @Zone1
WhilePrintingRecords;
NumberVar TotalSec := {Results.LCTIME};
NumberVar Days := Truncate (TotalSec / 86400);
NumberVar Hours := Truncate (Remainder (...
I need to suppress the detail section when drilling down, here is the scenario.
I have three groups
account(G1)
Salesperson(G2)
Customer(G3)
I have suppressed all the 3 group headers
The detail section is salesperson, purchase date, last contact
GF1(Count of all customers)
GF2A Hide suppress...
I seem to having a problem getting rid of my decimal point & 00 with this formula
ToText("Total Customers Not Satisfied")+" " + CStr(Sum({@TotalRecords},{results.accountno}))
If I remove the CStr it tells me a string is required here
The output is Total Customers Not...
Can anyone tell me why when I save a report to a .snp(snapshot) that the x & y values in my report chart vanish into thin air when viewing the report with the snapshot viewer. The rest of the report is fine. We are running MS Access 97
Thanks
Our report is grouped on salesperson and what I want to do is have the page header visible when I drill on a name, right now it disappears and all that shows is the details section,any suggesstions? I am using CR8
thanks
Help,
I keep getting this error everyday on the report server. It forces me to reboot the machine daily to make it work. We are running cr8 on a win2k advanced server and the permissions for the crystal page server and the web componenet server have full admin priv's on the machine. I have set...
I could probably find this if I searched but I have a fast project deadline with not enough time...you know the drill...anyway
How would one display the message in the report "No data found for this report" if there was no data returned with the user supplied parameters?
thanks
I have checked every possible permission setting that I can think of. I even created a user call CrystalReports, gave it administrator privs to login to the page server and just about everything else..still will not serve up the page?*(@$!)@
Thanks,
I did notice that it is running under the local system account as you said. I changed it to allow the machine to run it and it keeps reverting back to localsystem...idunno?
the permissions are wide open too and still will not run.
I have installed crystal 8.5 and the Crystal Enterprise that comes with it.
I have a report in a web directory
c:\inetpub\wwwroot\crystalreports\bsv\ssr.rpt
When navigating to the url http://myserver/crystalreports/bsv/ssr.rpt
I get the following error:
File...
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.