Search results for query: *

I am using Crystal 9.0, vb.net, Oracle database. I have an existing report and I need to bind it somehow to datagrid. I open new web page, add from toolbox datagrid and looking for a way to populate datagrid using my report. Is it possible to do? I am new in this. Maybe somebody can provide some...

I have a hyperlink button on drill down report. Ineed to be able to hide it when I drill down to details. How can I do this?

I have a drill down report with user see through CrystalViewer. And I have a LinkButton on this page where user can click and report will export to pdf format. But, when user click on one of the fields on the report to drill down to details I want this LinkButton became invisible. How can I do...

I have a strange problem. I have two different reports in web application. But, both of them user view through CrystalViewer, both drilldown reports. Both reports appear on the screen pretty fast but when I click print or print preview one of them almost does not work. For 10 pages report print...

I have a strange problem. I have two different reports in web application. But, both of them user view through CrystalViewer, both drilldown reports. Both reports appear on the screen pretty fast but when I click print or print preview one of them almost does not work. For 10 pages report print...

I need to give user possibility to sort report by Provider name, Location, Project Type or All Project Types. I created parameter SORT with then formula Sort which look like: if {?Sort} = "Provider Name" then {V_REPORTS_CALLIN.PROVIDER_NAME} else if {?Sort} = "Project Type" then...

I am using Crystal 9 and Oracle DB. I always use OLE DB for connection with the tables/views. Now I need to connect stored procedure and I have a problem. With OLE DB it does not work (looks like) and I cannot find native driver to establish new connection. Should I somehow install native...

I created sort parameter to give user possibility to sort by desired field. Then Create Sort formula: if {?Sort} = "PROJECT_NUMBER" then {Command.PROJECT_NUMBER} else if {?Sort} = "DATE_OF_COMPLAINT" then totext({Command.DATE_OF_COMPLAINT}, "yyyy-mm-dd") else if {?Sort} =...

I creates parameter Sort and then formula Sort where I have something like if {?Sort} = "Project#" then {V_PACS_PROJECT_STATUS.PROJECT_NUMBER} else if {?Sort} = "Open Date" then totext({PACS_PROJECT.OPEN_DATE},"yyyy-mm-dd") else if {?Sort} = "Provider...

Instead of normal Crystal viewer I have in design mode "Crystal Creating control" sign. It was OK before. I try to delete and put another viewer. Then I tried to restart computer. The same result. Can someone help me??

I have a web application with the number of Crystal reports added. I send them to .pdf or user can see them through Crystal viewer. One of the reports all of a sudden stop print. I can open the report,look at the report, but when I even try print preview it show just empty page and does not do...

It looks like easy thing but I cannot find the way to do it. My table have the following columns: Project# Draft_Date End_date Exit_date.... etc I need to count Draft_Date(or Exit_date or End_date) where Draft_date is not null and Distinct Project#. I am doing the formula if...

Is it possible to create the following parameter?... The field StaffID has many different ID's (SJM, LRD, RTV..) My parameter now : (if {?CoMng} <> &quot;All&quot; then ({PACS_PROJECT_STAFF.STAFF_ID}) = {?CoMng} else if {?CoMng} = &quot;All&quot; then true). How can I let user select...

I have a parameter out of Staff_Table.Last_Name. This table has a field Staff_id. I need to apply formula approx like this: Select Staff_Table.Last_Name where Staff_Table.Staff_ID = Project_Table.Staff_id and Project_Table.Staff_Type = 01. So, for my parameter I need only names with...

I have a table with following fields: Proj# DraftDate FinalDate ExitDate ....and much more 111 1/1/01 5/5/01 null 222 2/2/02 333 5/5/03 6/5/03 444 1/1/02 ...etc I need to have a report where I select Proj# where DraftDate is not...

I have report with four parameters. My record selection formula looks like: {FACTS_DIM_PROJECT_TYPE_CODE.ACTIVE} = &quot;Y&quot; and {V_PACS_PROJECT_STATUS.STATUS_CODE} = &quot;02&quot; and (if {?ProjType} <> &quot;All&quot; then {FACTS_DIM_PROJECT_TYPE_CODE.PROJECT_TYPE_DESCRIPTION} =...

I have Crystal 9.0 report. it is working perfectly. When I added reports to web application and let user see it in .pdf format it returns the following: Error in File C:\WINNT\TEMP\temp_5ac852e3-a928-4b64-b12c-8bc64e5395ca.rpt: Failed to open a rowset. I am running all the times reports this...

In my Cross-tab I need to have a columns using Status_Description(and it sorted alpha). I need to sorted columns by Status_Sequence field. How can I do this?? These two fields are corresponding. I can get a columns using Status_Sequence but column names in the report should be Descriptions

I have a report where I should give user possibility to select StaffType (01,02,03,04 or All). Then, depends which type user select he should go to different fields. For example: if user select 01 then he should select only from field CO_Manager (nothing else), if user select 02 then only from...

I have a parameter {?StaffType}: (if {?StaffType} <> &quot;All&quot; and {PACS_PROJECT_STAFF.STAFF_ACTIVE} = 'Y' then {PACS_PROJECT_STAFF.STAFF_TYPE} = {?StaffType} else if {?StaffType} = &quot;All&quot; and {PACS_PROJECT_STAFF.STAFF_ACTIVE} = 'Y' then {PACS_PROJECT_STAFF.STAFF_TYPE} in ['01'...