I'm looking for the easiest/quickest method to accomplish the below:
Column A B C
row 1 ='1'!$T$58 ='1'!$B$60 ='1'!$C$30
row 2 ='2'!$T$58 ='2'!$B$60 ='2'!$C$30
row 3 ='3'!$T$58 ='3'!$B$60 ='3'!$C$30
...
row 50
I have...
Hey All,
We have a domain setup at work, I'm playing with our first Vista machine on the network now.
I have it logged into the domain, but when trying to switch users/log off between the domain user profile and the 'this computer' profile it doesn't give me that option.
In XP Pro during the...
Hi all, using CR10:
I'm running a formula on a DateTime formatted table.
We have Drug Dates entered on the day they took a test. I'm trying to write a report that will let us know when a drug test is expiring within 30 days or if it has already expired. Drug Test's are good for 1 year exactly...
Hi all,
We currently have SBS 2003 with Exchange 2003 setup at our work. At work we have them log into the domain to grab their e-mails, files, etc.
For users to access their e-mail remotely we have a terminal server setup that they log in to.
I am wondering what are my options to have them...
Hi all, I'm use to dealing with SBS Server and AD, but I'm trying to help a group that does not have a Server.
Here is there layout:
They are networked on a WORKGROUP
15 XP Pro computers - most are single login users
1 XP Pro computer holds ALL the shared folers
The user's then access the...
Hi all,
Have a user with XP Pro, Crystal Reports 10 Dev. and every time she opens a report it crashes. It gives the CRW32.exe crashed error.
To my knowledge no new programs were installed. I un-installed CR 10, reinstalled, with no luck. (It has been working fine for months)
Should I try to...
Hi all, using CR 10...
I have several sub-reports within the report footers of a report.
Is it possible to change a label's text in the PAGE HEADER based on which Report Footer is being displayed on the current page?
I have 3 different report footers (with sub-reports in them) that have I...
Hi all,
Crystal Reports 10... MS SQL DB,
I have in a detail line these fields:
Date1 and Money .... then to the right a couple of date columns. These columns are generated by taking the CURRENT date, then adding a week to 1st column, 2 weeks to the 2nd, and so on. It looks like this:
Date1...
Hi all, using CR 10...
Details of report:
Group #1 Header
details line (usually 2 detail lines, either a "I" or "R" req. mode)
Group #1 Footer (has some calculations)
I have a formula in details (@curmi) that does this:
if {ET_REQ_HISTORY_HEADER_MC.Requisition_Mode} = "I" then...
Hello all,
I have a multiple value parameter coming in from a VB.NET app. I want to use it in my select formula for a CR 10 report.
For example the parameter (@cat) will be a string and contain something like: "A", "B", "C"
Then in the select expert formula in the report I have this...
Hi all, i'm going to post this here and in the VB.NET section to see if I can get more help on both sides.
Anyway, here is what I have:
I have a small vb.net app that runs reports made in crystal reports 10.
There is one report that has multiple selections for a parameter in the report. So...
Hi all, i'm going to post this here and in the Crystal Reports section to see if I can get more help on both sides.
Anyway, here is what I have:
I have a small vb.net app that runs reports made in crystal reports 10.
There is one report that has multiple selections for a parameter in the...
Hello all,
I have a basic .Net app that pushes a string (strCat) over into a crystal report 10 parameter {?@cat} .
The app has a bunch of checkboxes, once the user checks them and wants to run the report this code runs:
Public Sub checkboxes()
strCat = ""
If CheckBox1.Checked...
Hello all,
I have a basic .Net app that pushes a string (strCat) over into a crystal report parameter {?@cat} .
The app has a bunch of checkboxes, once the user checks them and wants to run the report this code runs:
Public Sub checkboxes()
strCat = ""
If CheckBox1.Checked =...
Can you use the PICTURE() function, or something else, to only show the last 4 digits of a social security number?
Thanks for any help...
Picture({Social_Security},"_____9999")
Using CR 10...
I have a formula in a GROUP FOOTER #2 that makes some calculations:
whileprintingrecords;
numbervar sumC := sumC + {@rated};
Based on criteria the FOOTER #2 will either show or be suppressed.
In the Group FOOTER #1 I have this: whileprintingrecords;
numbervar sumC;
Now, the...
hello all,
using CR 10, I have a DATE parameter (@enddate) where user's enter a date. I then want to use it at the end of this formula:
Round((datediff("d",minimum({ET_REQ_HISTORY_HEADER_MC.Requisition_Date},{ET_REQ_HISTORY_DETAIL_MC.Equipment_Code}), {?@enddate}) * .7143),0)
Though, it...
Using CR 10, MS SQL DB
Group Header #1 - grouping by a JOB number
Group Header #2 - grouping by a EQUIPMENT number
Details - Will either have 1 row, or 2 rows.
1 row could be an ISSUE on X Date
2 rows could be an ISSUE on X Date, and RETURN on X Date.
Group Footer #2 - I am calculating the...
hi all,
using CR 10 w/ MS SQL DB.
I have a report that shows invoice #'s and amounts in the detail section of a CR report.
There is a table called DI in the database that holds the path and filename of the scanned image of that invoice (by invoice #).
I want to create a file hyperlink on...
Hi all,
Using CR 10, MS SQL DB:
I have a report that adds billings together from different periods for Jobs, and then grouped by State (in which the job was done).
I want to be able to select the periods as a selection range. So instead of all 13 periods adding, I want to just do period...
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.