Search results for query: *

Hi, I have a tricky(?) problem here...... I have a product, that writes out reports to tables. SO, the table is create dynamically. Columns are decided by me, the datatypes are decided by the product. I have no control on the data types. If the database has a double, the report writer create the...

Hello, Have been struggling with the following query for a couple of days and hope someone could shed some light on this: The query: Select id, tran_no from table_x where client=@client and price=(case when @variable1=0 then @variable2 else @variable1 end) and date=(case when @datevariable1=''...

Hello all, I have a 'process' related question. First a little background on our evironment: We are using Crystal Report Application Server 9 with SQL Server 2000 and asp coding. We have developed an application in asp where users can select a report, provide values to the stored procedure...

Hello all, I have a 'process' related question. First a little bacground on our evironment: We are using Crystal Report Application Server 9 with SQL Server 2000 and asp coding. We have developed an application in asp where users can select a report, provide values to the stored procedure...

Hi, We are using asp, RDC to view, export reports via web. I have the following issues *only* when the reports are using crystal query instead of a stored procedure or table links. Issue: The report login fails when I use the following code. The same code works fine when the report uses stored...

Hi, we had a requirement recently, and i have been researching for a solution, in vain. Hope osmeone could throw some light. We ahve created a browser based application that renders crystal reports to users. The last page in a sequence of parameter prompting, criteria validating is the...

Hi, Did anyone work with the filter objects in RAS? I am having an issue working with this object. I am able to retrive the filter defined in the report, but not able to append a new filter to the existing one. Could someone throw some light please? Thank, Pavan

Hi, After two days of beating my head against the wall, i am coming for help, very desperately. Any help is much appreciated. I am trying to ste some values to the stored procedure parameters in a report. I dont know whats happening, but the report is not taking these parameters nor it it...

Hello everyone suffering with RASomania (like me!!), RAS has become something like...'Cant Bare you, Cant live without you!!' for all Crystal Users. The document is so adequate and any help is Oasis. Hope someone helps me with this issue. I am feeling lost!! We have created some ASP pages, that...

hi, Hope someone helps me with a workaround to this intriguing issue. We have a set of reports that we made available to our intranet clients via the RDC. There are a set of asp files that read the parameters of each report (that are stored in a table (Hardcoding??!!)) and user selects/enters...

hi, Hope someone helps me with a workaround to this intriguing issue. We have a set of reports that we made available to out intranet clients via the RDC. There are a set of asp files that read the parameters of each report (that are stored in a table (Hardcoding??!!)) and user selects/enters...

Hi, Hope someone will help me with this. I am trying to run crystal report through VB Code. I am using RDC here. My report has some date params to which user might pass in a NULL. I am not able to set it in the code. Everything i tried gets back an error. Any ideas? All i want to do is to able...

Hi, May be i am missing something here. Hope one of you can help me. I am trying to dynamic grouping on one of my reports and want the user to pass a parameter on which i would do the grouping. To explian better, lemme take an example. My report would take City, Country and zipcode as parameters...

Hi, Hope someone can help me with this. I am trying to pass a Null value for a Date parameter of a report, form VB. When run in Crystal environment, i am able to set it to Null and my stored procedure accepts null for this parameter. But form VB, when i try the following code I am getting a...

Hi, Got an additional question to my earlier one. Can we specify this 'characters per inch' in code? I am trying to export this report to a text file through VB also. Can i specify a setting in code to reflect no. of characters per inch? any help is much appreciated. Thanks, Pavan

Hi, This could be the dumbest question in ages. I have this report and want to export it to a text file. As the report is very big we want the characters to occupy less space. Now here is what i did: I ran the report, hit export, and the 'paginate' dialog box appears. Default is showing 60. I...

Hi everyone, Got a question thats troubling me. This is what i want to do: We have a report and it is not grouped by Country, State, City and Zip Code. What my users ask is to be able to specify a county name in place of zipcode...i.e they want to have an option to be able to select(or enter)...

hi, Got a quick question. I dunno if i am misisng a function here. I want a string which (if it is) is 5 chars in length to appear in 7 chars length. for example. If i am getting a string from database like 'Hello' i want it to be padded with two zeros like 00hello. Can i do this is sql? Any...

hi, Got a quick questions. I dunno if i am misisng a function here. I want a string which (if it is) is 5 chars in length to appear in 7 chars length. for example. If i am getting a string from database like 'Hello' i want it to be padded with two zeros like 00hello. Can i do this is sql? Any...

Hi, We are developing our reports using Crystal Reports 9. after the development we want to show the rpeorts on a browser. so we are using the CRViewer to show the report. Everything works fine and we are getting back the data and are abe to see the records. But here is the problem. I have 4...