Search results for query: *

no value in DEDRAT_0, i am alreday soritng this in STRDAT_0, but dor some reason it will not sort. tried to convert the value to a date but it willnot accept

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

Any help please?

Stored in the database

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

How can I convert data in a text field to date and compare with date parameter filed to return data only related to the parameter date?

Thanks boss (Ibass) you are the most helpfull and to the point every time i aske a question.

Boss, you are good as GOD on this. Can you tell me if I wanted to have a Quote and have them comma separated how I would do this. When I am exporting the data its coming in one line like a string rather then comma separated 143988 2-4 STDREV 2-5 STDREV 2-6 STDREV e.g. “100”,”p1”,”F”,”p2”...

I need to ideally export this data in csv format and want to keep it simple for the users, is it not possible to use any other method. Also this method will return all values but I want some values ignored as you can see from the report output

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

what i am getting is per Column a it repeating column B eg 1 XX MM JJ 60 55 20 2 XX 20 whai i need is XX MM JJ 1 60 55 20 2 20 etc

Sorry may be i am not explaining my selg well and also not doing this quite correct. Cross tab looks like this Column(B) Row (A) Summery(C) when I link it repeats the valuse for B which is what i dont want Thanks guys for giving so much time

only reason is that i dont want the columnB to repeat per Column A.

Unfortunately I don’t all the column fields. I there any way to possibly assign using some sort looping or arrays to assign the distinct values of the columns so that it can be retrieved after say using A[1] =aa or A[2]=FF etc

Thanks Ian, I have written this alreday using Pivot, is there anyway of writing this without Pivot since I am trying to use this as a sub report in a grouping section.

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

Mike what would be the complete command using awk and find / tmp -type f -o -type d -exec ls -l {} \; > /tmp/list would this work find . -type f -o -type d -exec ls -al {} \; | awk '{FS=" "; printf("%s %s %s\n",$1, $3, $9); }'

Thanks you Mike