I have an SSRS report when we export it to excel, it is exporting in 4 different tabs rather in one tab, I want it to be exported to one excel tab.
I have set the Disabled property in Page break of both the groups that exists to =IIF(Globals!RenderFormat.Name = "CSV" OR Globals!RenderFormat.Name = "EXCELOPENXML" OR Globals!RenderFormat.Name = "EXCEL", true, false), in report preview it is displaying correctly and generating the excel with only one sheet, but unfortunately when I try this in report viewer, it is displaying the following error
"A data source instance has not been supplied for the data source 'DataSet1'." Actually when I investigated it looks like it is missing the parameters, because the reports parameters are generated from the report dynamically some how they are not getting generated.
It runs perfectly in the report preview why isn't getting generated when I run from report viewer I am not understanding.
Can anybody please help me in this regard? I need some help any link, suggestion or code snippet any help would be really helpful.
Thanks in advance.
"There is enough hatred in the world, lets spread love compassion and affection."
i have two tables with same schema. i have to check table1 for any updates and insert the updates or the entire row into table2, only the most recently updated row.
so basically, table2 has the unique values from table1; for the duplicate entries in table1, there is only the most recent entry in table2.
i have tried to get the most recently updated id from table1:
SELECT distinct id
FROM table1 order by time_date desc limit 1;
now i need to use this id to get the other columns from table1 and insert the row with that id, into table2.
and i have to do this for all the entries in table1.
i have to update the row in table2 if it already exists, else insert new row. i check for recent record based on the date column, time_date.
both the tables have same schema.
any help would be great.!
LEFTJOIN CUSTOMER_BILLING_ADDRESS ba ON co.BA_ID = ba.BA_ID -- I'm guessing the ID column for ba and sa;LEFTJOIN CUSTOMER_SHIPPING_ADDRESS sa ON co.SA_ID = sa.SA_ID -- change them to the correct column names.
You've also got five queries to select a single column from the same record. You could replace that with a single SELECT:
Friends,I am working on a project....and in that project i have to take scanned image of finger with the help of fingerprint scanner.....and this image will be used as a password to log in the site.....so plzzzz..tell me how to store images in database..and how can i check the scanned image of finger of user with other scanned images
its web based project....like u can say...whenever we want to login on facebook,gmail,etc.we have to type our alphanumeric password....but i want user to scan his/her fingerprint..and then the fingerprint will be matched(as a password)......so my main aim is to provide more security to users..
ook...let me tell u...am a student and its final project which i have to submit...yeah..this project is having wide applications in banking,industries,etc.......
basically i will interface fingerprint scanner with the server.....
ook....as i have told u its a project...and it has wide variety of applications in industries and MNCs...........and yeah i just want to show that this can be implemented.....
and yeah the finger print scanner will be with the user(as in case of dell laptops..there is a fingerprint scanner)...and then with the help of that scanner ..scanned image can be given to the server....(and i think this can be done with the help of socket programming)...
Yes, and there's a reason why they all use their own security-systems, and an even better reason why most sites use a password.
There are existing examples for fingerprint-readers, and if you search you'd also find an SDK. It will work for existing applications, but I doubt that anything like FB or GMail would accept it as an alternative.
Bastard Programmer from Hell
If you can't read my code, try converting it here[^]