| Author |
Topic |
|
kdnichols
Posting Yak Master
232 Posts |
 Posted - 2008-04-14 : 18:06:53
|
| I have my report returning info in my dataset, but nothing is previewing and there are no errors when the report builds.What should I check out next? |
|
|
bbasir
Yak Posting Veteran
76 Posts |
Posted - 2008-04-14 : 18:51:18
|
| have you linked the controls on the layout window with the fields from the dataset?if that is correct i.e. if you have done the above........? then check the value in each of the controls on the report layout windows ie what do they state? it should say your datasetfield.value, if it states any thing else then that is a problem...i.e. first ,last or any other function it states should not be used, just the value. |
 |
|
|
kdnichols
Posting Yak Master
232 Posts |
Posted - 2008-04-14 : 19:01:51
|
| Yes, I can see them in edit expressions and I have the fields in a table. What should I check for next? |
|
|
|
bbasir
Yak Posting Veteran
76 Posts |
Posted - 2008-04-14 : 19:59:01
|
| I doubt it is a caching issue, bvut you can try to refresh the report on the preview window and then enter the inpur parameters and try to run the report.btw,when you edit a control on your layout window what does the control states, can you post it? post for couplf of controls... i.e. it should state some thing like that control.value |
|
|
|
kdnichols
Posting Yak Master
232 Posts |
Posted - 2008-04-15 : 07:49:45
|
| To admin please delete the new post, it is part of this quetion. My bad.Do I need to place the fields in text boxes and what about parameters? Do I need to include the same fields in a parameter? |
|
|
|
kdnichols
Posting Yak Master
232 Posts |
Posted - 2008-04-15 : 09:55:10
|
| It states Fields, and not dataset fields even though I have defined a data set. What should I do next? |
|
|
|
kdnichols
Posting Yak Master
232 Posts |
Posted - 2008-04-15 : 10:03:02
|
| So even in a dataset are you saying instead of = Fields!SOURCE_MAS_LOC.Value it should just be =SOURCE_MAST_LOC.Value? |
|
|
|
kdnichols
Posting Yak Master
232 Posts |
Posted - 2008-04-15 : 10:31:24
|
| This is an example of one of the fields:=First(Fields!SCHED_REC_DATE.Value, "DataSet1"). My report is still not generating data.I need help asap on this please thanks for all previous help. |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-04-15 : 13:14:28
|
| Do you have any filters applied on your dataset?Also why are using first() function?What are you trying to achieve? |
|
|
|
bbasir
Yak Posting Veteran
76 Posts |
Posted - 2008-04-15 : 13:38:08
|
| remove the "first" and you will get the data. that is what I suggested that you should do in the begining... i.e. not use first or any other function |
|
|
|
kdnichols
Posting Yak Master
232 Posts |
Posted - 2008-04-15 : 15:27:53
|
| Thanks, I took out the keyword "First" now the expression looks like this:Fields!(SOURCE_MAS_LOC.VALUE, "DataSet1") and I get an error message that it is expecting a another ) (parenthesis).What should I do next? |
|
|
|
kdnichols
Posting Yak Master
232 Posts |
Posted - 2008-04-15 : 15:39:22
|
| It may help to know that I am accessing an Oracle database. |
|
|
|
bbasir
Yak Posting Veteran
76 Posts |
Posted - 2008-04-15 : 16:50:37
|
| it should be like this...(Fields!SCHED_REC_DATE.Value, "DataSet1") |
|
|
|
|
Dataset returns data, but not on report