Before checking the 'no printer' option the report is already in landscape view. When clicking the 'no printer' option it goes to the potrait view and you can't change it back to landscape.
The textbox issue is that it'll wrap the text to the next row, but at the right margin of the textbox...
My crystal reports in asp.net pages are getting the text cut off and the carriage returns. I've set the text properties as 'can grow' but it's still getting cut off.
I've also tried unchecking the 'No printer' option in the report's 'print setup' menu. but then it shows the report in...
I'm running into the same issue. Following is a link describing why it wasn't working, http://support.microsoft.com/kb/891031.
The method suggested doesn't work for me though, as with <identity impersonate="true" userName="test" password="pass" /> would have all requests impersonate with this...
A portion of my site has an English/Spanish requirement. It's mostly web forms used for collecting data, so the translations were mostly labels and not content. I used the resource (.resx) files for the translations and didn't have to create separate pages. Even if your site is mostly...
An image map would still do the job. You would just use a combination of the polygons, circles, and rectangles to cover an area but they would all point to the same link. For examples if you had a map of the United States and wanted to map the state of Texas. You would use a rectangle to...
Thanks guys. Got it working over the weekend with the following query:
select
orderqty,
orderdt,
exrate,
isnull(exrate, (select exrate from exrate as e1 where exdate = (select max(e1.exdate) from exrate as e1 where e1.exdate < orderdt)))
from orders o
left join exrate e
on o.orderdt =...
That'll always return the same rate when a date is null. But I need to return the previous rate.
For example on the Currency table:
1/1/06 35.11
1/2/06 36.48
1/3/06 NULL
1/4/06 34.35
1/5/06 NULL
If order table has 1/3/06, I need to return 36.48 and if 1/5/06, 34.35 will be...
at first i joined on the dates, until i noticed that not all date existed for the currency table.
basic idea is i need to join on the date, but if date doesn't exist for currency table get the rate of previous existing date.
I have to tables in the following layout:
Order Table:
quantity
currency
date
Currency Table:
rate
date
Is there a way to get the the following is a one select statement w/out using a temp table:
Get the 'quantity', 'rate', 'quantity X rate' based on the date in the order table if the...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.