Search results for query: *

Hi, I recently inherited a bunch of reports that were developed by other people in the past and I am supposed to spec them out and make documentations about fields that are used, table joins etc. Some reports are very "busy". How do I know if it uses any subreports or summary fields and which...

Environment: SSRS 2008 I am using an Embedded XML connection as the data source and when I am trying to add the various datasets to the report, I am having a hard time defining a Time Out(in seconds) under Dataset Properties>Query. Under Choose a Data Source and Create a Query, I typed...

I have CR 11 and I know about the Performance Information but I am not sure how accurate the numbers are. Also it does not seem to capture the timestamp of the time it was launched and when it finished. I am hoping for more complete information to do analysis. Also we develop Crystal Reports to...

Right now I am manually capturing the start time of a report and end time of a report by looking at the clock. It does not take too much effort to get a start time but getting an accurate end time can be a pain as I have to constantly flip back and forth between the stuff I am working on and the...

Let's say I have a table that looks like this: ID Year 1 2007 1 2008 1 2009 2 2001 2 2002 2 2009 Now I need to run a query and return the data to like this: ID Years 1 2007, 2008, 2009 2 2001, 2002, 2009 Any easy way of writing a query to...

I am currently working with a "closed" DB and we cannot add any custom functions nor stored procs to. SQL Command is the closest thing to a stored proc. I know I can write a select statement in SQL Command but can I go to the extend of create multiple temp tables and refer to each other? Thanks.

Are you trying to use the SQL Command feature in Crystal? Yes, you can use a Crystal parameter with SQL. 1) go to your Database Expert, ODBC connection 2) click on Add Command, a new screen "Add Command to Report" will pop up 3) type in your select statement (query) 4) on the right side of the...

I haven't tested it in SQL but it should work as well. At the worst case, syntax may be a bit different (which I doubt) but the concept is the same. Good luck. EC

Hi T, Instead of displaying the field that could be NULL, replace it by a formula. IF ISNULL({table.field}) THEN 0 ELSE {table.field}

Goal: retrieve all Authorizations that cover Service Codes checked from the parameter screen. Each authorization can cover one or multiple services and the authorization table looks like: ---------------------------------------------------- authorization.number | authorization.servicecode...

Thanks for your advice but that report isn't using a stored proc. What I ended up doing was to set up a default start date and default end date which I may or may not end up using based on some other conditions.

I am supposed to create a report where the user can choose to use an "as of date" or a specified "date range". As a result I set up 3 date parameters with IF NOT ISNULL validation. However it seems like Crystal forces me to fill all 3 parameters when I try to preview the report. Anyway, I can...

Hi CR95user, thanks for the suggestion but your solution will not work. The 1st entry without any time conflict remains on the report: 01/06/2007 10:00am 10:15am BALL, MANDI And the 2nd entry end up being dropped. Only one of the 2 1:20pm entries remains: 01/06/2007 1:20pm...

Trying desperately to figure out how I can retrieve duplicate or overlapping service entries only. ie: 01/06/2007 10:00am 10:15am BALL, MANDI 01/06/2007 1:20pm 1:40pm BALL, MANDI 01/06/2007 1:20pm 1:40pm BALL, MANDI 01/06/2007 1:30pm 2:30pm...

I am using Crystal XI. Someone told me that replacing linked tables by a command object will enhance performance and make reports run faster. Is it always true? Currently there is still too little data to test on and be able to tell the difference, but after the data conversion, we may be...

Hi lbass, I need to do further testing on a wider Sample of data and let you. The CustID = PatID was a typo. Sorry. I will write back on Monday. Thanks.

Hi lbass, Contract Code is not available in the Service Details table so I will only be able to link on: svccode.CustID = Contract.CustID svccode.SvcCode in split({?pm-contract.svccode},"&") Do I make the subreport Record Selection look like this? svccode.CustID = {?pm-contract.svccode.PATID}...

Crystal XI Goal: Bring back service details (amount used, date, duration etc.) on screen for any services covered under the contract. The report gives the user a chance to compare total used vs total allowed. Facts: - Each contract covers 1 or many services - Each contract covers up to a...

yes I am using Crystal XI. Sorry for not precising it earlier.

This is what I end up writing: (IF ISNULL({?selected_notecreator}) OR {?selected_notecreator} = '' THEN TRUE ELSE {table.notecreatorfield} = {?selected_notetype}) It did work this way. Thanks guys!