Hi i have the following data i am trying to retreve using a link report.
CPY_0 DEDRAT_0 STRDAT_0 VAT_0 VATRAT_0
100 01-Jan-99 EXE 0
100 01-Jan-99 EXP 0
100 01-Jan-99 IRR 0
100 01-Jan-99 STD 17.5
100 01-Jan-99 ZER 0
100 01-Jan-99 OSS 0
100 25-Nov-08 STD 15
in the link report i am...
I am writing some financial report (e.g. P&L, Balance sheets etc).
Can any body please advise me on how I can bring data from multiple quires into the same data table?
i.e. Revenue in column and budgets etc on 1 column so I can do calculation.
I used crystal reports before where I could use...
I am trying to deploy a report which displays comments stored as images. When I run the report in visual studio it works fine, but when deployed and I try to run it via explorer it does not display the image.
I am not sure if this is something to do with the configuration of the reporting...
When i run the following query on its own and give the @Tutor parameter value All it seems to work.
SELECT VIEW_TUTOR.TUTOR_ID, VIEW_TUTOR.NAME, COURSES.DELIVERYTYPE, COURSES.SYLLABUS, QUESTION_RESULTS.RESPONSE, COURSES.DATE,
(CASE WHEN dbo.QUESTION_RESULTS.RESPONSE =...
Need help please, I think I need to use Array’s but I am not sure how I would use it.
Data
St data1 data2
100 p1 F
100 p1 R
100 p2 F
100 p3 R
100 p4 F
100 p4 R
200 p3 F
200 p4 F
200 p4 R
200 p5 R
200 p6 F
200 p6 R
Report output
Grouping required on St
100 p1 F p2 F p3 R p4 F
200 p3 F p4 F...
I need to assign unique data form two different fields to separate formulas
e.g of data
A B C
1 XX 60
2 XX 40
1 MM 55
3 MM 60
4 FF 67
1 JJ 20
The representation I am trying to as follows
Report :
Grouping @ A
Report would look like this
FF JJ MM XX
1 20 55 60
2 40
3 60...
Hi
I need to compare two servers to see if there is deference in software installed (OS and Application). One is the test server and the other is the live server.
I tried to use the find unix command ( find . –print > myfile ) to dump the file, but this file only shows the file name and path...
Need help people, used the formula long time ago and I think ive forgotten how to use it now.
WhilePrintingRecords
I am trying to extract data only from these records which meets two different codintions on the same filed.
E.g
Customer Paper Conditionfield
1 A 1...
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.