Search results for query: *

Hello, I am posting this again. Someone pointed me to the ASP samples on the Business Objects website and that unfortunately doesn't help me. The mulitple value parameters are hard coded in the samples. I need to know how to pass the checkbox values to the report via ASP. The values will...

Hello, I am using CR8.5. I downloaded some ASP samples from the Business Objects/CR knowledge base, but I am having some trouble with what I am trying to do. I have an HTML form that contains a list of values with checkboxes next to them. I would like the user to be able to select any number...

Hello, I am using CR 8.5 to create a report. There are several number fields in the report which show the correct data until I add in a memo field. When I add in the memo field it changes all of the data in the number fields to something completely incorrect. When I remove the memo field and...

Is there a limit to the number of parameters that can be used in a single report? Thanks, Carla

Good Afternoon, I have an HTML form in which users input a list of comma delimited numbers. Those numbers are then displayed in a table with other corresponding information from the database. The part I am having trouble with, is that I need to display a distinct count of the KA_ID field...

Good Afternoon, I have the following SQL statement: 'select KA_ID, BUG_ID, CREATED_BY from TABLE_KA where RTRIM(BUG_ID) like '%45627%' to pull Knowledge Assets out of a Knowledge database where a specific software bug number appears. For bug #45627, there are 5 Knowledge Assets in the...

Good Evening, I have a parameter that allows users to show either "All" records or records for the "Last7Days" meaning Last7Days including today. I am using the following formula and it seems to be pulling the correct data. Could someone please do a sanity check and tell...

Good Morning, I am trying to pull Customer Names from a database into an drop down menu. The below code has worked fine on it's current server for the past 2 years. I am trying to move it to a new server and keep getting the following error: ADODB.Recordset error '800a0bb9' Arguments are...

Hello, I have an ASP page where the user can select one of the following options from a drop down menu: "All" "Records from Last 7 Days" Depending on what option the user chooses he will see either all support cases or only support cases opened in the Last 7 Days. I am...

Hello, I have a date range parameter in my report and I am trying to figure out how to use ASP/HTML forms to pass the date range values to the report. I am using Crystal 8.5. Does anyone have any suggestions as to how to do this? Any help is appreciated. Best Regards, Carla

Hello, I have a tool on my web site (IIS 4.0) that uses a combination of ASP, CDONTS, and the SMTP service to send out .PDF files to customers. One customer is doing auto-processing based on MIME types which makes it important to him that the MIME type be set to the value he expects. In...

Hello, I have a vertical list of numbers in my details section. Each number is a result of a formula that calculates the number of days it took to resolve a support case. I need to check if the last number in the list is "0". If it is I have to check the second to last number to...

I created a report that contains 2 groups. The first group is based on the date a Technical Support case was entered and the group is printed for each month. The second group is based on the customer name that opened the Technical Support cases and contains all of the cases that the customer...

Hello, If a table is updated with a new field in the database, do I have to update the table in my report so that it includes that new field or will the table in the report be automatically updated? Thanks in advance for any information! Carla

Hello, I am somewhat new to this so please bear with me if this seems a little simple. I have a form that a user can fill out to send notfications to a list of email addresses that are pulled from a customer database. I need to allow the user to preview what is being sent before it is...

Hello, I have an asp program that pulls email addresses from a customer database and sends them an email with a PDF file as the attachment. This is all done using CDONTS. Some customers seem to receive the attachments fine. Others have asked me not to uuencode them because all they receive...

Hello, I have a formula {@daystoclose} which calculates the number of days to resolve a Technical Support case: CDate({SW_CASE.swDateResolved}) - CDate({SW_CASE.swDateCreated})) All of my closed cases are group by {@month}: DatePart ("m", {SW_CASE.swDateResolved}) & "/" &...

Hello, I am trying to figure out how to open a Microsoft Word document, extract engineering bug numbers from the text, and pass those numbers as parameters to Crystal in order to create a report. And I would also like to be able to generate and view this report from the web. Can this be...

Hello, I have a strange problem with my reports that contain charts. Each time I open a report the chart shifts its position to the left. It gets to the point where the data starts getting cut off on the left hand side. I position and size my charts by right clicking on the chart and...

I am creating a report by pulling data from a Customer Support database. I need to report on how many cases had a status of "open" on the last day of each month for the past 6 months not including the current month. For example, a case is opened in January and closed in March...