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

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.

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

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

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

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

Goal: trying to write a IF STATEMENT in the Record Selection Formula area to add extra conditions to filter data I am retrieving. If a Note creator is selected from the parameter list, then filter Notes by the selected Note creator, else return Notes entered by everyone. My code: (IF NOT...

Is there a way to make a subreport non clickable in Crystal XI? I need 2 subreports on the same spot of the main report: - 1 to show the itemized payment amounts (just values) - 1 on demand to show the detailed itemized payment with payment types, dates, payor, etc... Currently the 2 reports...

2 fields (can be one or more value each delimited with an '&' sign): - Service Code (string) ie. 100&200&CH&400&TV - Service Description (string) ie. Laundry&Plumbing&Cable and Heat&Wireless&Television Known facts: 1) # of Service Description = # of Service Codes 2) 1st Service Description...