Search results for query: *

Hi: I have a report that pulls additional rental charges such as pet rent and garage fee. each charge has a status of either being part of the renter's current lease or being part of a renewal proposal. Such as: Charge type charge description amt Current garage $50 Current...

Hi: I have records for a renter's renewal options. From my SQL query I get lease term offer rental rate 1 month renewal $1200 2 month renewal $950 6 month renewal $700 etc. I also have the current rent the person is paying and whether they are already on a...

Hi: I have a report that had the format groups with multiple columns on the layout tab of the section expert for the detail section checked. I no longer want the multiple columns, i unchecked the box and then saved the file but the detail section is still showing in design mode the column setup...

Hi: I have a report which is basically in run of renewal letters being sent to apartment renters. The letter to each renter may be 1 or 2 pages depending on the length of the detail section. The group is the apartment unit #. The page footer is the letter closing (signature, title of sender...

Hi: I have a report which is grouping based on the following hierarchy: propertyname, eventtype (rented or available), floorplan style, apartmentcategory (standard or non-standard pricing), apartment# I have a crosstab in the apartment # group which basically lists by lease term the rent for...

Hi: I have a SQL script where I use in the select statement: rank () over (partition by t.person order by lp.dsumest) as rankedbyrent I would like to break up this query into multiple union statements, so I can add a hardcoded "type" field for each select statement section based on multiple...

Hi: I have a report that is really a letter template for sending to apt. renters that are up for renewal. My SQL script pulls in all the possible lease proposals months 1 - 12 ranked by price lowest to highest (some of the rankings can be the same if the same price exists for more than one...

Hi: I am replacing both a word and a deliminator in a string. If the word is the first word in the string, it is causing a gap at the top of the list. My formula is below, any help would be most appreciated. dim uamenities as string if ISNULL({Command.unit_amenities}) or {Command.unit_amenities}...

Hi: I have a crystal 9 report that gets its data from a SQL Query. One of the fields returns a comma separate string of the amenities at a property such as 24 hour fitness center, courtesy patrol, Spa like swimming pool, etc. This list can have a variable # of items as each property is unique. I...

Hi: I need to list a payment schedule for a quote sheet for a potential lessee. My SQL query returns the lease month term as an integer which could be 6, 12, 4, etc. It also returns the proposed lease start date, lease end date, and the monthly rent being quoted. Within my report, it is easy to...

Hi: In my where clause I need to choose records based on a particular date to compare against two date columns. If the date from the database is older than getdate() than I want to compare getdate() against the two date columns if the date is newer (or in the future) than getdate() I want to...

Hi: I have a column which I need to parse out one value from a really long string. The column contains log file information which holds information regarding when a table receives an insert statement. The string looks like the string below just a lot longer. I need the value that says...

Hi: I have a column of data in a table which is basically a log file that contains basically just a dump of values that could be in a variety of orders. I want to pull 8 characters after the value UCODE = ' which looks like UCODE = 'br24hr02' I need the br24hr02 It will always be in the...

Hi I am using the Business Intelligence Design Studio version of Visual Studio. When I add a new report item and the report wizard opens: 1. I create the connection to the local copy of the database I am using 2. I paste the query I am using into the query window Then it freezes and goes into...

Hello: I am building a report that groups by the following: Parent Curriculum Main Activity Child Activities Sometimes the value for the group child activities is "NoDetail" which is just a hardcoded placeholder value generated by the query. I want to suppress the visibility of the Child...

Hello: I am creating a report using BIDS in sql server 2005. Within my query is the following case statement: case req.reqstatus when 0 then 'Assigned' when 1 then 'In Progress' when 2 then 'Fulfilled' when 3 then 'Overdue' when 4 then 'Expired' else 'Not Defined' end...

Hello: I am attempting to create a calculated field with the following: =IIF (Sum(Fields!totalilt.value = 0,0,Sum(Fields!totalilt.value)*100/Sum(fields!totalilt.value) where am I going wrong? Thanks much for the help.

Hello: I am new to SSRS, I am using the "BIDS" version that comes with sql server 2005. I am much more familiar with Crystal reports than this so I am slogging through. I have the following in my dataset query: 'Q' + datename(Q,a.EndDt) + ' ' + datename(YYYY, a.EndDt) enddate, When I group...

Hello: I know I must have my syntax wrong somewhere on this case statement but I can't see it. What's wrong with this? case when left(o2.org_name,3)= 'DEN' then o2.org_name when left(o2.org_name,3)= 'LAX' then o2.org_name when left(o2.org_name,3)= 'PHX' then o2.org_name when...

Hi: I'm trying to narrow down my search criteria for a set of completed learning activities by two possible words in a course name. I tried to do the following in the where clause and it didn't work: where a.activity in like('%Sales%', '%Service%') I can't use an "or" as there are other...