Search results for query: *

Just for closure, I finally figured this out. I was concatenating commas to my subreport parameter as follows ',' || '{?ID}' || ',' LIKE '%,' || table.field || ',%' and it would not work I moved ',' || '{?ID}' || ',' to a formula on the main report and linked to the formula and it worked...

Oops please ignore last post .. I am using the join method to parse the array. I should go home..my brain is not functioning!!

Additionally I have another parameter, lets call it {?Desc} This is a multi valued parameter and I select 3 values A B C from a pick list on the main report. This is used as a filter on the subreport command as Where 1 = Case When 'All' in ('{?Desc}') or table.field in ('{?Desc}')Then 1 Else...

Thanks LB, I looked at this solution. However it works if we use a multi valued parameter. The issue here is that the user does not want to enter each value and click the add (yes I know anal but *rolls eyes*), so I used a single valued parameter. i guess the solution I am interested in is...

I have a report which has parameters from the main 'container 'report which is a single valued parameter being passed to a subreport via a direct parameter to parameter link. I am simulating it to behave as a multivalued parameter by asking users to enter multiple values as a comma separated...

I have a report published to Crystal Enterprise that needs to be run on demand and exported to CSV file. I run this report and when I look under the export options, there is no CSV listed in the drop down. Our admin informed me that the only way to export a published report to CSV in crystal...

Ok, just so we can put this to rest... I removed all command objects used to populate the parameters and re added them one by one and linked them back to their respective parameters and was able to publish the report. No idea why this worked but makes me think CR somehow embeds the DB...

Thanks Turk, I had the admin check the rights and he said that could not be the issue since we have many other reports using the exact same structure with dynamic prompts working fine. I tried removing all dynamic prompts and adding them back one by one. The error returns as soon as I add the...

Hi, I am currently developing reports in CRXIR2 using a SQL Server 2005 DB with an ODBC connection. The issue I am facing is that I have a report with a total of 38 parameters. The main report acts as a shell to prompt the user for parameters and the actual data is pulled in by a sub...

Hi, I am currently developing reports that run off SQL Server command objects as datasource. These reports have 2 to 3 dynamic parameters. i.e. non cascading ones that use command objects to populate the drop downs. I need to be able to add the All option to these drop downs. That part is...

Thanks Turkbear. I did check and found that the server had the same printer settings as my client pc. Turns out our CE admin opened the reports on his personal CR and did a save as to CE thro there...That caused the reports to get saved with his local printer defaults ... rolls eyes. All good...

I have a few reports developed in Crystal Reports 10. The page layout for these reports are 11 x 17 landscape. I have set this in the printer settings and saved my rpt. When I publish to CE and try to view the reports. I do not see all the fields on the report Half of the report is cut off...

This might seem like a silly question but it has been bothering me for a while and any amount of googling or reference has not provided me with a satisfactory solution. I am using CR XI with Oracle 10. I have a 4 parameter stored procedure which I use in my report. Report is built and all is...

An update on this situation and I hope this helps someone help me. After monitoring the database sessions et al I found that it was one report that was the culprit. All other reports residing in java stored procedures run their sql code and close the database resources. Also we have...

My organization uses a jsp based CR9 reporting method. The jsp viewer is used to display the report. All the reports run off java stored procedures and each report has a subreport resting in it which runs off a regular pl/sql procedure and the parameters of the main and sub report are linked...

I might have possibly found the problem...but can some of the experts here help me put it in perspective. This whole bunch of reports rests within a java app and when I tested the same through stand alone CR it was throwing the error for some reports and ran ok with other reports. Finally I...

ODBC!

Enviroment CR 9 Jsp front end jdk 1.4.2 Oracle 10g (JAva stored procedure) Her is what is happening, when i execute my stored proc within toad it completes successfully Moment I use it as a data source for my CR it throws the PLS 00306 error for wrong number or types of parameters. Now all...

Well folks I feel real stupid writing this post but this thread needs closure. Turns out that I do not have execute rights on our QA database. But the reports that run off the stored procedures work just fine. The error happens only when I try to run the sprocs directly. God save us from the...

I run a command like this grant execute on package1 to xyz_user Is this not a explicit grant?