I need to use vba in ms access to open a crystal report 11 which is linked back to a query in that mdb.
All of the resolutions i read refer to viewers on the access form. I'm not using any...
I am fairly new to Crystal reports, so unfamiliar with SQL and limited in Crystal formulas. Keep running into the same problem.
I work in a health office, and need to find clients who are no...
I have an app written in vb.net 2008, which prints a crystal 10 report to a Zebra label printer. The report is not embedded in the app, it is pulled from the network. I have not been able to p...
Hello,
im using crystal reports 2008 and id like to know how to make the reports executables, rather than the rpt file. SO when i click it the report would open without opening the crystal re...
how to parse the following value. It's coming out of a single field from one table. But i need to separate this out n have the values in different columns in my report.
Column (As is in dat...
We have a large 3rd party SQL database on a SQL Express 2005 server. We need a report that in essence pivots the data from a row base to columnar. The data we need is structured as below:
...
As Before, I have 3 subs, each with Group1 - Parent, Group2 - Child and Details. Thanks to mlmcc, I can get the Total for the detail section of all 3 reports together. Now, the new want...
...
I have a database which I have a parameter prompt on the account number. I need to pull the first occurance of a field in another table. I want to pull the occurance with the oldest date on it.
Here is my formula:
DateAdd( 'm', -1 , {Date})
The Date field in my report is always the last day of whatever month and I want the formula to give me the last day of the previous month. S...
I have a C# Web project that involves storing Rich Text Editor content (HTML is being stored in SQL tables).
Example:
SELECT Title FROM MyDatabase.dbo.FancyTable ===>
'<a href="http://w...
I have a string range parameter used for sorting. If the user does not choose the "Name" option as a sort value, I need to insert it at the end of the sort parameter manually. I'm not sure h...
2 part Question:
1) I have a Crystal Report in which I am trying to count the number of apartments that were vacated. The problem is that for couples, there are actually 2 seperate records...
Hello Experts,
Is there a way for me to create a date parameter that will always retrieve records from an Oracle database which have a date value equal to the next day (DateTime field). If t...
if {BillInfoMain.iCompanyID}=1 then "Wideners Ambulance Service" else
if {BillInfoMain.iCompanyID}=2 then "Bland County Rescue Squad" else
if {BillInfoMain.iCompanyID}=3 then "Bad Directory"...
When I use the split function it works great; however sometimes the field I am splitting contains ' '' ' and I get an error. I try to handle the error but it doesn't seem to be correct.
Hello Expert
I have a sitatuation where I need to add an image to the report, the image has fixed dimensions and I must have the same height and width for the report so that when I print I ge...
I have 2 tables with 1:N replationship:
Table 1:
Rec_Id Name
Table2:
Ord_Id Rec_Id Price
Please help me how to create report with this relationship (1 page ...
Hello Experts,
I'm working on a report that queries an Oracle database, and I'm trying to come up with a formula that will return the next date value that occurs after the current date. For ...
Crystal 10: I created a report that groups all tickets for each client. I am trying to figure a way of updating the report so that it prints all clients with new tickets submitted within 90 ...
I need to do the following:
Search for a specific record type in a subreport (on a secondary table). If the record type is found, I store the date on that record in a variable to display o...
Im wanting to create a select expert formula that will only show records that contains a certain word or number.
Eg. If i have fields that have "04,06,08" and other combination's of number...
I need to create a report showing a record count for 2008, 2009 ytd, then comparing the current month of 2009 to the same month of 2008. Its just counting total records within one table (it d...
Hi all. My company just bought Abra Suite program that comes with Crystal Report 10 and we're testing to make some custom reports with CR. I ran into a problem when I tried to make a Beneficia...
Hi experts,
How could you print reports based made in CR based on number of copies provided by user. The copies could be from 1 to 99, hence it doesn't make sense to duplicate the report 99...
"10" & LEFT({Data.GL Number} & SPACE(25),25) & LEFT({Data.Debit Amount} & SPACE(12),12) & LEFT({Data.Credit Amount} & SPACE(12),12)
Right now, my {Data.Debit Amount} and {Data.Credit Amoun...
