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...

There is actually only one table in the report. Changing the driver to the Crystal ODBC driver did the trick. All of my numeric fields are now showing the correct data. Thanks for your help! Carla

Hello, Thanks for responding. I am adding in the memo field by dragging and dropping from the field explorer. Carla

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...

Thanks for both of your responses :o) I think I will end up needing about 10-15 parameters. I am running CR 8.5. Based on your reply, it looks like I will be all set. I was afraid to put a ton of effort into building the report with all of the parameters only to find that it wouldn't work...

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

Hi Genimuse, To answer your question, yes it is intentional that the KA ID may show up more than once in the table. The main thing the users want to see is the BUG_ID field. The KA (KA_ID) may contain more than bug id in the BUG_ID field. If the user inputs 2 BUG_IDs in the HTML form that...

Thanks for all of your responses. Quite a bit to absorb, but I am trying! :o) I tried adding in an additional SQL statment after the first one, to count the number of records, and it works somewhat, but not exactly. What I am having trouble with now is the placement of the additional SQL...

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...

I actually show the data using a recordset in ASP. I use 'like' becase all bug ids are preceded by other characters. The last 5 characters (45627) are always unique. Also, there may be more than one bug id in that field. They are separated by spaces. bug_id is a string. I suspect there...

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...

Hi dgillz, Thanks for your response. Yes, that field is a date time field. Confusing, I know :o) Thanks for your help! Carla

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...

Sincere thanks to everyone for your help. I finally got it working. It was a problem with my code. Here is the update: <% Dim conn, objRS set conn = server.createobject(&quot;ADODB.Connection&quot;) conn.open &quot;UID=xxxxx;pwd=xxxxxx;DRIVER={Microsoft ODBC for Oracle};SERVER=xxxx;&quot...

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...

dgillz, that worked wonderfully. Thank you. Thank you both for your responses :o)

Hello, I have an ASP page where the user can select one of the following options from a drop down menu: &quot;All&quot; &quot;Records from Last 7 Days&quot; 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

Go to 'File' --> 'Printer Setup' and you should see a box called 'Orientation'. You can change it to Landscape there.